/// <summary> /// 转入生产计划 /// </summary> /// <param name="SaleID"></param> /// <returns></returns> public int ToPlan(int SaleID, int FillMan) { try { // DataTable dt = GetList("(ID=" + SaleID + ")").Tables[0]; Hownet.Model.SalesOrderInfoList modSOI = GetModel(SaleID); Hownet.BLL.SysTem bllST = new SysTem(); Hownet.Model.SysTem modST = bllST.GetModel(bllST.GetMaxId() - 1); Hownet.BLL.ProductionPlan bllPP = new ProductionPlan(); Hownet.Model.ProductionPlan modPP = new Hownet.Model.ProductionPlan(); modPP.SalesOrderInfoID = modSOI.ID; // Convert.ToInt32(dt.Rows[0]["ID"]); modPP.MaterielID = modSOI.MaterielID; // Convert.ToInt32(dt.Rows[0]["MaterielID"]); modPP.BrandID = modSOI.BrandID; // Convert.ToInt32(dt.Rows[0]["BrandID"]); modPP.Num = modSOI.Num; // Convert.ToInt32(dt.Rows[0]["Num"]);// bllPP.NewNum(DateTime.Today, modST.NumType); // dalPP.NewNum(DateTime.Today, modST.NumType); modPP.DateTime = modSOI.DateTime; // Convert.ToDateTime(dt.Rows[0]["DateTime"]);// DateTime.Today; modPP.LastDate = modSOI.LastDate; // Convert.ToDateTime(dt.Rows[0]["LastDate"]); modPP.Remark = modSOI.Remark; // dt.Rows[0]["Remark"].ToString(); modPP.PWorkingID = modPP.BomID = 0; modPP.CompanyID = modSOI.CompanyID; // Convert.ToInt32(dt.Rows[0]["CompanyID"]); modPP.IsTicket = modPP.IsBom = false; modPP.VerifyDate = Convert.ToDateTime("1900-1-1"); modPP.VerifyMan = 0; modPP.DeparmentID = 0; modPP.UpData = 1; modPP.FillDate = DateTime.Today; modPP.FilMan = FillMan; modPP.TicketDate = Convert.ToDateTime("1900-1-1"); modPP.BedNO = string.Empty; modPP.PackingMethodID = modSOI.PackingMethodID; // Convert.ToInt32(dt.Rows[0]["PackingMethodID"]); modPP.SewingRemark = modSOI.Remark + "\r\n" + modSOI.SewingRemark; // dt.Rows[0]["Remark"].ToString() + "\r\n" + dt.Rows[0]["SewingRemark"].ToString(); modPP.TypeID = modPP.ParentID = 0; modPP.ParentID = 0; modPP.IsVerify = 1; modPP.AssociatedID = string.Empty; modPP.AssociatedMatID = 0; //dt.Rows[0]["IsToPlan"] = 1; modSOI.IsToPlan = true; Update(modSOI); // UpdateByDt(dt); return(bllPP.Add(modPP)); } catch (Exception ex) { return(0); } // return dal.ToPlan(SaleID, FillMan); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.SalesOrderInfoList model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.SalesOrderInfoList model) { return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.SalesOrderInfoList> DataTableToList(DataTable dt) { List <Hownet.Model.SalesOrderInfoList> modelList = new List <Hownet.Model.SalesOrderInfoList>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.SalesOrderInfoList model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.SalesOrderInfoList(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["MainID"].ToString() != "") { model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString()); } if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } if (dt.Rows[n]["BrandID"].ToString() != "") { model.BrandID = int.Parse(dt.Rows[n]["BrandID"].ToString()); } if (dt.Rows[n]["Num"].ToString() != "") { model.Num = int.Parse(dt.Rows[n]["Num"].ToString()); } if (dt.Rows[n]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString()); } if (dt.Rows[n]["LastDate"].ToString() != "") { model.LastDate = DateTime.Parse(dt.Rows[n]["LastDate"].ToString()); } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["IsVerify"].ToString() != "") { model.IsVerify = int.Parse(dt.Rows[n]["IsVerify"].ToString()); } if (dt.Rows[n]["VerifyDate"].ToString() != "") { model.VerifyDate = DateTime.Parse(dt.Rows[n]["VerifyDate"].ToString()); } if (dt.Rows[n]["VerifyMan"].ToString() != "") { model.VerifyMan = int.Parse(dt.Rows[n]["VerifyMan"].ToString()); } if (dt.Rows[n]["Progress"].ToString() != "") { model.Progress = int.Parse(dt.Rows[n]["Progress"].ToString()); } if (dt.Rows[n]["UpData"].ToString() != "") { model.UpData = int.Parse(dt.Rows[n]["UpData"].ToString()); } if (dt.Rows[n]["MeasureID"].ToString() != "") { model.MeasureID = int.Parse(dt.Rows[n]["MeasureID"].ToString()); } else { model.MeasureID = 0; } if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } else { model.CompanyID = 0; } if (dt.Rows[n]["FillMan"].ToString() != "") { model.FillMan = int.Parse(dt.Rows[n]["FillMan"].ToString()); } else { model.FillMan = 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]["PackingMethodID"].ToString() != "") { model.PackingMethodID = int.Parse(dt.Rows[n]["PackingMethodID"].ToString()); } else { model.PackingMethodID = 0; } model.SewingRemark = dt.Rows[n]["SewingRemark"].ToString(); if (dt.Rows[n]["IsToPlan"].ToString() != "") { if ((dt.Rows[n]["IsToPlan"].ToString() == "1") || (dt.Rows[n]["IsToPlan"].ToString().ToLower() == "true")) { model.IsToPlan = true; } else { model.IsToPlan = false; } } if (dt.Rows[n]["SunAmount"].ToString() != "") { model.SunAmount = int.Parse(dt.Rows[n]["SunAmount"].ToString()); } model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }