void QueryPolicy(Pagination pagination)
{
try
{
var list_query = PolicyManageService.GetRoundTripPolicies(GetCondition(pagination), item => item.CreateTime, OrderMode.Descending);
var list = from item in list_query
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//票证行程
TicketType = item.TicketType + "<br />" + item.VoyageType.GetDescription(),
//适用班期
// DepartureDatesFilter = item.DepartureDatesFilterType == DateMode.Date ? item.DepartureDatesFilter : StringOperation.TransferToChinese(item.DepartureDatesFilter),
//适用航班
Include = item.DepartureFlightsFilterType == LimitType.None ? "所有" : (item.DepartureFlightsFilterType == LimitType.Include ? item.DepartureFlightsFilter : " "),
//排除航班
Exclude = item.DepartureFlightsFilterType == LimitType.Exclude ? item.DepartureFlightsFilter : " ",
//适用舱位
Berths = item.Berths,
//价格
Price = item.Price.TrimInvaidZero(),
//返佣信息
Commission = BasePolicy.CanHaveSubordinate(CurrentCompany.CompanyId) ?
"内部: " + (item.InternalCommission * 100).TrimInvaidZero()
+ "%<br />下级: " + (item.SubordinateCommission * 100).TrimInvaidZero()
+ "%<br />同行: " + (item.ProfessionCommission * 100).TrimInvaidZero() + "%" :
"下级: " + (item.SubordinateCommission * 100).TrimInvaidZero()
+ "%<br />同行: " + (item.ProfessionCommission * 100).TrimInvaidZero() + "%",
InternalCommission = (item.InternalCommission * 100).TrimInvaidZero(),
SubordinateCommission = (item.SubordinateCommission * 100).TrimInvaidZero(),
ProfessionCommission = (item.ProfessionCommission * 100).TrimInvaidZero(),
//去程日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
//回程日期
ReturnDates = item.VoyageType == VoyageType.OneWay ? "" : (item.ReturnDateStart.Value.ToString("yyyy-MM-dd") + "<br />" + item.ReturnDateEnd.Value.ToString("yyyy-MM-dd")),
//供应方
Opearor = item.Creator,
Sudit = item.Audited ? "已审" : "未审",
SuditName = item.Audited ? "UnAudited" : "Audited",
SuditTip = item.Audited ? "取消审核" : "确认审核",
CanHaveSubordinate = BasePolicy.CanHaveSubordinate(CurrentCompany.CompanyId),
Hang = item.Suspended ? BasePolicy.GetHungInfo(item.Airline, this.CurrentCompany.CompanyId) : "未挂"
};
this.grv_back.DataSource = list;
this.grv_back.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = list_query.RowCount;
}
showempty.Visible = false;
grv_back.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}
void QueryPolicy(Pagination pagination)
{
try
{
var query_list = PolicyManageService.GetRoundTripPolicies(GetCondition(pagination), item => item.CreateTime, OrderMode.Descending);
var list = from item in query_list
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//票证行程
TicketType = item.TicketType + "<br />" + item.VoyageType.GetDescription(),
//适用班期
// DepartureDatesFilter = item.DepartureDatesFilterType == DateMode.Date ? item.DepartureDatesFilter : StringOperation.TransferToChinese(item.DepartureDatesFilter),
//适用航班
Include = item.DepartureFlightsFilterType == LimitType.None ? "所有" : (item.DepartureFlightsFilterType == LimitType.Include ? item.DepartureFlightsFilter : " "),
//排除航班
Exclude = item.DepartureFlightsFilterType == LimitType.Exclude ? item.DepartureFlightsFilter : " ",
////排除航线
//ExceptAirways = item.ExceptAirways.Length > 3 ? item.ExceptAirways.ToString().Substring(0, 3) + "...<div class='DepartureTip'>" + StringOperation.InsertFormat(item.ExceptAirways.ToString(), 32, "<br />") + "</div>" : item.ExceptAirways,
//适用舱位
Berths = item.Berths,
//返佣信息
Commission = "内部:" + (item.InternalCommission * 100).TrimInvaidZero()
+ "%<br />下级:" + (item.SubordinateCommission * 100).TrimInvaidZero()
+ "%<br />同行:" + (item.ProfessionCommission * 100).TrimInvaidZero() + "%",
//去程日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
//回程日期
ReturnDates = item.VoyageType == VoyageType.OneWay ? "" : (item.ReturnDateStart.Value.ToString("yyyy-MM-dd") + "<br />" + item.ReturnDateEnd.Value.ToString("yyyy-MM-dd")),
//供应方
Opearor = GetCompanyName(item.Owner),
Sudit = item.Audited == true ? "已审" : "未审",
Lock = item.Freezed == true ? "锁定" : "未锁定",
LockTip = item.Freezed == true ? "<a href='javascript:unlockpolicy(\"" + item.Id + "\")'>解锁</a>" : "<a href='javascript:lockpolicy(\"" + item.Id + "\")'>锁定</a>",
Hang = item.Suspended ? ChinaPay.B3B.TransactionWeb.PolicyModule.TransactionPolicy.BasePolicy.GetHungInfo(item.Airline, item.Owner) : "未挂"
};
this.grv_back.DataSource = list;
this.grv_back.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = query_list.RowCount;
}
showempty.Visible = false;
grv_back.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}
