private string toexcel(int tid) { IList <EyouSoft.Model.TourStructure.JPGYSTours> list = null; EyouSoft.BLL.TourStructure.Tour tBll = new EyouSoft.BLL.TourStructure.Tour(); int count = 0; count = Utils.GetInt(Utils.GetFormValue("hidRecordCount")); if (count == 0) { count = 100; } list = tBll.GetToursJPGYS(SiteUserInfo.CompanyID, count, pageIndex, ref recordCount, tid); if (recordCount != 0) { list = tBll.GetToursJPGYS(SiteUserInfo.CompanyID, count, pageIndex, ref recordCount, tid); } Response.Clear(); Response.AppendHeader("Content-Disposition", "attachment;filename=" + "area" + DateTime.Now.ToShortDateString() + ".xls"); Response.ContentEncoding = System.Text.Encoding.Default; Response.ContentType = "application/ms-excel"; //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符 StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n", "团号", "线路名称", "出团日期", "人数", "票款", "计调员", "代理费", "总费用"); foreach (EyouSoft.Model.TourStructure.JPGYSTours cs in list) { sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n", cs.TourCode, cs.RouteName, cs.LDate.ToString("yyyy-MM-dd"), cs.PeopleNum, cs.TicketPrice, cs.PlanNames, cs.AgencyPrice, cs.TotalAmount); } return(sb.ToString()); }
private void bind(int tid) { //初使化条件 pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); #region 查询条件 EyouSoft.Model.TourStructure.MTimesSummaryDiJieSearchInfo searchinfo = new EyouSoft.Model.TourStructure.MTimesSummaryDiJieSearchInfo(); DateTime?SDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("date")); DateTime?LDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LDate")); int? PayStatus = Utils.GetIntNull(Utils.GetQueryStringValue("status")); if (SDate != null) { this.txt_Date.Value = Convert.ToDateTime(SDate).ToString("yyyy-MM-dd"); } searchinfo.SDate = SDate; if (LDate != null) { this.txt_Date1.Value = Convert.ToDateTime(LDate).ToString("yyyy-MM-dd"); } searchinfo.EDate = LDate; if (SeleState.Items.FindByValue(PayStatus.ToString()) != null) { SeleState.Items.FindByValue(PayStatus.ToString()).Selected = true; } searchinfo.PayStatus = PayStatus; #endregion IList <EyouSoft.Model.TourStructure.JPGYSTours> list = null; EyouSoft.BLL.TourStructure.Tour tBll = new EyouSoft.BLL.TourStructure.Tour(); list = tBll.GetToursJPGYS(CurrentUserCompanyID, pageSize, pageIndex, ref recordCount, tid, searchinfo); len = list == null ? 0 : list.Count; this.repList.DataSource = list; this.repList.DataBind(); //设置总计 EyouSoft.Model.SupplierStructure.MTimesSummaryJiPiaoInfo jpInfoModel = new EyouSoft.BLL.CompanyStructure.CompanySupplier().GetTimesSummaryJiPiao(SiteUserInfo.CompanyID, tid, searchinfo); if (jpInfoModel != null) { this.lblTicketPrice.Text = Utils.FilterEndOfTheZeroString(jpInfoModel.TicketAmount.ToString("0.00")); this.lblAgencyPrice.Text = Utils.FilterEndOfTheZeroString(jpInfoModel.AgencyAmount.ToString("0.00")); this.lblNotPayAmount.Text = Utils.FilterEndOfTheZeroString(jpInfoModel.NotPayAmount.ToString("0.00")); this.lblTotalAmount.Text = Utils.FilterEndOfTheZeroString(jpInfoModel.TotalAmount.ToString("0.00")); this.lblPeopleNum.Text = jpInfoModel.PeopleNumber.ToString(); } //设置分页 BindPage(); }