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