/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.ProductWorkingInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,WorkingID,GroupBy,Machine,MachinePart,LineOne,LineTwo,Pin,Stitch,Width,StitchWidth,Remark,MakingsOne,MakingsTwo,MainID,IsTicket,Price,UseTime,FastTime,Orders,MaterielID,ColorID,SpecialWork,PWMID,PWIID,CustOder,IsCaiC,IsCut,CompanyID,IsSpecial,OneAmount,IsCanMove from ProductWorkingInfo "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Hownet.Model.ProductWorkingInfo model = new Hownet.Model.ProductWorkingInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["WorkingID"] != null && ds.Tables[0].Rows[0]["WorkingID"].ToString() != "") { model.WorkingID = int.Parse(ds.Tables[0].Rows[0]["WorkingID"].ToString()); } if (ds.Tables[0].Rows[0]["GroupBy"] != null && ds.Tables[0].Rows[0]["GroupBy"].ToString() != "") { model.GroupBy = int.Parse(ds.Tables[0].Rows[0]["GroupBy"].ToString()); } if (ds.Tables[0].Rows[0]["Machine"] != null && ds.Tables[0].Rows[0]["Machine"].ToString() != "") { model.Machine = int.Parse(ds.Tables[0].Rows[0]["Machine"].ToString()); } if (ds.Tables[0].Rows[0]["MachinePart"] != null && ds.Tables[0].Rows[0]["MachinePart"].ToString() != "") { model.MachinePart = int.Parse(ds.Tables[0].Rows[0]["MachinePart"].ToString()); } if (ds.Tables[0].Rows[0]["LineOne"] != null && ds.Tables[0].Rows[0]["LineOne"].ToString() != "") { model.LineOne = int.Parse(ds.Tables[0].Rows[0]["LineOne"].ToString()); } if (ds.Tables[0].Rows[0]["LineTwo"] != null && ds.Tables[0].Rows[0]["LineTwo"].ToString() != "") { model.LineTwo = int.Parse(ds.Tables[0].Rows[0]["LineTwo"].ToString()); } if (ds.Tables[0].Rows[0]["Pin"] != null && ds.Tables[0].Rows[0]["Pin"].ToString() != "") { model.Pin = int.Parse(ds.Tables[0].Rows[0]["Pin"].ToString()); } if (ds.Tables[0].Rows[0]["Stitch"] != null && ds.Tables[0].Rows[0]["Stitch"].ToString() != "") { model.Stitch = int.Parse(ds.Tables[0].Rows[0]["Stitch"].ToString()); } if (ds.Tables[0].Rows[0]["Width"] != null && ds.Tables[0].Rows[0]["Width"].ToString() != "") { model.Width = int.Parse(ds.Tables[0].Rows[0]["Width"].ToString()); } if (ds.Tables[0].Rows[0]["StitchWidth"] != null && ds.Tables[0].Rows[0]["StitchWidth"].ToString() != "") { model.StitchWidth = int.Parse(ds.Tables[0].Rows[0]["StitchWidth"].ToString()); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["MakingsOne"] != null && ds.Tables[0].Rows[0]["MakingsOne"].ToString() != "") { model.MakingsOne = int.Parse(ds.Tables[0].Rows[0]["MakingsOne"].ToString()); } if (ds.Tables[0].Rows[0]["MakingsTwo"] != null && ds.Tables[0].Rows[0]["MakingsTwo"].ToString() != "") { model.MakingsTwo = int.Parse(ds.Tables[0].Rows[0]["MakingsTwo"].ToString()); } if (ds.Tables[0].Rows[0]["MainID"] != null && ds.Tables[0].Rows[0]["MainID"].ToString() != "") { model.MainID = int.Parse(ds.Tables[0].Rows[0]["MainID"].ToString()); } if (ds.Tables[0].Rows[0]["IsTicket"] != null && ds.Tables[0].Rows[0]["IsTicket"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsTicket"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsTicket"].ToString().ToLower() == "true")) { model.IsTicket = true; } else { model.IsTicket = false; } } if (ds.Tables[0].Rows[0]["Price"] != null && ds.Tables[0].Rows[0]["Price"].ToString() != "") { model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString()); } if (ds.Tables[0].Rows[0]["UseTime"] != null && ds.Tables[0].Rows[0]["UseTime"].ToString() != "") { model.UseTime = decimal.Parse(ds.Tables[0].Rows[0]["UseTime"].ToString()); } if (ds.Tables[0].Rows[0]["FastTime"] != null && ds.Tables[0].Rows[0]["FastTime"].ToString() != "") { model.FastTime = decimal.Parse(ds.Tables[0].Rows[0]["FastTime"].ToString()); } if (ds.Tables[0].Rows[0]["Orders"] != null && ds.Tables[0].Rows[0]["Orders"].ToString() != "") { model.Orders = int.Parse(ds.Tables[0].Rows[0]["Orders"].ToString()); } if (ds.Tables[0].Rows[0]["MaterielID"] != null && ds.Tables[0].Rows[0]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(ds.Tables[0].Rows[0]["MaterielID"].ToString()); } if (ds.Tables[0].Rows[0]["ColorID"] != null && ds.Tables[0].Rows[0]["ColorID"].ToString() != "") { model.ColorID = int.Parse(ds.Tables[0].Rows[0]["ColorID"].ToString()); } if (ds.Tables[0].Rows[0]["SpecialWork"] != null && ds.Tables[0].Rows[0]["SpecialWork"].ToString() != "") { model.SpecialWork = int.Parse(ds.Tables[0].Rows[0]["SpecialWork"].ToString()); } if (ds.Tables[0].Rows[0]["PWMID"] != null && ds.Tables[0].Rows[0]["PWMID"].ToString() != "") { model.PWMID = int.Parse(ds.Tables[0].Rows[0]["PWMID"].ToString()); } if (ds.Tables[0].Rows[0]["PWIID"] != null && ds.Tables[0].Rows[0]["PWIID"].ToString() != "") { model.PWIID = int.Parse(ds.Tables[0].Rows[0]["PWIID"].ToString()); } if (ds.Tables[0].Rows[0]["CustOder"] != null && ds.Tables[0].Rows[0]["CustOder"].ToString() != "") { model.CustOder = ds.Tables[0].Rows[0]["CustOder"].ToString(); } if (ds.Tables[0].Rows[0]["IsCaiC"] != null && ds.Tables[0].Rows[0]["IsCaiC"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCaiC"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCaiC"].ToString().ToLower() == "true")) { model.IsCaiC = true; } else { model.IsCaiC = false; } } if (ds.Tables[0].Rows[0]["IsCut"] != null && ds.Tables[0].Rows[0]["IsCut"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCut"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCut"].ToString().ToLower() == "true")) { model.IsCut = true; } else { model.IsCut = false; } } if (ds.Tables[0].Rows[0]["CompanyID"] != null && ds.Tables[0].Rows[0]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString()); } if (ds.Tables[0].Rows[0]["IsSpecial"] != null && ds.Tables[0].Rows[0]["IsSpecial"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsSpecial"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSpecial"].ToString().ToLower() == "true")) { model.IsSpecial = true; } else { model.IsSpecial = false; } } if (ds.Tables[0].Rows[0]["OneAmount"] != null && ds.Tables[0].Rows[0]["OneAmount"].ToString() != "") { model.OneAmount = int.Parse(ds.Tables[0].Rows[0]["OneAmount"].ToString()); } if (ds.Tables[0].Rows[0]["IsCanMove"] != null && ds.Tables[0].Rows[0]["IsCanMove"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCanMove"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCanMove"].ToString().ToLower() == "true")) { model.IsCanMove = true; } else { model.IsCanMove = false; } } model.A = 1; return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.ProductWorkingInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ProductWorkingInfo("); strSql.Append("WorkingID,GroupBy,Machine,MachinePart,LineOne,LineTwo,Pin,Stitch,Width,StitchWidth,Remark,MakingsOne,MakingsTwo,MainID,IsTicket,Price,UseTime,FastTime,Orders,MaterielID,ColorID,SpecialWork,PWMID,PWIID,CustOder,IsCaiC,IsCut,CompanyID,IsSpecial,OneAmount,IsCanMove)"); strSql.Append(" values ("); strSql.Append("@WorkingID,@GroupBy,@Machine,@MachinePart,@LineOne,@LineTwo,@Pin,@Stitch,@Width,@StitchWidth,@Remark,@MakingsOne,@MakingsTwo,@MainID,@IsTicket,@Price,@UseTime,@FastTime,@Orders,@MaterielID,@ColorID,@SpecialWork,@PWMID,@PWIID,@CustOder,@IsCaiC,@IsCut,@CompanyID,@IsSpecial,@OneAmount,@IsCanMove)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WorkingID", SqlDbType.Int, 4), new SqlParameter("@GroupBy", SqlDbType.Int, 4), new SqlParameter("@Machine", SqlDbType.Int, 4), new SqlParameter("@MachinePart", SqlDbType.Int, 4), new SqlParameter("@LineOne", SqlDbType.Int, 4), new SqlParameter("@LineTwo", SqlDbType.Int, 4), new SqlParameter("@Pin", SqlDbType.Int, 4), new SqlParameter("@Stitch", SqlDbType.Int, 4), new SqlParameter("@Width", SqlDbType.Int, 4), new SqlParameter("@StitchWidth", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@MakingsOne", SqlDbType.Int, 4), new SqlParameter("@MakingsTwo", SqlDbType.Int, 4), new SqlParameter("@MainID", SqlDbType.Int, 4), new SqlParameter("@IsTicket", SqlDbType.Bit, 1), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@UseTime", SqlDbType.Decimal, 9), new SqlParameter("@FastTime", SqlDbType.Decimal, 9), new SqlParameter("@Orders", SqlDbType.Int, 4), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@SpecialWork", SqlDbType.Int, 4), new SqlParameter("@PWMID", SqlDbType.Int, 4), new SqlParameter("@PWIID", SqlDbType.Int, 4), new SqlParameter("@CustOder", SqlDbType.NVarChar, 50), new SqlParameter("@IsCaiC", SqlDbType.Bit, 1), new SqlParameter("@IsCut", SqlDbType.Bit, 1), new SqlParameter("@CompanyID", SqlDbType.Int, 4), new SqlParameter("@IsSpecial", SqlDbType.Bit, 1), new SqlParameter("@OneAmount", SqlDbType.Int, 4), new SqlParameter("@IsCanMove", SqlDbType.Bit, 1) }; parameters[0].Value = model.WorkingID; parameters[1].Value = model.GroupBy; parameters[2].Value = model.Machine; parameters[3].Value = model.MachinePart; parameters[4].Value = model.LineOne; parameters[5].Value = model.LineTwo; parameters[6].Value = model.Pin; parameters[7].Value = model.Stitch; parameters[8].Value = model.Width; parameters[9].Value = model.StitchWidth; parameters[10].Value = model.Remark; parameters[11].Value = model.MakingsOne; parameters[12].Value = model.MakingsTwo; parameters[13].Value = model.MainID; parameters[14].Value = model.IsTicket; parameters[15].Value = model.Price; parameters[16].Value = model.UseTime; parameters[17].Value = model.FastTime; parameters[18].Value = model.Orders; parameters[19].Value = model.MaterielID; parameters[20].Value = model.ColorID; parameters[21].Value = model.SpecialWork; parameters[22].Value = model.PWMID; parameters[23].Value = model.PWIID; parameters[24].Value = model.CustOder; parameters[25].Value = model.IsCaiC; parameters[26].Value = model.IsCut; parameters[27].Value = model.CompanyID; parameters[28].Value = model.IsSpecial; parameters[29].Value = model.OneAmount; parameters[30].Value = model.IsCanMove; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hownet.Model.ProductWorkingInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ProductWorkingInfo set "); strSql.Append("WorkingID=@WorkingID,"); strSql.Append("GroupBy=@GroupBy,"); strSql.Append("Machine=@Machine,"); strSql.Append("MachinePart=@MachinePart,"); strSql.Append("LineOne=@LineOne,"); strSql.Append("LineTwo=@LineTwo,"); strSql.Append("Pin=@Pin,"); strSql.Append("Stitch=@Stitch,"); strSql.Append("Width=@Width,"); strSql.Append("StitchWidth=@StitchWidth,"); strSql.Append("Remark=@Remark,"); strSql.Append("MakingsOne=@MakingsOne,"); strSql.Append("MakingsTwo=@MakingsTwo,"); strSql.Append("MainID=@MainID,"); strSql.Append("IsTicket=@IsTicket,"); strSql.Append("Price=@Price,"); strSql.Append("UseTime=@UseTime,"); strSql.Append("FastTime=@FastTime,"); strSql.Append("Orders=@Orders,"); strSql.Append("MaterielID=@MaterielID,"); strSql.Append("ColorID=@ColorID,"); strSql.Append("SpecialWork=@SpecialWork,"); strSql.Append("PWMID=@PWMID,"); strSql.Append("PWIID=@PWIID,"); strSql.Append("CustOder=@CustOder,"); strSql.Append("IsCaiC=@IsCaiC,"); strSql.Append("IsCut=@IsCut,"); strSql.Append("CompanyID=@CompanyID,"); strSql.Append("IsSpecial=@IsSpecial,"); strSql.Append("OneAmount=@OneAmount,"); strSql.Append("IsCanMove=@IsCanMove"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@WorkingID", SqlDbType.Int, 4), new SqlParameter("@GroupBy", SqlDbType.Int, 4), new SqlParameter("@Machine", SqlDbType.Int, 4), new SqlParameter("@MachinePart", SqlDbType.Int, 4), new SqlParameter("@LineOne", SqlDbType.Int, 4), new SqlParameter("@LineTwo", SqlDbType.Int, 4), new SqlParameter("@Pin", SqlDbType.Int, 4), new SqlParameter("@Stitch", SqlDbType.Int, 4), new SqlParameter("@Width", SqlDbType.Int, 4), new SqlParameter("@StitchWidth", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@MakingsOne", SqlDbType.Int, 4), new SqlParameter("@MakingsTwo", SqlDbType.Int, 4), new SqlParameter("@MainID", SqlDbType.Int, 4), new SqlParameter("@IsTicket", SqlDbType.Bit, 1), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@UseTime", SqlDbType.Decimal, 9), new SqlParameter("@FastTime", SqlDbType.Decimal, 9), new SqlParameter("@Orders", SqlDbType.Int, 4), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@SpecialWork", SqlDbType.Int, 4), new SqlParameter("@PWMID", SqlDbType.Int, 4), new SqlParameter("@PWIID", SqlDbType.Int, 4), new SqlParameter("@CustOder", SqlDbType.NVarChar, 50), new SqlParameter("@IsCaiC", SqlDbType.Bit, 1), new SqlParameter("@IsCut", SqlDbType.Bit, 1), new SqlParameter("@CompanyID", SqlDbType.Int, 4), new SqlParameter("@IsSpecial", SqlDbType.Bit, 1), new SqlParameter("@OneAmount", SqlDbType.Int, 4), new SqlParameter("@IsCanMove", SqlDbType.Bit, 1), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.WorkingID; parameters[1].Value = model.GroupBy; parameters[2].Value = model.Machine; parameters[3].Value = model.MachinePart; parameters[4].Value = model.LineOne; parameters[5].Value = model.LineTwo; parameters[6].Value = model.Pin; parameters[7].Value = model.Stitch; parameters[8].Value = model.Width; parameters[9].Value = model.StitchWidth; parameters[10].Value = model.Remark; parameters[11].Value = model.MakingsOne; parameters[12].Value = model.MakingsTwo; parameters[13].Value = model.MainID; parameters[14].Value = model.IsTicket; parameters[15].Value = model.Price; parameters[16].Value = model.UseTime; parameters[17].Value = model.FastTime; parameters[18].Value = model.Orders; parameters[19].Value = model.MaterielID; parameters[20].Value = model.ColorID; parameters[21].Value = model.SpecialWork; parameters[22].Value = model.PWMID; parameters[23].Value = model.PWIID; parameters[24].Value = model.CustOder; parameters[25].Value = model.IsCaiC; parameters[26].Value = model.IsCut; parameters[27].Value = model.CompanyID; parameters[28].Value = model.IsSpecial; parameters[29].Value = model.OneAmount; parameters[30].Value = model.IsCanMove; parameters[31].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }