private string toexcel(int tid) { IList <EyouSoft.Model.TourStructure.LBGYSTours> list = null; EyouSoft.BLL.TourStructure.Tour tBll = new EyouSoft.BLL.TourStructure.Tour(); list = tBll.GetToursGYS(CurrentUserCompanyID, 1, 1, ref recordCount, tid); if (recordCount != 0) { list = tBll.GetToursGYS(CurrentUserCompanyID, recordCount, 1, 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("<table border='1'><tr><th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th><th>{6}</th><tr>", "团号", "线路名称", "出团日期", "人数", "计调员", "返利", "结算费用"); foreach (EyouSoft.Model.TourStructure.LBGYSTours cs in list) { sb.AppendFormat("<td >{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><tr>", " " + cs.TourCode + " ", cs.RouteName, cs.LDate.ToString("yyyy-MM-dd"), cs.PlanPeopleNumber, cs.PlanNames, cs.CommissionAmount, cs.SettlementAmount); } sb.Append("</table>"); return(sb.ToString()); }
private void bind(int tid) { //初使化条件 pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); 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; IList <EyouSoft.Model.TourStructure.LBGYSTours> list = null; EyouSoft.BLL.TourStructure.Tour tBll = new EyouSoft.BLL.TourStructure.Tour(); list = tBll.GetToursGYS(CurrentUserCompanyID, pageSize, pageIndex, ref recordCount, tid, searchinfo); len = list == null ? 0 : list.Count; this.repList.DataSource = list; this.repList.DataBind(); //设置合计 EyouSoft.Model.SupplierStructure.MTimesSummaryDiJieInfo djInfoModel = new EyouSoft.BLL.CompanyStructure.CompanySupplier().GetTimesSummaryDiJie(SiteUserInfo.CompanyID, tid, searchinfo); if (djInfoModel != null) { this.lblCommissionAmount.Text = Utils.FilterEndOfTheZeroString(djInfoModel.CommAmount.ToString("0.00")); this.lblNotPayAmount.Text = Utils.FilterEndOfTheZeroString(djInfoModel.NotPayAmount.ToString("0.00")); this.lblSettlementAmount.Text = Utils.FilterEndOfTheZeroString(djInfoModel.TotalAmount.ToString("0.00")); this.lblPeopleNum.Text = djInfoModel.PeopleNumber.ToString(); } //设置分页 BindPage(); }