public bool GetDataByProdID(string ProdID, string ItemID,string beginDate,string endDate)
{
bool Mark = false;
string _SQL = "1=1";
if (!ProdID.Equals(""))
{
_SQL += " And LTRIM(PRODID)='{0}'";
Mark = true;
}
if (!ItemID.Equals(""))
{
_SQL += " And LTRIM(ItemID)='{1}'";
Mark = true;
}
if (!beginDate.Equals("") && !endDate.Equals(""))
{
_SQL += " And TRANSDATE BETWEEN '{2}' AND '{3}' ";
Mark = true;
}
if (!Mark)
{
_SQL = "1=1";}
_SQL = string.Format(_SQL, new string[] { ProdID, ItemID, beginDate, endDate });
GetDataCount(_SQL);
return GetData(PageSize, 1, _SQL);
}
[数据库使用技巧]动态生成sql语句_网络大本营
最新推荐文章于 2024-01-11 19:17:30 发布