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();
}
