private void ProcessDetail(IList <string> entStrList, CombineSplit csEnt)
{
if (entStrList != null && entStrList.Count > 0)
{
StockInfo siEnt = new StockInfo();
for (int j = 0; j < entStrList.Count; j++)
{
//组装拆分详细创建
Newtonsoft.Json.Linq.JObject objL = JsonHelper.GetObject <Newtonsoft.Json.Linq.JObject>(entStrList[j]);
CombineSplitDetail csdEnt = new CombineSplitDetail();
csdEnt.CombineSplitId = csEnt.Id;
csdEnt.ProductId = objL.Value <string>("ProductId");
csdEnt.ProductCode = objL.Value <string>("ProductCode");
csdEnt.ProductName = objL.Value <string>("ProductName");
csdEnt.ProductPcn = objL.Value <string>("ProductPcn");
csdEnt.StockQuantity = objL.Value <int>("StockQuantity");
csdEnt.ProductQuantity = objL.Value <int>("ProductQuantity");
csdEnt.DoCreate();
//更新库存
siEnts = StockInfo.FindAllByProperties("ProductId", csdEnt.ProductId, "WarehouseId", csEnt.WarehouseId);
if (siEnts.Count > 0)//如果库存信息存在
{
siEnt = siEnts[0];
if (csEnt.OperateType == "组装")
{
siEnt.StockQuantity -= csdEnt.ProductQuantity;
}
else
{
siEnt.StockQuantity += csdEnt.ProductQuantity;
}
siEnt.DoUpdate();
}
}
siEnts = StockInfo.FindAllByProperties("ProductId", csEnt.ProductId, "WarehouseId", csEnt.WarehouseId);
if (siEnts.Count > 0)
{
siEnt = siEnts[0];
if (csEnt.OperateType == "组装")
{
siEnt.StockQuantity += csEnt.ProductQuantity;
}
else
{
siEnt.StockQuantity -= csEnt.ProductQuantity;
}
siEnt.DoUpdate();
}
}
}
private void DoBatchDelete()
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
foreach (object obj in idList)
{
csEnt = CombineSplit.Find(obj);
siEnt = StockInfo.FindFirstByProperties("ProductId", csEnt.ProductId, "WarehouseId", csEnt.WarehouseId);
csdEnts = CombineSplitDetail.FindAllByProperties("CombineSplitId", csEnt.Id);
if (csEnt.OperateType == "组装")
{
siEnt.StockQuantity -= csEnt.ProductQuantity;
siEnt.DoUpdate();
foreach (CombineSplitDetail csdEnt in csdEnts)
{
siEnt = StockInfo.FindFirstByProperties("ProductId", csdEnt.ProductId, "WarehouseId", csEnt.WarehouseId);
siEnt.StockQuantity += csdEnt.ProductQuantity;
siEnt.DoUpdate();
csdEnt.DoDelete();
}
}
else
{
siEnt.StockQuantity += csEnt.ProductQuantity;
siEnt.DoUpdate();
foreach (CombineSplitDetail csdEnt in csdEnts)
{
siEnt = StockInfo.FindFirstByProperties("ProductId", csdEnt.ProductId, "WarehouseId", csEnt.WarehouseId);
siEnt.StockQuantity -= csdEnt.ProductQuantity;
siEnt.DoUpdate();
csdEnt.DoDelete();
}
}
csEnt.DoDelete();
}
}
}
string type = String.Empty; // 对象类型
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
switch (this.RequestAction)
{
case RequestActionEnum.Insert:
case RequestActionEnum.Create:
//添加库存数量
string WarehouseId = RequestData.Get <string>("WarehouseId");
string WarehouseName = RequestData.Get <string>("WarehouseName");
string json = RequestData.Get <string>("json");
Dictionary <string, object> dic = null;
json = json.Substring(1, json.Length - 2);
string[] objarr = json.Replace("},{", "#").Split('#');
for (int i = 0; i < objarr.Length; i++)
{
if (objarr.Length == 1)
{
dic = FromJson(objarr[i]) as Dictionary <string, object>;
}
else
{
if (i == 0)
{
dic = FromJson(objarr[i] + "}") as Dictionary <string, object>;
}
else if (i == objarr.Length - 1)
{
dic = FromJson("{" + objarr[i]) as Dictionary <string, object>;
}
else
{
dic = FromJson("{" + objarr[i] + "}") as Dictionary <string, object>;
}
}
if (dic != null)
{
StockInfo stoinfo = StockInfo.FindAllByProperties("ProductId", dic["Id"], "WarehouseId", WarehouseId).FirstOrDefault <StockInfo>();
if (stoinfo != null)
{
stoinfo.StockQuantity = (stoinfo.StockQuantity == null ? 0 : stoinfo.StockQuantity) + (dic.ContainsKey("Count") ? Convert.ToInt32(dic["Count"]) : 0);
stoinfo.DoUpdate();
}
else
{
stoinfo = new StockInfo
{
ProductCode = dic["Code"] + "",
ProductName = dic["Name"] + "",
ProductId = dic["Id"] + "",
WarehouseId = WarehouseId,
WarehouseName = WarehouseName,
StockQuantity = dic.ContainsKey("Count") ? Convert.ToInt32(dic["Count"]) : 0
};
stoinfo.DoCreate();
}
}
}
break;
}
}
/// <summary>
/// 更新库存
/// </summary>
/// <param name="childjson">出库单出库商品json</param>
private void UpdateStockInfo(IList <string> strList, DeliveryOrder deorder)
{
string db = ConfigurationManager.AppSettings["ExamineDB"];
string strguids = "";
Dictionary <string, object> dic = null;
StockInfo stoinfo = null;
for (int i = 0; i < strList.Count; i++)
{
dic = FromJson(strList[i]) as Dictionary <string, object>;
if (dic != null)
{
//记录日志begin
if (dic.ContainsKey("SmCount") && dic["SmCount"] + "" != "")
{
StockLog slEnt = new StockLog();//创建库存变更日志
slEnt.InOrOutDetailId = dic["Id"] + "";
slEnt.InOrOutBillNo = deorder.Number;
slEnt.OperateType = "产品出库";
slEnt.WarehouseId = deorder.WarehouseId;
slEnt.WarehouseName = deorder.WarehouseName;
IList <StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, dic["ProductId"], StockInfo.Prop_WarehouseId, deorder.WarehouseId);
if (siEnts.Count > 0)
{
slEnt.StockQuantity = siEnts[0].StockQuantity;
}
slEnt.Quantity = Convert.ToInt32(dic["SmCount"]);
slEnt.ProductId = dic["ProductId"] + "";
Product pEnt = Product.Find(dic["ProductId"]);
slEnt.ProductCode = pEnt.Code;
slEnt.ProductName = pEnt.Name;
slEnt.ProductIsbn = pEnt.Isbn;
slEnt.ProductPcn = pEnt.Pcn;
slEnt.DoCreate();
}
//记录日志end
//更新唯一编号的状态
if (dic.ContainsKey("Guids") && dic["Guids"] + "" != "")
{
string guids = dic["Guids"] + "";
guids = guids.Substring(0, guids.Length - 1);
strguids = "'" + guids.Replace(",", "','") + "'";
DataHelper.ExecSql("update " + db + "..Compressor set [state]='已出库',CustomerId='" + deorder.CId + "',DeliveryOrderId='" + deorder.Id + "' where SeriesNo in (" + strguids + ")");
}
//更新库存 OutCount
stoinfo = StockInfo.FindAllByProperties("ProductId", dic["ProductId"], "WarehouseId", deorder.WarehouseId).FirstOrDefault <StockInfo>();
if (stoinfo != null)
{
//SmCount 本次出库数量
stoinfo.StockQuantity -= (dic.ContainsKey("SmCount") && dic["SmCount"] + "" != "" ? Convert.ToInt32(dic["SmCount"]) : 0);
stoinfo.DoUpdate();
}
else
{
stoinfo = new StockInfo
{
ProductCode = dic["Code"] + "",
ProductId = dic["ProductId"] + "",
ProductName = dic["Name"] + "",
StockQuantity = -(dic.ContainsKey("SmCount") && dic["SmCount"] + "" != "" ? Convert.ToInt32(dic["SmCount"]) : 0),
WarehouseId = deorder.WarehouseId,
WarehouseName = deorder.WarehouseName
};
stoinfo.DoCreate();
}
}
}
}