public override Page <Qq_TbGood> Page(long page, long limit, Qq_TbGood queryModel, string orderFild, string orderType = "ASC")
{
var sql = new StringBuilder("select * from t_qq_TbGoods where 1=1 ");
var index = 0;
List <object> parames = new List <object>();
///淘宝标题
if (!string.IsNullOrEmpty(queryModel.Name))
{
sql.Append(" and Name like @" + index++);
parames.Add(queryModel.Name);
}
///标题
if (!string.IsNullOrEmpty(queryModel.Title))
{
sql.Append(" and Title like @" + index++);
parames.Add(queryModel.Title);
}
///导语
if (!string.IsNullOrEmpty(queryModel.HeadContent))
{
sql.Append(" and HeadContent like @" + index++);
parames.Add(queryModel.HeadContent);
}
if (!string.IsNullOrEmpty(queryModel.DeleteFlag))
{
sql.Append(" and DeleteFlag like @" + index++);
parames.Add(queryModel.DeleteFlag);
}
//排序
if (!string.IsNullOrEmpty(orderFild))
{
sql.Append(string.Format(" order by {0} {1} ", orderFild, orderType));
}
return(CurrentDB.Page <Qq_TbGood>(page, limit, sql.ToString(), parames.ToArray()));
}
