/// <summary>
/// 初始化线路列表
/// </summary>
private void InitRouteList()
{
//记录条数
int intRecordCount = 0;
//页码
CurrencyPage = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
//查询实体
MRouteSearch queryModel = new MRouteSearch();
#region 查询参数赋值
//线路来源,专线，地接
routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1);
queryModel.RouteSource = routeSource;
//专线Id
queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"), 0);
ILine1.CheckedId = queryModel.AreaId.ToString();
ddl_ZX.SelectedValue = queryModel.AreaId.ToString();
//专线类型
queryModel.RouteType = null;
if (Utils.GetIntSign(Utils.GetQueryStringValue("lineType"), -1) >= 0)
{
queryModel.RouteType = (AreaType)Utils.GetInt(Utils.GetQueryStringValue("lineType"));
}
//出发城市
queryModel.StartCity = Utils.GetInt(Utils.GetQueryStringValue("goCity"), 0);
ddl_goCity.SelectedValue = queryModel.StartCity.ToString();
//关键字
queryModel.RouteKey = Utils.GetQueryStringValue("keyWord") == "线路名称" ? string.Empty : Utils.GetQueryStringValue("keyWord");
txt_keyWord.Value = queryModel.RouteKey.Length > 0 ? queryModel.RouteKey : "线路名称";
#endregion
IRoute bll = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance();
//线路库列表
IList <MRoute> list = bll.GetBackCenterList(intPageSize, CurrencyPage, ref intRecordCount, SiteUserInfo.CompanyID, queryModel);
if (list != null && list.Count > 0)
{
//存在列表数据
rpt_List.DataSource = list;
rpt_List.DataBind();
ExportPageInfo1.Visible = true;
this.ExportPageInfo1.intPageSize = intPageSize;
this.ExportPageInfo1.intRecordCount = intRecordCount;
this.ExportPageInfo1.CurrencyPage = CurrencyPage;
this.ExportPageInfo1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExportPageInfo1.UrlParams.Add("lineId", queryModel.AreaId.ToString());
this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType"));
this.ExportPageInfo1.UrlParams.Add("goCity", queryModel.StartCity.ToString());
this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.RouteKey);
this.ExportPageInfo1.UrlParams.Add("routeSource", Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1).ToString());
}
else
{
//不存在列表数据
pnlNodata.Visible = true;
}
}
/// <summary>
/// 初始化线路列表
/// </summary>
private void InitRouteList()
{
//记录条数
int intRecordCount = 0;
//页码
int CurrencyPage = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
int intPageSize = 15;
IRoute bll = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance();
//查询实体
MRouteSearch queryModel = new MRouteSearch();
#region 查询参数赋值
routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1);
//线路来源,专线，地接
queryModel.RouteSource = routeSource;
//专线Id
queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"), 0);
if (Utils.GetIntSign(Utils.GetQueryStringValue("lineType"), -1) >= 0)
{
queryModel.RouteType = (AreaType)Utils.GetInt(Utils.GetQueryStringValue("lineType"));
}
//出发城市
queryModel.StartCity = Utils.GetInt(Utils.GetQueryStringValue("goCity"), 0);
//关键字
queryModel.RouteKey = Utils.GetQueryStringValue("keyWord") == "线路名称" ? string.Empty : Utils.GetQueryStringValue("keyWord");
#endregion
//线路库列表
IList <MRoute> list = bll.GetBackCenterList(intPageSize, CurrencyPage, ref intRecordCount, Utils.GetQueryStringValue("companyID"), queryModel);
if (list != null && list.Count > 0)
{
//存在列表数据
rpt_List.DataSource = list;
rpt_List.DataBind();
ExportPageInfo1.Visible = true;
this.ExportPageInfo1.intPageSize = intPageSize;
this.ExportPageInfo1.intRecordCount = intRecordCount;
this.ExportPageInfo1.CurrencyPage = CurrencyPage;
this.ExportPageInfo1.PageLinkURL = "/routeagency/routemanage/RouteView.aspx?";
this.ExportPageInfo1.UrlParams.Add("lineId", queryModel.AreaId.ToString());
this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType"));
this.ExportPageInfo1.UrlParams.Add("goCity", queryModel.StartCity.ToString());
this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.RouteKey);
this.ExportPageInfo1.UrlParams.Add("routeSource", Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1).ToString());
}
else
{
//不存在列表数据
pnlNodata.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 权限判断
if ((RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1) == RouteSource.专线商添加)
{
if (!CheckGrant(TravelPermission.专线_线路管理))
{
Utils.ResponseNoPermit();
return;
}
}
else if ((RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1) == RouteSource.地接社添加)
{
if (!CheckGrant(TravelPermission.地接_线路管理))
{
Utils.ResponseNoPermit();
return;
}
}
#endregion
//线路来源
routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1);
//操作类型
string Operating = Utils.GetQueryStringValue("Operating");
/*
* 存在操作,目前该页面只有保存操作
* 保存操作包含修改和添加
*/
if (Operating.Length > 0)
{
Save(Operating);
}
//生成页面唯一标识
Key = "AddTourism" + Guid.NewGuid().ToString();
if (!IsPostBack)
{
/*线路区域类型
* 国内长线 = 0,
* 国际线 = 1,
* 国内短线 = 2,
* 地接线路 = 3,
*/
travelRangeType = Utils.GetInt(Utils.GetQueryStringValue("travelRangeType"));
//专线类型
travelRangeId = Utils.GetInt(Utils.GetQueryStringValue("travelRangeId"));
//初始化页面
InitPage();
}
}
/// <summary>
/// 绑定线路区域
/// </summary>
private void BindLineArea()
{
//用户Id
string UserID = string.Empty;;
if (SiteUserInfo != null)
{
EyouSoft.SSOComponent.Entity.UserInfo UserInfoModel = SiteUserInfo;
UserID = UserInfoModel.ID ?? "0";
}
ICompanyUser companyUserBLL = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance();
EyouSoft.Model.CompanyStructure.CompanyUser companyUserModel = companyUserBLL.GetModel(UserID);
if (companyUserModel != null && companyUserModel.Area != null && companyUserModel.Area.Count > 0)
{
//国内
List <AreaBase> gn = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.国内长线).ToList();
//国际
List <AreaBase> gj = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.国际线).ToList();
//周边
List <AreaBase> zb = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.地接线路 || ty.RouteType == AreaType.国内短线).ToList();
if (gn != null && gn.Count > 0)
{
showGN = true;
rpt_gn.DataSource = gn;
rpt_gn.DataBind();
}
if (gj != null && gj.Count > 0)
{
showGJ = true;
rpt_gj.DataSource = gj;
rpt_gj.DataBind();
}
if (zb != null && zb.Count > 0)
{
showZB = true;
rpt_zb.DataSource = zb;
rpt_zb.DataBind();
}
routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1);
}
}
/// <summary>
/// 团队订单(专线，地接)
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="OrderType">订单来源</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <EyouSoft.Model.NewTourStructure.MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, string companyId, RouteSource OrderType, EyouSoft.Model.NewTourStructure.MTourListSearch search)
{
IList <MTourList> list = new List <MTourList>();
string tableName = "tbl_NewTourList";
string fields = "*,(select StartCityName,DayNum,LateNum from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId for xml raw,root) as RouteInfo,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as TravelName,(select CompanyType from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as CompanyType";
string primaryKey = "TourId";
string orderByString = "IssueTime DESC ";
StringBuilder strWhere = new StringBuilder("1=1");
strWhere.AppendFormat(" and Business='{0}' and OrderSource={1}", companyId, (int)OrderType);
if (search != null)
{
if (search.SLeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)>=0", search.SLeaveDate);
}
if (search.ELeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)<=0", search.ELeaveDate);
}
if (search.TourOrderStatus != null)
{
strWhere.AppendFormat(" and OrderStatus={0}", (int)search.TourOrderStatus);
}
if (!string.IsNullOrEmpty(search.TourKey))
{
strWhere.AppendFormat(" and (RouteName like '%{0}%' or exists(select 1 from tbl_CompanyInfo where Id=tbl_NewTourList.Travel and CompanyName like '%{0}%'))", search.TourKey.Trim());
}
if (search.AreaType != null)
{
strWhere.AppendFormat(" and exists(select 1 from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId and RouteType={0})", (int)search.AreaType);
}
}
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageCurrent, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (rdr.Read())
{
MTourList model = new MTourList();
model.TourId = rdr.IsDBNull(rdr.GetOrdinal("TourId")) ? "" : rdr.GetString(rdr.GetOrdinal("TourId"));
model.OrderNo = rdr.IsDBNull(rdr.GetOrdinal("OrderNo")) ? "" : rdr.GetString(rdr.GetOrdinal("OrderNo"));
model.TourNo = rdr.IsDBNull(rdr.GetOrdinal("TourNo")) ? "" : rdr.GetString(rdr.GetOrdinal("TourNo"));
model.RouteId = rdr.IsDBNull(rdr.GetOrdinal("RouteId")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteId"));
model.RouteName = rdr.IsDBNull(rdr.GetOrdinal("RouteName")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteName"));
model.StartDate = rdr.IsDBNull(rdr.GetOrdinal("StartDate")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("StartDate"));
model.Business = rdr.IsDBNull(rdr.GetOrdinal("Business")) ? "" : rdr.GetString(rdr.GetOrdinal("Business"));
model.SLeaveDate = rdr.IsDBNull(rdr.GetOrdinal("LeaveDate")) ? "" : rdr.GetString(rdr.GetOrdinal("LeaveDate"));
model.ComeBackDate = rdr.IsDBNull(rdr.GetOrdinal("ComeBackDate")) ? "" : rdr.GetString(rdr.GetOrdinal("ComeBackDate"));
model.TravelContact = rdr.IsDBNull(rdr.GetOrdinal("TravelContact")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelContact"));
model.TravelTel = rdr.IsDBNull(rdr.GetOrdinal("TravelTel")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelTel"));
model.VisitorContact = rdr.IsDBNull(rdr.GetOrdinal("VisitorContact")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorContact"));
model.VisitorTel = rdr.IsDBNull(rdr.GetOrdinal("VisitorTel")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorTel"));
model.ScheduleNum = rdr.IsDBNull(rdr.GetOrdinal("ScheduleNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ScheduleNum"));
model.AdultNum = rdr.IsDBNull(rdr.GetOrdinal("AdultNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("AdultNum"));
model.ChildrenNum = rdr.IsDBNull(rdr.GetOrdinal("ChildrenNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ChildrenNum"));
model.SingleRoomNum = rdr.IsDBNull(rdr.GetOrdinal("SingleRoomNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SingleRoomNum"));
model.VisitorNotes = rdr.IsDBNull(rdr.GetOrdinal("VisitorNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorNotes"));
model.TravelNotes = rdr.IsDBNull(rdr.GetOrdinal("TravelNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelNotes"));
model.BusinessNotes = rdr.IsDBNull(rdr.GetOrdinal("BusinessNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessNotes"));
model.IssueTime = rdr.IsDBNull(rdr.GetOrdinal("IssueTime")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
model.OrderStatus = (TourOrderStatus)rdr.GetByte(rdr.GetOrdinal("OrderStatus"));
model.TourStatus = (TourStatus)rdr.GetByte(rdr.GetOrdinal("TourStatus"));
model.OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? "" : rdr.GetString(rdr.GetOrdinal("OperatorId"));
model.TourPrice = rdr.IsDBNull(rdr.GetOrdinal("TourPrice")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("TourPrice"));
model.Travel = rdr.IsDBNull(rdr.GetOrdinal("Travel")) ? "" : rdr.GetString(rdr.GetOrdinal("Travel"));
model.DayNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "DayNum"));
model.LateNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "LateNum"));
model.StartCityName = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "StartCityName");
model.TravelName = rdr.IsDBNull(rdr.GetOrdinal("TravelName")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelName"));
model.CompanyType = (CompanyType)Enum.Parse(typeof(CompanyType), rdr["CompanyType"].ToString());
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 初始化页面
/// </summary>
private void InitPage()
{
#region 配置用户控件
//配置上传用户控件
files.IsGenerateThumbnail = true;
//标准报价包含用户控件配置
AddStandardRoute_ServiceStandard.ContainerID = Key;
#endregion
//线路区域类型名称
lbl_travelRangeName.Text = EyouSoft.Common.Utils.GetQueryStringValue("travelRangeName");
//绑定销售城市
SalesArea();
//绑定交通
BindTraffic();
//绑定推荐状态
BindRecommendType(false);
//绑定线路区域主题
BindTheme();
//线路Id
routeId = Utils.GetQueryStringValue("RouteId");
#region 修改-复制加载原有数据
if (routeId.Length > 0)
{
#region 页面赋值
//线路实体
MRoute model = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance().GetModel(routeId);
//线路来源
routeSource = model.RouteSource;
//专线类型
travelRangeId = model.AreaId;
if (model != null)
{
//线路配图
if (model.RouteImg.Length > 0)
{
img_showImg.Src = EyouSoft.Common.Domain.FileSystem + model.RouteImg1;
img_showImg.Visible = true;
//a_showImg.HRef = EyouSoft.Common.Domain.FileSystem + model.RouteImg;
//a_showImg.Visible = true;
}
#region 线路类型
//线路类型
travelRangeType = (int)model.RouteType;
if (model.RouteType == AreaType.国际线)
{
#region 主要浏览国家
if (model.BrowseCountrys != null && model.BrowseCountrys.Count > 0)
{
//主要浏览国家个数
int i = model.BrowseCountrys.Count;
//变量
string str = string.Empty, qzstr = string.Empty;
//递减遍历主要浏览国家
while (i-- > 0)
{
//国家信息
str += model.BrowseCountrys[i].CountryId + ",";
//签证信息
if (model.BrowseCountrys[i].IsVisa)
{
qzstr += model.BrowseCountrys[i].CountryId + ",";
}
}
//国家信息
hd_BrowseCountrys.Value = str.Substring(0, str.Length - 1);
//签证信息
if (qzstr.Length > 0)
{
hd_qz.Value = qzstr.Substring(0, qzstr.Length - 1);
}
}
//免签 直接显示免签
if (model.IsNotVisa)
{
chk_null.Checked = true;
hd_qz.Value = string.Empty;
}
//国际线路成人定金
txt_AdultDeposit.Text = model.AdultPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.AdultPrice);
//国际线路儿童定金
txt_ChildrenDeposit.Text = model.ChildrenPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.ChildrenPrice);
#endregion
}
else
{
#region 主要浏览城市
if (model.BrowseCitys != null && model.BrowseCitys.Count > 0)
{
//主要浏览城市个数
int i = model.BrowseCitys.Count;
//变量
string str = string.Empty;
//递减遍历主要浏览城市
while (i-- > 0)
{
/*
* 保存主要浏览城市信息
* 存在县保存:县id|城市id,
* 不存在县(城市)保存:城市id,
* 最终用js拆分
*/
if (model.BrowseCitys[i].CountyId > 0)
{
str += model.BrowseCitys[i].CountyId + "|" + model.BrowseCitys[i].CityId + ",";
}
else
{
str += model.BrowseCitys[i].CityId + ",";
}
}
//主要浏览城市信息
hd_BrowseCitys.Value = str.Substring(0, str.Length - 1);
}
#endregion
}
#endregion
#region 普通数据
//专线名称
lbl_travelRangeName.Text = model.AreaName;
//线路名称
txt_LineName.Text = model.RouteName;
//如果是推荐状态为 推荐 重新绑定推荐状态
if (model.RecommendType == RecommendType.推荐)
{
BindRecommendType(true);
}
//推荐状态
ddl_Status.SelectedValue = ((int)model.RecommendType).ToString();
//出发交通
ddl_DepartureTraffic.SelectedIndex = (int)model.StartTraffic - 1;
//返回交通
ddl_ReturnTraffic.SelectedIndex = (int)model.EndTraffic - 1;
//出发城市
hd_goCity.Value = model.StartCity + "|" + model.StartCityName;
//返回城市
hd_returnCity.Value = model.EndCity + "|" + model.EndCityName;
//线路特色
txt_LineFeatures.Value = model.Characteristic;
//最小成团人数
txt_MinNumberPeople.Text = model.GroupNum.ToString();
//参考价
txt_ReferencePrice.Text = Utils.FilterEndOfTheZeroDecimal(model.IndependentGroupPrice);
//住宿天数
txt_days.Text = model.Day.ToString();
//住宿夜数
txt_nights.Text = model.Late.ToString();
//提前几天报名
txt_EarlyDays.Text = model.AdvanceDayRegistration.ToString();
//散客报名无需成团，铁定发团
chk_FITRegistration.Checked = model.IsCertain;
//简易版行程
txt_AddTourismBriefnessTravel.Value = model.FastPlan;
//报价不包含
txt_PriceExcluding.Value = model.ServiceStandard.NotContainService;
//赠送项目
txt_GiftItems.Value = model.ServiceStandard.GiftInfo;
//儿童及其他安排
txt_OtherArr.Value = model.ServiceStandard.ChildrenInfo;
//购物安排
txt_ShoppingArr.Value = model.ServiceStandard.ShoppingInfo;
//自费项目
txt_ThisConsumption.Value = model.ServiceStandard.ExpenseItem;
//销售须知
txt_Notes.Value = model.VendorsNotes;
//备注
txt_Remarks.Value = model.ServiceStandard.Notes;
//主题
hd_SubjectLine.Value = SetTheme(model.Themes);
//销售区域
hd_SellCity.Value = SetSalesArea(model.Citys);
#endregion
#region 行程
//行程
if (model.ReleaseType == ReleaseType.Quick)
{
txt_AddTourismBriefnessTravel.Value = model.FastPlan;
}
else
{
if (model.StandardPlans != null && model.StandardPlans.Count > 0)
{
isTravel = true;
rpt_standardPlans.DataSource = model.StandardPlans.OrderBy(r => r.PlanDay).ToList();
rpt_standardPlans.DataBind();
}
}
#endregion
#region 报价
txt_FIT.Value = model.FitQuotation;
AddStandardRoute_ServiceStandard.RouteServiceStandardInfo = model.ServiceStandard;
//判断是否为团队
isServiceStandard = model.ServiceStandard.CarContent.Length > 0 || //用车
model.ServiceStandard.DinnerContent.Length > 0 || //用餐
model.ServiceStandard.ResideContent.Length > 0 || //住宿
model.ServiceStandard.SightContent.Length > 0 || //景点
model.ServiceStandard.TrafficContent.Length > 0 || //往返交通
model.ServiceStandard.GuideContent.Length > 0 || //导游
model.ServiceStandard.IncludeOtherContent.Length > 0; //其他包含
#endregion
}
#endregion
//保存类型
SaveType = Utils.GetQueryStringValue("type");
if (SaveType == "copy")
{
//复制
//清空线路ID
routeId = string.Empty;
//清空线路名称
txt_LineName.Text = string.Empty;
}
}
#endregion
/*
* 绑定出发返回城市
* 该方法需要根据线路区域类型显示不同的返回城市
* 为兼容添加与修改
* 该方法只能写在线路数据加载之后
*/
BindCity();
/*
* 绑定主要浏览国家或城市
* 该方法需要根据线路区域类型显示不同的返回城市
* 为兼容添加与修改
* 该方法只能写在线路数据加载之后
* 此方法与修改-复制原有数据中的代码无冲突
*/
BindCountrysOrCity();
}
