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 RatePolicyDetailModel GetDataByID(string id)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT ");
sql.AppendLine(" RoomPolicyID, StartDate, EndDate, RoomType,");
//sql.AppendLine(" RoomTypeName = case RoomType when 0 then 'King' when 1 then 'Queen' end, ");
sql.AppendLine(" WeekDays, BasicRate, DiscountRate, IsDelete");
sql.AppendLine(" FROM RoomPolicy WITH(NOLOCK)");
sql.AppendLine(" WHERE RoomPolicyID=@RoomPolicyID");
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@RoomPolicyID", id);
SqlAccess mySqlAccess = new SqlAccess();
DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString(), paras);
RatePolicyDetailModel ratePolicy = new RatePolicyDetailModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ratePolicy = DataMappingHelper <RatePolicyDetailModel> .DataTableToEntity(ds.Tables[0]);
}
return(ratePolicy);
}
/// <summary>
/// 获取User管理详细页面数据
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public UserUpdateModule GetUserByID(string userID)
{
StringBuilder str = new StringBuilder();
str.AppendLine(" SELECT ");
str.AppendLine(" UserID, Username, Password, IsDelete ");
str.AppendLine(" FROM LoginUser with(Nolock)");
str.AppendLine(" WHERE UserID = @UserID");
SqlParameter[] paras = new SqlParameter[1];
paras[0] = new SqlParameter("@UserID", userID);
SqlAccess mySqlAccess = new SqlAccess();
DataSet ds = mySqlAccess.ExecuteAdapter(str.ToString(), paras);
UserUpdateModule user = new UserUpdateModule();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
user = DataMappingHelper <UserUpdateModule> .DataTableToEntity(ds.Tables[0]);
}
return(user);
}
public ShippingDetailModel GetDataByID(string id)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT ");
sql.AppendLine(" ShippingID, State, ShippingRate, IsDelete");
sql.AppendLine(" FROM Shipping WITH(NOLOCK)");
sql.AppendLine(" WHERE ShippingID=@ShippingID");
SqlParameter[] paras = new SqlParameter[1];
paras[0] = new SqlParameter("@ShippingID", id);
SqlAccess mySqlAccess = new SqlAccess();
DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString(), paras);
ShippingDetailModel Shipping = new ShippingDetailModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Shipping = DataMappingHelper <ShippingDetailModel> .DataTableToEntity(ds.Tables[0]);
}
return(Shipping);
}
