/// <summary>
/// 删除（转库单）
/// </summary>
/// <returns></returns>
public ActionResult DeleteChanger(int changeID)
{
string strMsg = "fail";
try
{
B_ChangeList conver = (from tbWarHouser in myModels.B_ChangeList
where tbWarHouser.ChangeID == changeID
select tbWarHouser).Single();
myModels.B_ChangeList.Remove(conver);
int waDetialid = (int)conver.ChangeID;
//查询对应对应明细（总数量）
var converDetial = (from tbWarHouserDetial in myModels.B_ChangeDetailList
where tbWarHouserDetial.ChangeID == changeID
select tbWarHouserDetial).ToList();
int thyCount = converDetial.Count();
if (thyCount > 0)
{
for (int i = 0; i < thyCount; i++)
{
myModels.B_ChangeDetailList.Remove(converDetial[i]);
myModels.SaveChanges();
strMsg = "success";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 记录编号
/// </summary>
/// <returns></returns>
public ActionResult getEmpCode()
{
string Std = "";
var listy = (from tbem in myModels.B_ChangeList
orderby tbem.Remember
select tbem).ToList();
if (listy.Count > 0)
{
int intcoun = listy.Count;
B_ChangeList mymodell = listy[intcoun - 1];
int inemp = Convert.ToInt32(mymodell.Remember.Substring(1, 8));
inemp++;
Std = inemp.ToString();
for (int i = 0; i < 8; i++)
{
Std = Std.Length < 8 ? "0" + Std : Std;
}
}
else
{
Std = "00000001";
}
return(Json(Std, JsonRequestBehavior.AllowGet));
}
public ActionResult ShenheaiDan(B_ChangeList OK, bool state)
{
ReturnJsonVo returnJson = new ReturnJsonVo();
string strMag = "fali";
try
{
B_ChangeList MyB_ConverList = new B_ChangeList();
MyB_ConverList.ChangeID = OK.ChangeID;
MyB_ConverList.WareHouseID = OK.WareHouseID;
MyB_ConverList.Remember = OK.Remember;
MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID;
MyB_ConverList.StockPlaceID = OK.StockPlaceID;
MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo;
MyB_ConverList.payName = OK.payName;
MyB_ConverList.furlName = OK.furlName;
MyB_ConverList.RegisterName = OK.RegisterName;
MyB_ConverList.RegisterTime = OK.RegisterTime;
MyB_ConverList.ShiFouGou = OK.ShiFouGou;
MyB_ConverList.ExamineName = OK.ExamineName;
MyB_ConverList.ExamineTime = OK.ExamineTime;
myModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
B_ChangeList wafrtbool = (from tbbool in myModels.B_ChangeList
where tbbool.ChangeID == MyB_ConverList.ChangeID
select tbbool).Single(); //查询原状态
wafrtbool.ExamineNot = state;
myModels.Entry(wafrtbool).State = EntityState.Modified;
if (myModels.SaveChanges() > 0)//保存
{
returnJson.State = true;
returnJson.Text = "修改成功";
}
else
{
returnJson.State = false;
returnJson.Text = "修改失败";
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
}
public ActionResult UptoctPeiZaiDan(B_ChangeList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array JiZhuanidShu)
{
string strMag = "fali";
try
{
//一
string Z = ((string[])JiShangPiID)[0];
string[] intsid = Z.Split(',');
//二
string M = ((string[])JiRuJianShu)[0];
string[] intsRuJian = M.Split(',');
//三
string N = ((string[])JiRuXiShu)[0];
string[] intsNXiShu = N.Split(',');
//四id
string idc = ((string[])JiZhuanidShu)[0];
string[] intsidcXiShu = idc.Split(',');
B_ChangeList MyB_ConverList = new B_ChangeList();
MyB_ConverList.ChangeID = OK.ChangeID;
MyB_ConverList.WareHouseID = OK.WareHouseID;
MyB_ConverList.Remember = OK.Remember;
MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID;
MyB_ConverList.StockPlaceID = OK.StockPlaceID;
MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo;
MyB_ConverList.payName = OK.payName;
MyB_ConverList.furlName = OK.furlName;
MyB_ConverList.RegisterName = OK.RegisterName;
MyB_ConverList.RegisterTime = OK.RegisterTime;
MyB_ConverList.ShiFouGou = OK.ShiFouGou;
myModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified;
if (myModels.SaveChanges() > 0)
{
strMag = "succsee";
B_ChangeDetailList ConverDeTailList = new B_ChangeDetailList();
for (int H = 0; H < intsNXiShu.Length;)
{
for (int E = 0; E < intsRuJian.Length;)
{
for (int d = 0; d < intsid.Length;)
{
for (int idx = 0; idx < intsidcXiShu.Length; idx++)
{
ConverDeTailList.ChangeDetailID = Convert.ToInt32(intsidcXiShu[idx]); //转库ID
ConverDeTailList.ChangeID = MyB_ConverList.ChangeID; //返仓ID
ConverDeTailList.WareHouseDetiailID = Convert.ToInt32(intsid[d]);; //进仓明细ID
ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数
ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数
myModels.Entry(ConverDeTailList).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges(); //保存
d++;
H++;
E++;
}
}
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
public ActionResult InsectPeiZaiDan(B_ChangeList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu)
{
string strMag = "fali";
try
{
//一
string Z = ((string[])JiShangPiID)[0];
string[] intsid = Z.Split(',');
//二
string M = ((string[])JiRuJianShu)[0];
string[] intsRuJian = M.Split(',');
//三
string N = ((string[])JiRuXiShu)[0];
string[] intsNXiShu = N.Split(',');
int oldWareHouseRows = (from tb in myModels.B_ChangeList
where tb.Remember == OK.Remember
select tb).Count();
if (oldWareHouseRows == 0)
{
B_ChangeList MyB_ConverList = new B_ChangeList();
MyB_ConverList.WareHouseID = OK.WareHouseID;
MyB_ConverList.Remember = OK.Remember;
MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID;
MyB_ConverList.StockPlaceID = OK.StockPlaceID;
MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo;
MyB_ConverList.payName = OK.payName;
MyB_ConverList.furlName = OK.furlName;
MyB_ConverList.RegisterName = OK.RegisterName;
MyB_ConverList.RegisterTime = OK.RegisterTime;
MyB_ConverList.ShiFouGou = OK.ShiFouGou;
myModels.B_ChangeList.Add(MyB_ConverList);
if (myModels.SaveChanges() > 0)
{
strMag = "succsee";
B_ChangeDetailList ConverDeTailList = new B_ChangeDetailList();
for (int H = 0; H < intsNXiShu.Length;)
{
for (int E = 0; E < intsRuJian.Length;)
{
for (int d = 0; d < intsid.Length; d++)
{
ConverDeTailList.ChangeID = MyB_ConverList.ChangeID; //返仓ID
ConverDeTailList.WareHouseDetiailID = Convert.ToInt32(intsid[d]);; //进仓明细ID
ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数
ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数
myModels.B_ChangeDetailList.Add(ConverDeTailList);
myModels.SaveChanges();//保存
H++;
E++;
}
}
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMag, JsonRequestBehavior.AllowGet));
}
