private ProdDetails GetModelFromDataReader(SqlDataReader dr)
{
ProdDetails model = new ProdDetails();
model.ProdOrdID = dr["ProdOrdID"].ToDBString();
model.StartDate = dr["StartDate"].ToDateTime();
model.EndDate = dr["EndDate"].ToDateTime();
model.PInvtID = dr["PInvtID"].ToDBString();
model.QtytoProd = dr["QtytoProd"].ToDecimal();
model.LotSerNbr = dr["LotSerNbr"].ToDBString();
model.ProdDate = dr["ProdDate"].ToDateTime();
model.ShipDate = dr["ShipDate"].ToDateTime();
model.SiteID = dr["SiteID"].ToDBString();
model.WhseLoc = dr["WhseLoc"].ToDBString();
model.Remark2 = dr["Remark2"].ToCHString();
model.SONbr = dr["SONbr"].ToDBString();
model.MInvtID = dr["MInvtID"].ToDBString();
model.QtyReq = dr["QtyReq"].ToDecimal();
model.Allergic = dr["Allergic"].ToCHString();
model.CHDesc = dr["CHDesc"].ToCHString();
model.Descr = dr["Descr"].ToDBString();
model.InvtID = dr["InvtID"].ToDBString();
model.InvtType = dr["InvtType"].ToDBString();
model.NetWt = dr["NetWt"].ToDecimal();
model.SceneMaterial = dr["SceneMaterial"].ToDBString();
model.ShelfLife = dr["ShelfLife"].ToInt32();
model.StdGrossWt = dr["StdGrossWt"].ToDecimal();
model.StdTareWt = dr["StdTareWt"].ToDecimal();
model.StkUnit = dr["StkUnit"].ToDBString();
return(model);
}
/// <summary>
/// 获取最近一次的计算数据
/// </summary>
/// <param name="prod"></param>
/// <param name="user"></param>
/// <param name="strError"></param>
/// <returns></returns>
public bool GetLast(ref ProdHead prod, ref UserInfo user, ref string strError)
{
Prod_DB db = new Prod_DB();
using (SqlDataReader dr = db.GetLastProdHead())
{
if (dr.Read())
{
prod = GetAllotMainFromDataReader(dr);
}
}
if (prod == null || prod.AllotID == 0)
{
return(false);
}
prod.lstDetails = new List <ProdDetails>();
using (SqlDataReader dr = db.GetLastProdDetails())
{
while (dr.Read())
{
ProdDetails model = GetAllotDetailsFromDataReader(dr);
prod.lstDetails.Add(model);
}
}
if (prod.lstDetails.Count == 0)
{
return(false);
}
return(true);
}
private ProdDetails GetAllotDetailsFromDataReader(SqlDataReader dr)
{
ProdDetails model = new ProdDetails();
model.InvtID = dr["cInvCode"].ToDBString();
model.QtyReq = dr["QtyReq"].ToDecimal();
model.dTransfer = dr["QtyTransfer"].ToDecimal();
model.CHDesc = dr["CHDesc"].ToCHString();
model.Descr = dr["Descr"].ToDBString();
model.sInvType = dr["sInvType"].ToDBString();
model.WorkShopNo = dr["WorkShopNo"].ToDBString();
model.AllotRowNo = dr["RowNo"].ToInt32();
model.AllotDetailID = dr["AllotDetailID"].ToInt32();
model.iOperate = dr["iOperate"].ToInt32();
model.sOperate = dr["sOperate"].ToDBString();
model.WorkShopNo = dr["WorkShopNo"].ToDBString();
model.WorkshopStock = dr["WorkshopStock"].ToDecimal();
return(model);
}
public bool calcData(List <ProdHead> lstProd, ref ProdHead prod, UserInfo user, ref string strError)
{
prod = new ProdHead();
strError = string.Empty;
#region 制法及建筑获取
Building_Func bf = new Building_Func();
Preparation_Func pf = new Preparation_Func();
List <Building> lstB = new List <Building>();
Building b = new Building();
List <Preparation> lstP = new List <Preparation>();
Preparation p = new Preparation();
bf.GetBuildingList(ref lstB, b, user, ref strError);
pf.GetPreparationList(ref lstP, p, user, ref strError);
foreach (var outer in lstP)
{
foreach (var inner in lstB)
{
if (outer.bid == inner.ID)
{
if (inner.lstP != null)
{
lstP = new List <Preparation>();
}
inner.lstP.Add(outer);
}
}
}
#endregion
List <ProdHead> lstMetaData = new List <ProdHead>();
List <ProdDetails> lstMetaDetails = new List <ProdDetails>();
List <ProdDetails> lstGroupDetails = new List <ProdDetails>();//按物料和建筑编号分组的需求信息
ProdHead TmpProd = new ProdHead();
foreach (var item in lstProd)
{
GetProdDetailByProdOrdID(item, ref TmpProd, ref strError);
lstMetaData.Add(TmpProd);
}
List <string> lstMinvtID = new List <string>();
foreach (var item in lstMetaData)
{
lstMinvtID = lstMinvtID.Union <string>(item.lstDetails.Select(s => s.MInvtID).Distinct().ToList()).ToList();
}
string workShopNo = string.Empty;
foreach (var item in lstMetaData)
{
item.BuildingNo = lstB.FirstOrDefault(s => s.lstP.Exists(x => x.pCode.Equals(item.ProdMgrID))).bNo;
workShopNo = lstB.FirstOrDefault(s => s.lstP.Exists(x => x.pCode.Equals(item.ProdMgrID))).WareHouseNo;
foreach (var detail in item.lstDetails)
{
detail.ProdMgrID = item.ProdMgrID;
detail.BuildingNo = item.BuildingNo;
detail.WorkShopNo = workShopNo;
detail.iGrade = lstB.FirstOrDefault(s => s.bNo.Equals(detail.BuildingNo)).iGrade;
}
lstMetaDetails.AddRange(item.lstDetails);
}
foreach (var item in lstMetaDetails)
{
ProdDetails model = lstGroupDetails.Find(s => s.BuildingNo.Equals(item.BuildingNo) && s.MInvtID.Equals(item.MInvtID));
if (model == null)
{
lstGroupDetails.Add(item);
}
else
{
model.QtyReq += item.QtyReq;
}
}
lstGroupDetails = (from model in lstGroupDetails orderby model.InvtID, model.iGrade select model).ToList();
string strArrayMaterialNo = string.Empty;
foreach (var item in lstMinvtID)
{
strArrayMaterialNo += item;
}
strArrayMaterialNo = strArrayMaterialNo.Substring(0, strArrayMaterialNo.Length - 1);
#region 获取线边仓及车间仓库存
Stock_DB stb = new Stock_DB();
List <StockHead_Model> lstStockSum = new List <StockHead_Model>();
stb.QueryStockSumForTransfer(out lstStockSum, strArrayMaterialNo, out strError);
#endregion
List <StockReader> lstReader = new List <StockReader>();
foreach (var item in lstGroupDetails)
{
StockReader sr = lstReader.Find(s => s.InvtID.Equals(item.InvtID));
bool bFound = true;
if (string.IsNullOrEmpty(sr.InvtID))
{
bFound = false;
sr = new StockReader();
sr.InvtID = item.InvtID;
sr.workshopStock = lstStockSum.FirstOrDefault(model => model.MaterialNo == item.InvtID && model.WarehouseNo == item.WorkShopNo).iQuantity;
sr.currentStock = lstStockSum.FirstOrDefault(model => model.MaterialNo == item.InvtID && model.WarehouseNo == "01").iQuantity;
}
if (bFound)//获取当前料车间库存
{
sr.workshopStock = lstStockSum.FirstOrDefault(model => model.MaterialNo == item.InvtID && model.WarehouseNo == item.WorkShopNo).iQuantity;
}
item.CurrentStock = sr.currentStock;
item.WorkshopStock = sr.workshopStock;
if (item.SceneMaterial.Trim().Equals("1"))//现场物料，不用返还
{
item.sInvType = "现场物料";
if (item.QtyReq <= sr.workshopStock)
{
item.iOperate = 0;
item.sOperate = "无动作";
}
else
{
item.iOperate = 1;
item.sOperate = "领料";
if (item.QtyReq - sr.workshopStock <= sr.currentStock - sr.useageStock)
{
item.dTransfer = item.QtyReq - sr.workshopStock;
sr.useageStock += item.QtyReq - sr.workshopStock;
}
else
{
item.dTransfer = sr.currentStock - sr.useageStock;
sr.useageStock = sr.currentStock;
}
}
}
else if (bMustReturn(item))
{
item.sInvType = "必返品";
item.iOperate = -2;
if (item.QtyReq <= sr.workshopStock)
{
//item.iOperate = item.QtyReq == sr.workshopStock ? 0 : -2;
item.sOperate = item.QtyReq == sr.workshopStock ? "无动作" : "返料";
item.dTransfer = sr.workshopStock - item.QtyReq;
}
else
{
//item.iOperate = 1;
item.sOperate = "领料";
if (item.QtyReq - sr.workshopStock <= sr.currentStock - sr.useageStock)
{
item.dTransfer = item.QtyReq - sr.workshopStock;
sr.useageStock += item.QtyReq - sr.workshopStock;
}
else
{
item.dTransfer = sr.currentStock - sr.useageStock;
sr.useageStock = sr.currentStock;
}
}
}
else//普通料
{
item.sInvType = "普通料";
if (item.QtyReq <= sr.workshopStock)
{
item.iOperate = item.QtyReq == sr.workshopStock ? 0 : -1;
item.sOperate = item.QtyReq == sr.workshopStock ? "无动作" : "返料";
item.dTransfer = sr.workshopStock - item.QtyReq;
}
else
{
item.iOperate = 1;
item.sOperate = "领料";
if (item.QtyReq - sr.workshopStock <= sr.currentStock - sr.useageStock)
{
item.dTransfer = item.QtyReq - sr.workshopStock;
sr.useageStock += item.QtyReq - sr.workshopStock;
}
else
{
item.dTransfer = sr.currentStock - sr.useageStock;
sr.useageStock = sr.currentStock;
}
}
}
if (!bFound)
{
lstReader.Add(sr);
}
}
prod.lstDetails = lstGroupDetails;
#region 给实体类赋伪值，防止部分需要回写属性不被序列化
prod.AllotNo = "0000";
prod.AllotID = 0;
prod.AllotDate = DateTime.MaxValue;
prod.AllotUserNo = "NO ONE";
foreach (var item in prod.lstDetails)
{
item.AllotDetailID = 0;
item.AllotRowNo = 0;
}
#endregion
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("data_xml", SqlDbType.Xml),
new SqlParameter("strUserNo", SqlDbType.NVarChar),
new SqlParameter("strErrMsg", SqlDbType.NVarChar, 1000),
};
param[0].Direction = ParameterDirection.Input;
param[1].Direction = ParameterDirection.Input;
param[2].Direction = ParameterDirection.Output;
param[0].Size = 3000;
param[1].Size = 20;
param[2].Size = 1000;
param[0].Value = XMLUtil.XmlUtil.Serializer(typeof(ProdHead), prod);
param[1].Value = user.UserNo;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_SaveTransfer", param);
string ErrorMsg = param[2].Value.ToDBString();
if (ErrorMsg.StartsWith("execution error"))
{
throw new Exception(ErrorMsg);
}
prod = (ProdHead)XMLUtil.XmlUtil.Deserialize(typeof(ProdHead), param[0].Value.ToString());
return(true);
}
