/// <summary> /// 获取价格实体 /// </summary> /// <param name="pricesId">价格编号</param> /// <param name="trafficId">交通编号</param> /// <returns>价格实体</returns> public EyouSoft.Model.PlanStructure.TrafficPricesInfo GetTrafficPrices(string pricesId, int trafficId) { EyouSoft.Model.PlanStructure.TrafficPricesInfo model = null; DbCommand cmd = this._db.GetSqlStringCommand(SQL_TRAFFIC_GETPRICESINFO); this._db.AddInParameter(cmd, "PricesID", DbType.String, pricesId); this._db.AddInParameter(cmd, "TrafficId", DbType.Int32, trafficId); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo() { TrafficId = dr.IsDBNull(dr.GetOrdinal("TrafficId")) ? 0 : dr.GetInt32(dr.GetOrdinal("TrafficId")), TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0, TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0, InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")), PricesID = dr["PricesID"].ToString(), Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()), SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime")) }; } } return(model); }
/// <summary> /// 修改价格 /// </summary> /// <param name="pricemodel">价格实体</param> /// <returns>true 成功 false 失败</returns> public bool UpdateTrafficPrice(EyouSoft.Model.PlanStructure.TrafficPricesInfo pricemodel) { DbCommand cmd = this._db.GetSqlStringCommand(SQL_TRAFFIC_UPDATEPRICES); this._db.AddInParameter(cmd, "TrafficId", DbType.Int32, pricemodel.TrafficId); this._db.AddInParameter(cmd, "SDateTime", DbType.DateTime, pricemodel.SDateTime); this._db.AddInParameter(cmd, "TicketPrices", DbType.Decimal, pricemodel.TicketPrices); this._db.AddInParameter(cmd, "TicketNums", DbType.Int32, pricemodel.TicketNums); this._db.AddInParameter(cmd, "Status", DbType.Byte, Convert.ToInt32(pricemodel.Status)); this._db.AddInParameter(cmd, "InsueTime", DbType.DateTime, pricemodel.InsueTime); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }
/// <summary> /// 获取成本价 /// </summary> protected void GetPrice() { DateTime dt = Utils.GetDateTime(Utils.GetQueryStringValue("startDate")); int trafficId = Utils.GetInt(Utils.GetQueryStringValue("trafficId")); EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic(); EyouSoft.Model.PlanStructure.TrafficPricesInfo model = BLL.GetTrafficPriceModel(trafficId, dt); if (model != null) { Response.Clear(); Response.Write(string.Format("{{\"result\":\"{0}\",\"shengyu\":\"{1}\"}}", Utils.FilterEndOfTheZeroDecimal(model.TicketPrices), model.ShengYu.ToString())); Response.End(); } else { Response.Clear(); Response.Write(string.Format("{{\"result\":\"{0}\",\"shengyu\":\"{1}\"}}", 0, 0)); Response.End(); } }
/// <summary> /// 根据交通编号出团时间获取价格集合 /// </summary> /// <param name="trafficId">交通编号集合</param> /// <param name="LTourDate">出团时间</param> /// <returns>返回价格集合</returns> public IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> GetTrafficPriceList(DateTime LTourDate, params int[] trafficId) { IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> list = null; EyouSoft.Model.PlanStructure.TrafficPricesInfo model = null; var strSql = new StringBuilder(); strSql.Append(" SELECT PricesID,InsueTime,SDateTime, TrafficId,TicketPrices,TicketNums,[Status] "); strSql.AppendFormat( ",(SELECT SUM(to1.PeopleNumber - to1.LeaguePepoleNum) FROM tbl_TourOrder to1 WHERE to1.IsDelete = '0' AND EXISTS(SELECT 1 FROM tbl_TourOrderTraffic tot WHERE tot.OrderId = to1.ID AND tot.TrafficId = tbl_TrafficPrices.TrafficId) AND DATEDIFF(dd,to1.LeaveDate,tbl_TrafficPrices.SDateTime) = 0 and to1.OrderState IN({0},{1},{2})) as YiShiYong ", (int)Model.EnumType.TourStructure.OrderState.未处理, (int)Model.EnumType.TourStructure.OrderState.已成交, (int)Model.EnumType.TourStructure.OrderState.已留位); strSql.Append(" FROM tbl_TrafficPrices "); strSql.AppendFormat(" WHERE TrafficId in ({0}) AND DateDiff(dd,SDateTime,@LeaveDate)=0 ", trafficId); strSql.AppendFormat(" and [Status] = {0} ", (int)Model.EnumType.PlanStructure.TicketStatus.正常); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "LeaveDate", DbType.DateTime, LTourDate); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { list = new List <EyouSoft.Model.PlanStructure.TrafficPricesInfo>(); while (dr.Read()) { model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo() { PricesID = dr["PricesID"].ToString(), Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()), InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")), SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime")), TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0, TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0, TrafficId = dr.GetInt32(dr.GetOrdinal("TrafficId")), YiShiYong = dr.IsDBNull(dr.GetOrdinal("YiShiYong")) ? 0 : dr.GetInt32(dr.GetOrdinal("YiShiYong")) }; list.Add(model); } } return(list); }
/// <summary> /// 保存价格 /// </summary> protected string PageSave() { string ret = string.Empty; //开始时间 DateTime sDate = Utils.GetDateTime(Utils.GetFormValue("txtSDate")); //结束时间 DateTime eDate = Utils.GetDateTime(Utils.GetFormValue("txtEDate")); //价格 string[] PricesArr = Utils.GetFormValues("txtprice"); //数量 string[] NumArr = Utils.GetFormValues("txtnum"); if (PricesArr.Length > 0) { string tfID = Utils.GetQueryStringValue("tfId"); for (int i = 0; i < PricesArr.Length; i++) { EyouSoft.Model.PlanStructure.TrafficPricesInfo model = new EyouSoft.Model.PlanStructure.TrafficPricesInfo(); model.TrafficId = Utils.GetInt(tfID); model.InsueTime = DateTime.Now; model.SDateTime = sDate.AddDays(i); model.Status = EyouSoft.Model.EnumType.PlanStructure.TicketStatus.正常; model.TicketNums = Utils.GetInt(NumArr[i]); model.TicketPrices = Utils.GetDecimal(PricesArr[i]); bool result = new EyouSoft.BLL.PlanStruture.PlanTrffic().AddTrafficPrice(model); if (result) { ret = "{\"ret\":\"1\",\"msg\":\"添加成功!\"}"; } else { ret = "{\"ret\":\"0\",\"msg\":\"添加失败!\"}"; } } } return(ret); }
/// <summary> /// 修改价格 /// </summary> /// <param name="pricemodel">价格实体</param> /// <returns>true 成功 false 失败</returns> public bool UpdatetrafficPrice(EyouSoft.Model.PlanStructure.TrafficPricesInfo pricemodel) { if (pricemodel == null) { return(false); } bool result = Idal.UpdateTrafficPrice(pricemodel); if (result) { this.TongBuGengXinTuanDui(pricemodel.TrafficId); HandleLogsBll.Add( new EyouSoft.Model.CompanyStructure.SysHandleLogs() { ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理, EventCode = Model.CompanyStructure.SysHandleLogsNO.EventCode, EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理.ToString() + "更新交通价格!编号为:" + pricemodel.PricesID, EventTitle = "修改" + Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_交通管理.ToString() + "数据" }); } return(result); }
/// <summary> /// 保存 /// </summary> /// <param name="pricesId">价格编号</param> /// <returns></returns> protected string PageSave() { string msg = string.Empty; EyouSoft.Model.PlanStructure.TrafficPricesInfo priceInfo = new EyouSoft.Model.PlanStructure.TrafficPricesInfo(); priceInfo.InsueTime = DateTime.Now; priceInfo.SDateTime = Utils.GetDateTime(Utils.GetQueryStringValue("date")); priceInfo.Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus)Utils.GetInt(Utils.GetFormValue("radStatus")); priceInfo.TicketNums = Utils.GetInt(Utils.GetFormValue(this.txtTicketNums.UniqueID)); priceInfo.TicketPrices = Utils.GetDecimal(Utils.GetFormValue(this.txtTicketPrices.UniqueID)); priceInfo.TrafficId = Utils.GetInt(Utils.GetQueryStringValue("tfId")); if (Utils.GetQueryStringValue("type") == "update") { priceInfo.PricesID = Utils.GetQueryStringValue("pricesId"); bool ret = new EyouSoft.BLL.PlanStruture.PlanTrffic().UpdatetrafficPrice(priceInfo); if (ret) { msg = "{\"msg\":\"修改成功!\"}"; } else { msg = "{\"msg\":\"修改失败!\"}"; } } else { bool ret = new EyouSoft.BLL.PlanStruture.PlanTrffic().AddTrafficPrice(priceInfo); if (ret) { msg = "{\"msg\":\"添加成功!\"}"; } else { msg = "{\"msg\":\"添加失败!\"}"; } } return(msg); }
/// <summary> /// 获取价格列表 /// </summary> /// <param name="TrafficId">交通编号</param> /// <returns>价格集合</returns> public IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> GetPricesList(int trafficID) { IList <EyouSoft.Model.PlanStructure.TrafficPricesInfo> priceslist = null; EyouSoft.Model.PlanStructure.TrafficPricesInfo pricesmodel = null; StringBuilder sqlWhere = new StringBuilder(); sqlWhere.AppendFormat(" SELECT * "); sqlWhere.AppendFormat(" ,(SELECT SUM(to1.PeopleNumber - to1.LeaguePepoleNum) FROM tbl_TourOrder to1 WHERE to1.IsDelete = '0' AND EXISTS(SELECT 1 FROM tbl_TourOrderTraffic tot WHERE tot.OrderId = to1.ID AND tot.TrafficId = tbl_TrafficPrices.TrafficId) AND DATEDIFF(dd,to1.LeaveDate,tbl_TrafficPrices.SDateTime) = 0 and to1.OrderState IN({0},{1},{2})) as YiShiYong ", (int)Model.EnumType.TourStructure.OrderState.未处理, (int)Model.EnumType.TourStructure.OrderState.已成交, (int)Model.EnumType.TourStructure.OrderState.已留位); sqlWhere.AppendFormat(" FROM tbl_TrafficPrices WHERE TrafficId = {0} ORDER BY InsueTime DESC ", trafficID); DbCommand cmd = this._db.GetSqlStringCommand(sqlWhere.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { priceslist = new List <EyouSoft.Model.PlanStructure.TrafficPricesInfo>(); while (dr.Read()) { pricesmodel = new EyouSoft.Model.PlanStructure.TrafficPricesInfo() { InsueTime = dr.GetDateTime(dr.GetOrdinal("InsueTime")), PricesID = !dr.IsDBNull(dr.GetOrdinal("PricesID")) ? dr.GetString(dr.GetOrdinal("PricesID")) : string.Empty, SDateTime = dr.GetDateTime(dr.GetOrdinal("SDateTime")), Status = (EyouSoft.Model.EnumType.PlanStructure.TicketStatus) int.Parse(dr[dr.GetOrdinal("Status")].ToString()), TrafficId = Convert.ToInt32(dr["TrafficId"].ToString()), TicketNums = !dr.IsDBNull(dr.GetOrdinal("TicketNums")) ? dr.GetInt32(dr.GetOrdinal("TicketNums")) : 0, TicketPrices = !dr.IsDBNull(dr.GetOrdinal("TicketPrices")) ? dr.GetDecimal(dr.GetOrdinal("TicketPrices")) : 0, YiShiYong = dr.IsDBNull(dr.GetOrdinal("YiShiYong")) ? 0 : dr.GetInt32(dr.GetOrdinal("YiShiYong")) }; priceslist.Add(pricesmodel); } } return(priceslist); }
/// <summary> /// 保存事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { NumConfig = (int)(new EyouSoft.BLL.CompanyStructure.CompanySetting().GetTeamNumberOfPeople(CurrentUserCompanyID)); #region 将表单值 赋值给变量 //团号 string teamNum = Utils.InputText(this.txtTeamNum.Text); //线路区域名 string lineArea = Utils.GetFormValue(this.ddlLineArea.UniqueID); //计调员 string coordinatorId = Utils.GetFormValue(this.ddlSeller.UniqueID); //组团社ID int buyerCId = Utils.GetInt(this.hideGroupsId.Value); //组团社名称 string buyerCName = Utils.GetFormValue(this.txtGroupsName.UniqueID); //线路名称 string xianLuName = this.xianluWindow1.Name; //线路ID string routeId = this.xianluWindow1.Id; //天数 int dayCount = Utils.GetInt(this.txtDayCount.Text); //人数 int peopleCount = Utils.GetInt(this.txtPeopelCount.Text); //出发交通 string startTraffic = Utils.InputText(this.txtStartTraffic.Text); //返程交通 string endTraffic = Utils.InputText(this.txtEndTraffic.Text.Trim()); //出团日期 DateTime lDate = Convert.ToDateTime(this.txtLDate.Text); //回团日期 // DateTime rDate = Convert.ToDateTime(this.txtRDate.Text); //添加地接社信息 IList <EyouSoft.Model.TourStructure.TourLocalAgencyInfo> list = this.DiJieControl1.GetList; //添加价格组成 IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> listPrice = this.PriceControl1.GetList; //行程安排 string travel = Utils.EditInputText(this.txtTravel.Text); //服务标准 string services = Utils.EditInputText(this.txtServices.Text); //备注 string remarks = this.txtRemarks.Text; //常用城市 int tourCity = Utils.GetInt(Utils.GetFormValue(this.ddlCityList.UniqueID)); #endregion #region 验证 //判断线路区域不能为空 if (lineArea == "") { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择线路区域")); return; } //判断是否选择组团社 if (buyerCId <= 0) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择组团社!")); return; } if (coordinatorId == "-1") { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择计调员!")); return; } //判断线路名称不能为空 if (xianLuName == "") { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入线路名称!")); return; } //判断天数不能为空 if (dayCount == 0) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入天数!")); return; } //判断人数不能为空 if ((peopleCount == null || peopleCount == 0) && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.OnlyTotalNumber) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!")); return; } int crNum = Utils.GetInt(txt_crNum.Text); if (crNum == 0 && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.PartNumber) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!")); return; } #endregion #region 验证上传文件的格式是否正确 string msg = ""; if (!EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "fileField", new[] { ".gif", ".jpeg", ".jpg", ".png", ".xls", ".doc", ".docx", ".rar", ".txt" }, null, out msg)) { this.litMsg.Text = Utils.ShowMsg(msg); return; } #endregion //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(); //声明团队计划对象 EyouSoft.Model.TourStructure.TourTeamInfo model = new EyouSoft.Model.TourStructure.TourTeamInfo(); if (this.hideType.Value == "Update") { //如果是修改操作,那么先获的这个对象 model = (EyouSoft.Model.TourStructure.TourTeamInfo)bll.GetTourInfo(this.hideID.Value); } #region 对象属性赋值 //判断对象时候存在 if (model != null) { //对象属性赋值 model.TourCode = teamNum; model.AreaId = Convert.ToInt32(lineArea); model.Coordinator = new EyouSoft.Model.TourStructure.TourCoordinatorInfo(); model.Coordinator.CoordinatorId = Utils.GetInt(coordinatorId); //修改时原购买单位 if (model.BuyerCId > 0) { model.OBuyerCId = model.BuyerCId; } model.BuyerCId = buyerCId; model.BuyerCName = buyerCName; model.RouteName = xianLuName; if (model.RouteId > 0) { model.ORouteId = model.RouteId; } model.RouteId = Utils.GetInt(routeId); model.TourDays = dayCount; model.PlanPeopleNumber = peopleCount; model.LTraffic = startTraffic; model.RTraffic = endTraffic; model.LDate = lDate; model.LocalAgencys = list; model.Services = listPrice; model.CompanyId = SiteUserInfo.CompanyID; EyouSoft.Model.TourStructure.TourQuickPrivateInfo quickInfo = new EyouSoft.Model.TourStructure.TourQuickPrivateInfo(); quickInfo.QuickPlan = travel; quickInfo.Service = services; quickInfo.Remark = remarks; model.TourQuickInfo = quickInfo; model.OperatorId = SiteUserInfo.ID; model.TourType = EyouSoft.Model.EnumType.TourStructure.TourType.团队计划; model.ReleaseType = EyouSoft.Model.EnumType.TourStructure.ReleaseType.Quick; model.TicketStatus = EyouSoft.Model.EnumType.PlanStructure.TicketState.None; model.TotalAmount = PriceControl1.TotalAmount; model.TourCityId = tourCity; model.TourTraffic = new List <int>() { Utils.GetInt(Utils.GetFormValue("selectTraffic"), -1) }; ///人数、单价 by txb model.TourTeamUnit = new EyouSoft.Model.TourStructure.MTourTeamUnitInfo(); model.TourTeamUnit.NumberCr = Utils.GetInt(txt_crNum.Text); model.TourTeamUnit.NumberEt = Utils.GetInt(txt_rtNum.Text); model.TourTeamUnit.NumberQp = Utils.GetInt(txt_allNum.Text); model.TourTeamUnit.UnitAmountCr = PriceControl1.cr_price; model.TourTeamUnit.UnitAmountEt = PriceControl1.rt_price; model.TourTeamUnit.UnitAmountQp = PriceControl1.all_price; #endregion #region 单文件 //团队附件实体 EyouSoft.Model.TourStructure.TourAttachInfo attachModel = new EyouSoft.Model.TourStructure.TourAttachInfo(); //文件路径 string filePath = ""; //文件名 string fileName = ""; //文件上传 if (EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["fileField"], "TeamPlanFile", out filePath, out fileName)) { if (filePath.Trim() != "" && fileName.Trim() != "") { //设置文件上传后的虚拟路劲 attachModel.FilePath = filePath; //保存原文件名 attachModel.Name = fileName; IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>(); attachList.Add(attachModel); model.Attachs = attachList; } else if (Utils.GetFormValue(this.hideData.UniqueID).Trim() != "") { attachModel.FilePath = this.hideData.Value; IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>(); attachList.Add(attachModel); model.Attachs = attachList; } else { model.Attachs = null; } } else { //上传失败提示 this.litMsg.Text = Utils.ShowMsg("文件上传失败!"); return; } #endregion int count = 0; if (model.TourTraffic != null && model.TourTraffic.Count > 0) { EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic(); EyouSoft.Model.PlanStructure.TrafficPricesInfo TrafficPricesInfoModel = BLL.GetTrafficPriceModel(model.TourTraffic.First(), model.LDate); if (TrafficPricesInfoModel != null && TrafficPricesInfoModel.TicketNums > 0) { //如果是新增和复制 时 都做新增操作 if (this.hideType.Value == "Add" || this.hideType.Value == "Copy") { //数据库添加操作 count = bll.InsertTeamTourInfo(model); //新增成功 if (count > 0) { Utils.ShowAndRedirect("添加成功!", "/TeamPlan/TeamPlanList.aspx"); } else //失败时提示 if (count == -1) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("团号重复!")); } else { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("添加失败!")); } } else { //数据库修改操作 count = bll.UpdateTeamTourInfo(model); //成功提示 if (count > 0) { Utils.ShowAndRedirect("修改成功!", "/TeamPlan/TeamPlanList.aspx"); } else { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("修改失败!")); } } } else { Response.Write("<script type='text/javascript'>alert('提交失败,关联交通票数为零!');location.href=location.href;</script>"); } } else { Response.Write("<script type='text/javascript'>alert('提交失败,关联交通为空!');location.href=location.href;</script>"); } } else { Utils.ShowAndRedirect("该计划不存在!", "/TeamPlan/TeamPlanList.aspx"); } }
/// <summary> /// 保存事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { NumConfig = (int)(new EyouSoft.BLL.CompanyStructure.CompanySetting().GetTeamNumberOfPeople(CurrentUserCompanyID)); #region 将表单值赋值于变量 //团号 string teamNum = this.txtTeamNum.Text.Trim(); //线路区域名 string lineArea = Utils.GetFormValue(this.ddlLineArea.UniqueID); //计调员 string coordinatorId = Utils.GetFormValue(this.ddlSeller.UniqueID); //线路名称 string xianLuName = this.xianluWindow1.Name; //线路ID string routeId = this.xianluWindow1.Id; //组团社ID int buyerCId = Utils.GetInt(this.hideGroupsId.Value); //组团社名称 string buyerCName = Utils.GetFormValue(this.txtGroupsName.UniqueID); //天数 int?dayCount = Utils.GetIntNull(this.txtDayCount.Text); //人数 int?peopleCount = Utils.GetIntNull(this.txtPeopelCount.Text); //出发交通 string startTraffic = this.txtStartTraffic.Text.Trim(); //返程交通 string endTraffic = this.txtEndTraffic.Text.Trim(); //出团日期 DateTime lDate = Utils.GetDateTime(this.txtLDate.Text); //不含项目 string noProject = this.txtNoProject.Text.Trim(); //购物安排 string buyPlan = this.txtBuyPlan.Text; //儿童安排 string childPlan = this.txtChildPlan.Text; //自费项目 string selfProject = this.txtSelfProject.Text; //注意事项 string note = this.txtNote.Text; //温馨提示 string tips = this.txtTips.Text; //内部信息 string internalMsg = this.txtNeiBu.Text; //集合时间 //string gatheredTime = (Utils.GetFormValue(this.txtGathered.UniqueID)) + " " + ddl_jh_date.SelectedValue + ":00:00"; string gatheredTime = Utils.GetFormValue(this.txtGathered.UniqueID); //集合地点 string place = Utils.GetFormValue(this.txtPlace.UniqueID); //集合标志 string logo = Utils.GetFormValue(this.txtLogo.UniqueID); //送团人 string operatorId = this.selectOperator1.OperId; //常用城市 int tourCity = Utils.GetInt(Utils.GetFormValue(this.ddlCityList.UniqueID)); #endregion #region 验证上传文件的格式是否正确 string msg = ""; if (!EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "fileField", new[] { ".gif", ".jpeg", ".jpg", ".png", ".xls", ".doc", ".docx", ".rar", ".txt" }, null, out msg)) { this.litMsg.Text = Utils.ShowMsg(msg); return; } #endregion #region 地接信息 IList <EyouSoft.Model.TourStructure.TourLocalAgencyInfo> djList = this.DiJieControl1.GetList; #endregion #region 行程安排 IList <EyouSoft.Model.TourStructure.TourPlanInfo> planList = this.xingcheng1.GetValues(); #endregion #region 包含项目 IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> standList = this.PriceControl1.GetList; #endregion #region 验证 if (lineArea == "") { this.litMsg.Text = Utils.ShowMsg("请选择线路区域!"); return; } //判断是否选择组团社 if (buyerCId <= 0) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择组团社!")); return; } if (xianLuName == "") { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入线路名称!")); return; } if (coordinatorId == "-1") { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请选择计调员!")); return; } if (dayCount == null || dayCount == 0) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入天数!")); return; } if ((peopleCount == null || peopleCount == 0) && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.OnlyTotalNumber) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!")); return; } int crNum = Utils.GetInt(txt_crNum.Text); if (crNum == 0 && NumConfig == (int)EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.PartNumber) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, Utils.ShowMsg("请输入人数!")); return; } #endregion //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //声明model对象 EyouSoft.Model.TourStructure.TourTeamInfo model = new EyouSoft.Model.TourStructure.TourTeamInfo(); //如果是修改那么先获得该对象model if (this.hideType.Value == "Update") { //如果是修改操作,那么先获的这个对象 model = (EyouSoft.Model.TourStructure.TourTeamInfo)bll.GetTourInfo(this.hideID.Value); } //判断对象是否存在 if (model != null) { #region 对象属性赋值 model.TourCode = teamNum; model.AreaId = Convert.ToInt32(lineArea); //修改时原购买单位 if (model.BuyerCId > 0) { model.OBuyerCId = model.BuyerCId; } model.Coordinator = new EyouSoft.Model.TourStructure.TourCoordinatorInfo(); model.Coordinator.CoordinatorId = Utils.GetInt(coordinatorId); model.BuyerCId = buyerCId; model.BuyerCName = buyerCName; model.RouteName = xianLuName; if (model.RouteId != 0) { model.ORouteId = model.RouteId; } model.RouteId = Utils.GetInt(routeId); model.TourDays = Convert.ToInt32(dayCount); #region 添加送团人 if (this.selectOperator1.OperId.Trim() != "") { string[] operIdList = this.selectOperator1.OperId.Split(','); if (operIdList.Count() > 0) { model.SentPeoples = new List <EyouSoft.Model.TourStructure.TourSentPeopleInfo>(); for (int i = 0; i < operIdList.Count(); i++) { if (operIdList[i].Trim() != "") { EyouSoft.Model.TourStructure.TourSentPeopleInfo sentPeopleModel = new EyouSoft.Model.TourStructure.TourSentPeopleInfo(); sentPeopleModel.OperatorId = Utils.GetInt(operIdList[i]); model.SentPeoples.Add(sentPeopleModel); } } } } #endregion model.GatheringPlace = place; model.GatheringSign = logo; model.GatheringTime = gatheredTime; model.PlanPeopleNumber = Convert.ToInt32(peopleCount); model.LTraffic = startTraffic; model.RTraffic = endTraffic; model.LDate = lDate; model.LocalAgencys = djList; EyouSoft.Model.TourStructure.TourTeamNormalPrivateInfo tourTeamModel = new EyouSoft.Model.TourStructure.TourTeamNormalPrivateInfo(); tourTeamModel.Plans = planList; tourTeamModel.BuHanXiangMu = noProject; tourTeamModel.GouWuAnPai = buyPlan; tourTeamModel.ErTongAnPai = childPlan; tourTeamModel.ZiFeiXIangMu = selfProject; tourTeamModel.ZhuYiShiXiang = note; tourTeamModel.WenXinTiXing = tips; tourTeamModel.NeiBuXingXi = internalMsg; model.TourNormalInfo = tourTeamModel; model.Services = standList; model.CompanyId = SiteUserInfo.CompanyID; model.OperatorId = SiteUserInfo.ID; model.TourType = EyouSoft.Model.EnumType.TourStructure.TourType.团队计划; model.ReleaseType = EyouSoft.Model.EnumType.TourStructure.ReleaseType.Normal; model.TicketStatus = EyouSoft.Model.EnumType.PlanStructure.TicketState.None; model.TotalAmount = PriceControl1.TotalAmount; //model.SelfUnitPriceAmount = PriceControl1.OnePriceAll; model.TourCityId = tourCity; model.TourTraffic = new List <int>() { Utils.GetInt(Utils.GetFormValue("selectTraffic"), -1) }; ///人数、单价 by txb model.TourTeamUnit = new EyouSoft.Model.TourStructure.MTourTeamUnitInfo(); model.TourTeamUnit.NumberCr = Utils.GetInt(txt_crNum.Text); model.TourTeamUnit.NumberEt = Utils.GetInt(txt_rtNum.Text); model.TourTeamUnit.NumberQp = Utils.GetInt(txt_allNum.Text); model.TourTeamUnit.UnitAmountCr = PriceControl1.cr_price; model.TourTeamUnit.UnitAmountEt = PriceControl1.rt_price; model.TourTeamUnit.UnitAmountQp = PriceControl1.all_price; #endregion #region 单文件 //团队附件实体 EyouSoft.Model.TourStructure.TourAttachInfo attachModel = new EyouSoft.Model.TourStructure.TourAttachInfo(); //文件路径 string filePath = ""; //文件名 string fileName = ""; //文件上传 if (EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["fileField"], "TeamPlanFile", out filePath, out fileName)) { if (filePath.Trim() != "" && fileName.Trim() != "") { //设置文件上传后的虚拟路劲 attachModel.FilePath = filePath; //保存原文件名 attachModel.Name = fileName; IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>(); attachList.Add(attachModel); model.Attachs = attachList; } else if (this.hideData.Value.Trim() != "") { //设置文件上传后的虚拟路劲 attachModel.FilePath = this.hideData.Value; IList <EyouSoft.Model.TourStructure.TourAttachInfo> attachList = new List <EyouSoft.Model.TourStructure.TourAttachInfo>(); attachList.Add(attachModel); model.Attachs = attachList; } else { model.Attachs = null; } } else { //上传失败提示 this.litMsg.Text = Utils.ShowMsg("文件上传失败!"); return; } #endregion #region 数据操作 int count = 0; if (model.TourTraffic != null && model.TourTraffic.Count > 0) { EyouSoft.BLL.PlanStruture.PlanTrffic BLL = new EyouSoft.BLL.PlanStruture.PlanTrffic(); EyouSoft.Model.PlanStructure.TrafficPricesInfo TrafficPricesInfoModel = BLL.GetTrafficPriceModel(model.TourTraffic.First(), model.LDate); if (TrafficPricesInfoModel != null && TrafficPricesInfoModel.TicketNums > 0) { //新增和复制操作时 进行数据添加操作 if (this.hideType.Value == "Add" || this.hideType.Value == "Copy") { //数据库添加操作 count = bll.InsertTeamTourInfo(model); //新增成功 if (count > 0) { Utils.ShowAndRedirect("添加成功!", "/TeamPlan/TeamPlanList.aspx"); } else //失败时提示 if (count == -1) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('团号重复!');"); } else { EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('添加失败!');"); } } else { //数据库修改操作 count = bll.UpdateTeamTourInfo(model); //成功提示 if (count > 0) { Utils.ShowAndRedirect("修改成功!", "/TeamPlan/TeamPlanList.aspx"); } else { EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('修改失败!');"); } } } else { Response.Write("<script type='text/javascript'>alert('提交失败,关联交通票数为零!');location.href=location.href;</script>"); } } else { Response.Write("<script type='text/javascript'>alert('提交失败,关联交通为空!');location.href=location.href;</script>"); } #endregion } else { Utils.ShowAndRedirect("该计划不存在!", "/TeamPlan/TeamPlanList.aspx"); } }