/// <summary> /// 得到一个对象实体 /// </summary> public Model.Binning GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SLOT_ID,SLOT_INDEX,CAPACITY,PART_ID,SAPCODE,DESCRIPTION,BATCH_NO,STATUS,START_WEIGHT,CURRENT_WEIGHT,THAWING_DATETIME,READY_DATETIME,EXPIRY_DATETIME,MF_EXPIRY_DATE,USER_ID,USER_NAME,USER_GROUP,DEPARTMENT,UPDATED_TIME from Binning "); strSql.Append(" where "); SqlParameter[] parameters = { }; Model.Binning model = new Model.Binning(); DataTable dt = Common.DB.SqlDB.Query(strSql.ToString(), parameters); if (dt == null || dt.Rows.Count == 0) { return(null); } else { return(DataRowToModel(dt.Rows[0])); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Binning model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Binning model) { return(dal.Add(model)); }
public Model.Binning DataRowToModel(DataRow dr) { if (dr == null) { return(null); } Model.Binning model = new Model.Binning(); if (dr["SLOT_ID"].ToString() != "" || dr["SLOT_ID"] != null) { model.SLOT_ID = int.Parse(dr["SLOT_ID"].ToString()); } if (dr["SLOT_INDEX"].ToString() != "" || dr["SLOT_INDEX"] != null) { model.SLOT_INDEX = int.Parse(dr["SLOT_INDEX"].ToString()); } if (dr["CAPACITY"].ToString() != "" || dr["CAPACITY"] != null) { model.CAPACITY = int.Parse(dr["CAPACITY"].ToString()); } model.PART_ID = dr["PART_ID"].ToString(); model.SAPCODE = dr["SAPCODE"].ToString(); model.DESCRIPTION = dr["DESCRIPTION"].ToString(); model.BATCH_NO = dr["BATCH_NO"].ToString(); model.STATUS = dr["STATUS"].ToString(); if (dr["START_WEIGHT"].ToString() != "" || dr["START_WEIGHT"] != null) { model.START_WEIGHT = decimal.Parse(dr["START_WEIGHT"].ToString()); } if (dr["CURRENT_WEIGHT"].ToString() != "" || dr["CURRENT_WEIGHT"] != null) { model.CURRENT_WEIGHT = decimal.Parse(dr["CURRENT_WEIGHT"].ToString()); } if (dr["THAWING_DATETIME"].ToString() != "" || dr["THAWING_DATETIME"] != null) { model.THAWING_DATETIME = DateTime.Parse(dr["THAWING_DATETIME"].ToString()); } if (dr["READY_DATETIME"].ToString() != "" || dr["READY_DATETIME"] != null) { model.READY_DATETIME = DateTime.Parse(dr["READY_DATETIME"].ToString()); } if (dr["EXPIRY_DATETIME"].ToString() != "" || dr["EXPIRY_DATETIME"] != null) { model.EXPIRY_DATETIME = DateTime.Parse(dr["EXPIRY_DATETIME"].ToString()); } if (dr["MF_EXPIRY_DATE"].ToString() != "" || dr["MF_EXPIRY_DATE"] != null) { model.MF_EXPIRY_DATE = DateTime.Parse(dr["MF_EXPIRY_DATE"].ToString()); } model.USER_ID = dr["USER_ID"].ToString(); model.USER_NAME = dr["USER_NAME"].ToString(); model.USER_GROUP = dr["USER_GROUP"].ToString(); model.DEPARTMENT = dr["DEPARTMENT"].ToString(); if (dr["UPDATED_TIME"].ToString() != "" || dr["UPDATED_TIME"] != null) { model.UPDATED_TIME = DateTime.Parse(dr["UPDATED_TIME"].ToString()); } return(model); }
public SqlCommand UpdateCommand(Model.Binning model) { return(dal.UpdateCommand(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Binning model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Binning("); strSql.Append("SLOT_ID,SLOT_INDEX,CAPACITY,PART_ID,SAPCODE,DESCRIPTION,BATCH_NO,STATUS,START_WEIGHT,CURRENT_WEIGHT,THAWING_DATETIME,READY_DATETIME,EXPIRY_DATETIME,MF_EXPIRY_DATE,USER_ID,USER_NAME,USER_GROUP,DEPARTMENT,UPDATED_TIME)"); strSql.Append(" values ("); strSql.Append("@SLOT_ID,@SLOT_INDEX,@CAPACITY,@PART_ID,@SAPCODE,@DESCRIPTION,@BATCH_NO,@STATUS,@START_WEIGHT,@CURRENT_WEIGHT,@THAWING_DATETIME,@READY_DATETIME,@EXPIRY_DATETIME,@MF_EXPIRY_DATE,@USER_ID,@USER_NAME,@USER_GROUP,@DEPARTMENT,@UPDATED_TIME)"); SqlParameter[] parameters = { new SqlParameter("@SLOT_ID", SqlDbType.Int, 4), new SqlParameter("@SLOT_INDEX", SqlDbType.Int, 4), new SqlParameter("@CAPACITY", SqlDbType.Int, 4), new SqlParameter("@PART_ID", SqlDbType.VarChar, 50), new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 50), new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50), new SqlParameter("@STATUS", SqlDbType.VarChar, 50), new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime), new SqlParameter("@READY_DATETIME", SqlDbType.DateTime), new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime), new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime), new SqlParameter("@USER_ID", SqlDbType.VarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@USER_GROUP", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime) }; parameters[0].Value = model.SLOT_ID; parameters[1].Value = model.SLOT_INDEX; parameters[2].Value = model.CAPACITY; parameters[3].Value = model.PART_ID; parameters[4].Value = model.SAPCODE; parameters[5].Value = model.DESCRIPTION; parameters[6].Value = model.BATCH_NO; parameters[7].Value = model.STATUS; parameters[8].Value = model.START_WEIGHT; parameters[9].Value = model.CURRENT_WEIGHT; parameters[10].Value = model.THAWING_DATETIME; parameters[11].Value = model.READY_DATETIME; parameters[12].Value = model.EXPIRY_DATETIME; parameters[13].Value = model.MF_EXPIRY_DATE; parameters[14].Value = model.USER_ID; parameters[15].Value = model.USER_NAME; parameters[16].Value = model.USER_GROUP; parameters[17].Value = model.DEPARTMENT; parameters[18].Value = model.UPDATED_TIME; int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public SqlCommand UpdateCommand(Model.Binning model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Binning set "); strSql.Append("SLOT_ID=@SLOT_ID,"); strSql.Append("SLOT_INDEX=@SLOT_INDEX,"); strSql.Append("CAPACITY=@CAPACITY,"); strSql.Append("PART_ID=@PART_ID,"); strSql.Append("SAPCODE=@SAPCODE,"); strSql.Append("DESCRIPTION=@DESCRIPTION,"); strSql.Append("BATCH_NO=@BATCH_NO,"); strSql.Append("STATUS=@STATUS,"); strSql.Append("START_WEIGHT=@START_WEIGHT,"); strSql.Append("CURRENT_WEIGHT=@CURRENT_WEIGHT,"); strSql.Append("THAWING_DATETIME=@THAWING_DATETIME,"); strSql.Append("READY_DATETIME=@READY_DATETIME,"); strSql.Append("EXPIRY_DATETIME=@EXPIRY_DATETIME,"); strSql.Append("MF_EXPIRY_DATE=@MF_EXPIRY_DATE,"); strSql.Append("USER_ID=@USER_ID,"); strSql.Append("USER_NAME=@USER_NAME,"); strSql.Append("USER_GROUP=@USER_GROUP,"); strSql.Append("DEPARTMENT=@DEPARTMENT,"); strSql.Append("UPDATED_TIME=@UPDATED_TIME"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@SLOT_ID", SqlDbType.Int, 4), new SqlParameter("@SLOT_INDEX", SqlDbType.Int, 4), new SqlParameter("@CAPACITY", SqlDbType.Int, 4), new SqlParameter("@PART_ID", SqlDbType.VarChar, 50), new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 50), new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50), new SqlParameter("@STATUS", SqlDbType.VarChar, 50), new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime), new SqlParameter("@READY_DATETIME", SqlDbType.DateTime), new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime), new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime), new SqlParameter("@USER_ID", SqlDbType.VarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@USER_GROUP", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime) }; parameters[0].Value = model.SLOT_ID; parameters[1].Value = model.SLOT_INDEX; parameters[2].Value = model.CAPACITY; parameters[3].Value = model.PART_ID; parameters[4].Value = model.SAPCODE; parameters[5].Value = model.DESCRIPTION; parameters[6].Value = model.BATCH_NO; parameters[7].Value = model.STATUS; parameters[8].Value = model.START_WEIGHT; parameters[9].Value = model.CURRENT_WEIGHT; parameters[10].Value = model.THAWING_DATETIME; parameters[11].Value = model.READY_DATETIME; parameters[12].Value = model.EXPIRY_DATETIME; parameters[13].Value = model.MF_EXPIRY_DATE; parameters[14].Value = model.USER_ID; parameters[15].Value = model.USER_NAME; parameters[16].Value = model.USER_GROUP; parameters[17].Value = model.DEPARTMENT; parameters[18].Value = model.UPDATED_TIME; return(Common.DB.SqlDB.GenerateCommand(strSql.ToString(), parameters)); }