[数据库使用技巧]动态生成sql语句_网络大本营

来源：互联网发布：装修工人app软件编辑：程序博客网时间：2024/04/29 03:07

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);
        }