/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.MaterielStructMain GetModel(int MainID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MainID,Ver,MaterielID,DateTime,CompanyID,TaskID,Remark,IsDefault,IsVerify,VerifyManID,VerifyDateTime,Executant,Money,WorkingMoney,OutPrice,MaterielPro,GrossProfit,GrossPro,CMT,BySizeName,ExSize,MaterielLoss,PackLoss,FillManID,FillManName,VerifyManName from MaterielStructMain "); strSql.Append(" where MainID=@MainID"); SqlParameter[] parameters = { new SqlParameter("@MainID", SqlDbType.Int, 4) }; parameters[0].Value = MainID; Hownet.Model.MaterielStructMain model = new Hownet.Model.MaterielStructMain(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { 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()); } model.Ver = ds.Tables[0].Rows[0]["Ver"].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]["DateTime"] != null && ds.Tables[0].Rows[0]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["DateTime"].ToString()); } 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]["TaskID"] != null && ds.Tables[0].Rows[0]["TaskID"].ToString() != "") { model.TaskID = int.Parse(ds.Tables[0].Rows[0]["TaskID"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); if (ds.Tables[0].Rows[0]["IsDefault"] != null && ds.Tables[0].Rows[0]["IsDefault"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsDefault"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDefault"].ToString().ToLower() == "true")) { model.IsDefault = true; } else { model.IsDefault = false; } } if (ds.Tables[0].Rows[0]["IsVerify"] != null && ds.Tables[0].Rows[0]["IsVerify"].ToString() != "") { model.IsVerify = int.Parse(ds.Tables[0].Rows[0]["IsVerify"].ToString()); } if (ds.Tables[0].Rows[0]["VerifyManID"] != null && ds.Tables[0].Rows[0]["VerifyManID"].ToString() != "") { model.VerifyManID = int.Parse(ds.Tables[0].Rows[0]["VerifyManID"].ToString()); } if (ds.Tables[0].Rows[0]["VerifyDateTime"] != null && ds.Tables[0].Rows[0]["VerifyDateTime"].ToString() != "") { model.VerifyDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["VerifyDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["Executant"] != null && ds.Tables[0].Rows[0]["Executant"].ToString() != "") { model.Executant = int.Parse(ds.Tables[0].Rows[0]["Executant"].ToString()); } if (ds.Tables[0].Rows[0]["Money"] != null && ds.Tables[0].Rows[0]["Money"].ToString() != "") { model.Money = decimal.Parse(ds.Tables[0].Rows[0]["Money"].ToString()); } if (ds.Tables[0].Rows[0]["WorkingMoney"] != null && ds.Tables[0].Rows[0]["WorkingMoney"].ToString() != "") { model.WorkingMoney = decimal.Parse(ds.Tables[0].Rows[0]["WorkingMoney"].ToString()); } if (ds.Tables[0].Rows[0]["OutPrice"] != null && ds.Tables[0].Rows[0]["OutPrice"].ToString() != "") { model.OutPrice = decimal.Parse(ds.Tables[0].Rows[0]["OutPrice"].ToString()); } if (ds.Tables[0].Rows[0]["MaterielPro"] != null && ds.Tables[0].Rows[0]["MaterielPro"].ToString() != "") { model.MaterielPro = decimal.Parse(ds.Tables[0].Rows[0]["MaterielPro"].ToString()); } if (ds.Tables[0].Rows[0]["GrossProfit"] != null && ds.Tables[0].Rows[0]["GrossProfit"].ToString() != "") { model.GrossProfit = decimal.Parse(ds.Tables[0].Rows[0]["GrossProfit"].ToString()); } if (ds.Tables[0].Rows[0]["GrossPro"] != null && ds.Tables[0].Rows[0]["GrossPro"].ToString() != "") { model.GrossPro = decimal.Parse(ds.Tables[0].Rows[0]["GrossPro"].ToString()); } if (ds.Tables[0].Rows[0]["CMT"] != null && ds.Tables[0].Rows[0]["CMT"].ToString() != "") { model.CMT = decimal.Parse(ds.Tables[0].Rows[0]["CMT"].ToString()); } model.BySizeName = ds.Tables[0].Rows[0]["BySizeName"].ToString(); model.ExSize = ds.Tables[0].Rows[0]["ExSize"].ToString(); model.MaterielLoss = ds.Tables[0].Rows[0]["MaterielLoss"].ToString(); model.PackLoss = ds.Tables[0].Rows[0]["PackLoss"].ToString(); if (ds.Tables[0].Rows[0]["FillManID"] != null && ds.Tables[0].Rows[0]["FillManID"].ToString() != "") { model.FillManID = int.Parse(ds.Tables[0].Rows[0]["FillManID"].ToString()); } model.FillManName = ds.Tables[0].Rows[0]["FillManName"].ToString(); model.VerifyManName = ds.Tables[0].Rows[0]["VerifyManName"].ToString(); model.A = 1; return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.MaterielStructMain model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MaterielStructMain("); strSql.Append("Ver,MaterielID,DateTime,CompanyID,TaskID,Remark,IsDefault,IsVerify,VerifyManID,VerifyDateTime,Executant,Money,WorkingMoney,OutPrice,MaterielPro,GrossProfit,GrossPro,CMT,BySizeName,ExSize,MaterielLoss,PackLoss,FillManID,FillManName,VerifyManName)"); strSql.Append(" values ("); strSql.Append("@Ver,@MaterielID,@DateTime,@CompanyID,@TaskID,@Remark,@IsDefault,@IsVerify,@VerifyManID,@VerifyDateTime,@Executant,@Money,@WorkingMoney,@OutPrice,@MaterielPro,@GrossProfit,@GrossPro,@CMT,@BySizeName,@ExSize,@MaterielLoss,@PackLoss,@FillManID,@FillManName,@VerifyManName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Ver", SqlDbType.NVarChar, 50), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@DateTime", SqlDbType.DateTime), new SqlParameter("@CompanyID", SqlDbType.Int, 4), new SqlParameter("@TaskID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 255), new SqlParameter("@IsDefault", SqlDbType.Bit, 1), new SqlParameter("@IsVerify", SqlDbType.TinyInt, 1), new SqlParameter("@VerifyManID", SqlDbType.Int, 4), new SqlParameter("@VerifyDateTime", SqlDbType.DateTime), new SqlParameter("@Executant", SqlDbType.Int, 4), new SqlParameter("@Money", SqlDbType.Decimal, 9), new SqlParameter("@WorkingMoney", SqlDbType.Decimal, 9), new SqlParameter("@OutPrice", SqlDbType.Decimal, 9), new SqlParameter("@MaterielPro", SqlDbType.Decimal, 9), new SqlParameter("@GrossProfit", SqlDbType.Decimal, 9), new SqlParameter("@GrossPro", SqlDbType.Decimal, 9), new SqlParameter("@CMT", SqlDbType.Decimal, 9), new SqlParameter("@BySizeName", SqlDbType.NVarChar, 50), new SqlParameter("@ExSize", SqlDbType.NVarChar, 500), new SqlParameter("@MaterielLoss", SqlDbType.NVarChar, 500), new SqlParameter("@PackLoss", SqlDbType.NVarChar, 500), new SqlParameter("@FillManID", SqlDbType.Int, 4), new SqlParameter("@FillManName", SqlDbType.NVarChar, 50), new SqlParameter("@VerifyManName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Ver; parameters[1].Value = model.MaterielID; parameters[2].Value = model.DateTime; parameters[3].Value = model.CompanyID; parameters[4].Value = model.TaskID; parameters[5].Value = model.Remark; parameters[6].Value = model.IsDefault; parameters[7].Value = model.IsVerify; parameters[8].Value = model.VerifyManID; parameters[9].Value = model.VerifyDateTime; parameters[10].Value = model.Executant; parameters[11].Value = model.Money; parameters[12].Value = model.WorkingMoney; parameters[13].Value = model.OutPrice; parameters[14].Value = model.MaterielPro; parameters[15].Value = model.GrossProfit; parameters[16].Value = model.GrossPro; parameters[17].Value = model.CMT; parameters[18].Value = model.BySizeName; parameters[19].Value = model.ExSize; parameters[20].Value = model.MaterielLoss; parameters[21].Value = model.PackLoss; parameters[22].Value = model.FillManID; parameters[23].Value = model.FillManName; parameters[24].Value = model.VerifyManName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hownet.Model.MaterielStructMain model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MaterielStructMain set "); strSql.Append("Ver=@Ver,"); strSql.Append("MaterielID=@MaterielID,"); strSql.Append("DateTime=@DateTime,"); strSql.Append("CompanyID=@CompanyID,"); strSql.Append("TaskID=@TaskID,"); strSql.Append("Remark=@Remark,"); strSql.Append("IsDefault=@IsDefault,"); strSql.Append("IsVerify=@IsVerify,"); strSql.Append("VerifyManID=@VerifyManID,"); strSql.Append("VerifyDateTime=@VerifyDateTime,"); strSql.Append("Executant=@Executant,"); strSql.Append("Money=@Money,"); strSql.Append("WorkingMoney=@WorkingMoney,"); strSql.Append("OutPrice=@OutPrice,"); strSql.Append("MaterielPro=@MaterielPro,"); strSql.Append("GrossProfit=@GrossProfit,"); strSql.Append("GrossPro=@GrossPro,"); strSql.Append("CMT=@CMT,"); strSql.Append("BySizeName=@BySizeName,"); strSql.Append("ExSize=@ExSize,"); strSql.Append("MaterielLoss=@MaterielLoss,"); strSql.Append("PackLoss=@PackLoss,"); strSql.Append("FillManID=@FillManID,"); strSql.Append("FillManName=@FillManName,"); strSql.Append("VerifyManName=@VerifyManName"); strSql.Append(" where MainID=@MainID"); SqlParameter[] parameters = { new SqlParameter("@Ver", SqlDbType.NVarChar, 50), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@DateTime", SqlDbType.DateTime), new SqlParameter("@CompanyID", SqlDbType.Int, 4), new SqlParameter("@TaskID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 255), new SqlParameter("@IsDefault", SqlDbType.Bit, 1), new SqlParameter("@IsVerify", SqlDbType.TinyInt, 1), new SqlParameter("@VerifyManID", SqlDbType.Int, 4), new SqlParameter("@VerifyDateTime", SqlDbType.DateTime), new SqlParameter("@Executant", SqlDbType.Int, 4), new SqlParameter("@Money", SqlDbType.Decimal, 9), new SqlParameter("@WorkingMoney", SqlDbType.Decimal, 9), new SqlParameter("@OutPrice", SqlDbType.Decimal, 9), new SqlParameter("@MaterielPro", SqlDbType.Decimal, 9), new SqlParameter("@GrossProfit", SqlDbType.Decimal, 9), new SqlParameter("@GrossPro", SqlDbType.Decimal, 9), new SqlParameter("@CMT", SqlDbType.Decimal, 9), new SqlParameter("@BySizeName", SqlDbType.NVarChar, 50), new SqlParameter("@ExSize", SqlDbType.NVarChar, 500), new SqlParameter("@MaterielLoss", SqlDbType.NVarChar, 500), new SqlParameter("@PackLoss", SqlDbType.NVarChar, 500), new SqlParameter("@FillManID", SqlDbType.Int, 4), new SqlParameter("@FillManName", SqlDbType.NVarChar, 50), new SqlParameter("@VerifyManName", SqlDbType.NVarChar, 50), new SqlParameter("@MainID", SqlDbType.Int, 4) }; parameters[0].Value = model.Ver; parameters[1].Value = model.MaterielID; parameters[2].Value = model.DateTime; parameters[3].Value = model.CompanyID; parameters[4].Value = model.TaskID; parameters[5].Value = model.Remark; parameters[6].Value = model.IsDefault; parameters[7].Value = model.IsVerify; parameters[8].Value = model.VerifyManID; parameters[9].Value = model.VerifyDateTime; parameters[10].Value = model.Executant; parameters[11].Value = model.Money; parameters[12].Value = model.WorkingMoney; parameters[13].Value = model.OutPrice; parameters[14].Value = model.MaterielPro; parameters[15].Value = model.GrossProfit; parameters[16].Value = model.GrossPro; parameters[17].Value = model.CMT; parameters[18].Value = model.BySizeName; parameters[19].Value = model.ExSize; parameters[20].Value = model.MaterielLoss; parameters[21].Value = model.PackLoss; parameters[22].Value = model.FillManID; parameters[23].Value = model.FillManName; parameters[24].Value = model.VerifyManName; parameters[25].Value = model.MainID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }