コード例 #1
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 获取客户等级实体
        /// </summary>
        /// <param name="Id">主键编号</param>
        /// <returns></returns>
        public EyouSoft.Model.CompanyStructure.CustomStand GetModel(int Id)
        {
            EyouSoft.Model.CompanyStructure.CustomStand customStandModel = null;
            DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_CustomStand);

            this._db.AddInParameter(cmd, "Id", DbType.Int32, Id);

            using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
            {
                if (rdr.Read())
                {
                    customStandModel = new EyouSoft.Model.CompanyStructure.CustomStand();
                    if (!rdr.IsDBNull(rdr.GetOrdinal("Id")))
                    {
                        customStandModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("CustomStandName")))
                    {
                        customStandModel.CustomStandName = rdr.GetString(rdr.GetOrdinal("CustomStandName"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("CompanyId")))
                    {
                        customStandModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("OperatorId")))
                    {
                        customStandModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("LevType")))
                    {
                        customStandModel.LevType = (EyouSoft.Model.EnumType.CompanyStructure.CustomLevType) int.Parse(rdr[rdr.GetOrdinal("LevType")].ToString());
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IssueTime")))
                    {
                        customStandModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IsSystem")))
                    {
                        customStandModel.IsSystem = rdr[(rdr.GetOrdinal("IsSystem"))].ToString() == "1" ? true : false;
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IsDelete")))
                    {
                        customStandModel.IsDelete = rdr[rdr.GetOrdinal("IsDelete")].ToString() == "1" ? true : false;
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("SalerCommision")))
                    {
                        customStandModel.SalerCommision = rdr.GetDecimal(rdr.GetOrdinal("SalerCommision"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("LogisticsCommision")))
                    {
                        customStandModel.LogisticsCommision = rdr.GetDecimal(rdr.GetOrdinal("LogisticsCommision"));
                    }
                }
            }

            return(customStandModel);
        }
コード例 #2
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model">客户等级实体</param>
        /// <returns>true:成功 false:失败</returns>
        public bool Update(EyouSoft.Model.CompanyStructure.CustomStand model)
        {
            bool result = false;

            result = Dal.Update(model);
            handleLogsBll.Add(AddLogs("修改", result));

            return(result);
        }
コード例 #3
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model">客户等级实体</param>
        /// <returns>true:成功 false:失败</returns>
        public bool Update(EyouSoft.Model.CompanyStructure.CustomStand model)
        {
            DbCommand cmd = this._db.GetSqlStringCommand(SQL_UPDATE_CustomStand);

            this._db.AddInParameter(cmd, "CustomStandName", DbType.String, model.CustomStandName);
            this._db.AddInParameter(cmd, "LevType", DbType.Byte, (int)model.LevType);
            this._db.AddInParameter(cmd, "Id", DbType.Int32, model.Id);
            this._db.AddInParameter(cmd, "SalerCommision", DbType.Decimal, model.SalerCommision);
            this._db.AddInParameter(cmd, "LogisticsCommision", DbType.Decimal, model.LogisticsCommision);

            return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
        }
コード例 #4
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model">客户等级实体</param>
        /// <returns>true:成功 false:失败</returns>
        public bool Add(EyouSoft.Model.CompanyStructure.CustomStand model)
        {
            DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_CustomStand);

            this._db.AddInParameter(cmd, "CustomStandName", DbType.String, model.CustomStandName);
            this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, model.CompanyId);
            this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, model.OperatorId);
            this._db.AddInParameter(cmd, "IsSystem", DbType.String, model.IsSystem == true ? "1" : "0");
            this._db.AddInParameter(cmd, "LevType", DbType.Byte, (int)model.LevType);
            this._db.AddInParameter(cmd, "SalerCommision", DbType.Decimal, model.SalerCommision);
            this._db.AddInParameter(cmd, "LogisticsCommision", DbType.Decimal, model.LogisticsCommision);
            return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
        }
コード例 #5
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 根据公司编号获取客户等级信息
        /// </summary>
        /// <param name="companyId">公司编号</param>
        /// <returns></returns>
        public IList <EyouSoft.Model.CompanyStructure.CustomStand> GetCustomStandByCompanyId(int companyId)
        {
            IList <EyouSoft.Model.CompanyStructure.CustomStand> totals = new List <EyouSoft.Model.CompanyStructure.CustomStand>();

            EyouSoft.Model.CompanyStructure.CustomStand model = null;
            DbCommand cmd = this._db.GetSqlStringCommand(SQL_GetCustomStandByCompanyId);

            this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, companyId);

            using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
            {
                while (rdr.Read())
                {
                    model    = new EyouSoft.Model.CompanyStructure.CustomStand();
                    model.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
                    model.CustomStandName = rdr.GetString(rdr.GetOrdinal("CustomStandName"));
                    model.CompanyId       = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
                    model.OperatorId      = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
                    model.LevType         = (EyouSoft.Model.EnumType.CompanyStructure.CustomLevType) int.Parse(rdr[rdr.GetOrdinal("LevType")].ToString());
                    model.IssueTime       = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
                    model.IsSystem        = rdr[(rdr.GetOrdinal("IsSystem"))].ToString() == "1" ? true : false;
                    model.IsDelete        = rdr[rdr.GetOrdinal("IsDelete")].ToString() == "1" ? true : false;
                    if (!rdr.IsDBNull(rdr.GetOrdinal("SalerCommision")))
                    {
                        model.SalerCommision = rdr.GetDecimal(rdr.GetOrdinal("SalerCommision"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("LogisticsCommision")))
                    {
                        model.LogisticsCommision = rdr.GetDecimal(rdr.GetOrdinal("LogisticsCommision"));
                    }

                    totals.Add(model);
                }
            }

            return(totals);
        }
コード例 #6
0
        protected bool IsSystem;    //是否系统默认
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_基础设置_客户等级栏目))
            {
                Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_基础设置_客户等级栏目, false);
                return;
            }
            custLevel = Utils.GetFormValue("txtCustLevel");                                                                             //获取客户等级
            int    custId   = Utils.GetInt(Utils.GetQueryStringValue("custId"));                                                        //客户等级Id
            string method   = Utils.GetFormValue("hidMethod");                                                                          //获取当前操作(保存/继续)
            string showMess = "数据保存完成";                                                                                                 //提示消息

            EyouSoft.BLL.CompanyStructure.CompanyCustomStand customStandBll   = new EyouSoft.BLL.CompanyStructure.CompanyCustomStand(); //初始化custbll
            EyouSoft.Model.CompanyStructure.CustomStand      customStandModel = null;
            //无操作方式则为获取数据
            if (method == "")
            {
                #region 初次加载数据
                if (custId != 0)
                {
                    customStandModel = customStandBll.GetModel(custId);
                    if (customStandModel != null)
                    {
                        custLevel = customStandModel.CustomStandName;
                        IsSystem  = customStandModel.IsSystem;
                    }
                    return;
                }
                #endregion
            }
            else
            {
                #region 保存
                if (custLevel == "")
                {
                    MessageBox.Show(this, "客户等级不为空!");
                }
                bool result = false;
                customStandModel = new EyouSoft.Model.CompanyStructure.CustomStand();
                customStandModel.CustomStandName = custLevel;
                customStandModel.CompanyId       = CurrentUserCompanyID;
                customStandModel.IssueTime       = DateTime.Now;
                customStandModel.IsSystem        = false;
                customStandModel.OperatorId      = 0;
                customStandModel.LevType         = EyouSoft.Model.EnumType.CompanyStructure.CustomLevType.其他;
                if (custId != 0)
                {
                    customStandModel.Id = custId;
                    result = customStandBll.Update(customStandModel);
                }
                else
                {
                    result = customStandBll.Add(customStandModel);
                }
                if (!result)
                {
                    showMess = "数据保存失败";
                }
                //继续添加则刷新页面,否则关闭当前窗口
                if (method == "continue")
                {
                    MessageBox.ShowAndRedirect(this, showMess, "CustomerLevelEdit.aspx");
                }
                else
                {
                    MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.location='/systemset/basicinfo/CustomerLevel.aspx';window.parent.Boxy.getIframeDialog('{1}').hide();", showMess, Utils.GetQueryStringValue("iframeId")));
                }
                #endregion
            }
        }
コード例 #7
0
ファイル: CompanyCustomStand.cs プロジェクト: windygu/bbl
        /// <summary>
        /// 分页获取公司客户等级集合
        /// </summary>
        /// <param name="PageSize">每页显示条数</param>
        /// <param name="PageIndex">当前页码</param>
        /// <param name="RecordCount">总记录数</param>
        /// <param name="CompanyId">公司编号</param>
        /// <returns>公司客户等级集合</returns>
        public IList <EyouSoft.Model.CompanyStructure.CustomStand> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId)
        {
            IList <EyouSoft.Model.CompanyStructure.CustomStand> totals = new List <EyouSoft.Model.CompanyStructure.CustomStand>();

            string tableName     = "tbl_CompanyCustomStand";
            string primaryKey    = "Id";
            string orderByString = "IssueTime DESC";
            string fields        = " Id,CustomStandName,LevType,CompanyId,OperatorId,IssueTime,IsSystem,IsDelete,SalerCommision,LogisticsCommision ";

            StringBuilder cmdQuery = new StringBuilder(" IsDelete='0' ");

            cmdQuery.AppendFormat(" and CompanyId='{0}' ", CompanyId);

            using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString))
            {
                while (rdr.Read())
                {
                    EyouSoft.Model.CompanyStructure.CustomStand customStandInfo = new EyouSoft.Model.CompanyStructure.CustomStand();
                    if (!rdr.IsDBNull(rdr.GetOrdinal("Id")))
                    {
                        customStandInfo.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("CustomStandName")))
                    {
                        customStandInfo.CustomStandName = rdr.GetString(rdr.GetOrdinal("CustomStandName"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("CompanyId")))
                    {
                        customStandInfo.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("OperatorId")))
                    {
                        customStandInfo.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("LevType")))
                    {
                        customStandInfo.LevType = (EyouSoft.Model.EnumType.CompanyStructure.CustomLevType) int.Parse(rdr[rdr.GetOrdinal("LevType")].ToString());
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IssueTime")))
                    {
                        customStandInfo.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IsSystem")))
                    {
                        customStandInfo.IsSystem = rdr[(rdr.GetOrdinal("IsSystem"))].ToString() == "1" ? true : false;
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("IsDelete")))
                    {
                        customStandInfo.IsDelete = rdr[rdr.GetOrdinal("IsDelete")].ToString() == "1" ? true : false;
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("SalerCommision")))
                    {
                        customStandInfo.SalerCommision = rdr.GetDecimal(rdr.GetOrdinal("SalerCommision"));
                    }
                    if (!rdr.IsDBNull(rdr.GetOrdinal("LogisticsCommision")))
                    {
                        customStandInfo.LogisticsCommision = rdr.GetDecimal(rdr.GetOrdinal("LogisticsCommision"));
                    }

                    totals.Add(customStandInfo);
                }
            }

            return(totals);
        }
コード例 #8
0
ファイル: Sale_show.aspx.cs プロジェクト: windygu/bbl
        //销售列表详细数据初始化
        private void onInit()
        {
            if (OrderID != "")
            {
                EyouSoft.BLL.TourStructure.TourOrder   TourOrderBll   = new EyouSoft.BLL.TourStructure.TourOrder();
                EyouSoft.Model.TourStructure.TourOrder TourOrderModel = TourOrderBll.GetOrderModel(CurrentUserCompanyID, OrderID);
                System.Text.StringBuilder stringPrice = new System.Text.StringBuilder();

                if (TourOrderModel != null)
                {
                    #region 结算价绑定
                    //只有散拼有报价标准,单项服务与团队计划都没有报价标准
                    if (TourOrderModel.TourClassId == EyouSoft.Model.EnumType.TourStructure.TourType.散拼计划)
                    {
                        EyouSoft.BLL.CompanyStructure.CompanyPriceStand  CompanyPriceStandBll  = new EyouSoft.BLL.CompanyStructure.CompanyPriceStand();
                        EyouSoft.BLL.CompanyStructure.CompanyCustomStand CompanyCustomStandBll = new EyouSoft.BLL.CompanyStructure.CompanyCustomStand();
                        EyouSoft.BLL.TourStructure.Tour tourBLl = new EyouSoft.BLL.TourStructure.Tour();
                        PriceList             = tourBLl.GetPriceStandards(TourOrderModel.TourId);
                        CompanyPriceStandList = CompanyPriceStandBll.GetPriceStandByCompanyId(SiteUserInfo.CompanyID);
                        CustomStandList       = CompanyCustomStandBll.GetCustomStandByCompanyId(SiteUserInfo.CompanyID);
                        for (int j = 0; j < CompanyPriceStandList.Count; j++)
                        {
                            if (j == 0)
                            {
                                stringPrice.Append("<tr><td align=\"center\">报价标准</td>");
                                for (int i = 0; i < CustomStandList.Count; i++)
                                {
                                    EyouSoft.Model.CompanyStructure.CustomStand CustomStand = CustomStandList[i];
                                    stringPrice.AppendFormat("<td><div style=\"text-align: center;\">{0}</div></td>", CustomStand.CustomStandName);
                                }
                                stringPrice.Append("</tr>");
                            }
                            EyouSoft.Model.CompanyStructure.CompanyPriceStand CompanyPriceStand = CompanyPriceStandList[j];
                            stringPrice.Append("<tr>");
                            stringPrice.AppendFormat("<td><div class=\"divPrice\" val=\"{0}\">", CompanyPriceStand.Id);
                            stringPrice.AppendFormat("<div style=\"text-align: center;\">{0}</div></td>", CompanyPriceStand.PriceStandName);
                            for (int i = 0; i < CustomStandList.Count; i++)
                            {
                                EyouSoft.Model.CompanyStructure.CustomStand CustomStand = CustomStandList[i];
                                stringPrice.Append("<td>");

                                stringPrice.AppendFormat("<input type=\"radio\" name=\"radio\" id=\"radio{0}\" value=\"{0}\" />", CustomStand.Id);
                                stringPrice.AppendFormat("成人价:<span name=\"sp_cr_price\">{0}</span>", FilterEndOfTheZeroDecimal(GetPriceBy(CompanyPriceStand.Id, CustomStand.Id, true)));
                                stringPrice.AppendFormat("儿童价:<span name=\"sp_et_price\">{0}</span>", FilterEndOfTheZeroDecimal(GetPriceBy(CompanyPriceStand.Id, CustomStand.Id, false)));
                            }
                            stringPrice.Append("</td></tr>");
                        }
                        price = stringPrice.ToString();
                    }
                    //如果该订单是团队计划订单,则不显示成人数与儿童数,显示总人数
                    else if (TourOrderModel.TourClassId == EyouSoft.Model.EnumType.TourStructure.TourType.团队计划)
                    {
                        this.SanPingPersonNum.Visible = false;
                        this.lblTeamPersonNum.Visible = true;
                        this.lblTeamPersonNum.Enabled = false;
                    }
                    PriceStandId  = TourOrderModel.PriceStandId.ToString();
                    CustomerLevId = TourOrderModel.CustomerLevId.ToString();
                    #endregion
                    #region 订单基本数据
                    //线路名称
                    this.lblLineName.Text = TourOrderModel.RouteName;
                    //出团日期
                    this.lblChuTuanDate.Text = TourOrderModel.LeaveDate.ToString("yyyy-MM-dd");
                    //当前空位
                    this.lblCurFreePosi.Text = TourOrderModel.RemainNum.ToString();
                    //出发交通
                    this.lblChuFanTra.Text = TourOrderModel.LeaveTraffic;
                    //返回交通
                    this.lblBackTra.Text = TourOrderModel.ReturnTraffic;
                    //联系人
                    this.lblContactName.Text = TourOrderModel.ContactName;
                    //电话
                    this.lblContactPhone.Text = TourOrderModel.ContactTel;
                    //手机
                    this.lblContactMobile.Text = TourOrderModel.ContactMobile;
                    //传真
                    this.lblContactFax.Text = TourOrderModel.ContactFax;
                    //特殊要求说明
                    this.txtSpecialRe.Text = TourOrderModel.SpecialContent;
                    //操作留言
                    this.txtOperMes.Text = TourOrderModel.OperatorContent;
                    //人数(成人)
                    this.txtDdultCount.Text = TourOrderModel.AdultNumber.ToString();
                    //人数(儿童)
                    this.txtChildCount.Text = TourOrderModel.ChildNumber.ToString();
                    //总金额
                    this.txtTotalMoney.Text = Utils.FilterEndOfTheZeroString(TourOrderModel.SumPrice.ToString());
                    //总人数
                    this.lblTeamPersonNum.Text = TourOrderModel.PeopleNumber.ToString();
                    if (!string.IsNullOrEmpty(TourOrderModel.CustomerFilePath))
                    {
                        this.hykCusFile.NavigateUrl = TourOrderModel.CustomerFilePath;
                        this.hykCusFile.Visible     = true;
                    }

                    ltrBuyerTourCode.Text = TourOrderModel.BuyerTourCode;
                    #endregion
                    #region 订单游客数据
                    System.Collections.Generic.IList <EyouSoft.Model.TourStructure.TourOrderCustomer> curList = TourOrderModel.CustomerList;
                    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\" 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\" id=\"cusType\" name=\"cusType\">");
                                stringBuilder.Append("<option value=\"0\">请选择</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\" id=\"cusType\" name=\"cusType\">");
                                stringBuilder.Append("<option value=\"0\">请选择</option>");
                                stringBuilder.Append("<option value=\"1\" >成人</option>");
                                stringBuilder.Append("<option value=\"2\" selected=\"selected\">儿童</option>");
                                stringBuilder.Append(" </select>");
                            }
                            //其它
                            else
                            {
                                stringBuilder.Append("<select disabled=\"disabled\" id=\"cusType\" name=\"cusType\">");
                                stringBuilder.Append("<option value=\"0\"  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("</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("</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("</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("</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("</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\" 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 id=\"cusSex\" class='ddlSex' 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 id=\"cusSex\" class='ddlSex' 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 id=\"cusSex\" class='ddlSex' 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\" 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.ToString() == "true" ? "1" : "0"));
                                stringBuilder.AppendFormat("<input id=\"spe{0}\" type=\"hidden\" name=\"specive\" value=\"{1}\" />", curList[i].ID, str);
                            }
                            else
                            {
                                stringBuilder.AppendFormat("<input id=\"spe{0}\" type=\"hidden\" name=\"specive\" value=\"\" />", curList[i].ID);
                            }
                            stringBuilder.AppendFormat("<a sign=\"speService\" href=\"javascript:void(0)\" onclick=\"OrderEdit.OpenSpecive('spe{0}',$(this))\">特服</a></td>", curList[i].ID);
                            stringBuilder.Append("</tr>");
                        }
                    }
                    cusHtml = stringBuilder.ToString();
                    #endregion

                    if (TourOrderModel.BuyerContactId > 0)
                    {
                        var buyerContactInfo = new EyouSoft.BLL.CompanyStructure.Customer().GetCustomerContactModel(TourOrderModel.BuyerContactId);
                        if (buyerContactInfo != null)
                        {
                            this.ltrBuyerContact.Text = string.Format("姓名:{0}&nbsp;&nbsp;电话:{1}&nbsp;&nbsp;手机:{2}&nbsp;&nbsp;QQ:{3}", buyerContactInfo.Name
                                                                      , buyerContactInfo.Tel
                                                                      , buyerContactInfo.Mobile
                                                                      , buyerContactInfo.qq);
                            buyerContactInfo = null;
                        }
                    }
                }

                TourOrderBll   = null;
                TourOrderModel = null;
            }
        }