protected void DateInit()
{
//初使化查询条件
PageIndex = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("page"), 1);
//线路名称
RouteName = EyouSoft.Common.Utils.GetQueryStringValue("_RouteName");
//出团时间
Starttime = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("_Stratime"));
//出游天数
TourDays = EyouSoft.Common.Utils.GetIntNull(EyouSoft.Common.Utils.GetQueryStringValue("_Tourdays"));
//地接安排查询实体
EyouSoft.Model.TourStructure.TourSearchInfo Search = new EyouSoft.Model.TourStructure.TourSearchInfo();
//判断线路名称是否是空
if (RouteName == null)
{
Search.RouteName = null;
}
else
{
Search.RouteName = RouteName;
}
//判断出团时间是否是空
if (Starttime == null)
{
Search.SDate = null;
Search.EDate = null;
}
else
{
Search.SDate = Starttime;
Search.EDate = Starttime;
}
//判断出游天数是否是空
if (TourDays == null)
{
Search.TourDays = null;
}
else
{
Search.TourDays = TourDays;
}
//地接安排列表实体
IList <EyouSoft.Model.TourStructure.LBDJAPTourInfo> list = null;
list = Tourbll.GetToursDJAP(SiteUserInfo.CompanyID, SiteUserInfo.LocalAgencyCompanyInfo.CompanyId, PageSize, PageIndex, ref RecordCount, Search);
if (list != null && list.Count > 0)
{
this.len = list.Count;
//数据绑定
this.Replist.DataSource = list;
this.Replist.DataBind();
//设置分页
BindPage();
}
else
{
this.ExporPageInfoSelect1.Visible = false;
}
}
/// <summary>
/// 页面初始化方法
/// </summary>
/// <param name="teamNumber">团队编号</param>
/// <param name="teamName">团队名称</param>
/// <param name="dayCount">天数</param>
/// <param name="beginDate">开始日期</param>
/// <param name="endDate">结束日期</param>
protected void DataInit(string teamNumber, string routeName, int?dayCount, DateTime?beginDate, DateTime?endDate, int?areaId, int[] SellerId, int[] CoordinatorId, string orderName)
{
//声明查询对象
EyouSoft.Model.TourStructure.TourSearchInfo searchModel = new EyouSoft.Model.TourStructure.TourSearchInfo();
//团号查询
searchModel.TourCode = teamNumber;
//线路名称
searchModel.RouteName = routeName;
//游客姓名
searchModel.YouKeName = orderName;
//团队天数
searchModel.TourDays = dayCount;
//出团日期
searchModel.SDate = beginDate;
//截止日期
searchModel.EDate = endDate;
//线路区域编号
searchModel.AreaId = areaId;
//销售员编号
searchModel.Sellers = SellerId;
//计调员编号
searchModel.Coordinators = CoordinatorId;
searchModel.TourStatus = (EyouSoft.Model.EnumType.TourStructure.TourStatus?)Utils.GetEnumValue(typeof(EyouSoft.Model.EnumType.TourStructure.TourStatus), Utils.GetQueryStringValue("tourStatus"), null);
//人数、团款合计
int peopleSum = 0;
decimal paraSum = 0;
//声明bll对象
EyouSoft.BLL.TourStructure.Tour bllOrder = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo);
//获得团队计划集合
IList <EyouSoft.Model.TourStructure.LBTeamTourInfo> list = bllOrder.GetToursTeam(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchModel);
bllOrder.GetToursTeamHeJi(SiteUserInfo.CompanyID, searchModel, out peopleSum, out paraSum);
//判断集合是否有数据
if (list != null && list.Count > 0)
{
lt_peopleNum.Text = peopleSum.ToString();
lt_paraSum.Text = "￥" + paraSum.ToString("0.00");
//页面控件数据绑定
this.rptList.DataSource = list;
this.rptList.DataBind();
//设置分页
BindPage();
//不显示无数据提示
lblMsg.Visible = false;
}
else
{
lt_paraSum.Visible = false;
lt_peopleNum.Visible = false;
//没有数据隐藏分页控件
this.ExportPageInfo1.Visible = false;
lblMsg.Visible = true;
}
}
/// <summary>
/// 绑定线路列表
/// </summary>
protected void BindInitLineProducts(int?LineTypeID, string LineName, DateTime?StarTime, DateTime?EndTime)
{
EyouSoft.Model.TourStructure.TourSearchInfo ModelTourSearch = new EyouSoft.Model.TourStructure.TourSearchInfo();
//出团结束时间
ModelTourSearch.EDate = EndTime;
//出团开始时间
ModelTourSearch.SDate = StarTime;
//线路名称
ModelTourSearch.RouteName = LineName;
//线路区域编号
ModelTourSearch.AreaId = LineTypeID;
ModelTourSearch.Areas = SiteUserInfo.Areas;
//线路筛选
if (Request.QueryString["xlid"] != "" && Request.QueryString["xlid"] != null)
{
ModelTourSearch.AreaId = Utils.GetInt(Utils.GetQueryStringValue("xlid"));
}
//获取首页团号
if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("tourid")))
{
ModelTourSearch.TourId = Utils.GetQueryStringValue("tourid");
}
ModelTourSearch.TourCityId = Utils.GetIntNull(Utils.GetQueryStringValue("cityID"));
if (ModelTourSearch.SDate.HasValue || ModelTourSearch.EDate.HasValue)
{
TourDisplayType = EyouSoft.Model.EnumType.CompanyStructure.TourDisplayType.明细团;
}
//组团端计划列表
IList <EyouSoft.Model.TourStructure.LBZTTours> LBZTToursList = new List <EyouSoft.Model.TourStructure.LBZTTours>();
//计划中心业务类
EyouSoft.BLL.TourStructure.Tour BllTour = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo, false);
//获取组团端计划列表
LBZTToursList = BllTour.GetToursZTD(SiteUserInfo.CompanyID, PageSize, PageIndex, ref RecordCount, ModelTourSearch, TourDisplayType);
if (LBZTToursList.Count > 0)
{
this.LineProductLists.DataSource = LBZTToursList;
this.LineProductLists.DataBind();
BinPage();
}
else
{
this.ExporPageInfoSelect1.Visible = false;
}
ModelTourSearch = null;
LBZTToursList = null;
BllTour = null;
}
/// <summary>
/// 页面初始化方法
/// </summary>
/// <param name="areaName">线路名称</param>
/// <param name="beginDate">出发时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="areaId">线路区域ID</param>
/// <param name="cityId">出港城市ID</param>
protected void DataInit(string areaName, DateTime?beginDate, DateTime?endDate, int?areaId, int?cityId)
{
if (areaId == 0)
{
areaId = null;
}
if (cityId == 0)
{
cityId = null;
}
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(null, false);
//声明查询model
EyouSoft.Model.TourStructure.TourSearchInfo searchModel = new EyouSoft.Model.TourStructure.TourSearchInfo();
//查询model 属性赋值
searchModel.AreaId = areaId;
searchModel.SDate = beginDate;
searchModel.EDate = endDate;
searchModel.RouteName = areaName;
searchModel.TourCityId = cityId;
IList <EyouSoft.Model.TourStructure.LBZTTours> list = bll.GetToursSiteHot(companyId, pageSize, pageIndex, ref recordCount, searchModel, CompanyStructure.TourDisplayType.明细团);
if (list != null && list.Count > 0)
{
this.rptTourList.DataSource = list;
this.rptTourList.DataBind();
BindPage();
this.lblMsg.Visible = false;
}
else
{
//如果默认省份的第一个城市无数据，则取消第一城市
searchModel.TourCityId = null;
list = bll.GetToursSiteHot(companyId, pageSize, pageIndex, ref recordCount, searchModel, CompanyStructure.TourDisplayType.明细团);
if (list != null && list.Count > 0)
{
this.rptTourList.DataSource = list;
this.rptTourList.DataBind();
BindPage();
this.lblMsg.Visible = false;
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.lblMsg.Text = "未找到相关线路信息!";
}
}
}
/// <summary>
/// init tours
/// </summary>
void InitTours()
{
PageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
int recordCount = 0;
TourDisplayType = new EyouSoft.BLL.CompanyStructure.CompanySetting().GetSiteTourDisplayType(Master.CompanyId);
var searchInfo = new EyouSoft.Model.TourStructure.TourSearchInfo();
searchInfo.RouteName = Utils.GetQueryStringValue("routename");
searchInfo.SDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("sldate"));
searchInfo.EDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("eldate"));
searchInfo.TourCityId = Utils.GetIntNull(Utils.GetQueryStringValue("cityid"));
searchInfo.AreaId = Utils.GetIntNull(Utils.GetQueryStringValue("areaid"));
if (searchInfo.AreaId.HasValue && searchInfo.AreaId.Value == 0)
{
searchInfo.AreaId = null;
}
if (searchInfo.TourCityId.HasValue && searchInfo.TourCityId.Value == 0)
{
searchInfo.TourCityId = null;
}
if (searchInfo.SDate.HasValue || searchInfo.EDate.HasValue)
{
TourDisplayType = EyouSoft.Model.EnumType.CompanyStructure.TourDisplayType.明细团;
}
var items = new EyouSoft.BLL.TourStructure.Tour().GetToursSiteHot(Master.CompanyId, PageSize, PageIndex, ref recordCount, searchInfo, TourDisplayType);
if (items != null && items.Count > 0)
{
rptTours.DataSource = items;
rptTours.DataBind();
divPaging.Visible = true;
divEmpty.Visible = false;
paging.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
paging.UrlParams.Add(Request.QueryString);
paging.intPageSize = PageSize;
paging.CurrencyPage = PageIndex;
paging.intRecordCount = recordCount;
}
else
{
divPaging.Visible = false;
divEmpty.Visible = true;
}
}
/// <summary>
/// 页面初始化方法
/// </summary>
/// <param name="areaName">线路名称</param>
/// <param name="beginDate">出发时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="areaId">线路区域ID</param>
/// <param name="cityId">出港城市ID</param>
protected void DataInit(string areaName, DateTime?beginDate, DateTime?endDate, int?areaId, int?cityId)
{
DdlAreaInit(areaId.ToString());
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(null, false);
//声明查询model
EyouSoft.Model.TourStructure.TourSearchInfo searchModel = new EyouSoft.Model.TourStructure.TourSearchInfo();
//查询model 属性赋值
searchModel.AreaId = areaId;
searchModel.SDate = beginDate;
searchModel.EDate = endDate;
searchModel.RouteName = areaName;
if (cityId != 0)
{
searchModel.TourCityId = cityId;
}
//根据查询条件取得的结果集list
IList <EyouSoft.Model.TourStructure.LBZTTours> list = bll.GetToursSiteHot(companyId, pageSize, pageIndex, ref recordCount, searchModel, CompanyStructure.TourDisplayType.明细团);
if (list != null && list.Count > 0)
{
//显示分页控件
this.ExporPageInfoSelect1.Visible = true;
//将list赋给repeater的数据源
this.rptTourList.DataSource = list;
//绑定数据
this.rptTourList.DataBind();
//绑定分页数据
BindPage();
//隐藏无数据提示控件
this.lblMsg.Visible = false;
}
else
{
//隐藏分页控件
this.ExporPageInfoSelect1.Visible = false;
this.lblMsg.Text = "未找到相关线路信息!";
//显示无数据提示控件
this.lblMsg.Visible = true;
}
}
/// <summary>
/// 列表初始化
/// </summary>
/// <param name="teamNum"></param>
/// <param name="id"></param>
/// <param name="time"></param>
protected void DataInit(string teamNum, string name, DateTime?time, string isAccount)
{
EyouSoft.Model.TourStructure.TourSearchInfo searchModel = new EyouSoft.Model.TourStructure.TourSearchInfo();
searchModel.SDate = time;
//searchModel.FDate = time;
searchModel.TourCode = teamNum;
searchModel.RouteName = name;
searchModel.EDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchModel.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchModel.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
searchModel.TourType = (EyouSoft.Model.EnumType.TourStructure.TourType?)Utils.GetEnumValue(typeof(EyouSoft.Model.EnumType.TourStructure.TourType), Utils.GetQueryStringValue("tourtype"), null);
IList <EyouSoft.Model.TourStructure.LBAccountingTourInfo> list = null;
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo);
#region 总计参数
//总收入
decimal income = 0;
//总支出
decimal expenditure = 0;
//总利润分配
decimal payOff = 0;
//总成人数
int adultNumber = 0;
//总儿童数
int childNumber = 0;
#endregion
//获取统计
if (isAccount == "no")
{
list = bll.GetToursNotAccounting(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchModel);
//获取待核算总计结果
bll.GetToursNotAccounting(SiteUserInfo.CompanyID, searchModel, ref income, ref expenditure, ref payOff, ref adultNumber, ref childNumber);
}
else
{
list = bll.GetToursAccounting(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchModel);
//获取以核算总计结果
bll.GetToursAccounting(SiteUserInfo.CompanyID, searchModel, ref income, ref expenditure, ref payOff, ref adultNumber, ref childNumber);
}
#region 总计赋值
//总收入
lblincome.Text = income.ToString("￥#0.##");
//总支出
lblexpenditure.Text = expenditure.ToString("￥#0.##");
//总利润分配
lblpayOff.Text = payOff.ToString("#0.##");
//总人数
lblNumber.Text = adultNumber.ToString() + " + " + childNumber.ToString();
//总毛利
lblml.Text = (income - expenditure).ToString("#0.##");
//纯利
lblcl.Text = (income - expenditure - payOff).ToString("#0.##");
int renShu = adultNumber + childNumber;
decimal maoLi = income - expenditure;
if (renShu == 0)
{
ltrRenJunMaoLi.Text = "0";
}
else
{
ltrRenJunMaoLi.Text = (maoLi / renShu).ToString("C2");
}
if (income <= 0)
{
ltrMaoLiLv.Text = "0%";
}
else
{
ltrMaoLiLv.Text = ((maoLi / income) * 100).ToString("F2") + "%";
}
#endregion
int pageCount = recordCount / pageSize;
if (recordCount % pageSize > 0)
{
pageCount++;
}
if (pageIndex > pageCount)
{
pageIndex = pageCount;
}
if (pageIndex < 1)
{
pageIndex = 1;
}
if (list != null && list.Count > 0)
{
this.rptList.DataSource = list;
this.rptList.DataBind();
BindPage();
}
else
{
this.ExportPageInfo1.Visible = false;
this.lblMsg.Text = "未找到相关数据!";
}
}
