C# winform 查询页面如何动态新增查询条件

Question

点击新增条件，复制控件

Answer 1

public DataTable QueryInventoryInfo(string productId, string productName, string categoryName)
{
string sql = "select ProductId,ProductName,Unit,UnitPrice,Discount,TotalCount,MaxCount,MinCount,InventoryStatus,CategoryName,CategoryId ";
sql += "from view_QueryInventoryInfo where 1=1";
if (productId.Length != 0)
{
sql += string.Format(" and ProductId='{0}'", productId);
}
if (productName.Length != 0)
{
sql += string.Format(" and ProductName like '%{0}%'", productName);
}
if(categoryName.Length !=0)
{
sql += string.Format(" and CategoryName ='{0}'",categoryName);
}
return SQLHelper.GetDataSet(sql).Tables[0];
}
试用这个办法