private ActionResult GetPages(RtnStockSeacher condition, string where)
{
PageJsonModel <ScaleRtnStokeDetail> page = new PageJsonModel <ScaleRtnStokeDetail>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = "ScaleRtnStoke s left join C_User as c on c.UserName=s.Consignee";
page.strSelect = " s.ReturnTime,s.BigCode,s.MiddleCode,s.SmallCode,s.OrderNo,s.OutTime,s.OutOrderNo,c.Name ";
page.strWhere = where;
if (string.IsNullOrWhiteSpace(condition.orderby) == false)
{
page.strOrder = Common.FilteSQLStr(condition.orderby);
}
else
{
page.strOrder = "ReturnTime desc";
}
page.LoadList();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult GetRecordPageDetail(RtnStockSeacher condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.OrderNo))
{
where += string.Format(" and OrderNo='{0}'", Common.Filter(condition.OrderNo));
}
if (condition.RtnWay != 0)
{
where += string.Format(" and RtnWay={0}", condition.RtnWay);
string codeStr = "SmallCode";
if (condition.RtnWay == 2)
{
codeStr = "MiddleCode";
}
if (condition.RtnWay == 3)
{
codeStr = "BigCode";
}
if (!string.IsNullOrWhiteSpace(condition.BarCode))
{
where += string.Format(" and {0}='{1}'", codeStr, Common.Filter(condition.BarCode));
}
}
return(GetPages(condition, where));
}
public ActionResult GetSmallCodePage(RtnStockSeacher condition)
{
string where = string.Empty;
if (condition.ReturnTime != 0)
{
where += string.Format(" and ReturnTime>={0} and ReturnTime<{1}", condition.ReturnTime, condition.ReturnTime + 86400);
}
if (!string.IsNullOrWhiteSpace(condition.OrderNo))
{
where += string.Format(" and OrderNo='{0}'", Common.Filter(condition.OrderNo));
}
if (!string.IsNullOrWhiteSpace(condition.BigCode))
{
where += string.Format(" and BigCode='{0}'", Common.Filter(condition.BigCode));
}
if (!string.IsNullOrWhiteSpace(condition.MiddleCode))
{
where += string.Format(" and MiddleCode='{0}'", Common.Filter(condition.MiddleCode));
}
if (!string.IsNullOrWhiteSpace(condition.ProductNo))
{
where += string.Format(" and ProducctNo='{0}'", Common.Filter(condition.ProductNo));
}
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(" and SmallCode like '%{0}%'", Common.Filter(condition.keyword));
}
return(GetPages(condition, where));
}
