void QueryPolicy(Pagination pagination)
{
try
{
var listQuery = PolicyManageService.QueryNotchPolicies(GetCondition(), pagination);
var list = from item in listQuery
select new
{
//政策编号
id = item.Id,
//航空公司
item.Airline,
//票证行程
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),
//排除航线
item.ExceptAirways,
//适用舱位
item.Berths,
//返佣信息
Commission = (item.IsInternal ? "内部: " + (item.InternalCommission * 100).TrimInvaidZero() + "%<br />" : "")
+ "下级: " + (item.SubordinateCommission * 100).TrimInvaidZero() + "%<br />"
+ "" + ((item.IsPeer) ? "同行: " + (item.ProfessionCommission * 100).TrimInvaidZero() + "%" : ""),
//去程日期
DepartureDates = item.DepartureDateStart.ToString("yyyy-MM-dd") + "<br />" + item.DepartureDateEnd.ToString("yyyy-MM-dd"),
//操作人
Opearor = base_policy_manage.GetCompanyName(item.Owner)
+ (item.DiscountPoint ? "<br />已扣点" : "")
+ (item.MountPoint ? "<br />已贴点" : ""),
Sudit = item.Audited ? "已审" : "未审",
Lock = item.Freezed ? "锁定" : "未锁",
LockTip = item.Freezed ? "<a href='javascript:unlockpolicy(\"" + item.Id + "\")'>解锁</a>" : "<a href='javascript:lockpolicy(\"" + item.Id + "\")'>锁定</a>",
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂"
};
this.grv_normal.DataSource = list;
this.grv_normal.DataBind();
if (listQuery.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_normal.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}
void QueryPolicy(Pagination pagination)
{
try
{
var querylist = PolicyManageService.QueryNotchPolicies(GetCondition(), pagination);
var list = from item in querylist
select new
{
//政策编号
id = item.Id,
//航空公司
Airline = item.Airline,
//出发城市
Departure = item.Departure,
//到达城市
Arrival = item.Arrival,
//票证行程
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,
//返佣信息
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(),
// VipCommission = (item.VipCommission * 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.IsPeer,
//内部
item.IsInternal,
Hang = item.Suspended ? (item.SuspendByPlatform ? "平台挂起" : "公司挂起") : "未挂"
};
this.grv_normal.DataSource = list;
this.grv_normal.DataBind();
if (list.Any())
{
this.pager.Visible = true;
if (pagination.GetRowCount)
{
this.pager.RowCount = pagination.RowCount;
}
showempty.Visible = false;
grv_normal.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
this.pager.Visible = false;
showempty.Visible = true;
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "查询");
}
}