public ResResultModel GetOrderSendList(PdaOrderSendModel model)
{
try
{
var bll = new OrderSend();
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
var list = bll.GetList(model.PageIndex, model.PageSize, sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
return(ResResult.Response(true, "", JsonConvert.SerializeObject(list)));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
private void GetOrderSendList(HttpContext context, int pageIndex, int pageSize, string keyword)
{
var bll = new OrderSend();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
if (!string.IsNullOrWhiteSpace(keyword))
{
parms = new ParamsHelper();
sqlWhere = new StringBuilder("and (o.OrderCode like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
var list = bll.GetList(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}