private ActionResult GetInStockCensusPages(InStockCensusShow condition, string where)
{
string StrForm = "(select count(*) count,s.IntoOrderNo,s.BigCode,s.MiddleCode,p.ProductNumber ProductNumber,p.ProductName ProductName,s.IntoTime " +
"from Scale s left join Product p on s.ProductNo=p.ProductNumber where s.IsInto=1 " + where +
"group by ProductNumber,ProductName,s.IntoOrderNo,s.BigCode,s.MiddleCode,s.IntoTime) as InStockScaleShow ";
PageJsonModel <InStockCensus> page = new PageJsonModel <InStockCensus>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = StrForm;
page.strSelect = " * ";
if (string.IsNullOrWhiteSpace(condition.orderby) == false)
{
page.strOrder = Common.FilteSQLStr(condition.orderby);
}
else
{
page.strOrder = "IntoTime desc";
}
page.LoadList();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
ScaleCodeCount IntoStockCount = Scale.GetIntoStockCount(where);
page.pageResponse.BigCount = IntoStockCount.BigCount;
page.pageResponse.MiddleCount = IntoStockCount.MiddleCount;
page.pageResponse.SmallCount = IntoStockCount.SmallCount;
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult GetInStockCensusPage(InStockCensusShow condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(" and ( BigCode='{0}' or MiddleCode='{0}' or SmallCode='{0}')", Common.Filter(condition.keyword));
}
if (!string.IsNullOrWhiteSpace(condition.ProductNumber))
{
where += string.Format(" and ProductNo='{0}'", condition.ProductNumber);
}
if (!string.IsNullOrWhiteSpace(condition.DatCreateB))
{
where += string.Format(" and IntoTime >={0} ", CommonFunc.GetTimestamp(Convert.ToDateTime(condition.DatCreateB + " 00:00:00")));
}
if (!string.IsNullOrWhiteSpace(condition.DatCreateE))
{
where += string.Format(" and IntoTime <={0} ", CommonFunc.GetTimestamp(Convert.ToDateTime(condition.DatCreateE + " 23:59:59")));
}
return(GetInStockCensusPages(condition, where));
}
