IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticAirLine> list = null;//未收集合
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!CheckGrant(TravelPermission.机票管理_机票管理_出票统计))
{
Utils.ResponseNoPermit(TravelPermission.机票管理_机票管理_出票统计, false);
}
Bind();
#region 导出报表请求
if (Utils.GetInt(Request.QueryString["isExport"], 0) == 1)
{
var bll = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(SiteUserInfo);
var model = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
model.OfficeName = Utils.GetQueryStringValue("OfficeName");
model.CompanyId = SiteUserInfo.CompanyID;
model.DepartName = Utils.GetQueryStringValue("DepartMents");
string strDepIds = Utils.GetQueryStringValue("DepartIds");
model.DepartIds = JiPiao_TuiList.GetIntArrByStr(strDepIds);
model.StartTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("DateTime"));
model.EndTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("endtime"));
model.LeaveDateStart = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
model.LeaveDateEnd = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
list = bll.GetTicketOutStatisticAirLine(model);
if (list != null && list.Count != 0)
{
ToExcel(this.rpt_list, list);
}
}
#endregion
}
}
void Bind()
{
pageIndex = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1);
EyouSoft.BLL.StatisticStructure.TicketOutStatistic bll = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(SiteUserInfo);
EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti model = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
model.OfficeName = Utils.GetQueryStringValue("OfficeName");
model.CompanyId = SiteUserInfo.CompanyID;
model.DepartName = Utils.GetQueryStringValue("DepartMents");
string strDepIds = Utils.GetQueryStringValue("DepartIds");
model.DepartIds = JiPiao_TuiList.GetIntArrByStr(strDepIds);
model.StartTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("DateTime"));
model.EndTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("endtime"));
model.LeaveDateStart = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
model.LeaveDateEnd = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
list = bll.GetTicketOutStatisticAirLine(model);
if (list != null && list.Count > 0)
{
recordCount = list.Count;
rpt_list.DataSource = list.Skip((pageIndex - 1) * pageSize).Take(pageSize);
rpt_list.DataBind();
#region 设置总计
//总票数
this.lblAllTickets = list.Sum(p => p.TicketOutNum).ToString();
//应付机票款
this.lblNeedMoney = list.Sum(p => p.TotalAmount).ToString("￥#,###0.00");
//已付机票款
this.lblOverMoney = list.Sum(p => p.PayAmount).ToString("￥#,###0.00");
//未付机票款
this.lblNoMoney = list.Sum(p => p.UnPaidAmount).ToString("￥#,###0.00");
#endregion
#region 设置分页
ExportPageInfo1.intPageSize = pageSize;
ExportPageInfo1.intRecordCount = recordCount;
ExportPageInfo1.PageLinkURL = Request.Path + "?";
ExportPageInfo1.UrlParams = Request.QueryString;
ExportPageInfo1.CurrencyPage = pageIndex;
#endregion
}
else
{
//没有数据隐藏控件
ExportPageInfo1.Visible = false;
}
UCselectDepart.GetDepartmentName = model.DepartName;
UCselectDepart.GetDepartId = strDepIds;
txt_date.Value = model.StartTicketOutTime.HasValue ? model.StartTicketOutTime.Value.ToString("yyyy-MM-dd") : "";
txt_endDate.Value = model.EndTicketOutTime.HasValue ? model.EndTicketOutTime.Value.ToString("yyyy-MM-dd") : "";
txt_spq.Value = model.OfficeName;
txtLeaveDateStart.Text = model.LeaveDateStart.HasValue ? model.LeaveDateStart.Value.ToString("yyyy-MM-dd") : string.Empty;
txtLeaveDateEnd.Text = model.LeaveDateEnd.HasValue ? model.LeaveDateEnd.Value.ToString("yyyy-MM-dd") : string.Empty;
}