protected void btnOutput3_Click(object sender, EventArgs e)
{
//整理后数据Gov3
if (string.IsNullOrEmpty(txt_name3djs.Text))
{
return;
}
IList<Model.DJ_GroupConsumRecord> gcrlist = bllCustomRecord.GetGCR8Multi(null, null, null, null, null);
#region 筛选省市
if (CurrentDpt.Area.Level == Model.AreaLevel.省)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 2))).ToList();
}
else if (CurrentDpt.Area.Level == Model.AreaLevel.市)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 4))).ToList();
}
else if (CurrentDpt.Area.Level == Model.AreaLevel.区县)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 6))).ToList();
}
#endregion
#region 筛选时间
string[] tempdate = txt_yijiedai3.Text.Split(new char[] { '年', '月' });
if (tempdate.Length >= 2)
{
var begin_date = new DateTime(int.Parse(tempdate[0]), int.Parse(tempdate[1]), 1);
var end_date = begin_date.AddMonths(1);
gcrlist = gcrlist
.Where(x => x.ConsumeTime >= begin_date && x.ConsumeTime < end_date)
.ToList();
//筛选企业
if (!string.IsNullOrEmpty(txt_name2.Text))
{
gcrlist = gcrlist.Where(x => x.Enterprise.Name == txt_name3djs.Text).ToList();
}
}
else
{
return;
}
#endregion
#region 整理数据
IList<statics_Gov3> sm3 = new List<statics_Gov3>();
foreach (var item3 in gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo != null))
{
var temp = new statics_Gov3();
temp.Name = item3.Route.DJ_TourGroup.DJ_DijiesheInfo.Name;
temp.Gname = item3.Route.DJ_TourGroup.Name;
temp.GId = item3.Route.DJ_TourGroup.Id.ToString();
temp.Bedate = item3.Route.DJ_TourGroup.BeginDate.ToShortDateString() + "~" + item3.Route.DJ_TourGroup.EndDate.ToShortDateString();
#region 昨日住宿
var temp_y_hotel = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days));
if (temp_y_hotel.Count() > 0)
{
foreach (var item in temp_y_hotel)
{
temp.y_hotel += item.Enterprise.Name + " ";
}
}
else
{
temp.y_hotel = "无";
}
#endregion
#region 今日住宿
var temp_t_hotel = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days + 1));
if (temp_t_hotel.Count() > 0)
{
foreach (var item in temp_t_hotel)
{
temp.t_hotel += item.Enterprise.Name + " ";
}
}
else
{
temp.t_hotel = "无";
}
#endregion
#region 今日景区
var temp_t_scenic = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.景点)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days + 1));
if (temp_t_scenic.Count() > 0)
{
foreach (var item in temp_t_hotel)
{
temp.t_scenic += item.Enterprise.Name + " ";
}
}
else
{
temp.t_scenic = "无";
}
#endregion
sm3.Add(temp);
}
#endregion
//创建datatable
DataTable tblDatas = new DataTable("Datas");
tblDatas.Columns.Add("id", Type.GetType("System.String"));
tblDatas.Columns.Add("djsname", Type.GetType("System.String"));
tblDatas.Columns.Add("gname", Type.GetType("System.String"));
tblDatas.Columns.Add("datetime", Type.GetType("System.String"));
tblDatas.Columns.Add("situation", Type.GetType("System.String"));
int i = 1;
foreach (var item in sm3)
{
tblDatas.Rows.Add(new object[] { i++, item.Name, item.Gname, item.Bedate,
"上一日住宿："+item.y_hotel+"，准备入住："+item.t_hotel+"今日游览："+item.t_scenic });
}
new ExcelOplib.ExcelOutput().Download2Excel(tblDatas, this.Page, new List<string>() {
"序号","地接社名称","团队名称","时间","游览情况"
}, CurrentDpt.Name + "[" + DateTime.Today.ToString("yyyy-MM-dd") + "]" + "团队旅游情况表");
}
//protected void BindGov3()
//{
////整理后数据Gov3
//IList<Model.DJ_TourGroup> tglist = blltg.();
//#region 筛选省市
//if (CurrentDpt.Area.Level == Model.AreaLevel.省)
//{
// tglist = tglist
// .Where(x => x.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 2)))
// .ToList();
//}
//if (CurrentDpt.Area.Level == Model.AreaLevel.市)
//{
// tglist = tglist
// .Where(x => x.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 4)))
// .ToList();
//}
//if (CurrentDpt.Area.Level == Model.AreaLevel.区县)
//{
// tglist = tglist
// .Where(x => x.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 6)))
// .ToList();
//}
//#endregion
////筛选企业
//if (!string.IsNullOrEmpty(txt_name3djs.Text))
//{
// tglist = tglist.Where(x => x.Routes.Where(y => y.Enterprise.Name == txt_name3djs.Text.Trim()).Count() > 0).ToList();
//}
////筛选日期
//string[] temp = txt_yijiedai3.Text.Split(new char[] { '年', '月' });
//if (!string.IsNullOrEmpty(txt_yijiedai3.Text) && temp.Length >= 2)
//{
// var begin_date = new DateTime(int.Parse(temp[0]), int.Parse(temp[1]), 1);
// var end_date = begin_date.AddMonths(1);
// tglist = tglist.Where(x => x.BeginDate >= begin_date && x.EndDate.AddDays(x.DaysAmount) < end_date).ToList();
//}
//IList<statics_Gov3> sm3 = new List<statics_Gov3>();
//foreach (var item3 in tglist.Where(x => x.DJ_DijiesheInfo != null))
//{
// var temp = new statics_Gov3();
// temp.Name = item3.DJ_DijiesheInfo.Name;
// temp.Gname = item3.Name;
// temp.GId = item3.Id.ToString();
// temp.Bedate = item3.BeginDate.ToShortDateString() + "~" + item3.EndDate.ToShortDateString();
// var temp_y_hotel = item3.Routes
// .Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
// .Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.BeginDate).Days));
// if (temp_y_hotel.Count() > 0)
// {
// foreach (var item in temp_y_hotel)
// {
// temp.y_hotel += item.Enterprise.Name + " ";
// }
// }
// else
// {
// temp.y_hotel = "无";
// }
// var temp_t_hotel = item3.Routes
// .Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
// .Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.BeginDate).Days + 1));
// if (temp_t_hotel.Count() > 0)
// {
// foreach (var item in temp_t_hotel)
// {
// temp.t_hotel += item.Enterprise.Name + " ";
// }
// }
// else
// {
// temp.t_hotel = "无";
// }
// var temp_t_scenic = item3.Routes
// .Where(x => x.Enterprise.Type == Model.EnterpriseType.景点)
// .Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.BeginDate).Days + 1));
// if (temp_t_scenic.Count() > 0)
// {
// foreach (var item in temp_t_hotel)
// {
// temp.t_scenic += item.Enterprise.Name + " ";
// }
// }
// else
// {
// temp.t_scenic = "无";
// }
// sm3.Add(temp);
//}
//////V.2012.10.27
//////团队名字非空
////if (!string.IsNullOrEmpty(txt_name3.Text))
////{
//// //地接社名字非空
//// if (!string.IsNullOrEmpty(txt_name3djs.Text))
//// {
//// sm3 = sm3.Where(x => x.Name.Split(new string[] { txt_name3djs.Text }, StringSplitOptions.None).Count() > 1).ToList();
//// rptGov3.DataSource = sm3.Where(x => x.Name.Split(new string[] { txt_name3.Text }, StringSplitOptions.None).Count() > 1);
//// }
//// else
//// {
//// rptGov3.DataSource = sm3.Where(x => x.Name.Split(new string[] { txt_name3.Text }, StringSplitOptions.None).Count() > 1);
//// }
////}
//////团队名字空
////else
////{
////if (!string.IsNullOrEmpty(txt_name3djs.Text))
////{
//// rptGov3.DataSource = sm3.Where(x => x.Name.Split(new string[] { txt_name3djs.Text }, StringSplitOptions.None).Count() > 1);
////}
////else
////{
////V.20120.10.30
//rptGov3.DataSource = sm3;
////}
////}
//rptGov3.DataBind();
//}
protected void BindGov3()
{
if (string.IsNullOrEmpty(txt_name3djs.Text))
{
return;
}
IList<Model.DJ_GroupConsumRecord> gcrlist = bllCustomRecord.GetGCR8Multi(null, null, null, null, null);
#region 筛选省市
if (CurrentDpt.Area.Level == Model.AreaLevel.省)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 2))).ToList();
}
else if (CurrentDpt.Area.Level == Model.AreaLevel.市)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 4))).ToList();
}
else if (CurrentDpt.Area.Level == Model.AreaLevel.区县)
{
gcrlist = gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo.Area.Code.StartsWith(CurrentDpt.Area.Code.Substring(0, 6))).ToList();
}
#endregion
#region 筛选时间
string[] tempdate = txt_yijiedai3.Text.Split(new char[] { '年', '月' });
if (tempdate.Length >= 2)
{
var begin_date = new DateTime(int.Parse(tempdate[0]), int.Parse(tempdate[1]), 1);
var end_date = begin_date.AddMonths(1);
gcrlist = gcrlist
.Where(x => x.ConsumeTime >= begin_date && x.ConsumeTime < end_date)
.ToList();
//筛选企业
if (!string.IsNullOrEmpty(txt_name3djs.Text))
{
gcrlist = gcrlist.Where(x => x.Enterprise.Name == txt_name3djs.Text).ToList();
}
}
else
{
return;
}
#endregion
#region 整理数据
IList<statics_Gov3> sm3 = new List<statics_Gov3>();
foreach (var item3 in gcrlist.Where(x => x.Route.DJ_TourGroup.DJ_DijiesheInfo != null))
{
var temp = new statics_Gov3();
temp.Name = item3.Route.DJ_TourGroup.DJ_DijiesheInfo.Name;
temp.Gname = item3.Route.DJ_TourGroup.Name;
temp.GId = item3.Route.DJ_TourGroup.Id.ToString();
temp.Bedate = item3.Route.DJ_TourGroup.BeginDate.ToShortDateString() + "~" + item3.Route.DJ_TourGroup.EndDate.ToShortDateString();
#region 昨日住宿
var temp_y_hotel = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days));
if (temp_y_hotel.Count() > 0)
{
foreach (var item in temp_y_hotel)
{
temp.y_hotel += item.Enterprise.Name + " ";
}
}
else
{
temp.y_hotel = "无";
}
#endregion
#region 今日住宿
var temp_t_hotel = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.宾馆)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days + 1));
if (temp_t_hotel.Count() > 0)
{
foreach (var item in temp_t_hotel)
{
temp.t_hotel += item.Enterprise.Name + " ";
}
}
else
{
temp.t_hotel = "无";
}
#endregion
#region 今日景区
var temp_t_scenic = item3.Route.DJ_TourGroup.Routes
.Where(x => x.Enterprise.Type == Model.EnterpriseType.景点)
.Where(x => x.DayNo == ((DateTime.Parse(txt_yijiedai3.Text) - item3.Route.DJ_TourGroup.BeginDate).Days + 1));
if (temp_t_scenic.Count() > 0)
{
foreach (var item in temp_t_hotel)
{
temp.t_scenic += item.Enterprise.Name + " ";
}
}
else
{
temp.t_scenic = "无";
}
#endregion
sm3.Add(temp);
}
#endregion
rptGov3.DataSource = sm3;
rptGov3.DataBind();
}
