/// <summary>
/// 添加团队订单(单团预订)
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool AddTourList(MTourList item)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Tour_AddTourPlan");
this._db.AddInParameter(cmd, "TourId", DbType.AnsiStringFixedLength, item.TourId);
this._db.AddInParameter(cmd, "RouteId", DbType.AnsiStringFixedLength, item.RouteId);
this._db.AddInParameter(cmd, "OrderNo", DbType.String, item.OrderNo);
this._db.AddInParameter(cmd, "RouteName", DbType.String, item.RouteName);
this._db.AddInParameter(cmd, "StartDate", DbType.DateTime, item.StartDate);
this._db.AddInParameter(cmd, "Business", DbType.AnsiStringFixedLength, item.Business);
this._db.AddInParameter(cmd, "LeaveDate", DbType.String, item.SLeaveDate);
this._db.AddInParameter(cmd, "ComeBackDate", DbType.String, item.ComeBackDate);
this._db.AddInParameter(cmd, "TravelContact", DbType.String, item.TravelContact);
this._db.AddInParameter(cmd, "TravelTel", DbType.String, item.TravelTel);
this._db.AddInParameter(cmd, "VisitorContact", DbType.String, item.VisitorContact);
this._db.AddInParameter(cmd, "VisitorTel", DbType.String, item.VisitorTel);
this._db.AddInParameter(cmd, "ScheduleNum", DbType.Int32, item.ScheduleNum);
this._db.AddInParameter(cmd, "AdultNum", DbType.Int32, item.AdultNum);
this._db.AddInParameter(cmd, "ChildrenNum", DbType.Int32, item.ChildrenNum);
this._db.AddInParameter(cmd, "SingleRoomNum", DbType.Int32, item.SingleRoomNum);
this._db.AddInParameter(cmd, "VisitorNotes", DbType.String, item.VisitorNotes);
this._db.AddInParameter(cmd, "TravelNotes", DbType.String, item.TravelNotes);
this._db.AddInParameter(cmd, "BusinessNotes", DbType.String, item.BusinessNotes);
this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, item.IssueTime);
this._db.AddInParameter(cmd, "OrderStatus", DbType.Byte, (int)EyouSoft.Model.NewTourStructure.TourOrderStatus.未确认);
this._db.AddInParameter(cmd, "TourStatus", DbType.Byte, (int)EyouSoft.Model.NewTourStructure.TourStatus.收客);
this._db.AddInParameter(cmd, "OperatorId", DbType.AnsiStringFixedLength, item.OperatorId);
this._db.AddInParameter(cmd, "TourPrice", DbType.Decimal, item.TourPrice);
this._db.AddInParameter(cmd, "Travel", DbType.AnsiStringFixedLength, item.Travel);
_db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedure(cmd, _db);
return(Convert.ToInt32(_db.GetParameterValue(cmd, "Result")) == 1 ? true : false);
}
protected void GetModelByOrderNoId()
{
if (!string.IsNullOrEmpty(TourId))
{
modelMTourList = EyouSoft.BLL.NewTourStructure.BTourList.CreateInstance().GetModel(TourId);
if (modelMTourList == null)
{
modelMTourList = new MTourList();
}
else
{
GetStatues(modelMTourList.OrderStatus);
#region 获取专线商联系人
modelCompany = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(modelMTourList.Business);
if (modelCompany == null)
{
modelCompany = new CompanyDetailInfo();
}
else
{
ContactInfo.Text = modelCompany.ContactInfo.ContactName + " 电话：" + modelCompany.ContactInfo.Tel;
}
#endregion
MRoute modelMroute = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance().GetModel(modelMTourList.RouteId);
litPriceTeam.Text = modelMroute.IndependentGroupPrice.ToString("0.00");
#region 获取游客联系人
litVisitorContact.Text = modelMTourList.VisitorContact + " 电话：" + modelMTourList.VisitorTel;
#endregion
}
}
}
/// <summary>
/// 运营前台 单团订单 专线或地接修改
/// </summary>
/// <param name="model">修改实体</param>
/// <returns></returns>
public bool OrderModifyZXDJ(MTourList model)
{
string sql = "update tbl_NewTourList set ScheduleNum=@ScheduleNum,BusinessNotes=@BusinessNotes where TourId=@TourId";
DbCommand cmd = this._db.GetSqlStringCommand(sql.ToString());
this._db.AddInParameter(cmd, "ScheduleNum", DbType.Int32, model.ScheduleNum);
this._db.AddInParameter(cmd, "BusinessNotes", DbType.String, model.BusinessNotes);
this._db.AddInParameter(cmd, "TourId", DbType.AnsiStringFixedLength, model.TourId);
return(DbHelper.ExecuteSql(cmd, this._db) == 1 ? true : false);
}
/// <summary>
/// 运营前台 单团订单 组团修改
/// </summary>
/// <param name="model">修改实体</param>
/// <returns></returns>
public bool OrderModifyZT(MTourList model)
{
string sql = "update tbl_NewTourList set TravelContact=@TravelContact,TravelTel=@TravelTel,VisitorContact=@VisitorContact,VisitorTel=@VisitorTel,ScheduleNum=@ScheduleNum,TravelNotes=@TravelNotes where TourId=@TourId";
DbCommand cmd = this._db.GetSqlStringCommand(sql.ToString());
this._db.AddInParameter(cmd, "ScheduleNum", DbType.Int32, model.ScheduleNum);
this._db.AddInParameter(cmd, "TravelContact", DbType.String, model.TravelContact);
this._db.AddInParameter(cmd, "TravelTel", DbType.String, model.TravelTel);
this._db.AddInParameter(cmd, "VisitorContact", DbType.String, model.VisitorContact);
this._db.AddInParameter(cmd, "VisitorTel", DbType.String, model.VisitorTel);
this._db.AddInParameter(cmd, "TravelNotes", DbType.String, model.TravelNotes);
this._db.AddInParameter(cmd, "TourId", DbType.AnsiStringFixedLength, model.TourId);
return(DbHelper.ExecuteSql(cmd, this._db) == 1 ? true : false);
}
/// <summary>
/// 获得实体
/// </summary>
/// <param name="TourId"></param>
/// <returns></returns>
public MTourList GetModel(string TourId)
{
MTourList model = null;
string sql = @"SELECT [TourId]
,[TourNo]
,[OrderNo]
,[RouteId]
,[RouteName]
,[StartDate]
,[Business]
,[LeaveDate]
,[ComeBackDate]
,[TravelContact]
,[TravelTel]
,[VisitorContact]
,[VisitorTel]
,[ScheduleNum]
,[AdultNum]
,[ChildrenNum]
,[SingleRoomNum]
,[VisitorNotes]
,[TravelNotes]
,[BusinessNotes]
,[IssueTime]
,[OrderStatus]
,[TourStatus]
,[OperatorId]
,[TourPrice]
,[Travel],(select StartCityName,EndCityName,GroupNum,DayNum,LateNum,AdultPrice,ChildrenPrice,VendorsNotes,StartTraffic,EndTraffic from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId for xml raw,root) as RouteInfo,(select CompanyName,ContactMQ,ContactQQ from tbl_CompanyInfo where Id=tbl_NewTourList.Travel for xml raw,root) as TravelInfo,(select CompanyName,ContactMQ,ContactQQ from tbl_CompanyInfo where Id=tbl_NewTourList.Business for xml raw,root) as BusinessInfo,(select ContactName from tbl_CompanyUser where Id=tbl_NewTourList.OperatorId) as OperatorName
FROM tbl_NewTourList WHERE TourId=@TourId";
DbCommand cmd = this._db.GetSqlStringCommand(sql);
this._db.AddInParameter(cmd, "TourId", DbType.AnsiStringFixedLength, TourId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
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.OperatorName = rdr.IsDBNull(rdr.GetOrdinal("OperatorName")) ? "" : rdr.GetString(rdr.GetOrdinal("OperatorName"));
model.TravelName = rdr.IsDBNull(rdr.GetOrdinal("TravelInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("TravelInfo")), "CompanyName");
model.TravelMQ = rdr.IsDBNull(rdr.GetOrdinal("TravelInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("TravelInfo")), "ContactMQ");
model.TravelQQ = rdr.IsDBNull(rdr.GetOrdinal("TravelInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("TravelInfo")), "ContactQQ");
model.BusinessName = rdr.IsDBNull(rdr.GetOrdinal("BusinessInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("BusinessInfo")), "CompanyName");
model.BusinessMQ = rdr.IsDBNull(rdr.GetOrdinal("BusinessInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("BusinessInfo")), "ContactMQ");
model.BusinessQQ = rdr.IsDBNull(rdr.GetOrdinal("BusinessInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("BusinessInfo")), "ContactQQ");
model.VendorsNotes = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "VendorsNotes");
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.EndCityName = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "EndCityName");
model.GroupNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "GroupNum"));
model.AdultPrice = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetDecimal(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "AdultPrice"));
model.ChildrenPrice = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetDecimal(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "ChildrenPrice"));
if (!rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")))
{
model.StartTraffic = (TrafficType)Enum.Parse(typeof(TrafficType), GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "StartTraffic"));
model.EndTraffic = (TrafficType)Enum.Parse(typeof(TrafficType), GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "EndTraffic"));
}
}
}
return(model);
}
/// <summary>
/// 团队订单-运营后台
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, 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.Business) as BusinessName,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as TravelName";
string primaryKey = "TourId";
string orderByString = "IssueTime DESC ";
StringBuilder strWhere = new StringBuilder("1=1");
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 (isnull(RouteName,'') + (select isnull(CompanyName,'') from tbl_CompanyInfo where Id=tbl_NewTourList.Business) + (select isnull(CompanyName,'') from tbl_CompanyInfo where Id=tbl_NewTourList.Travel)) 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.BusinessName = rdr.IsDBNull(rdr.GetOrdinal("BusinessName")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessName"));
model.TravelName = rdr.IsDBNull(rdr.GetOrdinal("TravelName")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelName"));
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 页面初始化
/// </summary>
private void InitPage()
{
routeId = Utils.GetQueryStringValue("routeId");
tourId = Utils.GetQueryStringValue("tourId");
IntRouteSource = Utils.GetInt(Utils.GetQueryStringValue("intRouteSource"), 0);
if (IntRouteSource >= 0)
{
if (IntRouteSource == 2)
{
title = "地接社";
}
else
{
title = "专线社";
}
}
else
{
title = "组团社";
}
//判断是否为组团
isZT = Utils.GetQueryStringValue("isZT").Length > 0;
if (routeId.Length > 0)
{
if (!SiteUserInfo.CompanyRole.HasRole(CompanyType.组团))
{
Response.Clear();
Response.Write("<script>javascript: window.location.href='/default.aspx';</script>");
Response.End();
return;
}
#region 单团预定初始化
MRoute model = BRoute.CreateInstance().GetModel(routeId);
if (model != null)
{
advanceDayRegistration = model.AdvanceDayRegistration.ToString();
companyID = model.Publishers;
//lbl_MQ.Text = SiteUserInfo.ContactInfo.MQ;
//lbl_QQ.Text = SiteUserInfo.ContactInfo.QQ;
//线路名称
lbl_routeName.Text = model.RouteName;
//发布人名称
lbl_operatorName.Text = model.OperatorName;
CompanyDetailInfo cdModel = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(model.Publishers);
MQ = cdModel.ContactInfo.MQ;
QQ = cdModel.ContactInfo.QQ;
a_gowd.HRef = Utils.GetShopUrl(model.Publishers);
lbl_operatorName.Text = cdModel.CompanyName;
lbl_sTraffic.Text = model.StartTraffic + " " + model.StartCityName;
lbl_eTraffic.Text += model.EndTraffic + " " + model.EndCityName;
isGJ = model.RouteType == AreaType.国际线;
//团队参考价
lbl_groupNum.Text = (model.IndependentGroupPrice == 0 ?
"一团一议" : Utils.FilterEndOfTheZeroDecimal(model.IndependentGroupPrice) + " 元") + ", 最小成团人数 " + model.GroupNum + " 人";
//定金
if (isGJ)
{
string strPrice = "成人：";
//成人定金
if (model.AdultPrice <= 0)
{
strPrice += (model.AdultPrice == -1 ? "电询" : "无需定金");
}
else
{
strPrice += (model.AdultPrice.ToString("F0") + "元");
}
strPrice += " 儿童：";
//儿童定金
if (model.ChildrenPrice <= 0)
{
strPrice += (model.ChildrenPrice == -1 ? "电询" : "无需定金");
}
else
{
strPrice += (model.ChildrenPrice.ToString("F0") + "元");
}
lbl_Price.Text = strPrice;
}
//组团社联系人姓名
txt_travelContact.Value = Request.QueryString["contact"] ?? SiteUserInfo.ContactInfo.ContactName;
//组团社联系人电话
txt_travelTel.Value = Request.QueryString["tel"] ?? SiteUserInfo.ContactInfo.Tel;
//成人数未传值默认为1人
string adult = Request.QueryString["adult"] ?? "1";
//儿童数未传值默认为0人
string child = Request.QueryString["child"] ?? "0";
//预定人数=成人数+儿童数
txt_adultPrice.Value = (Utils.GetInt(adult) + Utils.GetInt(child)).ToString();
//参考金额＝预定人数*参考金额
//参考总金额
lbl_tourPrice.Text = model.IndependentGroupPrice == 0 ?
"一团一议" :
Utils.FilterEndOfTheZeroDecimal((Utils.GetInt(adult) + Utils.GetInt(child)) * model.IndependentGroupPrice) + " 元";
IndependentGroupPrice = model.IndependentGroupPrice == 0 ?
"一团一议" :
model.IndependentGroupPrice.ToString();
}
#endregion
}
else if (tourId.Length > 0)
{
#region 团队订单管理查看初始化
MTourList model = BTourList.CreateInstance().GetModel(tourId);
if (model != null)
{
orderStatus = model.OrderStatus;
//出团时间
lbl_leaveDate.Text = model.StartDate.ToString("yyyy-MM-dd");
//线路名称(定团旅行社)
lbl_routeName.Text = model.RouteName;
lbl_sTraffic.Text = model.StartTraffic + " " + model.StartCityName;
lbl_eTraffic.Text += model.EndTraffic + " " + model.EndCityName;
if (isZT)
{
MQ = model.BusinessMQ;
QQ = model.BusinessQQ;
lbl_operatorName.Text = model.BusinessName;
a_gowd.HRef = Utils.GetShopUrl(model.Business);
lbl_OrderNo.Text = model.OrderNo;
//组团社联系人
txt_travelContact.Value = model.TravelContact;
//组团社联系人电话
txt_travelTel.Value = model.TravelTel;
//游客联系人
txt_visitorContact.Value = model.VisitorContact;
//游客联系人电话
txt_visitorTel.Value = model.VisitorTel;
}
else
{
MQ = model.TravelMQ;
QQ = model.TravelQQ;
lbl_operatorName.Text = model.TravelName;
a_gowd.HRef = Utils.GetShopUrl(model.Travel);
//组团社联系人
lbl_travel.Text = model.TravelContact + " 联系电话:" + model.TravelTel;
//游客联系人
lbl_visitor.Text = model.VisitorContact + " 联系电话:" + model.VisitorTel;
}
if (model.RouteId.Length > 0)
{
routeId = model.RouteId;
MRoute routeModel = BRoute.CreateInstance().GetModel(model.RouteId);
if (routeModel != null)
{
isGJ = routeModel.RouteType == AreaType.国际线;
#region 团队参考价
//团队参考价
lbl_groupNum.Text = "最小成团人数: " + routeModel.GroupNum + " 人," +
(routeModel.IndependentGroupPrice == 0 ?
"一团一议"
:
"参考价: " + Utils.FilterEndOfTheZeroDecimal(routeModel.IndependentGroupPrice) + " 元");
if (isZT)
{
lbl_groupNum.Text += "</br>同业销售须知:</br>";
lbl_groupNum.Text += model.VendorsNotes;
lbl_businessNotes.Text = model.BusinessNotes;
txt_travelNotes.Value = model.TravelNotes;
}
else
{
lbl_travelNotes.Text = model.TravelNotes;
txt_businessNotes.Value = model.BusinessNotes;
}
#endregion
#region 定金
//定金
if (isGJ)
{
lbl_Price.Text = "成人定金：" + (model.AdultPrice < 0 ? "电询" : Utils.FilterEndOfTheZeroDecimal(model.AdultPrice)) + " 儿童定金：" + (model.ChildrenPrice < 0 ? "电询" : Utils.FilterEndOfTheZeroDecimal(model.ChildrenPrice));
}
#endregion
#region 参考总金额
//参考总金额
lbl_tourPrice.Text = routeModel.IndependentGroupPrice == 0 ?
"一团一议" :
Utils.FilterEndOfTheZeroDecimal(model.ScheduleNum * routeModel.IndependentGroupPrice) + " 元";
IndependentGroupPrice = routeModel.IndependentGroupPrice == 0 ?
"一团一议" :
Utils.FilterEndOfTheZeroDecimal(routeModel.IndependentGroupPrice) + " 元";
#endregion
}
}
//预定人数
txt_adultPrice.Value = model.ScheduleNum.ToString();
//下单时间
lbl_issueTime.Text = model.IssueTime.ToString("yyyy-MM-dd HH:mm") + " " + model.OperatorName;
}
#endregion
}
}
/// <summary>
/// 保存
/// </summary>
private void Save()
{
routeId = Utils.GetQueryStringValue("routeId");
tourId = Utils.GetQueryStringValue("tourId");
if (tourId.Length <= 0 && routeId.Length > 0)
{
#region 组团社-单团预定
MTourList model = new MTourList();
MRoute brModel = BRoute.CreateInstance().GetModel(routeId);
//线路Id
model.RouteId = routeId;
//线路名称
model.RouteName = brModel.RouteName;
//下单人编号
model.OperatorId = SiteUserInfo.ID;
//下单人名称
model.OperatorName = SiteUserInfo.UserName;
//下单时间
model.IssueTime = DateTime.Now;
//预定人数
model.ScheduleNum = Utils.GetInt(Utils.GetFormValue(txt_adultPrice.UniqueID));
//组团社备注
model.TravelNotes = Utils.GetFormValue(txt_travelNotes.UniqueID);
//组团社联系人
model.TravelContact = Utils.GetFormValue(txt_travelContact.UniqueID);
//组团社联系人电话
model.TravelTel = Utils.GetFormValue(txt_travelTel.UniqueID);
//游客联系人
model.VisitorContact = Utils.GetFormValue(txt_visitorContact.UniqueID);
//游客联系人电话
model.VisitorTel = Utils.GetFormValue(txt_visitorTel.UniqueID);
//出发日期
model.StartDate = Utils.GetDateTime(Utils.GetFormValue(txt_leaveDate.UniqueID));
//预订公司编号
model.Travel = SiteUserInfo.CompanyID;
//发布线路专线商或地接社公司编号
model.Business = Utils.GetQueryStringValue("companyID");
bool isSave = BTourList.CreateInstance().AddTourList(model);
#region 发送短信模块
if (isSave)
{
EyouSoft.Model.SystemStructure.MSysSettingInfo SettingInfoModel = EyouSoft.BLL.SystemStructure.SystemInfo.CreateInstance().GetSysSetting();
//获得组团公司实体
EyouSoft.Model.CompanyStructure.CompanyDetailInfo travelComModel = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(SiteUserInfo.CompanyID);
////获得专线或地接公司实体
EyouSoft.Model.CompanyStructure.CompanyDetailInfo tourComModel = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(brModel.Publishers);
if (SettingInfoModel != null && travelComModel != null)
{
if (SettingInfoModel.OrderSmsCompanyTypes.Contains(travelComModel.CompanyLev))
{
string sendMsg = SettingInfoModel.OrderSmsTemplate;
sendMsg = sendMsg.Replace("[预订公司]", SiteUserInfo.CompanyName);
sendMsg = sendMsg.Replace("[预订联系电话]", SiteUserInfo.ContactInfo.Mobile);
sendMsg = sendMsg.Replace("[预订出发时间]", model.StartDate.ToString("yyyy-MM-dd"));
sendMsg = sendMsg.Replace("[预订产品]", model.RouteName);
sendMsg = sendMsg.Replace("[预订数量]", model.ScheduleNum.ToString() + "人");
#region 发送操作
EyouSoft.Model.SMSStructure.SendMessageInfo sendMessageInfo = new EyouSoft.Model.SMSStructure.SendMessageInfo();
sendMessageInfo.CompanyId = SiteUserInfo.CompanyID;
sendMessageInfo.CompanyName = SiteUserInfo.CompanyName;
sendMessageInfo.UserId = this.SiteUserInfo.ID;
sendMessageInfo.UserFullName = SiteUserInfo.ContactInfo.ContactName;
sendMessageInfo.SMSContent = sendMsg;
sendMessageInfo.SendTime = DateTime.Now;
//添加要发送的手机号码
List <EyouSoft.Model.SMSStructure.AcceptMobileInfo> moblieList = new List <EyouSoft.Model.SMSStructure.AcceptMobileInfo>();
EyouSoft.Model.SMSStructure.AcceptMobileInfo mobileModel = new EyouSoft.Model.SMSStructure.AcceptMobileInfo();
mobileModel.IsEncrypt = false;
if (tourComModel.ContactInfo != null)
{
mobileModel.Mobile = tourComModel.ContactInfo.Mobile;
}
moblieList.Add(mobileModel);
sendMessageInfo.Mobiles = moblieList;
//发送通道
EyouSoft.Model.SMSStructure.SMSChannel sendChannel = new EyouSoft.Model.SMSStructure.SMSChannelList()[Convert.ToInt32(SettingInfoModel.OrderSmsChannelIndex)];
sendMessageInfo.SendChannel = sendChannel;
sendMessageInfo.SendType = EyouSoft.Model.SMSStructure.SendType.直接发送;
EyouSoft.IBLL.SMSStructure.ISendMessage sBll = EyouSoft.BLL.SMSStructure.SendMessage.CreateInstance();
EyouSoft.Model.SMSStructure.SendResultInfo SendResultModel = sBll.Send(sendMessageInfo);
SendResultModel = null;
sendMessageInfo = null;
#endregion
}
}
}
#endregion
Response.Clear();
Response.Write(isSave.ToString().ToLower());
Response.End();
#endregion
}
else if (tourId.Length > 0)
{
#region 组团-地接-专线修改
MTourList model = BTourList.CreateInstance().GetModel(tourId);
model.ScheduleNum = Utils.GetInt(Utils.GetFormValue(txt_adultPrice.UniqueID));
if (Utils.GetQueryStringValue("isZT").Length > 0)
{
//组团修改
model.TravelNotes = Utils.GetFormValue(txt_travelNotes.UniqueID);
//组团社联系人
model.TravelContact = Utils.GetFormValue(txt_travelContact.UniqueID);
//组团社联系人电话
model.TravelTel = Utils.GetFormValue(txt_travelTel.UniqueID);
//游客联系人
model.VisitorContact = Utils.GetFormValue(txt_visitorContact.UniqueID);
//游客联系人电话
model.VisitorTel = Utils.GetFormValue(txt_visitorTel.UniqueID);
Response.Clear();
Response.Write(BTourList.CreateInstance().OrderModifyZT(model));
Response.End();
}
else
{
//专线,地接修改
model.BusinessNotes = Utils.GetFormValue(txt_businessNotes.UniqueID);
Response.Clear();
Response.Write(BTourList.CreateInstance().OrderModifyZXDJ(model));
Response.End();
}
#endregion
}
}
