protected void InitStatisList() { Datetime = EyouSoft.Common.Utils.GetQueryStringValue("DateTime"); ticketendtime = EyouSoft.Common.Utils.GetQueryStringValue("endtime"); EyouSoft.Model.PlanStructure.JiaoTongChuPiaoSearch search = new EyouSoft.Model.PlanStructure.JiaoTongChuPiaoSearch(); search.StartTime = EyouSoft.Common.Utils.GetDateTimeNullable(Datetime); search.EndTime = EyouSoft.Common.Utils.GetDateTimeNullable(ticketendtime); IList <EyouSoft.Model.PlanStructure.JiaoTongChuPiao> list = new EyouSoft.BLL.PlanStruture.PlanTrffic().GetJiaoTongChuPiao(this.SiteUserInfo.CompanyID, search); if (list != null && list.Count > 0) { this.prtticketlist.DataSource = list; this.prtticketlist.DataBind(); BindPage(); lenght = list.Count; #region 设置总计 //总票数 this.lblAllTickets.Text = list.Sum(p => p.ChuPiaoShu).ToString(); this.labDaiLiFeiCount.Text = list.Sum(p => p.AgencyPrice).ToString("0.00"); #endregion this.lblMsg.Visible = false; } else { this.lblMsg.Visible = true; this.ExportPageInfo1.Visible = false; } }
/// <summary> /// 导出Excel /// </summary> public void CreateExcel(string FileName) { Datetime = EyouSoft.Common.Utils.GetQueryStringValue("DateTime"); ticketendtime = EyouSoft.Common.Utils.GetQueryStringValue("endtime"); //列表数据绑定 Response.Clear(); Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls"); Response.ContentEncoding = System.Text.Encoding.Default; Response.ContentType = "application/ms-excel"; EyouSoft.Model.PlanStructure.JiaoTongChuPiaoSearch search = new EyouSoft.Model.PlanStructure.JiaoTongChuPiaoSearch(); search.StartTime = EyouSoft.Common.Utils.GetDateTimeNullable(Datetime); search.EndTime = EyouSoft.Common.Utils.GetDateTimeNullable(ticketendtime); IList <EyouSoft.Model.PlanStructure.JiaoTongChuPiao> list = new EyouSoft.BLL.PlanStruture.PlanTrffic().GetJiaoTongChuPiao(this.SiteUserInfo.CompanyID, search); if (list != null && list.Count > 0) { //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符 System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.AppendFormat("{0}\t{1}\t{2}\n", "交通名称", "出票数", "代理费"); foreach (EyouSoft.Model.PlanStructure.JiaoTongChuPiao cp in list) { sb.AppendFormat("{0}\t{1}\t{2}\n", cp.TrafficName, cp.ChuPiaoShu, cp.AgencyPrice.ToString("0.00")); } sb.AppendFormat("{0}\t{1}\t{2}\n", "总计", list.Sum(p => p.ChuPiaoShu).ToString(), list.Sum(p => p.AgencyPrice).ToString("0.00")); Response.Write(sb.ToString()); Response.End(); } }