/// <summary> /// 专线端添加报价并生成团队计划 /// </summary> /// <param name="info">团队计划列表信息业务实体</param> /// <param name="LineInquireQuoteInfo">线路询价报价实体类</param> /// <returns></returns> public bool AddQuote(EyouSoft.Model.TourStructure.TourTeamInfo info, EyouSoft.Model.TourStructure.LineInquireQuoteInfo LineInquireQuoteInfo) { if (LineInquireQuoteInfo.CompanyId == 0 || LineInquireQuoteInfo.Id == 0) { return(false); } if (QuoteSuccessInsertPlan(LineInquireQuoteInfo.Id, info)) { //同步组团询价游客信息到团队计划订单 dal.SyncQuoteTravellerToTourTeamOrder(LineInquireQuoteInfo.Id, info.TourId); LineInquireQuoteInfo.QuoteState = EyouSoft.Model.EnumType.TourStructure.QuoteState.已成功; if (dal.UpdateQuote(LineInquireQuoteInfo)) { #region LGWR EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_组团社询价.ToString() + "添加了一条报价,编号:" + LineInquireQuoteInfo.Id; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "添加报价"; logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_组团社询价; logInfo.OperatorId = 0; this.Logwr(logInfo); return(true); #endregion } } return(false); }
/// <summary> /// 组团端添加一个询价 /// </summary> /// <param name="LineInquireQuoteInfo"></param> /// <returns></returns> public bool AddInquire(EyouSoft.Model.TourStructure.LineInquireQuoteInfo LineInquireQuoteInfo) { if (LineInquireQuoteInfo.CompanyId == 0 || LineInquireQuoteInfo.CustomerId == 0) { return(false); } LineInquireQuoteInfo.QuoteState = EyouSoft.Model.EnumType.TourStructure.QuoteState.未处理; if (dal.AddInquire(LineInquireQuoteInfo)) { #region LGWR //EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); //logInfo.CompanyId = 0; //logInfo.DepatId = 0; //logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; //logInfo.EventIp = string.Empty; //logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_组团社询价.ToString() + "添加了一条询价"; //logInfo.EventTime = DateTime.Now; //logInfo.EventTitle = "添加询价"; //logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_组团社询价; //logInfo.OperatorId = 0; //this.Logwr(logInfo); return(true); #endregion } return(false); }
protected void lkBtn_save_Click(object sender, EventArgs e) { EyouSoft.Model.TourStructure.LineInquireQuoteInfo lineInfo = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); int id = 0; id = Convert.ToInt32(Utils.GetQueryStringValue("id")); lineInfo = SaveInfo(id); TheResult(lineQuoteBll.UpdateQuote(lineInfo), "save"); }
//根据状态屏蔽按钮 protected void CheckBtn(EyouSoft.Model.TourStructure.LineInquireQuoteInfo lineInfo) { if (lineInfo.QuoteState == EyouSoft.Model.EnumType.TourStructure.QuoteState.已成功) { this.lkBtn_save.Visible = false; this.submit.Visible = false; } else { this.lkBtn_save.Visible = true; this.submit.Visible = true; } }
/// <summary> /// 专线端修改报价 /// </summary> /// <param name="LineInquireQuoteInfo"></param> /// <returns></returns> public bool UpdateQuote(EyouSoft.Model.TourStructure.LineInquireQuoteInfo LineInquireQuoteInfo) { DbCommand dc = this.DB.GetStoredProcCommand("proc_Inquire_UpdateQuote"); this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, LineInquireQuoteInfo.CompanyId); this.DB.AddInParameter(dc, "Id", DbType.Int32, LineInquireQuoteInfo.Id); this.DB.AddInParameter(dc, "RouteId", DbType.Int32, LineInquireQuoteInfo.RouteId); this.DB.AddInParameter(dc, "RouteName", DbType.String, LineInquireQuoteInfo.RouteName); this.DB.AddInParameter(dc, "ContactTel", DbType.String, LineInquireQuoteInfo.ContactTel); this.DB.AddInParameter(dc, "ContactName", DbType.String, LineInquireQuoteInfo.ContactName); this.DB.AddInParameter(dc, "LeaveDate", DbType.DateTime, LineInquireQuoteInfo.LeaveDate); this.DB.AddInParameter(dc, "AdultNumber", DbType.Int32, LineInquireQuoteInfo.PeopleNum); this.DB.AddInParameter(dc, "ChildNumber", DbType.Int32, LineInquireQuoteInfo.ChildNumber); this.DB.AddInParameter(dc, "SpecialClaim", DbType.String, LineInquireQuoteInfo.SpecialClaim); this.DB.AddInParameter(dc, "Remark", DbType.String, LineInquireQuoteInfo.Remark); this.DB.AddInParameter(dc, "TicketAgio", DbType.Decimal, LineInquireQuoteInfo.TicketAgio); this.DB.AddInParameter(dc, "QuoteState", DbType.Byte, (int)LineInquireQuoteInfo.QuoteState); this.DB.AddInParameter(dc, "XingCheng", DbType.String, CreateXingChengAskXML(LineInquireQuoteInfo.XingCheng)); this.DB.AddInParameter(dc, "ASK", DbType.String, CreateQuoteAskXML(LineInquireQuoteInfo.Requirements)); this.DB.AddInParameter(dc, "QuoteInfo", DbType.String, CreateQuoteListXML(LineInquireQuoteInfo.Services)); this.DB.AddOutParameter(dc, "Result", DbType.Int32, 4); this.DB.AddInParameter(dc, "TotalAmount", DbType.Decimal, LineInquireQuoteInfo.TotalAmount); if (LineInquireQuoteInfo.Traveller != null) { this.DB.AddInParameter(dc, "TravellerDisplayType", DbType.Byte, LineInquireQuoteInfo.Traveller.TravellerDisplayType); this.DB.AddInParameter(dc, "TravellerFilePath", DbType.String, LineInquireQuoteInfo.Traveller.TravellerFilePath); this.DB.AddInParameter(dc, "Travellers", DbType.String, this.CreateQuoteTravellersXML(LineInquireQuoteInfo.Traveller.Travellers)); } else { this.DB.AddInParameter(dc, "TravellerDisplayType", DbType.Byte, EyouSoft.Model.EnumType.TourStructure.CustomerDisplayType.None); this.DB.AddInParameter(dc, "TravellerFilePath", DbType.String, DBNull.Value); this.DB.AddInParameter(dc, "Travellers", DbType.String, DBNull.Value); } DbHelper.RunProcedure(dc, DB); object Result = this.DB.GetParameterValue(dc, "Result"); return(int.Parse(Result.ToString()) > 0 ? true : false); }
protected void Page_Load(object sender, EventArgs e) { tsModel = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); string act = string.Empty; act = EyouSoft.Common.Utils.GetQueryStringValue("act"); if (!IsPostBack) { switch (act) { case "del": AreaDel(); //删除操作 break; default: bind(); break; } } }
protected EyouSoft.Model.TourStructure.LineInquireQuoteInfo InitInfo(int id) { //记录我社报价价格 decimal price = 0; //询价实体类 EyouSoft.Model.TourStructure.LineInquireQuoteInfo lineInfo = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); lineQuoteBll = new EyouSoft.BLL.TourStructure.LineInquireQuoteInfo(SiteUserInfo); lineInfo = lineQuoteBll.GetQuoteModel(id, SiteUserInfo.CompanyID, 0, false); if (lineInfo != null) { //为类赋值 //折扣 this.txt_agio.Value = Utils.FilterEndOfTheZeroString(EyouSoft.Common.Utils.GetDecimal(lineInfo.TicketAgio.ToString()).ToString("0.00")); //出团日期 this.txt_BegTime.Value = ((DateTime)(lineInfo.LeaveDate)).ToString("yyyy-MM-dd"); //联系人姓名 this.txt_contactName.Value = Utils.GetString(lineInfo.ContactName, ""); //联系人电话 this.txt_contactTel.Value = Utils.GetString(lineInfo.ContactTel, ""); //总人数 this.txt_peopleCount.Value = Utils.GetString(Convert.ToString(lineInfo.PeopleNum), ""); //询价单位名称 this.txt_quoteCompany.Value = Utils.GetString(lineInfo.CustomerName, ""); //询价单位编号 this.hid_QuoteCompanyId.Value = Convert.ToString(lineInfo.CustomerId); //客户要求用户控件赋值 this.ConProjectControl1.SetList = lineInfo.Requirements; ConProjectControl1.SetDataList(); //价格组成用户控件赋值 this.PriceControl1.SetList = lineInfo.Services; this.PriceControl1.TotalAmount = lineInfo.TotalAmount; //行程要求 if (lineInfo.XingCheng != null) { this.txtRoutingNeed.Text = Utils.GetString(lineInfo.XingCheng.QuotePlan, ""); file = Utils.GetString(lineInfo.XingCheng.PlanAccessory, ""); this.hid_img_name.Value = Utils.GetString(lineInfo.XingCheng.PlanAccessoryName, ""); this.hid_img_path.Value = Utils.GetString(lineInfo.XingCheng.PlanAccessory, ""); } //状态 this.lblResult.Text = Convert.ToString(lineInfo.QuoteState); //特殊需求 this.txt_need.Value = Utils.GetString(lineInfo.SpecialClaim, ""); //线路用户控件赋值 this.xianluWindow1.Name = lineInfo.RouteName; this.xianluWindow1.Id = Convert.ToString(lineInfo.RouteId); this.xianluWindow1.publishType = 1; //备注 this.txt_remark.Value = lineInfo.Remark; #region 订单游客数据 EyouSoft.BLL.TourStructure.TourOrder TourOrderBll = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo); System.Collections.Generic.IList <EyouSoft.Model.TourStructure.TourOrderCustomer> curList = lineInfo.Traveller.Travellers; System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); if (curList != null && curList.Count > 0) { for (int i = 0; i < curList.Count; i++) { if (curList[i].VisitorType == EyouSoft.Model.EnumType.TourStructure.VisitorType.成人) { stringBuilder.AppendFormat("<tr itemtype=\"{0}\">", "adult"); } else if (curList[i].VisitorType == EyouSoft.Model.EnumType.TourStructure.VisitorType.儿童) { stringBuilder.AppendFormat("<tr itemtype=\"{0}\">", "child"); } else { stringBuilder.AppendFormat("<tr itemtype=\"{0}\">", "other"); } stringBuilder.AppendFormat("<td style=\"width: 5%\" bgcolor=\"#e3f1fc\" index=\"{0}\" align=\"center\">{0}</td><td height=\"25\" bgcolor=\"#e3f1fc\" align=\"center\">", i + 1); stringBuilder.AppendFormat("<input type=\"text\" class=\"searchinput\" id=\"cusName\" MaxLength=\"50\" valid=\"required\" errmsg=\"请填写姓名!\" name=\"cusName\" value=\"{0}\" /></td>", curList[i].VisitorName); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\">"); #region 游客类型 if (curList[i].VisitorType == EyouSoft.Model.EnumType.TourStructure.VisitorType.成人) { stringBuilder.Append("<select disabled=\"disabled\" title=\"请选择\" id=\"cusType\" name=\"cusType\">"); stringBuilder.Append("<option value=\"\">请选择</option>"); stringBuilder.Append("<option value=\"1\" selected=\"selected\">成人</option>"); stringBuilder.Append("<option value=\"2\">儿童</option>"); stringBuilder.Append(" </select>"); } //儿童 else if (curList[i].VisitorType == EyouSoft.Model.EnumType.TourStructure.VisitorType.儿童) { stringBuilder.Append("<select disabled=\"disabled\" title=\"请选择\" id=\"cusType\" name=\"cusType\">"); stringBuilder.Append("<option value=\"\">请选择</option>"); stringBuilder.Append("<option value=\"1\" >成人</option>"); stringBuilder.Append("<option value=\"2\" selected=\"selected\">儿童</option>"); stringBuilder.Append(" </select>"); } //其它 else { stringBuilder.Append("<select id=\"cusType\" title=\"请选择\" name=\"cusType\">"); stringBuilder.Append("<option value=\"\" selected=\"selected\">请选择</option>"); stringBuilder.Append("<option value=\"1\" >成人</option>"); stringBuilder.Append("<option value=\"2\">儿童</option>"); stringBuilder.Append(" </select>"); } #endregion stringBuilder.Append("</td>"); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\">"); #region 游客证件类型 switch (curList[i].CradType) { case EyouSoft.Model.EnumType.TourStructure.CradType.身份证: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\" selected=\"selected\">身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\">港澳通行证</option>"); stringBuilder.Append("<option value=\"6\">户口本</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.TourStructure.CradType.护照: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\">身份证</option>"); stringBuilder.Append("<option value=\"2\" selected=\"selected\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\">港澳通行证</option>"); stringBuilder.Append("<option value=\"6\">户口本</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.TourStructure.CradType.军官证: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\">身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\" selected=\"selected\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\">港澳通行证</option>"); stringBuilder.Append("<option value=\"6\">户口本</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.TourStructure.CradType.台胞证: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\">身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\" selected=\"selected\">台胞证</option>"); stringBuilder.Append("<option value=\"5\">港澳通行证</option>"); stringBuilder.Append("<option value=\"6\">户口本</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.TourStructure.CradType.港澳通行证: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\">身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\" selected=\"selected\">港澳通行证</option>"); stringBuilder.Append("<option value=\"6\">户口本</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.TourStructure.CradType.户口本: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\">身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\" >港澳通行证</option>"); stringBuilder.Append("<option value=\"6\" selected=\"selected\">户口本</option>"); stringBuilder.Append("</select>"); break; } default: { stringBuilder.Append("<select id=\"cusCardType\" name=\"cusCardType\">"); stringBuilder.Append("<option value=\"0\" selected=\"selected\">请选择证件</option>"); stringBuilder.Append("<option value=\"1\" >身份证</option>"); stringBuilder.Append("<option value=\"2\">护照</option>"); stringBuilder.Append("<option value=\"3\">军官证</option>"); stringBuilder.Append("<option value=\"4\">台胞证</option>"); stringBuilder.Append("<option value=\"5\">港澳通行证</option>"); stringBuilder.Append("</select>"); break; } } #endregion stringBuilder.Append("</td>"); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\">"); stringBuilder.AppendFormat("<input type=\"text\" class=\"searchinput searchinput02\" id=\"cusCardNo\" MaxLength=\"150\" onblur='getSex(this)' name=\"cusCardNo\" value=\"{0}\">", curList[i].CradNumber); stringBuilder.Append("</td>"); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\">"); #region 游客性别 switch (curList[i].Sex) { case EyouSoft.Model.EnumType.CompanyStructure.Sex.男: { stringBuilder.Append("<select class='ddlSex' id=\"cusSex\" name=\"cusSex\">"); stringBuilder.Append("<option value=\"0\">请选择</option>"); stringBuilder.Append("<option value=\"1\" selected=\"selected\">男</option>"); stringBuilder.Append("<option value=\"2\">女</option>"); stringBuilder.Append("</select>"); break; } case EyouSoft.Model.EnumType.CompanyStructure.Sex.女: { stringBuilder.Append("<select class='ddlSex' id=\"cusSex\" name=\"cusSex\">"); stringBuilder.Append("<option value=\"0\">请选择</option>"); stringBuilder.Append("<option value=\"1\">男</option>"); stringBuilder.Append("<option value=\"2\" selected=\"selected\">女</option>"); stringBuilder.Append("</select>"); break; } default: { stringBuilder.Append("<select class='ddlSex' id=\"cusSex\" name=\"cusSex\">"); stringBuilder.Append("<option value=\"0\" selected=\"selected\">请选择</option>"); stringBuilder.Append("<option value=\"1\">男</option>"); stringBuilder.Append("<option value=\"2\">女</option>"); break; } } #endregion stringBuilder.Append("</td>"); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\">"); stringBuilder.AppendFormat("<input type=\"text\" class=\"searchinput\" id=\"cusPhone\" MaxLength=\"50\" name=\"cusPhone\" value=\"{0}\">", curList[i].ContactTel); stringBuilder.Append("</td>"); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\" width=\"6%\">"); if (curList[i].SpecialServiceInfo != null) { string str = string.Format("txtItem={0}&txtServiceContent={1}&txtCost={2}&ddlOperate={3}", curList[i].SpecialServiceInfo.ProjectName, curList[i].SpecialServiceInfo.ServiceDetail, curList[i].SpecialServiceInfo.Fee, (curList[i].SpecialServiceInfo.IsAdd ? "0" : "1")); stringBuilder.AppendFormat("<input id=\"spe{0}\" type=\"hidden\" name=\"specive\" value=\"{1}\" />", curList[i].ID, str); } else { string special = ""; if (curList[i].SpecialServiceInfo != null) { string isadd = curList[i].SpecialServiceInfo.IsAdd ? "0" : "1"; special = "txtItem=" + curList[i].SpecialServiceInfo.ProjectName + "&txtServiceContent=" + curList[i].SpecialServiceInfo.ServiceDetail + "&ddlOperate=" + isadd + "&txtCost=" + Utils.FilterEndOfTheZeroDecimal(curList[i].SpecialServiceInfo.Fee); } stringBuilder.AppendFormat("<input id=\"spe{0}\" type=\"hidden\" name=\"specive\" value=\"{1}\" />", curList[i].ID, special); } stringBuilder.AppendFormat("<a sign=\"speService\" href=\"javascript:void(0)\" onclick=\"OrderEdit.OpenSpecive('spe{0}')\">特服</a></td>", curList[i].ID); stringBuilder.Append("<td bgcolor=\"#e3f1fc\" align=\"center\" width=\"15%\">"); stringBuilder.AppendFormat("<input type=\"hidden\" name=\"cusID\" value=\"{0}\" />", curList[i].ID); stringBuilder.Append("<a sign=\"add\" href=\"javascript:void(0)\" onclick=\"OrderEdit.AddCus()\">添加</a> "); stringBuilder.Append("<input type=\"hidden\" name=\"cusState\" value=\"EDIT\" />"); string msg = ""; if (TourOrderBll.IsDoDelete(curList[i].ID, ref msg)) { stringBuilder.Append("<a sign=\"del\" href=\"javascript:void(0)\" onclick=\"OrderEdit.DelCus($(this))\">删除</a></td></tr>"); } else { stringBuilder.AppendFormat("<span>{0}</span>", msg); } } } cusHtml = stringBuilder.ToString(); #endregion } CheckBtn(lineInfo); return(lineInfo); }
protected void CreatQuicklyTeam() { int id = Convert.ToInt32(Utils.GetQueryStringValue("id")); EyouSoft.Model.TourStructure.LineInquireQuoteInfo lineInfo = SaveInfo(id); //生成页面上取值后的lineInfo EyouSoft.Model.RouteStructure.RouteInfo route = new EyouSoft.Model.RouteStructure.RouteInfo(); //生成线路信息 EyouSoft.BLL.RouteStructure.Route routeBll = new EyouSoft.BLL.RouteStructure.Route(); //routeBll类 EyouSoft.Model.TourStructure.TourTeamInfo tourTeamInfo = new EyouSoft.Model.TourStructure.TourTeamInfo(); //生成团队计划类 //获取线路 route = routeBll.GetRouteInfo(lineInfo.RouteId); //客户单位编号 tourTeamInfo.BuyerCId = lineInfo.CustomerId; //客户单位名称 tourTeamInfo.BuyerCName = lineInfo.CustomerName; //公司编号 tourTeamInfo.CompanyId = lineInfo.CompanyId; //出团日期 tourTeamInfo.LDate = (DateTime)lineInfo.LeaveDate; //线路编号 tourTeamInfo.RouteId = lineInfo.RouteId; //线路名称 tourTeamInfo.RouteName = lineInfo.RouteName; //客户单位编号 tourTeamInfo.BuyerCId = lineInfo.CustomerId; //客户单位名称 tourTeamInfo.BuyerCName = lineInfo.CustomerName; //公司编号 tourTeamInfo.CompanyId = lineInfo.CompanyId; //发布人编号 tourTeamInfo.OperatorId = SiteUserInfo.ID; //总人数 tourTeamInfo.PlanPeopleNumber = lineInfo.PeopleNum; //团队计划发布类型 tourTeamInfo.ReleaseType = EyouSoft.Model.EnumType.TourStructure.ReleaseType.Quick; if (new EyouSoft.BLL.CompanyStructure.CompanySetting().GetTeamNumberOfPeople(SiteUserInfo.CompanyID) == EyouSoft.Model.EnumType.CompanyStructure.TeamNumberOfPeople.PartNumber) { tourTeamInfo.TourTeamUnit = new EyouSoft.Model.TourStructure.MTourTeamUnitInfo() { NumberCr = tourTeamInfo.PlanPeopleNumber, NumberEt = 0, NumberQp = 0, UnitAmountCr = 0, UnitAmountEt = 0, UnitAmountQp = 0 }; } else { tourTeamInfo.TourTeamUnit = null; } //生成快速发布信息实体 tourTeamInfo.TourQuickInfo = new EyouSoft.Model.TourStructure.TourQuickPrivateInfo(); if (lineInfo.XingCheng != null) { //快速发布——行程内容 tourTeamInfo.TourQuickInfo.QuickPlan = lineInfo.XingCheng.QuotePlan; } //快速发布——备注 tourTeamInfo.TourQuickInfo.Remark = lineInfo.Remark; //快速发布——服务标准 tourTeamInfo.TourQuickInfo.Service = lineInfo.SpecialClaim; //销售员ID tourTeamInfo.SellerId = SiteUserInfo.ID; //我社报价 tourTeamInfo.TotalAmount = PriceControl1.TotalAmount; //团号 tourTeamInfo.TourCode = this.hid_tourCode.Value; //天数 tourTeamInfo.TourDays = Utils.GetInt(this.hid_dayCount.Value, 1); //计调员 tourTeamInfo.Coordinator = new EyouSoft.Model.TourStructure.TourCoordinatorInfo(); tourTeamInfo.Coordinator.CoordinatorId = Utils.GetInt(this.hid_peopleId.Value, 0); tourTeamInfo.Coordinator.Name = this.hid_peopleName.Value; //包含项目集合 tourTeamInfo.Services = this.PriceControl1.GetList; //区域路线编号 tourTeamInfo.AreaId = Utils.GetInt(this.hid_areaId.Value, 0); TheResult(lineQuoteBll.AddQuote(tourTeamInfo, lineInfo), "Submit"); }
protected EyouSoft.Model.TourStructure.LineInquireQuoteInfo SaveInfo(int id) { EyouSoft.Model.TourStructure.LineInquireQuoteInfo lineInfo = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); //预计出团日期 lineInfo.LeaveDate = Utils.GetDateTime(Utils.GetFormValue(this.txt_BegTime.UniqueID)); //总人数 lineInfo.PeopleNum = Utils.GetInt(Utils.GetFormValue(this.txt_peopleCount.UniqueID), 0); //状态 lineInfo.QuoteState = EyouSoft.Model.EnumType.TourStructure.QuoteState.已处理; //备注 lineInfo.Remark = Utils.GetFormValue(this.txt_remark.UniqueID); //客人要求集合 lineInfo.Requirements = ConProjectControl1.GetDataList(); //线路编号 lineInfo.RouteId = Utils.GetInt(xianluWindow1.Id); //线路名称 lineInfo.RouteName = xianluWindow1.Name; //价格组成集合 lineInfo.Services = PriceControl1.GetList; //总价 lineInfo.TotalAmount = PriceControl1.TotalAmount; //行程 lineInfo.XingCheng = new EyouSoft.Model.TourStructure.XingChengMust(); lineInfo.XingCheng.QuotePlan = Request.Form[this.txtRoutingNeed.UniqueID]; lineInfo.XingCheng.QuoteId = id; //行程_附件 string filepath = string.Empty; string oldfilename = string.Empty; bool file_result = EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["routingFile"], "TourQuotePriceFile", out filepath, out oldfilename); if (filepath != "") { lineInfo.XingCheng.PlanAccessory = filepath; lineInfo.XingCheng.PlanAccessoryName = oldfilename; } else { if (hid_img_path.Value != "null") { lineInfo.XingCheng.PlanAccessory = hid_img_path.Value; lineInfo.XingCheng.PlanAccessoryName = hid_img_name.Value; } else { lineInfo.XingCheng.PlanAccessoryName = ""; lineInfo.XingCheng.PlanAccessory = ""; } } //机票折扣 lineInfo.TicketAgio = Utils.GetDecimal(Utils.GetFormValue(this.txt_agio.UniqueID)); //特殊要求 lineInfo.SpecialClaim = Utils.GetFormValue(this.txt_need.UniqueID); //编号 lineInfo.Id = id; //公司ID lineInfo.CompanyId = SiteUserInfo.CompanyID; //联系人姓名 lineInfo.ContactTel = Utils.GetFormValue(this.txt_contactTel.UniqueID); //联系人电话 lineInfo.ContactName = Utils.GetFormValue(this.txt_contactName.UniqueID); //询价单位编号 lineInfo.CustomerId = Utils.GetInt(this.hid_QuoteCompanyId.Value, 0); //询价单位名称 lineInfo.CustomerName = Utils.GetFormValue(this.txt_quoteCompany.UniqueID); ///////////////////////////////////////游客信息 int cusLength = Utils.GetFormValues("cusName").Length; lineInfo.Traveller = new EyouSoft.Model.TourStructure.TourEverydayApplyTravellerInfo(); lineInfo.Traveller.Travellers = new List <EyouSoft.Model.TourStructure.TourOrderCustomer>(); for (int i = 0; i < cusLength; i++) { //游客id string cusID = Utils.GetFormValues("cusID")[i]; EyouSoft.Model.TourStructure.TourOrderCustomer toc = new EyouSoft.Model.TourStructure.TourOrderCustomer(); toc.VisitorName = Utils.GetFormValues("cusName")[i]; toc.VisitorType = (EyouSoft.Model.EnumType.TourStructure.VisitorType)(Utils.GetInt(Utils.GetFormValues("cusType")[i])); toc.CradType = (EyouSoft.Model.EnumType.TourStructure.CradType)(Utils.GetInt(Utils.GetFormValues("cusCardType")[i])); toc.CradNumber = Utils.GetFormValues("cusCardNo")[i]; //游客性别 int cusSex = Utils.GetInt(Utils.GetFormValues("cusSex")[i]); #region 性别 if (cusSex == 1) { toc.Sex = EyouSoft.Model.EnumType.CompanyStructure.Sex.男; } else if (cusSex == 2) { toc.Sex = EyouSoft.Model.EnumType.CompanyStructure.Sex.女; } else { toc.Sex = EyouSoft.Model.EnumType.CompanyStructure.Sex.未知; } #endregion toc.ContactTel = Utils.GetFormValues("cusPhone")[i]; toc.IssueTime = DateTime.Now; EyouSoft.Model.TourStructure.CustomerSpecialService specModel = new EyouSoft.Model.TourStructure.CustomerSpecialService(); if (string.IsNullOrEmpty(cusID)) { toc.ID = System.Guid.NewGuid().ToString(); } else { toc.ID = cusID; } if (Utils.GetFormValues("cusState")[i] == "DEL") { toc.IsDelete = true; } else { toc.IsDelete = false; } //特服 string specive = Utils.GetFormValues("specive")[i]; if (!string.IsNullOrEmpty(specive)) { if (specive.LastIndexOf(',') + 1 == specive.Length) { specive = specive.Substring(0, specive.Length - 1); } specModel.CustormerId = toc.ID; specModel.ProjectName = Server.UrlDecode(Utils.GetFromQueryStringByKey(specive, "txtItem")); specModel.ServiceDetail = Server.UrlDecode(Utils.GetFromQueryStringByKey(specive, "txtServiceContent")); specModel.IsAdd = Utils.GetFromQueryStringByKey(specive, "ddlOperate") == "0" ? true : false; specModel.Fee = Utils.GetDecimal(Utils.GetFromQueryStringByKey(specive, "txtCost")); specModel.IssueTime = DateTime.Now; //特服项目名不能为空,否则不添加该条特服信息 if (!string.IsNullOrEmpty(specModel.ProjectName)) { toc.SpecialServiceInfo = specModel; } } lineInfo.Traveller.Travellers.Add(toc); } /// return(lineInfo); }
/// <summary> /// <summary> /// 获取询价报价实体 /// </summary> /// <param name="Id">主键编号</param> /// <param name="CompanyId">专线公司编号</param> /// <param name="CustomerId">组团公司编号</param> /// <param name="isZhuTuan">是否组团端,1是,0不是</param> /// <returns></returns> public EyouSoft.Model.TourStructure.LineInquireQuoteInfo GetQuoteModel(int Id, int CompanyId, int CustomerId, int isZhuTuan) { EyouSoft.Model.TourStructure.LineInquireQuoteInfo model = null; DbCommand dc = this.DB.GetStoredProcCommand("proc_Tour_GetInquireQuote"); this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, CompanyId); this.DB.AddInParameter(dc, "CustomerId", DbType.Int32, CustomerId); this.DB.AddInParameter(dc, "isZhuTuan", DbType.Int32, isZhuTuan); this.DB.AddInParameter(dc, "Id", DbType.Int32, Id); using (IDataReader dr = DbHelper.RunReaderProcedure(dc, this.DB)) { if (dr.Read()) { #region 询价报价基本信息 model = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CompanyId = dr.IsDBNull(dr.GetOrdinal("CompanyId")) ? 0 : dr.GetInt32(dr.GetOrdinal("CompanyId")); model.RouteId = dr.IsDBNull(dr.GetOrdinal("RouteId")) ? 0 : dr.GetInt32(dr.GetOrdinal("RouteId")); model.RouteName = dr["RouteName"].ToString(); model.CustomerId = dr.IsDBNull(dr.GetOrdinal("CustomerId")) ? 0 : dr.GetInt32(dr.GetOrdinal("CustomerId")); model.CustomerName = dr["CustomerName"].ToString(); model.ContactName = dr["ContactName"].ToString(); model.ContactTel = dr["ContactTel"].ToString(); model.LeaveDate = dr.IsDBNull(dr.GetOrdinal("LeaveDate")) ? System.DateTime.Now : dr.GetDateTime(dr.GetOrdinal("LeaveDate")); model.AdultNumber = dr.IsDBNull(dr.GetOrdinal("AdultNumber")) ? 0 : dr.GetInt32(dr.GetOrdinal("AdultNumber")); model.ChildNumber = dr.IsDBNull(dr.GetOrdinal("ChildNumber")) ? 0 : dr.GetInt32(dr.GetOrdinal("ChildNumber")); model.PeopleNum = model.AdultNumber + model.ChildNumber; model.SpecialClaim = dr["SpecialClaim"].ToString(); model.TicketAgio = dr.IsDBNull(dr.GetOrdinal("TicketAgio")) ? 0 : dr.GetDecimal(dr.GetOrdinal("TicketAgio")); model.IssueTime = dr.IsDBNull(dr.GetOrdinal("IssueTime")) ? System.DateTime.Now : dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.QuoteState = (EyouSoft.Model.EnumType.TourStructure.QuoteState)dr.GetByte(dr.GetOrdinal("QuoteState")); model.Remark = dr["Remark"].ToString(); model.BuildTourId = dr["BuildTourId"].ToString(); model.TotalAmount = dr.GetDecimal(dr.GetOrdinal("TotalAmount")); model.Traveller = new EyouSoft.Model.TourStructure.TourEverydayApplyTravellerInfo(); model.Traveller.TravellerDisplayType = (EyouSoft.Model.EnumType.TourStructure.CustomerDisplayType)dr.GetByte(dr.GetOrdinal("TravellerDisplayType")); model.Traveller.TravellerFilePath = dr["TravellerFilePath"].ToString(); model.Traveller.Travellers = new List <EyouSoft.Model.TourStructure.TourOrderCustomer>(); #endregion #region 行程要求 EyouSoft.Model.TourStructure.XingChengMust XingChengMust = null; dr.NextResult(); if (dr.Read()) { XingChengMust = new EyouSoft.Model.TourStructure.XingChengMust() { QuoteId = dr.IsDBNull(dr.GetOrdinal("QuoteId")) ? 0 : dr.GetInt32(dr.GetOrdinal("QuoteId")), QuotePlan = dr["QuotePlan"].ToString(), PlanAccessory = dr["PlanAccessory"].ToString(), PlanAccessoryName = dr["PlanAccessoryName"].ToString() }; } model.XingCheng = XingChengMust; #endregion #region 客人要求信息集合 IList <EyouSoft.Model.TourStructure.TourServiceInfo> TourServiceInfoList = new List <EyouSoft.Model.TourStructure.TourServiceInfo>(); EyouSoft.Model.TourStructure.TourServiceInfo TourServiceInfo = null; dr.NextResult(); while (dr.Read()) { TourServiceInfo = new EyouSoft.Model.TourStructure.TourServiceInfo() { Service = dr["ConcreteAsk"].ToString(), ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)dr.GetInt32(dr.GetOrdinal("ItemType")) }; TourServiceInfoList.Add(TourServiceInfo); } model.Requirements = TourServiceInfoList; #endregion #region 价格组成信息集合 IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> TourTeamServiceInfoList = new List <EyouSoft.Model.TourStructure.TourTeamServiceInfo>(); EyouSoft.Model.TourStructure.TourTeamServiceInfo TourTeamServiceInfo = null; dr.NextResult(); while (dr.Read()) { TourTeamServiceInfo = new EyouSoft.Model.TourStructure.TourTeamServiceInfo() { Service = dr["Reception"].ToString(), LocalPrice = dr.IsDBNull(dr.GetOrdinal("LocalQuote")) ? 0 : dr.GetDecimal(dr.GetOrdinal("LocalQuote")), SelfPrice = dr.IsDBNull(dr.GetOrdinal("MyQuote")) ? 0 : dr.GetDecimal(dr.GetOrdinal("MyQuote")), ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)dr.GetInt32(dr.GetOrdinal("ItemId")), LocalPeopleNumber = dr.GetInt32(dr.GetOrdinal("LocalPeopleNumber")), LocalUnitPrice = dr.GetDecimal(dr.GetOrdinal("LocalUnitPrice")), SelfPeopleNumber = dr.GetInt32(dr.GetOrdinal("SelfPeopleNumber")), SelfUnitPrice = dr.GetDecimal(dr.GetOrdinal("SelfUnitPrice")) }; TourTeamServiceInfoList.Add(TourTeamServiceInfo); } model.Services = TourTeamServiceInfoList; #endregion #region 游客信息 if (dr.NextResult() && model != null) { while (dr.Read()) { EyouSoft.Model.TourStructure.TourOrderCustomer traveller = new EyouSoft.Model.TourStructure.TourOrderCustomer() { ID = dr.GetString(dr.GetOrdinal("TravellerId")), VisitorName = dr["TravellerName"].ToString(), CradType = (EyouSoft.Model.EnumType.TourStructure.CradType)dr.GetByte(dr.GetOrdinal("CertificateType")), CradNumber = dr["CertificateCode"].ToString(), Sex = (EyouSoft.Model.EnumType.CompanyStructure.Sex)dr.GetByte(dr.GetOrdinal("Gender")), VisitorType = (EyouSoft.Model.EnumType.TourStructure.VisitorType)dr.GetByte(dr.GetOrdinal("TravellerType")), ContactTel = dr["Telephone"].ToString(), }; traveller.SpecialServiceInfo = new EyouSoft.Model.TourStructure.CustomerSpecialService() { CustormerId = traveller.ID, Fee = !dr.IsDBNull(dr.GetOrdinal("Fee")) ? dr.GetDecimal(dr.GetOrdinal("Fee")) : 0, IsAdd = !dr.IsDBNull(dr.GetOrdinal("IsAdd")) ? dr.GetByte(dr.GetOrdinal("IsAdd")) == 1 ? true : false : false, ProjectName = dr["ServiceName"].ToString(), ServiceDetail = dr["ServiceDetail"].ToString() }; model.Traveller.Travellers.Add(traveller); } } #endregion } } return(model); }
/// <summary> /// 获取询价列表 /// </summary> /// <param name="companyId">公司编号(专线:专线公司编号,组团:组团公司编号)</param> /// <param name="pageSize">每页显示的记录数</param> /// <param name="pageIndex">返回第几页</param> /// <param name="recordCount">返回的记录数</param> /// <param name="isZhuTuan">专线:False,组团:True</param> /// <returns></returns> public IList <EyouSoft.Model.TourStructure.LineInquireQuoteInfo> GetInquireList(int companyId, int pageSize, int pageIndex, ref int recordCount, bool isZhuTuan, EyouSoft.Model.TourStructure.LineInquireQuoteSearchInfo SearchInfo) { IList <EyouSoft.Model.TourStructure.LineInquireQuoteInfo> items = new List <EyouSoft.Model.TourStructure.LineInquireQuoteInfo>(); EyouSoft.Model.TourStructure.LineInquireQuoteInfo item = null; StringBuilder cmdQuery = new StringBuilder(); string tableName = "tbl_CustomerQuote"; string primaryKey = "Id"; string orderByString = "IssueTime DESC"; StringBuilder fields = new StringBuilder(); #region 要查询的字段 fields.Append(" Id,LeaveDate,RouteName,CustomerId,AdultNumber+ChildNumber AS PeopleNum,(select name from tbl_Customer where Id=tbl_CustomerQuote.CustomerId) as CustomerName,ContactName,ContactTel,QuoteState,"); fields.Append("(select TourCode from tbl_Tour where TourId=tbl_CustomerQuote.BuildTourId) as TourCode,"); //fields.Append("(select RouteName from tbl_Tour where TourId=tbl_CustomerQuote.BuildTourId) as RouteName,"); fields.Append("(select TourDays from tbl_Tour where TourId=tbl_CustomerQuote.BuildTourId) as TourDays"); //fields.Append("(select LeaveDate from tbl_Tour where TourId=tbl_CustomerQuote.BuildTourId) as ChuTuanDate"); fields.Append(" ,IssueTime "); #endregion #region 拼接查询条件 if (isZhuTuan) { cmdQuery.AppendFormat(" CustomerId={0} AND IsDelete=0", companyId); } else { cmdQuery.AppendFormat(" CompanyId={0} AND IsDelete=0", companyId); } if (SearchInfo != null) { if (!string.IsNullOrEmpty(SearchInfo.TourNo) || SearchInfo.DayNum != 0) { cmdQuery.Append(" AND EXISTS(SELECT 1 FROM tbl_Tour AS A WHERE A.TourId=tbl_CustomerQuote.BuildTourId "); if (!string.IsNullOrEmpty(SearchInfo.TourNo)) { cmdQuery.AppendFormat(" AND A.TourCode LIKE '%{0}%' ", SearchInfo.TourNo); } if (SearchInfo.DayNum != 0) { cmdQuery.AppendFormat(" AND A.TourDays={0} ", SearchInfo.DayNum); } cmdQuery.Append(" ) "); } if (!String.IsNullOrEmpty(SearchInfo.RouteName)) { cmdQuery.AppendFormat(" AND RouteName like '%{0}%'", SearchInfo.RouteName); } if (SearchInfo.SDate.HasValue && SearchInfo.SDate != DateTime.MinValue) { cmdQuery.AppendFormat(" AND LeaveDate>'{0}' ", SearchInfo.SDate.Value.AddDays(-1)); } if (SearchInfo.EDate.HasValue && SearchInfo.EDate != DateTime.MinValue) { cmdQuery.AppendFormat(" AND LeaveDate<'{0}' ", SearchInfo.EDate.Value.AddDays(1)); } if (SearchInfo.XunTuanETime.HasValue) { cmdQuery.AppendFormat(" AND IssueTime<'{0}' ", SearchInfo.XunTuanETime.Value.AddDays(1)); } if (SearchInfo.XunTuanSTime.HasValue) { cmdQuery.AppendFormat(" AND IssueTime>'{0}' ", SearchInfo.XunTuanSTime.Value); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { item = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo() { Id = rdr.GetInt32(rdr.GetOrdinal("Id")), CustomerId = rdr.GetInt32(rdr.GetOrdinal("CustomerId")), RouteName = rdr["RouteName"].ToString(), LeaveDate = rdr.IsDBNull(rdr.GetOrdinal("LeaveDate")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("LeaveDate")), PeopleNum = rdr.IsDBNull(rdr.GetOrdinal("PeopleNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("PeopleNum")), CustomerName = rdr["CustomerName"].ToString(), ContactName = rdr["ContactName"].ToString(), ContactTel = rdr["ContactTel"].ToString(), QuoteState = (EyouSoft.Model.EnumType.TourStructure.QuoteState)rdr.GetByte(rdr.GetOrdinal("QuoteState")), IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")) }; items.Add(item); } } return(items); }