public DataSet GetTicketLine(int TaskID, int PWIID, int TaskDepID, int DPWID) { DataSet ds = new DataSet(); Hownet.BLL.ProductWorkingInfo bllPWI = new ProductWorkingInfo(); Hownet.Model.ProductWorkingInfo modPWI = new Hownet.Model.ProductWorkingInfo(); if (TaskDepID == 0) { modPWI = bllPWI.GetModel(PWIID); } else { modPWI = bllPWI.GetModel(DPWID); } if (!modPWI.IsSpecial)//不是特殊工序 { return(dal.GetTicketLine(TaskID, PWIID, TaskDepID, DPWID)); } else { return(dal.GetSpecialTicketLine(TaskID, PWIID, TaskDepID, DPWID)); } if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { ds.Tables.Clear(); ds = dal.GetSpecialTicketLine(TaskID, PWIID, TaskDepID, DPWID); } return(ds); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.ProductWorkingInfo model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.ProductWorkingInfo model) { return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.ProductWorkingInfo> DataTableToList(DataTable dt) { List <Hownet.Model.ProductWorkingInfo> modelList = new List <Hownet.Model.ProductWorkingInfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.ProductWorkingInfo model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.ProductWorkingInfo(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } else { model.ID = 0; } if (dt.Rows[n]["WorkingID"].ToString() != "") { model.WorkingID = int.Parse(dt.Rows[n]["WorkingID"].ToString()); } else { model.WorkingID = 0; } if (dt.Rows[n]["GroupBy"].ToString() != "") { model.GroupBy = int.Parse(dt.Rows[n]["GroupBy"].ToString()); } else { model.GroupBy = 0; } if (dt.Rows[n]["Machine"].ToString() != "") { model.Machine = int.Parse(dt.Rows[n]["Machine"].ToString()); } else { model.Machine = 0; } if (dt.Rows[n]["MachinePart"].ToString() != "") { model.MachinePart = int.Parse(dt.Rows[n]["MachinePart"].ToString()); } else { model.MachinePart = 0; } if (dt.Rows[n]["LineOne"].ToString() != "") { model.LineOne = int.Parse(dt.Rows[n]["LineOne"].ToString()); } else { model.LineOne = 0; } if (dt.Rows[n]["LineTwo"].ToString() != "") { model.LineTwo = int.Parse(dt.Rows[n]["LineTwo"].ToString()); } else { model.LineTwo = 0; } if (dt.Rows[n]["Pin"].ToString() != "") { model.Pin = int.Parse(dt.Rows[n]["Pin"].ToString()); } else { model.Pin = 0; } if (dt.Rows[n]["Stitch"].ToString() != "") { model.Stitch = int.Parse(dt.Rows[n]["Stitch"].ToString()); } else { model.Stitch = 0; } if (dt.Rows[n]["Width"].ToString() != "") { model.Width = int.Parse(dt.Rows[n]["Width"].ToString()); } else { model.Width = 0; } if (dt.Rows[n]["StitchWidth"].ToString() != "") { model.StitchWidth = int.Parse(dt.Rows[n]["StitchWidth"].ToString()); } else { model.StitchWidth = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["MakingsOne"].ToString() != "") { model.MakingsOne = int.Parse(dt.Rows[n]["MakingsOne"].ToString()); } else { model.MakingsOne = 0; } if (dt.Rows[n]["MakingsTwo"].ToString() != "") { model.MakingsTwo = int.Parse(dt.Rows[n]["MakingsTwo"].ToString()); } else { model.MakingsTwo = 0; } if (dt.Rows[n]["MainID"].ToString() != "") { model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString()); } else { model.MainID = 0; } if (dt.Rows[n]["IsTicket"].ToString() != "") { if ((dt.Rows[n]["IsTicket"].ToString() == "1") || (dt.Rows[n]["IsTicket"].ToString().ToLower() == "true")) { model.IsTicket = true; } else { model.IsTicket = false; } } if (dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } else { model.Price = 0; } if (dt.Rows[n]["UseTime"].ToString() != "") { model.UseTime = decimal.Parse(dt.Rows[n]["UseTime"].ToString()); } else { model.UseTime = 0; } if (dt.Rows[n]["FastTime"].ToString() != "") { model.FastTime = decimal.Parse(dt.Rows[n]["FastTime"].ToString()); } else { model.FastTime = 0; } if (dt.Rows[n]["Orders"].ToString() != "") { model.Orders = int.Parse(dt.Rows[n]["Orders"].ToString()); } else { model.Orders = 0; } if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } else { model.MaterielID = 0; } if (dt.Rows[n]["ColorID"].ToString() != "") { model.ColorID = int.Parse(dt.Rows[n]["ColorID"].ToString()); } else { model.ColorID = 0; } if (dt.Rows[n]["SpecialWork"].ToString() != "") { model.SpecialWork = int.Parse(dt.Rows[n]["SpecialWork"].ToString()); } else { model.SpecialWork = 0; } if (dt.Rows[n]["PWMID"].ToString() != "") { model.PWMID = int.Parse(dt.Rows[n]["PWMID"].ToString()); } else { model.PWMID = 0; } if (dt.Rows[n]["PWIID"].ToString() != "") { model.PWIID = int.Parse(dt.Rows[n]["PWIID"].ToString()); } else { model.PWIID = 0; } model.CustOder = dt.Rows[n]["CustOder"].ToString(); if (dt.Rows[n]["IsCaiC"].ToString() != "") { if ((dt.Rows[n]["IsCaiC"].ToString() == "1") || (dt.Rows[n]["IsCaiC"].ToString().ToLower() == "true")) { model.IsCaiC = true; } else { model.IsCaiC = false; } } if (dt.Rows[n]["IsCut"].ToString() != "") { if ((dt.Rows[n]["IsCut"].ToString() == "1") || (dt.Rows[n]["IsCut"].ToString().ToLower() == "true")) { model.IsCut = true; } else { model.IsCut = false; } } if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } else { model.CompanyID = 0; } if (dt.Rows[n]["IsSpecial"].ToString() != "") { if ((dt.Rows[n]["IsSpecial"].ToString() == "1") || (dt.Rows[n]["IsSpecial"].ToString().ToLower() == "true")) { model.IsSpecial = true; } else { model.IsSpecial = false; } } if (dt.Rows[n]["OneAmount"].ToString() != "") { model.OneAmount = int.Parse(dt.Rows[n]["OneAmount"].ToString()); } else { model.OneAmount = 0; } if (dt.Rows[n]["IsCanMove"] != null && dt.Rows[n]["IsCanMove"].ToString() != "") { if ((dt.Rows[n]["IsCanMove"].ToString() == "1") || (dt.Rows[n]["IsCanMove"].ToString().ToLower() == "true")) { model.IsCanMove = true; } else { model.IsCanMove = false; } } model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }
public bool CheckWorking(int TaskID, int PWIID, int CompanyID) { Hownet.BLL.ProductWorkingInfo bllPWI = new ProductWorkingInfo(); Hownet.BLL.Working bllW = new Working(); Hownet.BLL.WorkTicket bllWT = new WorkTicket(); Hownet.Model.ProductWorkingInfo modPWI = new Hownet.Model.ProductWorkingInfo(); modPWI = bllPWI.GetModel(PWIID); if (!modPWI.IsSpecial) //不是特殊工序 { if (!dal.CheckWorking(TaskID, PWIID, modPWI.OneAmount)) //已生成工票中没有这道工序 { Hownet.Model.WorkTicketInfo modWTI; DataTable dtWT = new DataTable(); dtWT = bllWT.GetList("(TaskID=" + TaskID + ") And (OneAmount=" + modPWI.OneAmount + ")").Tables[0]; for (int i = 0; i < dtWT.Rows.Count; i++) { modWTI = new Hownet.Model.WorkTicketInfo(); modWTI.NotAmount = modWTI.Amount = int.Parse(dtWT.Rows[i]["Amount"].ToString()); modWTI.BackID = 0; modWTI.DateTime = null; modWTI.EmployeeID = 0; modWTI.IsDel = false; modWTI.MainID = int.Parse(dtWT.Rows[i]["ID"].ToString()); if (TaskID > 0) { modWTI.TaskID = TaskID; modWTI.PWorkingInfoID = PWIID; } modWTI.WorkingID = modPWI.WorkingID; Add(modWTI); } } return(true); } else { DataTable dtTem = bllPWI.GetList("(PWIID=" + modPWI.ID + ")").Tables[0]; List <Hownet.Model.ProductWorkingInfo> li = bllPWI.DataTableToList(dtTem);//是特殊工序时,查找其构成的普通工序 if (li.Count == 0) { return(false); } for (int i = 0; i < li.Count; i++) { if (dal.CheckWorking(TaskID, li[i].ID, li[i].OneAmount)) { return(true); } } Hownet.Model.WorkTicketInfo modWTI; DataTable dtWT = new DataTable(); dtWT = bllWT.GetList("(TaskID=" + TaskID + ") And (OneAmount=" + li[0].OneAmount + ")").Tables[0]; DataRow[] drs; bool t = false; for (int i = 0; i < dtWT.Rows.Count; i++) { t = false; modWTI = new Hownet.Model.WorkTicketInfo(); modWTI.NotAmount = modWTI.Amount = int.Parse(dtWT.Rows[i]["Amount"].ToString()); modWTI.BackID = 0; modWTI.DateTime = null; modWTI.EmployeeID = 0; modWTI.IsDel = false; modWTI.MainID = int.Parse(dtWT.Rows[i]["ID"].ToString()); if (TaskID > 0) { modWTI.TaskID = TaskID; } //if (CompanyID > 0) //{ drs = dtTem.Select("(CompanyID=" + CompanyID + ") And (ColorID=" + dtWT.Rows[i]["ColorID"] + ") And (MaterielID=" + dtWT.Rows[i]["SizeID"] + ")");//同客户同颜色同尺码 if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=" + CompanyID + ") And (ColorID=0) And (MaterielID=" + dtWT.Rows[i]["SizeID"] + ")"); //同客户同尺码无颜色 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=" + CompanyID + ") And (ColorID=" + dtWT.Rows[i]["ColorID"] + ") And (MaterielID=0)"); //同客户同颜色无尺码 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=0) And (ColorID=" + dtWT.Rows[i]["ColorID"] + ") And (MaterielID=" + dtWT.Rows[i]["SizeID"] + ")"); //无客户同颜色同尺码 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=" + CompanyID + ") And (ColorID=0) And (MaterielID=0)"); //仅客户 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=0) And (ColorID=" + dtWT.Rows[i]["ColorID"] + ") And (MaterielID=0)"); //仅颜色 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=0) And (ColorID=0) And (MaterielID=" + dtWT.Rows[i]["SizeID"] + ")"); //仅尺码 } if (drs.Length == 0) { drs = dtTem.Select("(CompanyID=0) And (ColorID=0) And (MaterielID=0)"); //无客户无颜色无尺码 } if (drs.Length > 0) { modWTI.WorkingID = int.Parse(drs[0]["WorkingID"].ToString()); modWTI.PWorkingInfoID = int.Parse(drs[0]["ID"].ToString()); } else { t = true; } //} //else //{ // drs = dtTem.Select("(CompanyID=0) And (ColorID=" + dtWT.Rows[i]["ColorID"] + ")"); // if (drs.Length == 0) // { // drs = dtTem.Select("(CompanyID=0) And (ColorID=0)"); // } // if (drs.Length > 0) // { // modWTI.WorkingID = int.Parse(drs[0]["WorkingID"].ToString()); // modWTI.PWorkingInfoID = int.Parse(drs[0]["ID"].ToString()); // } // else // { // t = true; // } //} if (!t) { Add(modWTI); } } } return(true); }