/// <summary>
/// 采购退货审核
/// </summary>
/// <param name="MainID"></param>
/// <param name="t">真为入库，假为出库</param>
public void VerifyBack(int MainID, bool t)
{
try
{
Hownet.BLL.StockBack bllSB = new StockBack();
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
Hownet.Model.StockBack modSB = bllSB.GetModel(MainID);
Hownet.Model.StockBackInfo modSBI = new Hownet.Model.StockBackInfo();
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + MainID + ")").Tables[0]);
if (li.Count > 0)
{
Hownet.Model.Repertory modRep = new Hownet.Model.Repertory();
for (int i = 0; i < li.Count; i++)
{
if (li[i].DemandID > 0)
{
modRep = GetModel(li[i].DemandID);
modRep.Amount = li[i].Amount;
InOrOut(modRep, t);
}
if (li[i].StockInfoID > 0)
{
modSBI = bllSBI.GetModel(li[i].StockInfoID);
if (!t)
{
modSBI.NotAmount += li[i].Amount;
modSBI.NotPriceAmount += li[i].Amount;
}
else
{
modSBI.NotAmount -= li[i].Amount;
modSBI.NotPriceAmount -= li[i].Amount;
}
bllSBI.Update(modSBI);
}
}
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// 审核外协来料单
/// </summary>
/// <param name="MainID"></param>
/// <param name="IsVerify"></param>
/// <param name="VerifyManID"></param>
/// <returns></returns>
public int VerifyWXIn(int MainID, bool IsVerify, int VerifyManID)
{
try
{
Hownet.Model.StockBack modSB = GetModel(MainID);
if (IsVerify)
{
modSB.IsVerify = 3;
modSB.VerifyDate = DateTime.Now;
modSB.VerifyMan = VerifyManID;
}
else
{
modSB.IsVerify = 1;
modSB.VerifyDate = Convert.ToDateTime("1900-1-1");
modSB.VerifyMan = 0;
}
Update(modSB);
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
Hownet.BLL.MaterielList bllML = new MaterielList();
Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList();
Hownet.Model.StockBackInfo modSBI;
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + modSB.ID + ")").Tables[0]);
Hownet.BLL.Repertory bllR = new Repertory();
Hownet.Model.Repertory modR;
if (li.Count > 0)
{
for (int i = 0; i < li.Count; i++)
{
if (li[i].StockInfoID > 0)
{
modSBI = bllSBI.GetModel(li[i].StockInfoID);
if (IsVerify)
{
modSBI.NotPriceAmount += li[i].Amount;
modSBI.NotAmount -= li[i].Amount;
}
else
{
modSBI.NotPriceAmount -= li[i].Amount;
modSBI.NotAmount += li[i].Amount;
}
li[i].NotPriceAmount = modSBI.NotPriceAmount;
li[i].NotAmount = modSBI.NotAmount;
bllSBI.Update(li[i]);
bllSBI.Update(modSBI);
}
if (li[i].MListID == 0)
{
modML.BrandID = li[i].BrandID;
modML.ColorID = li[i].ColorID;
modML.ColorOneID = li[i].ColorOneID;
modML.ColorTwoID = li[i].ColorTwoID;
modML.SizeID = li[i].SizeID;
modML.MaterielID = li[i].MaterielID;
modML.MeasureID = li[i].CompanyMeasureID;
modML.SpecID = 0;
li[i].MListID = bllML.GetID(modML);
bllSBI.Update(li[i]);
}
modR = new Hownet.Model.Repertory();
modR.Amount = li[i].Amount;
modR.MListID = li[i].MListID;
modR.MeasureID = li[i].CompanyMeasureID;
modR.DepartmentID = modSB.DepotID;
modR.BrandID = li[i].BrandID;
modR.BrandName = li[i].BrandName;
modR.ColorID = li[i].ColorID;
modR.ColorName = li[i].ColorName;
modR.ColorOneID = li[i].ColorOneID;
modR.ColorOneName = li[i].ColorOneName;
modR.ColorTwoID = li[i].ColorTwoID;
modR.ColorTwoName = li[i].ColorTwoName;
modR.CompanyID = li[i].CompanyID;
modR.CompanyName = string.Empty;
modR.DeparmentName = string.Empty;
modR.DepartmentID = modSB.DepotID;
modR.DepotInfoID = 0;
modR.DepotInfoName = string.Empty;
modR.ID = 0;
modR.MaterielID = li[i].MaterielID;
modR.MaterielName = li[i].MaterielName;
modR.MeasureName = string.Empty;
modR.PlanID = 0;
modR.Remark = string.Empty;
modR.SizeID = li[i].SizeID;
modR.SizeName = li[i].SizeName;
modR.SpecID = li[i].SpecID;
modR.SpecName = li[i].SpecName;
modR.SupplierID = 0;
modR.SupplierName = string.Empty;
modR.SupplierSN = string.Empty;
bllR.InOrOut(modR, IsVerify);
}
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 审核外协领料单
/// </summary>
/// <param name="MainID"></param>
/// <param name="IsVerify">真为入库，假为出库</param>
/// <param name="VerifyManID"></param>
/// <returns></returns>
public int VerifyWXOut(int MainID, bool IsVerify, int VerifyManID)
{
try
{
Hownet.Model.StockBack modSB = GetModel(MainID);
if (IsVerify)
{
modSB.IsVerify = 3;
modSB.VerifyDate = DateTime.Now;
modSB.VerifyMan = VerifyManID;
}
else
{
modSB.IsVerify = 1;
modSB.VerifyDate = Convert.ToDateTime("1900-1-1");
modSB.VerifyMan = 0;
}
Update(modSB);
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
Hownet.Model.StockBackInfo modSBI;
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + modSB.ID + ")").Tables[0]);
Hownet.BLL.Repertory bllR = new Repertory();
Hownet.Model.Repertory modR;
if (li.Count > 0)
{
for (int i = 0; i < li.Count; i++)
{
if (li[i].StockInfoID > 0)
{
modSBI = bllSBI.GetModel(li[i].StockInfoID);
if (IsVerify)
{
modSBI.NotPriceAmount += li[i].Amount;
modSBI.NotAmount -= li[i].Amount;
}
else
{
modSBI.NotPriceAmount -= li[i].Amount;
modSBI.NotAmount += li[i].Amount;
}
li[i].NotPriceAmount = modSBI.NotPriceAmount;
li[i].NotAmount = modSBI.NotAmount;
bllSBI.Update(li[i]);
bllSBI.Update(modSBI);
}
if (li[i].DemandID > 0)
{
modR = bllR.GetModel(li[i].DemandID);
if (IsVerify)
{
modR.Amount -= li[i].Amount;
if (modR.Amount < 0)
{
modR.Amount = 0;
}
}
else
{
modR.Amount += li[i].Amount;
}
bllR.Update(modR);
}
}
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 审核外协加工单
/// </summary>
/// <param name="MainID"></param>
/// <param name="IsVerify"></param>
/// <param name="VerifyManID"></param>
/// <returns></returns>
public int VerifyWX(int MainID, bool IsVerify, int VerifyManID)
{
try
{
Hownet.Model.StockBack modSB = GetModel(MainID);
if (IsVerify)
{
modSB.IsVerify = 3;
modSB.VerifyDate = DateTime.Now;
modSB.VerifyMan = VerifyManID;
}
else
{
modSB.IsVerify = 1;
modSB.VerifyDate = Convert.ToDateTime("1900-1-1");
modSB.VerifyMan = 0;
}
Update(modSB);
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + modSB.ID + ") And (MListID=0)").Tables[0]);
Hownet.BLL.MaterielList bllML = new MaterielList();
Hownet.Model.MaterielList modML;
if (li.Count > 0)
{
for (int i = 0; i < li.Count; i++)
{
modML = new Hownet.Model.MaterielList();
modML.BrandID = li[i].BrandID;
modML.ColorID = li[i].ColorID;
modML.ColorOneID = li[i].ColorOneID;
modML.ColorTwoID = li[i].ColorTwoID;
modML.MaterielID = li[i].MaterielID;
modML.MeasureID = li[i].CompanyMeasureID;
modML.SizeID = li[i].SizeID;
modML.SpecID = 0;
li[i].MListID = bllML.GetID(modML);
bllSBI.Update(li[i]);
}
}
li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + modSB.ID * -1 + ") And (MListID=0)").Tables[0]);
if (li.Count > 0)
{
for (int i = 0; i < li.Count; i++)
{
modML = new Hownet.Model.MaterielList();
modML.BrandID = li[i].BrandID;
modML.ColorID = li[i].ColorID;
modML.ColorOneID = li[i].ColorOneID;
modML.ColorTwoID = li[i].ColorTwoID;
modML.MaterielID = li[i].MaterielID;
modML.MeasureID = li[i].CompanyMeasureID;
modML.SizeID = li[i].SizeID;
modML.SpecID = 0;
li[i].MListID = bllML.GetID(modML);
bllSBI.Update(li[i]);
}
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.StockBack model)
{
dal.Update(model);
}
/// <summary>
/// 审核/弃审入库单
/// </summary>
/// <param name="ID">入库单ID</param>
/// <param name="t">真为审核入库，假为弃审出库</param>
public void Verify(int ID, bool t, int Depot)
{
Hownet.BLL.SysTem bllST = new SysTem();
Hownet.Model.SysTem modST = bllST.GetModel(bllST.GetMaxId() - 1);
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
Hownet.BLL.MaterielList bllML = new MaterielList();
Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList();
Hownet.BLL.Repertory bllRep = new Repertory();
Hownet.BLL.StockBackInfoList bllSBIL = new StockBackInfoList();
Hownet.BLL.RepertoryList bllRL = new RepertoryList();
List <Hownet.Model.StockBackInfoList> liSBIL;
Hownet.Model.RepertoryList modRL;
Hownet.Model.Repertory modRep;
Hownet.Model.StockBackInfo modSBI;
Hownet.Model.StockBack modSB = GetModel(ID);
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + ID + ")").Tables[0]);
for (int i = 0; i < li.Count; i++)
{
if (li[i].StockInfoID > 0)
{
modSBI = bllSBI.GetModel(li[i].StockInfoID);
modSBI.NotAmount -= li[i].Amount;
//if (dt.Rows[i]["NeedIsEnd"] != null && dt.Rows[i]["NeedIsEnd"] != DBNull.Value && dt.Rows[i]["NeedIsEnd"].ToString() != string.Empty)
// modSBI.IsEnd = Convert.ToInt32(dt.Rows[i]["NeedIsEnd"]);
bllSBI.Update(modSBI);
}
if (li[i].MListID == 0)
{
modML.BrandID = li[i].BrandID;
modML.ColorID = li[i].ColorID;
modML.ColorOneID = li[i].ColorOneID;
modML.ColorTwoID = li[i].ColorTwoID;
modML.SizeID = li[i].SizeID;
modML.MaterielID = li[i].MaterielID;
modML.MeasureID = li[i].CompanyMeasureID;
li[i].MListID = bllML.GetID(modML);
bllSBI.Update(li[i]);
}
liSBIL = bllSBIL.DataTableToList(bllSBIL.GetList("(InfoID=" + li[i].ID + ")").Tables[0]);
if (liSBIL.Count > 0)
{
for (int j = 0; j < liSBIL.Count; j++)
{
if (t)
{
liSBIL[j].BatchNumber = li[i].MListID;
bllSBIL.Update(liSBIL[j]);
modRL = new Hownet.Model.RepertoryList();
modRL.A = 1;
modRL.Amount = modRL.NotAmount = liSBIL[j].Amount;
modRL.BatchNumber = liSBIL[j].BatchNumber;
modRL.DateTime = DateTime.Now;
modRL.DepotInfoID = liSBIL[j].DepotInfoID;
modRL.DepotInfoName = string.Empty;
modRL.ID = 0;
modRL.IsEnd = false;
modRL.MainID = ID;
modRL.Remark = liSBIL[j].Remark;
modRL.SpecID = liSBIL[j].SpecID;
modRL.SpecName = string.Empty;
modRL.StockListID = liSBIL[j].ID;
modRL.QRID = liSBIL[j].ID.ToString();
bllRL.Add(modRL);
}
else
{
bllRL.DeleteByStockInfoID(liSBIL[j].ID);
}
}
}
if ((!modST.MaterielByTask) && (modSB.State != (int)Hownet.BLL.Enums.TableType._采购部收货))
{
modRep = new Hownet.Model.Repertory();
modRep.BrandID = li[i].BrandID;
modRep.ColorID = li[i].ColorID;
modRep.ColorOneID = li[i].ColorOneID;
modRep.ColorTwoID = li[i].ColorTwoID;
modRep.SizeID = li[i].SizeID;
modRep.MaterielID = li[i].MaterielID;
modRep.MeasureID = li[i].CompanyMeasureID;
modRep.MListID = li[i].MListID;
modRep.Amount = li[i].Amount;
modRep.DepartmentID = Depot;
modRep.Price = li[i].Price;
modRep.Money = li[i].Money;
bllRep.InOrOut(modRep, t);
}
if (modSB.State == (int)Hownet.BLL.Enums.TableType._采购部收货)
{
modRep = new Hownet.Model.Repertory();
modRep.BrandID = li[i].BrandID;
modRep.ColorID = li[i].ColorID;
modRep.ColorOneID = li[i].ColorOneID;
modRep.ColorTwoID = li[i].ColorTwoID;
modRep.SizeID = li[i].SizeID;
modRep.MaterielID = li[i].MaterielID;
modRep.MeasureID = li[i].CompanyMeasureID;
modRep.MListID = li[i].MListID;
modRep.Amount = li[i].Amount;
modRep.DepartmentID = Depot;
modRep.Price = li[i].Price;
modRep.Money = li[i].Money;
bllRep.InOrOut(modRep, t);
}
}
// Hownet.Model.StockBack modSB = GetModel(ID);
if (modSB.State == (int)Hownet.BLL.Enums.TableType.P2D)
{
if (modSB.CompanyID > 0)
{
Hownet.BLL.Company bllCom = new Company();
Hownet.Model.Company modCom = bllCom.GetModel(modSB.CompanyID);
if (t)//收货
{
modCom.Weight -= modSB.Weight;
}
else
{
modCom.Weight += modSB.Weight;
}
bllCom.Update(modCom);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.StockBack model)
{
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Hownet.Model.StockBack> DataTableToList(DataTable dt)
{
List <Hownet.Model.StockBack> modelList = new List <Hownet.Model.StockBack>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Hownet.Model.StockBack model;
for (int n = 0; n < rowsCount; n++)
{
model = new Hownet.Model.StockBack();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
else
{
model.ID = 0;
}
if (dt.Rows[n]["DataTime"].ToString() != "")
{
model.DataTime = DateTime.Parse(dt.Rows[n]["DataTime"].ToString());
}
else
{
model.DataTime = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["Num"].ToString() != "")
{
model.Num = int.Parse(dt.Rows[n]["Num"].ToString());
}
else
{
model.Num = 0;
}
if (dt.Rows[n]["CompanyID"].ToString() != "")
{
model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString());
}
else
{
model.CompanyID = 0;
}
model.Remark = dt.Rows[n]["Remark"].ToString();
if (dt.Rows[n]["Money"].ToString() != "")
{
model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString());
}
else
{
model.Money = 0;
}
if (dt.Rows[n]["IsVerify"].ToString() != "")
{
model.IsVerify = int.Parse(dt.Rows[n]["IsVerify"].ToString());
}
else
{
model.IsVerify = 0;
}
if (dt.Rows[n]["VerifyMan"].ToString() != "")
{
model.VerifyMan = int.Parse(dt.Rows[n]["VerifyMan"].ToString());
}
else
{
model.VerifyMan = 0;
}
if (dt.Rows[n]["VerifyDate"].ToString() != "")
{
model.VerifyDate = DateTime.Parse(dt.Rows[n]["VerifyDate"].ToString());
}
else
{
model.VerifyDate = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["DepotID"].ToString() != "")
{
model.DepotID = int.Parse(dt.Rows[n]["DepotID"].ToString());
}
else
{
model.DepotID = 0;
}
if (dt.Rows[n]["LastMoney"].ToString() != "")
{
model.LastMoney = decimal.Parse(dt.Rows[n]["LastMoney"].ToString());
}
else
{
model.LastMoney = 0;
}
if (dt.Rows[n]["BackMoney"].ToString() != "")
{
model.BackMoney = decimal.Parse(dt.Rows[n]["BackMoney"].ToString());
}
else
{
model.BackMoney = 0;
}
if (dt.Rows[n]["FillDate"].ToString() != "")
{
model.FillDate = DateTime.Parse(dt.Rows[n]["FillDate"].ToString());
}
else
{
model.FillDate = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["FillMan"].ToString() != "")
{
model.FillMan = int.Parse(dt.Rows[n]["FillMan"].ToString());
}
else
{
model.FillMan = 0;
}
if (dt.Rows[n]["UpData"].ToString() != "")
{
model.UpData = int.Parse(dt.Rows[n]["UpData"].ToString());
}
else
{
model.UpData = 0;
}
if (dt.Rows[n]["State"].ToString() != "")
{
model.State = int.Parse(dt.Rows[n]["State"].ToString());
}
else
{
model.State = 0;
}
if (dt.Rows[n]["BackDate"].ToString() != "")
{
model.BackDate = DateTime.Parse(dt.Rows[n]["BackDate"].ToString());
}
else
{
model.BackDate = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["TaskID"].ToString() != "")
{
model.TaskID = int.Parse(dt.Rows[n]["TaskID"].ToString());
}
else
{
model.TaskID = 0;
}
model.StockRemark = dt.Rows[n]["StockRemark"].ToString();
if (dt.Rows[n]["DeparmentType"] != null && dt.Rows[n]["DeparmentType"].ToString() != "")
{
model.DeparmentType = int.Parse(dt.Rows[n]["DeparmentType"].ToString());
}
if (dt.Rows[n]["Weight"] != null && dt.Rows[n]["Weight"].ToString() != "")
{
model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString());
}
if (dt.Rows[n]["OtherTypeID"] != null && dt.Rows[n]["OtherTypeID"].ToString() != "")
{
model.OtherTypeID = int.Parse(dt.Rows[n]["OtherTypeID"].ToString());
}
model.A = int.Parse(dt.Rows[n]["A"].ToString());
modelList.Add(model);
}
}
return(modelList);
}
/// <param name="t">真为审核入库，假为弃审出库</param>
public bool VerifyStock(int MainID, int PackID, bool t, int VerifyMan)
{
try
{
Hownet.BLL.StockBack bllSB = new StockBack();
Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo();
Hownet.BLL.Repertory bllRep = new Repertory();
Hownet.BLL.Deparment bllDep = new Deparment();
Hownet.BLL.PackAmount bllPA = new PackAmount();
Hownet.BLL.MaterielList bllML = new MaterielList();
Hownet.BLL.Materiel bllMat = new Materiel();
Hownet.Model.PackAmount modPA = new Hownet.Model.PackAmount();
Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList();
Hownet.Model.StockBack modSB = bllSB.GetModel(MainID);
Hownet.Model.StockBackInfo modSBI = new Hownet.Model.StockBackInfo();
Hownet.Model.Repertory modRep = new Hownet.Model.Repertory();
Hownet.Model.Deparment modDep = bllDep.GetModel(PackID);
List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + MainID + ")").Tables[0]);
modPA.DepartmentID = PackID;
for (int i = 0; i < li.Count; i++)
{
modRep.BrandID = modPA.BrandID = modML.BrandID = li[i].BrandID;
modRep.ColorID = modPA.ColorID = modML.ColorID = li[i].ColorID;
modRep.ColorOneID = modPA.ColorOneID = modML.ColorOneID = li[i].ColorOneID;
modRep.ColorTwoID = modPA.ColorTwoID = modML.ColorTwoID = li[i].ColorTwoID;
modRep.SizeID = modPA.SizeID = modML.SizeID = li[i].SizeID;
modRep.MaterielID = modPA.MaterielID = modML.MaterielID = li[i].MaterielID;
modRep.MeasureID = modPA.MeasureID = modML.MeasureID = bllMat.GetModel(li[i].MaterielID).MeasureID;
modRep.PlanID = modPA.PlanID = 0;
modRep.Remark = modPA.Remark = string.Empty;
modRep.DepartmentID = modPA.DepartmentID = modSB.DepotID;
modRep.Amount = modPA.Amount = li[i].Amount;
modSBI = bllSBI.GetModel(li[i].StockInfoID);
if (modSBI != null)
{
if (t)
{
modSBI.NotAmount -= li[i].Amount;
}
else
{
modSBI.NotAmount += li[i].Amount;
}
bllSBI.Update(modSBI);
}
if (li[i].MListID == 0)
{
modRep.MListID = modPA.MListID = li[i].MListID = bllML.GetID(modML);
bllSBI.Update(li[i]);
}
else
{
modRep.MListID = modPA.MListID = li[i].MListID;
}
if (modDep.TypeID == 39)
{
bllPA.InOrOut(modPA, t);
}
else if (modDep.TypeID == 42)
{
bllRep.InOrOut(modRep, t);
}
}
if (t)
{
modSB.IsVerify = 3;
modSB.VerifyDate = DateTime.Today;
modSB.VerifyMan = VerifyMan;
}
else
{
modSB.IsVerify = 1;
modSB.VerifyDate = DateTime.Parse("1900-1-1");
modSB.VerifyMan = 0;
}
bllSB.Update(modSB);
return(true);
}
catch (Exception ex)
{
return(false);
}
}