public ActionResult UptaleJingCangDan(Array JieShouMingXiID, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state)
{
string strMag = "fali";
ReturnJsonVo returnJson = new ReturnJsonVo();
//声明字符串接收“数组的信息”
//一（订单明细ID）
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');//剪切出来
//二（入库件数）
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三（入库细数）
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
//四(进仓明细ID)
string V = ((string[])JieShouMingXiID)[0];
string[] intsV = V.Split(',');//剪切出来
try
{
B_WareHouseList WareHouse = new B_WareHouseList();
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID
WareHouse.Remember = Request.Form["Remember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门
WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
if (WareHouse.WareHouseID > 0)
{
var ling = (from tbWarHreDiell in myModels.B_WareHouseDetiailList
where tbWarHreDiell.WareHouseID == WareHouse.WareHouseID
select tbWarHreDiell).Count();
if (ling > 0)
{
if (V.Length > 0)
{
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
for (int m = 0; m < intsV.Length; m++)
{
B_WareHouseDetiailList WareHouseDetial = new B_WareHouseDetiailList();
WareHouseDetial.WareHouseDetiailID = Convert.ToInt32(intsV[m]); //进仓单明细ID
WareHouseDetial.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID
WareHouseDetial.OrderFormDetailID = Convert.ToInt32(intsZ[d]); //订单明细ID
WareHouseDetial.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetial.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
WareHouseDetial.YuanMumberOfPack = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetial.YuanSubdivision = Convert.ToDecimal(intsM[E]); //入库件数
myModels.Entry(WareHouseDetial).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();//保存
strMag = "succsse";
H++;
E++;
d++;
}
}
}
}
}
B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtbool.HoveNot = state; //改变是否为冲红单状态
myModels.Entry(wafrtbool).State = EntityState.Modified; //EntityState (生成 using) 这句代码意思把它进行修改
if (myModels.SaveChanges() > 0) //保存
{
returnJson.State = true;
returnJson.Text = "修改成功";
}
else
{
returnJson.State = false;
returnJson.Text = "修改失败";
}
}
else
{
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
}
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state)
{
string strMag = "fali";
ReturnJsonVo returnJson = new ReturnJsonVo();
try
{
//一
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');
//二
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
//判断记录编号是否存在
int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList
where tbWareHouse.Remember == WareHouse.Remember
select tbWareHouse).Count();
if (oldWareHouseRows == 0)
{
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.Remember = Request.Form["Remember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门
WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
if (WareHouse.OrderFormID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 &&
WareHouse.RegisterName != null && WareHouse.RegisterTime != null)
{
myModels.B_WareHouseList.Add(WareHouse);
myModels.SaveChanges();
B_OrderFormList wafrtbool = (from tbbool in myModels.B_OrderFormList
where tbbool.OrderFormID == WareHouse.OrderFormID
select tbbool).Single(); //查询原状态
wafrtbool.ShiFouShouHuo = state; //改变是否为收货状态
myModels.Entry(wafrtbool).State = EntityState.Modified;
myModels.SaveChanges();
B_WareHouseList wafrtboolWa = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboolWa.HoveNot = state; //有无订单
myModels.Entry(wafrtboolWa).State = EntityState.Modified; //EntityState (生成 using) 这句代码意思把它进行修改
if (myModels.SaveChanges() > 0) //保存
{
returnJson.State = true;
returnJson.Text = "修改成功";
}
else
{
returnJson.State = false;
returnJson.Text = "修改失败";
}
B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList();
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID
WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID
WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
WareHouseDetiail.YuanMumberOfPack = Convert.ToDecimal(intsN[H]); //原入库细数
WareHouseDetiail.YuanSubdivision = Convert.ToDecimal(intsM[E]); //原入库件数
myModels.B_WareHouseDetiailList.Add(WareHouseDetiail);
myModels.SaveChanges();//保存
E++;
H++;
strMag = "succsse";
}
}
}
}
else
{
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
}
public ActionResult ChongHongWareHouss(Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state)
{
//一
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');
//二
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
string strMag = "fali";
ReturnJsonVo returnJson = new ReturnJsonVo();
try
{
B_WareHouseList WareHouse = new B_WareHouseList();
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.Remember = Request.Form["Remember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点
WareHouse.Appendix = Request.Form["Appendix"]; //附件张数
WareHouse.Evidences = Request.Form["Evidences"]; //原始单号
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人ID
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人
WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间
myModels.B_WareHouseList.Add(WareHouse);
myModels.SaveChanges();
if (WareHouse.WareHouseID > 0)
{
B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList();
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID
WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //商品ID
WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
myModels.B_WareHouseDetiailList.Add(WareHouseDetiail);
myModels.SaveChanges(); //保存
H++;
E++;
}
}
}
B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtbool.ExamineNot = state; //改变审核
myModels.Entry(wafrtbool).State = EntityState.Modified;
B_WareHouseList wafrtboodl = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboodl.Status = state; //改变生效
myModels.Entry(wafrtboodl).State = EntityState.Modified;
B_WareHouseList wafrtboosdl = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboosdl.CrushRedNot = state; //改变冲红
myModels.Entry(wafrtboosdl).State = EntityState.Modified;
if (myModels.SaveChanges() > 0)//保存
{
returnJson.State = true;
returnJson.Text = "修改成功";
}
else
{
returnJson.State = false;
returnJson.Text = "修改失败";
}
strMag = "success";
}
//return Json("success", JsonRequestBehavior.AllowGet);
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
}
public ActionResult UptaleJingCangDan(Array JieShouMingXiID, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu)
{
string strMag = "fali";
//一（订单明细ID）
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');
//二（入库件数）
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三（入库细数）
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
//四(进仓明细ID)
string V = ((string[])JieShouMingXiID)[0];
string[] intsV = V.Split(',');
try
{
B_WareHouseList WareHouse = new B_WareHouseList();
WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.Remember = Request.Form["Remember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点
WareHouse.Appendix = Request.Form["Appendix"]; //附件张数
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
if (WareHouse.WareHouseID > 0)
{
var ling = (from tbWarHreDiell in myModels.B_WareHouseDetiailList
where tbWarHreDiell.WareHouseID == WareHouse.WareHouseID
select tbWarHreDiell).Count();
if (ling > 0)
{
if (V.Length > 0)
{
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
for (int m = 0; m < intsV.Length; m++)
{
B_WareHouseDetiailList WareHouseDetial = new B_WareHouseDetiailList();
WareHouseDetial.WareHouseDetiailID = Convert.ToInt32(intsV[m]); //进仓单明细ID
WareHouseDetial.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID
WareHouseDetial.OrderFormDetailID = Convert.ToInt32(intsZ[d]); //商品ID
WareHouseDetial.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetial.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
myModels.Entry(WareHouseDetial).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();//保存
H++;
E++;
d++;
}
}
}
}
}
return(Json("sussec", JsonRequestBehavior.AllowGet));
}
else
{
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu)
{
string strMag = "fali";
//添加（这个类（bit 类型类））
ReturnJsonVo returnJson = new ReturnJsonVo();
try
{
//一
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');
//二
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
//判断记录编号是否存在
int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList
where tbWareHouse.Remember == WareHouse.Remember
select tbWareHouse).Count();
if (oldWareHouseRows == 0)
{
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.Remember = Request.Form["Remember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门（采购）
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点（销售部门）
WareHouse.Appendix = Request.Form["Appendix"]; //附件张数
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
if (WareHouse.QuFenLeiXingID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 &&
WareHouse.RegisterName != null && WareHouse.RegisterTime != null && WareHouse.OrderFormPactID > 0)
{
myModels.B_WareHouseList.Add(WareHouse);
myModels.SaveChanges();
B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList();
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID
WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID
WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
myModels.B_WareHouseDetiailList.Add(WareHouseDetiail);
myModels.SaveChanges(); //保存
E++;
H++;
}
}
}
}
else
{
return(Json("fali", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state)
{
string strMag = "fali";
//添加（这个类（bit 类型类））
ReturnJsonVo returnJson = new ReturnJsonVo();
try
{
//声明字符串接收“数组的信息”
//一
string Z = ((string[])JieShouID)[0];
string[] intsZ = Z.Split(',');//剪切出来
//二
string M = ((string[])JieShouJianShu)[0];
string[] intsM = M.Split(',');
//三
string N = ((string[])JieShouRuKuXiShu)[0];
string[] intsN = N.Split(',');
//判断记录编号是否存在
int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList
where tbWareHouse.Remember == WareHouse.Remember
select tbWareHouse).Count();
if (oldWareHouseRows == 0)
{
WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID
WareHouse.Remember = Request.Form["CrRemember"]; //记录编号
WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门
WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID
WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID
WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点
WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人
WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间
WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人
WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人
WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间
WareHouse.Appendix = Request.Form["Appendix"]; //附件
WareHouse.Evidences = Request.Form["Evidences"]; //原始单号
if (WareHouse.OrderFormID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 &&
WareHouse.RegisterName != null && WareHouse.RegisterTime != null && WareHouse.ExamineName != null && WareHouse.ExamineTime != null)
{
myModels.B_WareHouseList.Add(WareHouse);
myModels.SaveChanges();
if (WareHouse.WareHouseID > 0)
{
B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList();
for (int H = 0; H < intsN.Length;)
{
for (int E = 0; E < intsM.Length;)
{
for (int d = 0; d < intsZ.Length; d++)
{
WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID
WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID
WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数
WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数
myModels.B_WareHouseDetiailList.Add(WareHouseDetiail);
myModels.SaveChanges(); //保存
H++;
E++;
}
}
}
B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtbool.CrushRedNot = state; //改变是否为冲红单状态
myModels.Entry(wafrtbool).State = EntityState.Modified;
B_WareHouseList wafrtboodl = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboodl.ExamineNot = state; //改变审核状态
myModels.Entry(wafrtboodl).State = EntityState.Modified;
B_WareHouseList wafrtboole = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboole.Status = state; //改变生效状态
myModels.Entry(wafrtboole).State = EntityState.Modified;
B_WareHouseList wafrtboojgfle = (from tbbool in myModels.B_WareHouseList
where tbbool.WareHouseID == WareHouse.WareHouseID
select tbbool).Single(); //查询原状态
wafrtboojgfle.HoveNot = state; //改变是否订单
myModels.Entry(wafrtboojgfle).State = EntityState.Modified;
if (myModels.SaveChanges() > 0)//保存
{
returnJson.State = true;
returnJson.Text = "修改成功";
}
else
{
returnJson.State = false;
returnJson.Text = "修改失败";
}
}
}
else
{
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
}
