void QueryPolicy(Pagination pagination)
{
try
{
var query_list = PolicyManageService.QueryBargainPolicies(GetCondition(), pagination);
var list = from item in query_list
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//中转城市
Transit = item.Transit,
//排除日期
DepartureDateFilter = item.DepartureDateFilter,
//适用班期
DepartureWeekFilter = StringOperation.TransferToChinese(item.DepartureWeekFilter),
//航班限制
Include = item.DepartureFlightsFilterType == LimitType.None ? "不限" : (item.DepartureFlightsFilterType == LimitType.Include ? ("适用：" + item.DepartureFlightsFilter) : "不适用：" + item.DepartureFlightsFilter),
//适用舱位
Berths = item.Berths,
//提前天数
BeforehandDays = item.BeforehandDays > -1 ? item.BeforehandDays.ToString() : "",
//发布价格
PriceInfo = item.PriceType == PriceType.Price ? (item.Price > -1 ? (item.Price.TrimInvaidZero() + "元") : "") : (item.PriceType == PriceType.Discount ? (item.Price * 100).TrimInvaidZero() + "折" : "按返佣"),
//返佣信息
Commission = (item.IsInternal ? "内部: " + (item.InternalCommission * 100).TrimInvaidZero() + "%<br />" : "")
+ "下级: " + (item.SubordinateCommission * 100).TrimInvaidZero() + "%<br />"
+ "" + ((item.IsPeer) ? "同行: " + (item.ProfessionCommission * 100).TrimInvaidZero() + "%" : ""),
//行程类型
TicketType = item.TicketType + "<br />" + item.VoyageType.GetDescription(),
//航班日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
//提供者
Opearor = base_policy_manage.GetCompanyName(item.Owner),
Sudit = item.Audited == true ? "已审" : "未审",
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂",
LockTip = item.Freezed == true ? "<a href='javascript:unlockpolicy(\"" + item.Id + "\")'>解锁</a>" : "<a href='javascript:lockpolicy(\"" + item.Id + "\")'>锁定</a>",
Lock = item.Freezed == true ? "锁定" : "未锁定"
};
this.grv_bargain.DataSource = list;
this.grv_bargain.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_bargain.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}
void QueryPolicy(Pagination pagination)
{
try
{
var list_query = PolicyManageService.QueryBargainPolicies(GetCondition(), pagination);
var list = from item in list_query
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//中转城市
Transit = item.Transit,
//票证行程
TicketType = item.TicketType + "<br />" + item.VoyageType.GetDescription(),
//排除日期
DepartureDateFilter = item.DepartureDateFilter,
//适用班期
DepartureWeekFilter = StringOperation.TransferToChinese(item.DepartureWeekFilter),
//航班限制
Include = item.DepartureFlightsFilterType == LimitType.None ? "不限" : (item.DepartureFlightsFilterType == LimitType.Include ? ("适用：" + item.DepartureFlightsFilter) : "不适用：" + item.DepartureFlightsFilter),
//适用舱位
Berths = item.Berths,
//发布价格
Price = (item.PriceType == PriceType.Price ? item.Price : 0).TrimInvaidZero(),
//发布价格
PriceInfo = item.PriceType == PriceType.Price ? (item.Price > -1 ? (item.Price.TrimInvaidZero() + "元") : "") : (item.PriceType == PriceType.Discount ? (item.Price * 100).TrimInvaidZero() + "折" : "按返佣"),
//价格类型
PriceTypes = item.PriceType,
//发布折扣
DisCount = ((item.PriceType == PriceType.Discount ? item.Price : 0) * 100).TrimInvaidZero(),
//提前天数
BeforehandDays = item.BeforehandDays > -1 ? item.BeforehandDays.ToString() : "",
//返佣信息
Commission = (item.IsInternal ? "内部: " + (item.InternalCommission * 100).TrimInvaidZero() + "%<br />" : "")
+ "下级: " + (item.SubordinateCommission * 100).TrimInvaidZero() + "%<br />"
+ "" + ((item.IsPeer) ? "同行: " + (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"),
//操作人
Opearor = item.Creator,
Sudit = item.Audited ? "已审" : "未审",
SuditName = item.Audited ? "UnAudited" : "Audited",
SuditTip = item.Audited ? "取消审核" : "确认审核",
item.IsInternal,
item.IsPeer,
item.VoyageType,
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂"
};
this.grv_bargain.DataSource = list;
this.grv_bargain.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_bargain.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}