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));
}
