public ViewResult NCInventory(PlanSearchCondition condition, string errorMsg = "", bool isloadCondition = false)
{
if (isloadCondition)
{
condition = TempData["nc_inventory_condition"] as PlanSearchCondition;
}
if (string.IsNullOrEmpty(errorMsg) == false)
{
ViewBag.ErrorMsg = errorMsg;
}
// 委外仓库
ViewBag.ListCK = bll_Product.GetWWCK();
// 委外转库线材
var list = new List <NCInventoryDto>();
list.AddRange(bll_Product.GetNCInventory(condition?.LineWhCode, condition?.Gz, condition?.Zxbz, condition?.Gg, condition?.SearchBatchNo));
ViewBag.InventoryData = list.OrderBy(w => w.BatchNo).ThenBy(w => w.StlGrd).ThenBy(w => w.Spec).ToList();
// 用于在Action中传递查询条件
TempData["nc_inventory_condition"] = condition;
return(View(condition));
}
public ViewResult Plan(PlanSearchCondition condition)
{
//string user = Request.Headers.cur
var list = bll.GetWWOrdList(
condition?.Gz, condition?.Zxbz, condition?.Gg,
condition?.Kh, condition?.Wl, condition?.Ht, condition?.LineWhCode,
condition?.BeginTime, condition?.EndTime);
//var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
ViewBag.PlanData = list;
// 委外仓库
ViewBag.ListCK = bll_Product.GetWWCK();
return(View(condition));
}
public ViewResult InventoryManager(PlanSearchCondition condition, string errorMsg = "", bool isloadCondition = false)
{
if (isloadCondition)
{
condition = TempData["inventory_condition"] as PlanSearchCondition;
}
if (string.IsNullOrEmpty(errorMsg) == false)
{
ViewBag.ErrorMsg = errorMsg;
}
// 委外仓库
ViewBag.ListCK = bll_Product.GetWWCK();
// 委外转库线材
var list = new List <NF.MODEL.Mod_TRC_ROLL_PRODCUT>();
list.AddRange(bll_Product.GetByWWCK(condition?.LineWhCode, condition?.Gz, condition?.Zxbz, condition?.Gg, condition?.SearchBatchNo));
var listzkd = new List <NF.MODEL.ZKDInfoDto>();
var user = System.Web.HttpContext.Current.Session["CurrentUser"] as CurrentUser;
listzkd.AddRange(bll_Product.GetWWZKD(user?.Id, condition?.SearchBatchNo));
ViewBag.ZKDData = listzkd;
var ncList = bll_Product.GetNCInventory(condition?.LineWhCode, condition?.Gz, condition?.Zxbz, condition?.Gg, condition?.SearchBatchNo);
ViewBag.InventoryData = list.GroupBy(w => new
{
w.C_BATCH_NO,
w.C_STL_GRD,
w.C_STD_CODE,
w.C_SPEC,
w.C_MAT_CODE,
w.C_MAT_DESC,
w.C_LINEWH_CODE,
w.C_BZYQ,
w.C_JUDGE_LEV_ZH,
w.C_SALE_AREA
}).Select(w =>
{
Expression <Func <NCInventoryDto, bool> > expre = x =>
x.StdCode == w.Key.C_STD_CODE &
x.StlGrd == w.Key.C_STL_GRD &
x.MtrlCode == w.Key.C_MAT_CODE &
x.ZLDJ == w.Key.C_JUDGE_LEV_ZH;
if (string.IsNullOrEmpty(w.Key.C_BZYQ))
{
expre = expre.And(x => string.IsNullOrEmpty(x.BZYQ) == string.IsNullOrEmpty(w.Key.C_BZYQ));
}
else
{
expre = expre.And(x => x.BZYQ == w.Key.C_BZYQ);
}
var expre1 = expre.And(l => l.BatchNo == w.Key.C_BATCH_NO);
var ncItem = ncList.FirstOrDefault(expre1.Compile());
if (ncItem == null)
{
var expre2 = expre.And(l => l.BatchNo.Contains(w.Key.C_BATCH_NO));
ncItem = ncList.FirstOrDefault(expre2.Compile());
}
var item = new ProductGrpInfo
{
BatchNo = w.Key.C_BATCH_NO,
Spec = w.Key.C_SPEC,
StdCode = w.Key.C_STD_CODE,
StlGrd = w.Key.C_STL_GRD,
Count = w.Count(),
Wgt = w.Sum(x => x.N_WGT),
MtrlCode = w.Key.C_MAT_CODE,
MtrlName = w.Key.C_MAT_DESC,
InventoryCode = w.Key.C_LINEWH_CODE,
BZYQ = w.Key.C_BZYQ,
ZLDJ = w.Key.C_JUDGE_LEV_ZH,
SalesArea = w.Key.C_SALE_AREA,
NCCount = ncItem?.Count ?? 0,
NCWgt = ncItem?.Wgt ?? 0,
NCBatchNO = ncItem?.BatchNo
};
ncList.Remove(ncItem);
return(item);
}).OrderBy(w => w.BatchNo).ThenBy(w => w.StlGrd).ThenBy(w => w.Spec).ToList();
// 用于在Action中传递查询条件
TempData["inventory_condition"] = condition;
return(View(condition));
}
