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, "查询"); } }