void QueryPolicy(Pagination pagination)
{
try
{
var list_query = PolicyManageService.QuerySpecialPolicies(GetCondition(), pagination);
var list = from item in list_query
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//排除日期
DepartureDateFilter = item.DepartureDateFilter,
//适用班期
DepartureWeekFilter = StringOperation.TransferToChinese(item.DepartureWeekFilter),
//航班限制
Include = item.DepartureFlightsFilterType == LimitType.None ? "不限" : (item.DepartureFlightsFilterType == LimitType.Include ? ("适用：" + item.DepartureFlightsFilter) : "不适用：" + item.DepartureFlightsFilter),
//提前天数
BeforehandDays = item.BeforehandDays == -1 ? "" : item.BeforehandDays + "",
//特殊票类型
Type = item.Type.GetDescription(),
//发布价格
Price = item.PriceType == PriceType.Price ? item.Price.TrimInvaidZero() : (item.Price * 100).TrimInvaidZero(),
//价格/直减
PriceInfo = item.PriceType == PriceType.Price ? (item.Price == -1 ? "" : item.Price.TrimInvaidZero() + "元") : (item.PriceType == PriceType.Subtracting ? (item.Price * 100).TrimInvaidZero() + "%" : ""),
//航班日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
item.PriceType,
item.IsInternal,
item.IsPeer,
InternalCommission = item.PriceType == PriceType.Price ? item.InternalCommission.TrimInvaidZero() : (item.InternalCommission * 100).TrimInvaidZero(),
SubordinateCommission = CurrentCompany.CompanyType == CompanyType.Provider || (CurrentCompany.CompanyType == CompanyType.Supplier && OEM != null) ? item.PriceType == PriceType.Price ? item.SubordinateCommission.TrimInvaidZero() : (item.SubordinateCommission * 100).TrimInvaidZero() : "-1",
ProfessionCommission = item.PriceType == PriceType.Price ? item.ProfessionCommission.TrimInvaidZero() : (item.ProfessionCommission * 100).TrimInvaidZero(),
Commission = ((item.InternalCommission < 0 && !item.IsInternal) ? "" : ("内部: " + (item.PriceType == PriceType.Price ? item.InternalCommission.TrimInvaidZero() + "元<br />" : (item.InternalCommission * 100).TrimInvaidZero() + "%<br />")))
+ (item.SubordinateCommission < 0 ? "" : CurrentCompany.CompanyType == CompanyType.Provider || (CurrentCompany.CompanyType == CompanyType.Supplier && OEM != null) ? ("下级: " + (item.PriceType == PriceType.Price ? item.SubordinateCommission.TrimInvaidZero() + "元<br />" : (item.SubordinateCommission * 100).TrimInvaidZero() + "%<br />")) : "")
+ ((item.ProfessionCommission < 0 && !item.IsPeer) ? "" : ("同行: " + (item.PriceType == PriceType.Price ? item.ProfessionCommission.TrimInvaidZero() + "元" : (item.ProfessionCommission * 100).TrimInvaidZero() + "%"))),
TypeValue = item.Type,
//操作人
Opearor = item.Creator,
Sudit = item.Audited ? "已审" : "未审",
SuditName = item.Audited ? "UnAudited" : "Audited",
SuditTip = item.Audited ? "取消审核" : "确认审核",
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂",
//是否是特价舱位
item.IsBargainBerths
};
this.grv_specical.DataSource = list;
this.grv_specical.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_specical.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.QuerySpecialPolicies(GetCondition(), pagination);
var list = from item in list_query
select new
{
//航空公司 出发城市 到达城市 适用班期 适用航班 排除航班 提前时间 发布价格 航班日期 供应方 产品审核 平台审核 是否锁定 是否挂起
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//特殊票类型
SpecialType = item.Type.GetDescription(),
//排除日期
DepartureDateFilter = item.DepartureDateFilter,
//适用班期
DepartureWeekFilter = StringOperation.TransferToChinese(item.DepartureWeekFilter),
//航班限制
Include = item.DepartureFlightsFilterType == LimitType.None ? "不限" : (item.DepartureFlightsFilterType == LimitType.Include ? ("适用：" + item.DepartureFlightsFilter) : "不适用：" + item.DepartureFlightsFilter),
//提前时间
BeforehandDays = item.BeforehandDays > -1 ? item.BeforehandDays + "天" : "",
//发布价格
Price = item.Price,
//价格/直减
PriceInfo = item.PriceType == PriceType.Price ? (item.Price == -1 ? "" : item.Price.TrimInvaidZero() + "元") : (item.PriceType == PriceType.Subtracting ? (item.Price * 100).TrimInvaidZero() + "%" : ""),
//航班日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
Commission = ((item.InternalCommission < 0 && !item.IsInternal) ? "" : ("内部: " + (item.PriceType == PriceType.Price ? item.InternalCommission.TrimInvaidZero() + "元<br />" : (item.InternalCommission * 100).TrimInvaidZero() + "%<br />")))
+ (item.SubordinateCommission < 0 ? "" : ("下级: " + (item.PriceType == PriceType.Price ? item.SubordinateCommission.TrimInvaidZero() + "元<br />" : (item.SubordinateCommission * 100).TrimInvaidZero() + "%<br />")))
+ ((item.ProfessionCommission < 0 && !item.IsPeer) ? "" : ("同行: " + (item.PriceType == PriceType.Price ? item.ProfessionCommission.TrimInvaidZero() + "元" : (item.ProfessionCommission * 100).TrimInvaidZero() + "%"))),
//供应方
Opearor = base_policy_manage.GetCompanyName(item.Owner),
//产品审核
Sudit = item.Audited == true ? "已审" : "未审",
//平台审核
State = item.PlatformAudited == true ? "已审" : "未审",
//是否锁定
Lock = item.Freezed == true ? "锁定" : "未锁定",
LockTip = item.Freezed == true ? "<a href='javascript:unlockpolicy(\"" + item.Id + "\")'>解锁</a>" : "<a href='javascript:lockpolicy(\"" + item.Id + "\")'>锁定</a>",
SuditName = item.PlatformAudited == true ? "UnAudited" : "Audited",
SuditTip = item.PlatformAudited == true ? "取消审核" : "确认审核",
//挂起
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂"
};
this.grv_special.DataSource = list;
this.grv_special.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_special.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}
