public RoomRateDetailModel GetDataByID(string id)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT ");
sql.AppendLine(" RoomRateID, RateName, RateType,");
sql.AppendLine(" BasicRate, DiscountRate, DiscountDays, IsDelete");
sql.AppendLine(" FROM RoomRate WITH(NOLOCK)");
sql.AppendLine(" WHERE RoomRateID=@RoomRateID");
SqlParameter[] paras = new SqlParameter[1];
paras[0] = new SqlParameter("@RoomRateID", id);
SqlAccess mySqlAccess = new SqlAccess();
DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString(), paras);
RoomRateDetailModel roomRate = new RoomRateDetailModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
roomRate = DataMappingHelper <RoomRateDetailModel> .DataTableToEntity(ds.Tables[0]);
}
return(roomRate);
}
public void InsertData(RoomRateDetailModel model)
{
List <string> sqls = new List <string>();
List <SqlParameter[]> cmdParms = new List <SqlParameter[]>();
StringBuilder str = new StringBuilder();
str.AppendLine("Insert into RoomRate");
str.AppendLine(" (RateName, RateType, BasicRate, DiscountRate, DiscountDays, IsDelete, CreateTime, CreateUser, UpdateTime, UpdateUser) ");
str.AppendLine(" Values (@RateName, @RateType, @BasicRate, @DiscountRate, @DiscountDays, @IsDelete, getdate(), @CreateUser,getdate(), @UpdateUser);");
SqlParameter[] paras = new SqlParameter[8];
paras[0] = new SqlParameter("@RateName", Common.VariableConvert.ConvertStringToDBValue(model.RateName));
paras[1] = new SqlParameter("@RateType", model.RateType);
paras[2] = new SqlParameter("@BasicRate", model.BasicRate);
paras[3] = new SqlParameter("@DiscountRate", model.DiscountRate);
paras[4] = new SqlParameter("@DiscountDays", model.DiscountDays);
paras[5] = new SqlParameter("@IsDelete", Common.VariableConvert.BitConverter(model.IsDelete));
paras[6] = new SqlParameter("@CreateUser", Common.VariableConvert.ConvertStringToDBValue(model.CreateUser));
paras[7] = new SqlParameter("@UpdateUser", Common.VariableConvert.ConvertStringToDBValue(model.UpdateUser));
sqls.Add(str.ToString());
cmdParms.Add(paras);
SqlAccess mySqlAccess = new SqlAccess();
mySqlAccess.ExecuteNonQuerys(sqls, cmdParms);
}
public void UpdateData(RoomRateDetailModel model)
{
List <string> sqls = new List <string>();
List <SqlParameter[]> cmdParms = new List <SqlParameter[]>();
StringBuilder str = new StringBuilder();
str.AppendLine("update RoomRate set");
str.AppendLine(" RateName=@RateName");
str.AppendLine(" ,RateType=@RateType");
str.AppendLine(" ,BasicRate=@BasicRate");
str.AppendLine(" ,DiscountRate=@DiscountRate");
str.AppendLine(" ,DiscountDays=@DiscountDays");
str.AppendLine(" ,IsDelete=@IsDelete");
str.AppendLine(" ,UpdateTime=getdate()");
str.AppendLine(" ,UpdateUser=@UpdateUser");
str.AppendLine(" where RoomRateID=@RoomRateID");
SqlParameter[] paras = new SqlParameter[8];
paras[0] = new SqlParameter("@RateName", Common.VariableConvert.ConvertStringToDBValue(model.RateName));
paras[1] = new SqlParameter("@RateType", model.RateType);
paras[2] = new SqlParameter("@BasicRate", model.BasicRate);
paras[3] = new SqlParameter("@DiscountRate", model.DiscountRate);
paras[4] = new SqlParameter("@DiscountDays", model.DiscountDays);
paras[5] = new SqlParameter("@IsDelete", Common.VariableConvert.BitConverter(model.IsDelete));
paras[6] = new SqlParameter("@UpdateUser", Common.VariableConvert.ConvertStringToDBValue(model.UpdateUser));
paras[7] = new SqlParameter("@RoomRateID", model.RoomRateID);
sqls.Add(str.ToString());
cmdParms.Add(paras);
SqlAccess mySqlAccess = new SqlAccess();
mySqlAccess.ExecuteNonQuerys(sqls, cmdParms);
}
