public UserSalaryItemModel ReaderBind(IDataReader dataReader) { UserSalaryItemModel model = new UserSalaryItemModel { UserItemID = dataReader["UserItemID"].ToString(), UserCode = dataReader["UserCode"].ToString(), ItemCode = dataReader["ItemCode"].ToString() }; object obj2 = dataReader["ItemValue"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.ItemValue = new decimal?((decimal)obj2); } return(model); }
public int Update(UserSalaryItemModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update SaM_UserSalaryItem set "); builder.Append("UserCode=@UserCode,"); builder.Append("ItemCode=@ItemCode,"); builder.Append("ItemValue=@ItemValue"); builder.Append(" where UserItemID=@UserItemID "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@UserItemID", SqlDbType.NVarChar, 0x40), new SqlParameter("@UserCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ItemCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ItemValue", SqlDbType.Decimal, 9) }; commandParameters[0].Value = model.UserItemID; commandParameters[1].Value = model.UserCode; commandParameters[2].Value = model.ItemCode; commandParameters[3].Value = model.ItemValue; return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); }
public UserSalaryItemModel GetModel(string UserItemID) { StringBuilder builder = new StringBuilder(); builder.Append("select UserItemID,UserCode,ItemCode,ItemValue from SaM_UserSalaryItem "); builder.Append(" where UserItemID=@UserItemID "); UserSalaryItemModel model = null; using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@UserItemID", UserItemID) })) { if (reader.Read()) { model = this.ReaderBind(reader); } } return(model); }
public int Add(SqlTransaction trans, UserSalaryItemModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SaM_UserSalaryItem("); builder.Append("UserItemID,UserCode,ItemCode,ItemValue)"); builder.Append(" values ("); builder.Append("@UserItemID,@UserCode,@ItemCode,@ItemValue)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@UserItemID", SqlDbType.NVarChar, 0x40), new SqlParameter("@UserCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ItemCode", SqlDbType.NVarChar, 0x40), new SqlParameter("@ItemValue", SqlDbType.Decimal, 9) }; commandParameters[0].Value = model.UserItemID; commandParameters[1].Value = model.UserCode; commandParameters[2].Value = model.ItemCode; commandParameters[3].Value = model.ItemValue; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public int Update(UserSalaryItemModel model) { return(this.dal.Update(model)); }
public int Add(SqlTransaction trans, UserSalaryItemModel model) { return(this.dal.Add(trans, model)); }
public int Add(UserSalaryItemModel model) { return(this.dal.Add(null, model)); }