62,025
社区成员
发帖
与我相关
我的任务
分享
StringBuilder sql = new StringBuilder();
sql.Append("select * from SellData where isDel=@isDel ");
if (model.BigClassID != 0)
sql.Append("and bigClass=@bigClass ");
if (model.SmallClassID != 0)
sql.Append("and smallClass=@smallClass ");
if (model.ShopID != 0)
sql.Append("and shopID=@shopID ");
if (model.StartTime != DateTime.MinValue && model.EndTime != DateTime.MaxValue)
sql.Append("and sellDate between @startTime and @endTime ");
sql.Append("order by id desc");
OleDbParameter[] op = new OleDbParameter[]{
new OleDbParameter("@bigClass",OleDbType.Integer,20),
new OleDbParameter("@smallClass",OleDbType.Integer,20),
new OleDbParameter("@shopID",OleDbType.Integer,20),
new OleDbParameter("@startTime",OleDbType.DBDate,20),
new OleDbParameter("@endTime",OleDbType.DBDate,20),
new OleDbParameter("@isDel",OleDbType.Integer,10)
};
op[0].Value = model.BigClassID;
op[1].Value = model.SmallClassID;
op[2].Value = model.ShopID;
op[3].Value = model.StartTime;
op[4].Value = model.EndTime;
op[5].Value = model.IsDel;
System.Text.StringBuilder sql = new System.Text.StringBuilder();
System.Collections.Hashtable list = new Hashtable();
sql.Append("select * from SellData where isDel=@isDel ");
OleDbParameter IsDel = new OleDbParameter("@IsDel", OleDbType.Integer, 20);
IsDel.Value = model.IsDel;
list.Add("IsDel", IsDel);
if (model.BigClassID != 0) {
OleDbParameter BigClassID = new OleDbParameter("@bigClass", OleDbType.Integer, 20);
BigClassID.Value = model.BigClassID;
list.Add("BigClassID", BigClassID);
sql.Append("and bigClass=@bigClass ");
}
if (model.SmallClassID != 0) {
OleDbParameter SmallClassID = new OleDbParameter("@smallClass", OleDbType.Integer, 20);
SmallClassID.Value = model.SmallClassID;
list.Add("SmallClassID", SmallClassID);
sql.Append("and smallClass=@smallClass ");
}
if (model.ShopID != 0) {
OleDbParameter ShopID = new OleDbParameter("@shopID", OleDbType.Integer, 20);
ShopID.Value = model.ShopID;
list.Add("ShopID", ShopID);
sql.Append("and shopID=@shopID ");
}
if (model.StartTime != DateTime.MinValue && model.EndTime != DateTime.MaxValue) {
OleDbParameter StartTime = new OleDbParameter("@startTime", OleDbType.Integer, 20);
StartTime.Value = model.StartTime;
list.Add("StartTime", StartTime);
OleDbParameter EndTime = new OleDbParameter("@EndTime", OleDbType.Integer, 20);
EndTime.Value = model.EndTime;
list.Add("EndTime", EndTime);
sql.Append("and sellDate between @startTime and @endTime ");
}
sql.Append("order by id desc");
OleDbParameter[] op = new OleDbParameter[list.Count];
int index = 0;
foreach (System.Collections.DictionaryEntry entry in list) {
op[index] = (OleDbParameter)entry.Value;
index++;
}
StringBuilder sql = new StringBuilder();
sql.Append("select * from SellData where isDel=@isDel ");
if (model.BigClassID != 0)
sql.Append("and bigClass='"+model.BigClassID +"' ");
if (model.SmallClassID != 0)
sql.Append("and smallClass=@'"+model.SmallClassID +"'");
if (model.ShopID != 0)
sql.Append("and shopID='"+model.ShopID +"'");
if (model.StartTime != DateTime.MinValue && model.EndTime != DateTime.MaxValue)
sql.Append("and sellDate between '"+model.StartTime +"' and '"+model.EndTime+"'");
sql.Append("order by id desc");