private static ChargePriceRange[] GetPriceRangeList()
{
if (PriceRangeList == null)
{
PriceRangeList = ChargePriceRange.GetChargePriceRangeList();
}
return(PriceRangeList);
}
private static ChargePriceRange[] GetPriceRangeList(ViewImportFeeDetail2 self)
{
var list = new List <ChargePriceRange>();
if (PriceRangeList == null || PriceRangeList.Length == 0)
{
PriceRangeList = ChargePriceRange.GetChargePriceRangeList();
}
if (PriceFeeRangeList == null)
{
PriceFeeRangeList = ChargeFeePriceRange.GetAllActiveChargeFeePriceRangeList();
}
if (self.RoomFeeID > 0)
{
if (PriceFeeRangeList != null && PriceFeeRangeList.Length > 0)
{
var my_pricefee_list = PriceFeeRangeList.Where(p => p.RoomFeeID == self.RoomFeeID && p.SummaryID == self.ChargeID).ToArray();
foreach (var item in my_pricefee_list)
{
var data = new ChargePriceRange();
data.SummaryID = item.SummaryID;
data.MinValue = item.MinValue;
data.MaxValue = item.MaxValue;
data.BasePrice = item.BasePrice;
data.BaseType = item.BaseType;
data.IsActive = item.IsActive;
list.Add(data);
}
}
return(list.OrderBy(p =>
{
decimal minvalue = 0;
decimal.TryParse(p.MinValue, out minvalue);
return minvalue;
}).ToArray());
}
else
{
if (PriceRangeList != null && PriceRangeList.Length > 0)
{
list = PriceRangeList.Where(p => p.SummaryID == self.ChargeID).OrderBy(p =>
{
decimal minvalue = 0;
decimal.TryParse(p.MinValue, out minvalue);
return(minvalue);
}).ToList();
}
return(list.ToArray());
}
}
public static Ui.DataGrid GetChargePriceRangeGridBySummaryID(int SummaryID, string orderBy, long startRowIndex, int pageSize)
{
long totalRows = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("[SummaryID]=@SummaryID");
parameters.Add(new SqlParameter("@SummaryID", SummaryID));
string fieldList = "[ChargePriceRange].* ";
string Statement = " from [ChargePriceRange] where " + string.Join(" and ", conditions.ToArray());
ChargePriceRange[] list = new ChargePriceRange[] { };
list = GetList <ChargePriceRange>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray();
DataAccess.Ui.DataGrid dg = new Ui.DataGrid();
dg.rows = list;
dg.total = totalRows;
dg.page = pageSize;
return(dg);
}