private ActionResult GetOutStockCencusPages(OutStockCensusShow condition, string where)
{
PageJsonModel <OutStockCensus> page = new PageJsonModel <OutStockCensus>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
string strForm = "";
strForm = @"(select count(*) count,s.CreateTime,s.OutOrderNo,s.BigCode,s.MiddleCode,s.Consignee Consignee, s.Shipper Shipper,p.ProductName ProductName,p.ProductNumber ProductNumber " +
"from ScaleOutStoke s left join Product p on s.ProductNo=p.ProductNumber where Shipper='总部' " + where;
strForm += " group by s.CreateTime,s.OutOrderNo,s.BigCode,s.MiddleCode,s.Consignee,s.Shipper,p.ProductName,p.ProductNumber) as OutStockScaleShow left join C_User as c on c.UserName=OutStockScaleShow.Consignee";
page.strForm = strForm;
page.strSelect = " OutStockScaleShow.*,c.Name C_Name ";
if (string.IsNullOrWhiteSpace(condition.orderby) == false)
{
page.strOrder = Common.FilteSQLStr(condition.orderby);
}
else
{
page.strOrder = "OutStockScaleShow.CreateTime desc";
}
page.LoadList();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
ScaleCodeCount OutCodeCount = ScaleOutStoke.GetC_UserOutCount(where);
page.pageResponse.BigCount = OutCodeCount.BigCount;
page.pageResponse.MiddleCount = OutCodeCount.MiddleCount;
page.pageResponse.SmallCount = OutCodeCount.SmallCount;
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
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 GetBigCodePageKuCun(BigScaleSearch condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.BigCode))
{
where += " and ( b.ProductNumber+b.ProductName like '%" + condition.BigCode + "%' )";
}
PageJsonModel <BigScale> page = new PageJsonModel <BigScale>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = "(select COUNT(SmallCode) as SmallCount,sum(b.kw) as [money],b.ProductName,b.ProductNumber,b.ProductImg" +
" from Scale as a left join Product as b on a.ProductNo=b.ProductNumber" +
" where StateID in (6,9)" + where +
" group by b.ProductName,b.ProductNumber,b.ProductImg) as BigScale";
page.strSelect = " * ";
if (string.IsNullOrWhiteSpace(condition.orderby) == false)
{
page.strOrder = Common.FilteSQLStr(condition.orderby);
}
else
{
page.strOrder = " ProductName ";
}
page.LoadList();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
ScaleCodeCount OutCodeCount = Scale.GetStockCount(where);
page.pageResponse.SmallCount = OutCodeCount.SmallCount;
page.pageResponse.SumPrice = OutCodeCount.SumPrice;
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
private ActionResult GetRtnStockCencusPages(RtnStockCensusShow condition, string where)
{
string strForm = @"(select ReturnTime,BigCode,MiddleCode,ProductNumber,ProductName,ProductImg,COUNT(SmallCode) as SmallCount,OperaUser,PRealName,OrderNo from ( " +
"select (ReturnTime/86400*86400-28800) as ReturnTime,BigCode,MiddleCode,SmallCode,ProductNumber,ProductName,ProductImg,OperaUser,PRealName,OrderNo " +
"from ScaleRtnStoke as a left join Product as b on a.ProducctNo=b.ProductNumber left join PDAUser as d on a.OperaUser=d.PUserName " +
"where a.Shipper='总部' " + where + ") as def " +
"group by ReturnTime,BigCode,MiddleCode,ProductNumber,ProductName,ProductImg,OperaUser,PRealName,OrderNo) as RtnCountTB";
PageJsonModel <RtnStockCensus> page = new PageJsonModel <RtnStockCensus>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strSelect = " ReturnTime,BigCode,MiddleCode,ProductNumber,ProductName,ProductImg,OperaUser,PRealName,SmallCount,OrderNo ";
page.strForm = strForm;
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)
{
ScaleCodeCount OutCodeCount = RtnStockScale.GetRtnStockCount(where);
page.pageResponse.BigCount = OutCodeCount.BigCount;
page.pageResponse.MiddleCount = OutCodeCount.MiddleCount;
page.pageResponse.SmallCount = OutCodeCount.SmallCount;
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}