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