/// <summary>
/// 添加物料入仓
/// </summary>
private void AddEnterWareHouse(HttpContext context)
{
Model.domain_EnterWareHouseLog log = new Model.domain_EnterWareHouseLog()
{
OrderID = context.Request["OrderID"]??"",
MaterialName = context.Request["MaterialName"]??"",
ModelNumber = context.Request["ModelNumber"] ?? "",
CategoryName = context.Request["CategoryName"] ?? "",
UnitName = context.Request["UnitName"]??"",
Amout = decimal.Parse(context.Request["Amout"]??""),
WareHouseID = NCore.DataConvert.ToInt(context.Request["WareHouseID"],0),
WareHouseName = context.Request["WareHouseName"]??"",
Suppliers = context.Request["Suppliers"]??"",
Remark = context.Request["Remark"]??"",
DealWithBy = context.Request["DealWithBy"] ?? "",
Department = context.Request["Department"] ?? "",
DoBy = context.Request["DoBy"] ?? "",
DoTime = DateTime.Now
};
db.domain_EnterWareHouseLog.Add(log);
int num = db.SaveChanges();
}
/// <summary>
/// 添加物料入仓
/// </summary>
private void AddEnterWareHouse(HttpContext context)
{
int WareHouseID = NCore.DataConvert.ToInt(context.Request["WareHouseID"],0);
string WareHouseName = context.Request["WareHouseName"] ?? "";
string MaterialName = context.Request["MaterialName"]??"";
string ModelNumber = context.Request["ModelNumber"] ?? "";
decimal Amout = decimal.Parse(context.Request["Amout"] ?? "");
Model.domain_EnterWareHouseLog log = new Model.domain_EnterWareHouseLog()
{
OrderID = context.Request["OrderID"]??"",
MaterialName = MaterialName,
ModelNumber = ModelNumber,
CategoryName = context.Request["CategoryName"] ?? "",
UnitName = context.Request["UnitName"]??"",
Amout = Amout,
WareHouseID = WareHouseID,
WareHouseName = WareHouseName,
Suppliers = context.Request["Suppliers"]??"",
Remark = context.Request["Remark"]??"",
DealWithBy = context.Request["DealWithBy"] ?? "",
Department = context.Request["Department"] ?? "",
DoBy = context.Request["DoBy"] ?? "",
DoTime = DateTime.Now
};
db.domain_EnterWareHouseLog.Add(log);
int num = db.SaveChanges();
if (num > 0) //日志录入成功
{
List<domain_Material_WareHouse> list = db.domain_Material_WareHouse
.Where(w => w.WareHouseID == WareHouseID
&& w.MaterialName == MaterialName
&& w.MaterialModelNumber == ModelNumber)
.ToList();
if (list.Count > 0)
{ //物料库存表中存在
domain_Material_WareHouse mw = list[0];
//增加库存量
mw.KuCun += Amout;
//先将实体附加到实体上下文中
db.domain_Material_WareHouse.Attach(mw);
//手动修改实体的状态
db.Entry(mw).State = EntityState.Modified;
int r1= db.SaveChanges();
if(r1>0)
{
context.Response.Write("{\"d\":1}");
}
else
{
context.Response.Write("{\"d\":0,\"msg\":\"保存失败！\"}");
}
}
else
{ //物料库存表中不存在
domain_Material_WareHouse mw = new domain_Material_WareHouse()
{
KuCun = Amout,
MaterialModelNumber = ModelNumber,
MaterialName = MaterialName,
WareHouseID = WareHouseID,
WareHouseName = WareHouseName
};
db.domain_Material_WareHouse.Add(mw);
int r1 = db.SaveChanges();
if (r1 > 0)
{
context.Response.Write("{\"d\":1}");
}
else
{
context.Response.Write("{\"d\":0,\"msg\":\"保存失败！\"}");
}
}
}
else
{
context.Response.Write("{\"d\":0,\"msg\":\"保存失败！\"}");
}
}
