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