Пример #1
0
        public int CounsellorInfoRegister(CounsellorInfoEntity CounsellorInfo)//律师信息注册方法
        {
            string sSQLText       = "insert into CounsellorInfo values('" + CounsellorInfo.lcounsellorID + "','" + CounsellorInfo.scounsellorPassword + "','" + CounsellorInfo.scounsellorName + "','" + CounsellorInfo.scounsellorSex + "','" + CounsellorInfo.icounsellorAge + "','" + CounsellorInfo.scounsellorEmail + "','" + CounsellorInfo.lcounsellorPhoneNumber + "','" + CounsellorInfo.scounsellorImage + "','" + CounsellorInfo.scounsellorSelfIntroduction + "','" + CounsellorInfo.lcounsellorWallet + "','" + CounsellorInfo.icounsellorLevel + "','" + CounsellorInfo.lcounsellorOfferMoney + "','" + CounsellorInfo.sacounsellorAdvantageField[0] + "','" + CounsellorInfo.sacounsellorAdvantageField[1] + "','" + CounsellorInfo.sacounsellorAdvantageField[2] + "','" + CounsellorInfo.sacounsellorAdvantageField[3] + "','" + CounsellorInfo.sacounsellorAdvantageField[4] + "','" + CounsellorInfo.sacounsellorAdvantageField[5] + "','" + CounsellorInfo.sacounsellorAdvantageField[6] + "','" + CounsellorInfo.sacounsellorAdvantageField[7] + "')";
            int    iReturnedValue = DAL.DataBaseAccess.ExecuteSql(sSQLText);

            return(iReturnedValue);
        }
Пример #2
0
        public CounsellorInfoEntity GetCounsellorInfoByID(long lCounsellorID)//展示律师全部信息方法
        {
            string               sSQLText       = "select * from CounsellorInfo where CounsellorID='" + lCounsellorID + "'";
            DataTable            dataTable      = DAL.DataBaseAccess.GetDataSet(sSQLText);//返回多值
            CounsellorInfoEntity CounsellorInfo = new CounsellorInfoEntity();

            if (dataTable.Rows.Count > 0)
            {
                CounsellorInfo.lcounsellorID               = long.Parse("" + dataTable.Rows[0][0]);
                CounsellorInfo.scounsellorPassword         = "" + dataTable.Rows[0][1];
                CounsellorInfo.scounsellorName             = "" + dataTable.Rows[0][2];
                CounsellorInfo.scounsellorSex              = "" + dataTable.Rows[0][3];
                CounsellorInfo.icounsellorAge              = int.Parse("" + dataTable.Rows[0][4]);
                CounsellorInfo.scounsellorEmail            = "" + dataTable.Rows[0][5];
                CounsellorInfo.lcounsellorPhoneNumber      = long.Parse("" + dataTable.Rows[0][6]);
                CounsellorInfo.scounsellorImage            = "" + dataTable.Rows[0][7];
                CounsellorInfo.scounsellorSelfIntroduction = "" + dataTable.Rows[0][8];
                CounsellorInfo.lcounsellorWallet           = long.Parse("" + dataTable.Rows[0][9]);
                CounsellorInfo.icounsellorLevel            = int.Parse("" + dataTable.Rows[0][10]);
                CounsellorInfo.lcounsellorOfferMoney       = long.Parse("" + dataTable.Rows[0][11]);
                for (int iCounter = 12; iCounter < 20; iCounter++)
                {
                    CounsellorInfo.sacounsellorAdvantageField[iCounter - 12] = "" + dataTable.Rows[0][iCounter];
                }
            }
            return(CounsellorInfo);
        }
    private void CounsellorInfoDisplayPage()
    {
        long lCounsellorID = long.Parse(Request.QueryString["CounsellorID"].ToString());
        CounsellorInfoBusiness CounsellorInfoBusiness = new CounsellorInfoBusiness();//实体化BLL层中的CounsellorInfoBusiness类
        CounsellorInfoEntity   CounsellorInfoDetails  = new CounsellorInfoEntity();

        CounsellorInfoDetails = CounsellorInfoBusiness.GetCounsellorResumeInfoByID(lCounsellorID);

        IMGCounsellorImage.ImageUrl        = CounsellorInfoDetails.scounsellorImage;
        LBLCounsellorName.Text             = CounsellorInfoDetails.scounsellorName;
        LBLCounsellorSex.Text              = CounsellorInfoDetails.scounsellorSex;
        LBLCounsellorAge.Text              = CounsellorInfoDetails.icounsellorAge.ToString();
        LBLCounsellorEmail.Text            = CounsellorInfoDetails.scounsellorEmail;
        LBLCounsellorPhoneNumber.Text      = CounsellorInfoDetails.lcounsellorPhoneNumber.ToString();
        LBLCounsellorSelfIntroduction.Text = CounsellorInfoDetails.scounsellorSelfIntroduction;
        LBLCounsellorWallet.Text           = CounsellorInfoDetails.lcounsellorWallet.ToString();

        string[] saCounsellorAdvantageFields = new string[8];
        saCounsellorAdvantageFields = CounsellorInfoDetails.sacounsellorAdvantageField;

        StringBuilder CounsellorAdvantageFields = new StringBuilder();

        for (int iCounter = 0; iCounter < 8; iCounter++)
        {
            CounsellorAdvantageFields.Append(saCounsellorAdvantageFields[iCounter] + ",");
        }

        string sCounsellorAdvantageFields = CounsellorAdvantageFields.ToString();

        LBLCounsellorAdvantageFields.Text = sCounsellorAdvantageFields;

        long lBoardMemberSequenceID = long.Parse(Session["UsersID"].ToString());
        BoardInfoBusiness BoardInfo = new BoardInfoBusiness();

        int iJudgementValue = (int)BoardInfo.ApplySelectionJudgement(lBoardMemberSequenceID);

        if (iJudgementValue > 0)
        {
            LBLVote.Text      = "您已投票!";
            BTNAgree.Visible  = false;
            BTNRefuse.Visible = false;
        }
        else
        {
            LBLVote.Visible = false;
        }
        long lBoardApplyID;

        lBoardApplyID = BoardInfo.GetBoardApplyIDByCounsellorID(lCounsellorID);

        BoardInfoBusiness GetResultAmount = new BoardInfoBusiness();//显示投票数

        LBLAgreeCount.Text  = GetResultAmount.BoardApplyAgreeAmount(lBoardApplyID).ToString();
        LBLRefuseCount.Text = GetResultAmount.BoardApplyRefuseAmount(lBoardApplyID).ToString();
    }
Пример #4
0
        public CounsellorInfoEntity GetBoardPersonInfoByCounsellorID(long lBoardMemberSequenceID)//通过董事会成员ID展示董事会成员姓名与性别方法
        {
            string               sSQLText  = "select CounsellorName,CounsellorSex from CounsellorInfo where CounsellorID=(select BoardMemberIDfromCounsellor from BoardInfo where BoardMemberSequenceID ='" + lBoardMemberSequenceID + "')";
            DataTable            dataTable = DAL.DataBaseAccess.GetDataSet(sSQLText);
            CounsellorInfoEntity BoardMemberPersonalInfo = new CounsellorInfoEntity();

            if (dataTable.Rows.Count > 0)
            {
                BoardMemberPersonalInfo.scounsellorName = "" + dataTable.Rows[0][0];
                BoardMemberPersonalInfo.scounsellorSex  = "" + dataTable.Rows[0][1];
            }
            return(BoardMemberPersonalInfo);
        }
    private void BoardMemberInfoDefaultDisplay()
    {
        LBLFounderCode.Visible = false;
        long lBoardSequenceID = long.Parse(Session["BoardMemberID"].ToString());

        //LBLBoardGreetings.Text=
        BoardInfoBusiness    BoardMemberPersonalInfoDisplay = new BoardInfoBusiness();
        CounsellorInfoEntity BoardMemberPersonalInfo        = new CounsellorInfoEntity();

        BoardMemberPersonalInfo = BoardMemberPersonalInfoDisplay.GetBoardPersonInfoByCounsellorID(lBoardSequenceID);
        LBLBoardMemberName.Text = BoardMemberPersonalInfo.scounsellorName;
        if (BoardMemberPersonalInfo.scounsellorSex == "男")
        {
            LBLBoardMemberSex.Text = "先生";
        }
        else if (BoardMemberPersonalInfo.scounsellorSex == "女")
        {
            LBLBoardMemberSex.Text = "女生";
        }
        else
        {
            LBLBoardMemberSex.Text = BoardMemberPersonalInfo.scounsellorSex;
        }

        BoardInfoBusiness BoardInfo = new BoardInfoBusiness();
        long lBoardID = BoardInfo.GetBoardMemberIDBySequence(lBoardSequenceID);

        BoardInfoEntity BoardMemberInfo = new BoardInfoEntity();

        BoardMemberInfo         = BoardInfo.GetBoardInfoBySequenceID(lBoardSequenceID);
        LBLBoardSecretKEY.Text  = BoardMemberInfo.boardSecretKey;
        LBLBoardSequenceID.Text = BoardMemberInfo.boadrMemberSequenceID.ToString();
        if (!IsPostBack)
        {
            TBBoardPassword.Text = BoardMemberInfo.boardMemberLoginPassword;
        }


        if (lBoardID % 100 != 67)
        {
            LBLFounderCode.Visible = true;
            LBLFounderCode.Text    = "欢迎您,创始人" + lBoardID.ToString();
        }
        else
        {
            LBLBoardSequenceID.Visible = false;
        }
    }
Пример #6
0
    private void CounsellorDetailInfoDisplay()
    {
        long lUsersID = long.Parse(Session["UsersID"].ToString());

        if (lUsersID == 0 || lUsersID % 100 == 67)
        {
            BTNEstablishContract.Visible = false;
        }

        long lCounsellorID = long.Parse(Request.QueryString["CounsellorID"].ToString());
        //long lCounsellorID = 2020110619480567;//测试用

        CounsellorInfoBusiness CounsellorInfoBusiness = new CounsellorInfoBusiness();//实体化BLL层中的CounsellorInfoBusiness类
        CounsellorInfoEntity   CounsellorInfoEntity   = new CounsellorInfoEntity();
        ContractInfoBusiness   ContractInfo           = new ContractInfoBusiness();

        //最上面的信息
        CounsellorInfoEntity         = CounsellorInfoBusiness.GetCounsellorInfoByID(lCounsellorID);
        LBLCounsellorName.Text       = CounsellorInfoEntity.scounsellorName;
        LBLCounsellorLevel.Text      = CounsellorInfoEntity.icounsellorLevel.ToString();
        IMGCounsellorImage.ImageUrl  = CounsellorInfoEntity.scounsellorImage.ToString();
        LBLCounsellorTips.Text       = CounsellorInfoEntity.scounsellorSelfIntroduction.ToString();
        LBLCounsellorOfferMoney.Text = CounsellorInfoEntity.lcounsellorOfferMoney.ToString();

        //第一页信息
        LBLCounsellorNamePage1.Text      = CounsellorInfoEntity.scounsellorName;
        LBLCounsellorSex.Text            = CounsellorInfoEntity.scounsellorSex;
        LBLCounsellorContractAmount.Text = ((int)ContractInfo.CounsellorContractAmount(lCounsellorID)).ToString();
        //第三页信息

        for (int iCounter = 0; iCounter < CounsellorInfoEntity.sacounsellorAdvantageField.Length; iCounter++)
        {
            //循环给Label赋值
            Label LBLCounsellorAdvantageFields = (Label)this.Master.FindControl("ContentPlaceHolder1").FindControl("LBLCounsellorAdvantageField" + iCounter);
            if (CounsellorInfoEntity.sacounsellorAdvantageField[iCounter] == "待定")
            {
                LBLCounsellorAdvantageFields.Visible = false;
            }
            else
            {
                LBLCounsellorAdvantageFields.Text = CounsellorInfoEntity.sacounsellorAdvantageField[iCounter];
            }
        }
        //第四页的信息
        LBLCounsellorPhoneNumber.Text = CounsellorInfoEntity.lcounsellorPhoneNumber.ToString();
    }
Пример #7
0
    protected void BTNEstablishContract_Click(object sender, EventArgs e)
    {
        long lClientID = long.Parse(Session["UsersID"].ToString());
        ClientInfoBusiness GetClientWallet = new ClientInfoBusiness();
        ClientInfoEntity   ClientWallet    = new ClientInfoEntity();

        ClientWallet = GetClientWallet.GetClientInfoByID(lClientID);


        long lCounsellorID = long.Parse(Request.QueryString["CounsellorID"].ToString());
        CounsellorInfoBusiness CounsellorInfoBusiness = new CounsellorInfoBusiness();//实体化BLL层中的CounsellorInfoBusiness类
        CounsellorInfoEntity   CounsellorInfoEntity   = new CounsellorInfoEntity();

        CounsellorInfoEntity = CounsellorInfoBusiness.GetCounsellorInfoByID(lCounsellorID);

        ContractInfoBusiness ContractEstablish = new ContractInfoBusiness();

        int iCounsellorContractExistDetect = int.Parse(ContractEstablish.CounsellorContractExistDetect(lClientID).ToString());

        if (iCounsellorContractExistDetect > 0)
        {
            Response.Write("<script>alert('您已经与该律师签约!')</script>");
        }
        else
        {
            if (ClientWallet.lclientWallet >= CounsellorInfoEntity.lcounsellorOfferMoney)
            {
                int iContractJudegementValue   = ContractEstablish.ContractEstablish(lCounsellorID, lClientID);
                int iClientJudegementValue     = GetClientWallet.ClientWalletMoneyUpdate(CounsellorInfoEntity.lcounsellorOfferMoney, lClientID);
                int iCounsellorJudegementValue = CounsellorInfoBusiness.CounsellorWalletMoneyUpdate(lCounsellorID, CounsellorInfoEntity.lcounsellorOfferMoney);
                if (iContractJudegementValue > 0 && iClientJudegementValue > 0 && iCounsellorJudegementValue > 0)
                {
                    Response.Write("<script>alert('您已经成功签约!')</script>");
                }
                else
                {
                    Response.Write("<script>alert('签约失败!')</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('您的余额不足以签约!')</script>");
            }
        }
    }
Пример #8
0
    private void ArticleInfoDisplay(long lArticleID)
    {
        //获得文章信息
        ArticleInfoBusiness GetArticleInfoByArticleID = new ArticleInfoBusiness();
        ArticleInfoEntity   ArticleInfo = new ArticleInfoEntity();

        ArticleInfo                    = GetArticleInfoByArticleID.GetArticleInfoByID(lArticleID);
        LBLArticleTitle.Text           = ArticleInfo.sarticleTitle;
        LBLArticleReadCountNumber.Text = ArticleInfo.iarticleReadCount.ToString();
        LBLArticleLikedCount.Text      = ArticleInfo.iarticleLikedCount.ToString();
        LBLArticleDislikedCount.Text   = ArticleInfo.iarticleDislikedCount.ToString();
        LBLArticleContent.Text         = ArticleInfo.sarticleContent;

        //获得作者信息
        CounsellorInfoBusiness GetArticleAutherInfo = new CounsellorInfoBusiness();
        CounsellorInfoEntity   ArticleAutherInfo    = new CounsellorInfoEntity();

        long lAuthorID = ArticleInfo.larticleAutherID;

        if (lAuthorID == 0L)
        {
            BTNArticleDisliked.Visible      = false;
            LBLArticleDisliked.Visible      = false;
            LBLArticleDislikedCount.Visible = false;
            IMGArticleAuthorImage.Visible   = false;
            LBLAuthorName.Text          = "管理员";
            LBAutherInfoDetails.Visible = false;
            LBLAuthorTips.Text          = "此文章由管理员发布";
        }
        else
        {
            ArticleAutherInfo              = GetArticleAutherInfo.GetCounsellorInfoByID(lAuthorID);
            LBLAuthorName.Text             = ArticleAutherInfo.scounsellorName;
            IMGArticleAuthorImage.ImageUrl = ArticleAutherInfo.scounsellorImage;
            LBLAuthorTips.Text             = ArticleAutherInfo.scounsellorSelfIntroduction;
        }
    }
    private string QuestionFieldRandom()
    {
        //递归实现问题领域的随机选取
        long lCounsellorID = long.Parse(Session["UsersID"].ToString());
        CounsellorInfoBusiness CounsellorInfoBusiness = new CounsellorInfoBusiness();//实体化BLL层中的CounsellorInfoBusiness类
        CounsellorInfoEntity   CounsellorInfoEntity   = new CounsellorInfoEntity();

        CounsellorInfoEntity = CounsellorInfoBusiness.GetCounsellorInfoByID(lCounsellorID);
        string[] saCounsellorAdvantageFields = new string[8];

        for (int iCounter = 0; iCounter < saCounsellorAdvantageFields.Length; iCounter++)
        {
            saCounsellorAdvantageFields[iCounter] = CounsellorInfoEntity.sacounsellorAdvantageField[iCounter];
        }//将获取的擅长领域加入到本方法内的数组

        Random RandomQuestionID           = new Random();
        int    iIndex                     = RandomQuestionID.Next(saCounsellorAdvantageFields.Length);
        int    iQuestionFieldExistCounter = 0;
        string sQuestionFieldRandom       = saCounsellorAdvantageFields[iIndex].ToString();

        string[] sQuestionFields = { "刑法·贪污贿赂问题", "刑事诉讼法", "民法·合同问题", "民法·知识产权", "婚姻继承问题", "民法·侵权责任问题", "民法·抵押担保问题", "刑法·盗窃罪共犯问题" };
        for (int iCounter = 0; iCounter < 8; iCounter++)
        {
            if (sQuestionFieldRandom == sQuestionFields[iCounter])
            {
                iQuestionFieldExistCounter++;
            }
        }
        if (iQuestionFieldExistCounter > 0)
        {
            return(sQuestionFieldRandom);
        }
        else
        {
            return(QuestionFieldRandom());
        }
    }
Пример #10
0
        public CounsellorInfoEntity GetCounsellorResumeInfoByID(long lCounsellorID)//展示律师全部信息方法
        {
            string               sSQLText       = "select CounsellorInfo.CounsellorID,CounsellorImage,CounsellorName,CounsellorSex,CounsellorAge,CounsellorEmail,CounsellorPhoneNumber,CounsellorSelfIntroduction,CounsellorWallet,CounsellorAdvantageField1,CounsellorAdvantageField2,CounsellorAdvantageField3,CounsellorAdvantageField4,CounsellorAdvantageField5,CounsellorAdvantageField6,CounsellorAdvantageField7,CounsellorAdvantageField8 from BoardApplyInfo,CounsellorInfo where BoardApplyInfo.CounsellorID=CounsellorInfo.CounsellorID and CounsellorInfo.CounsellorID='" + lCounsellorID + "'";
            DataTable            dataTable      = DAL.DataBaseAccess.GetDataSet(sSQLText);//返回多值
            CounsellorInfoEntity CounsellorInfo = new CounsellorInfoEntity();

            if (dataTable.Rows.Count > 0)
            {
                CounsellorInfo.lcounsellorID               = long.Parse("" + dataTable.Rows[0][0]);
                CounsellorInfo.scounsellorImage            = "" + dataTable.Rows[0][1];
                CounsellorInfo.scounsellorName             = "" + dataTable.Rows[0][2];
                CounsellorInfo.scounsellorSex              = "" + dataTable.Rows[0][3];
                CounsellorInfo.icounsellorAge              = int.Parse("" + dataTable.Rows[0][4]);
                CounsellorInfo.scounsellorEmail            = "" + dataTable.Rows[0][5];
                CounsellorInfo.lcounsellorPhoneNumber      = long.Parse("" + dataTable.Rows[0][6]);
                CounsellorInfo.scounsellorSelfIntroduction = "" + dataTable.Rows[0][7];
                CounsellorInfo.lcounsellorWallet           = long.Parse("" + dataTable.Rows[0][8]);
                for (int iCounter = 9; iCounter < 17; iCounter++)
                {
                    CounsellorInfo.sacounsellorAdvantageField[iCounter - 9] = "" + dataTable.Rows[0][iCounter];
                }
            }
            return(CounsellorInfo);
        }
Пример #11
0
    private void UsersInfoInsert()
    {
        long   UserID       = long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss"));//用户ID的设置
        string UserPassword = TBUserPassword.Text;

        if (RBClientSelected.Checked == true)
        {
            long lClientPhoneNumber = long.Parse(TBUserPhoneNumber.Text);
            ClientInfoBusiness ClientExistJudgement = new ClientInfoBusiness();
            int iClientExitsJudgement = (int)ClientExistJudgement.ClientExistJudgementByClientPhoneNumber(lClientPhoneNumber);
            if (iClientExitsJudgement == 0)
            {
                ClientInfoEntity ClientInfo = new ClientInfoEntity();              //实例化Entity层客户的信息
                ClientInfo.lclientID       = long.Parse(UserID.ToString() + "99"); //客户ID详细设置
                ClientInfo.sclientPassword = TBUserPassword.Text;
                ClientInfo.sclientName     = TBUserName.Text;
                if (RBUserMale.Checked == true)
                {
                    ClientInfo.sclientSex = "男";
                }
                else if (RBUserFemale.Checked == true)
                {
                    ClientInfo.sclientSex = "女";
                }
                else
                {
                    Response.Write("<script>alert('请务必选择性别!')</script>");
                }

                ClientInfo.iclientAge                 = int.Parse(DDLUserAge.SelectedValue);
                ClientInfo.sclientEmail               = TBUserEmail.Text;
                ClientInfo.lclientPhoneNumber         = long.Parse(TBUserPhoneNumber.Text);
                ClientInfo.lclientDepositingMoney     = long.Parse(DDLClientDepositingMoney.SelectedValue) * 10000;
                ClientInfo.lclientWallet              = 0;
                ClientInfo.lclientTotalDepositedMoney = 0;

                IMGUserImageUpLoad();
                ClientInfo.sclientImage = "WebImages/ClientImages/" + this.sFullyUsersUploadImagePathAndName;

                ClientInfo.sclientAddress = TBClientAddress.Text;
                ClientInfo.lclientPoints  = 0;
                ClientInfo.iclientLevel   = 1;
                ClientInfoBusiness ClientRegister = new ClientInfoBusiness();
                int iResultJudgement = ClientRegister.ClientInfoRegister(ClientInfo);
                if (iResultJudgement > 0)
                {
                    Session["UsersID"] = long.Parse(UserID.ToString() + "99");
                    Response.Redirect("~/03ClientPersonalCentre.aspx");
                }
                else
                {
                    Response.Write("<script>alert('抱歉,未成功注册!')</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('该手机号已注册!')</script>");
            }
        }
        else if (RBCounsellorSelected.Checked == true)
        {
            CounsellorInfoBusiness CounsellorExistInfo = new CounsellorInfoBusiness();
            BlackListInfoBusiness  BlackListExistInfo  = new BlackListInfoBusiness();
            if ((int)CounsellorExistInfo.CounsellorExistJudgementByCounsellorPhoneNumber(long.Parse(TBUserPhoneNumber.Text)) != 0)
            {
                Response.Write("<script>alert('抱歉,该手机号已注册')</script>");
            }
            else if ((int)BlackListExistInfo.BlackListExist(long.Parse(TBUserPhoneNumber.Text), TBUserEmail.Text) > 0)
            {
                Response.Write("<script>alert('由于您的违规行为,不可注册!')</script>");
            }
            else
            {
                CounsellorInfoEntity CounsellorInfo = new CounsellorInfoEntity();

                CounsellorInfo.lcounsellorID       = long.Parse(UserID.ToString() + "67");
                CounsellorInfo.scounsellorPassword = TBUserPassword.Text;
                CounsellorInfo.scounsellorName     = TBUserName.Text;
                if (RBUserMale.Checked == true)
                {
                    CounsellorInfo.scounsellorSex = "男";
                }
                else
                {
                    CounsellorInfo.scounsellorSex = "女";
                }
                CounsellorInfo.icounsellorAge         = int.Parse(DDLUserAge.SelectedValue);
                CounsellorInfo.scounsellorEmail       = TBUserEmail.Text;
                CounsellorInfo.lcounsellorPhoneNumber = long.Parse(TBUserPhoneNumber.Text);
                IMGUserImageUpLoad();
                CounsellorInfo.scounsellorImage            = "WebImages/CounsellorImages/" + this.sFullyUsersUploadImagePathAndName;
                CounsellorInfo.scounsellorSelfIntroduction = TBCounsellorSelfIntroduction.Text;
                CounsellorInfo.lcounsellorWallet           = 0;
                CounsellorInfo.icounsellorLevel            = 0;
                CounsellorInfo.lcounsellorOfferMoney       = 0;
                CounsellorInfo.sacounsellorAdvantageField  = CounsellorAdvantageFieldsInfo();

                CounsellorInfoBusiness CounsellorInfoRegister = new CounsellorInfoBusiness();

                int iResultJudgement = CounsellorInfoRegister.CounsellorInfoRegister(CounsellorInfo);
                if (iResultJudgement > 0)
                {
                    Session["UsersID"] = long.Parse(UserID.ToString() + "67");
                    Response.Redirect("~/03CounsellorPersonalCentre.aspx");
                }
                else
                {
                    Response.Write("<script>alert('抱歉,未成功注册!')</script>");
                }
            }
        }
    }
    private void CounsellorInfoDisplayPage()
    {
        string[] saDefaultCounsellorAdvantageFields = { "刑法·盗窃罪共犯问题", "刑法·贪污贿赂问题", "刑事诉讼法", "民法·合同问题", "民法·知识产权", "婚姻继承问题", "民法·侵权责任问题", "民法·抵押担保问题" };//默认全部擅长领域
        int      iCounsellorAge;
        long     lCounsellorID = long.Parse(Session["UsersID"].ToString());

        LBLBoardSequenceID.Visible = false;
        LBLBoardPassword.Visible   = false;


        CounsellorInfoBusiness CounsellorInfoBusiness = new CounsellorInfoBusiness();//实体化BLL层中的CounsellorInfoBusiness类
        CounsellorInfoEntity   CounsellorInfoEntity   = new CounsellorInfoEntity();

        if (!IsPostBack)
        {
            CounsellorInfoEntity = CounsellorInfoBusiness.GetCounsellorInfoByID(lCounsellorID);
            string[] saCounsellorAdvantageFields = new string[8];
            IMGCounsellorImageDisplay.ImageUrl = CounsellorInfoEntity.scounsellorImage;
            LBLCounsellorName.Text             = CounsellorInfoEntity.scounsellorName;
            LBLCounsellorID.Text      = CounsellorInfoEntity.lcounsellorID.ToString();
            TBCounsellorPassword.Text = CounsellorInfoEntity.scounsellorPassword.ToString();
            TBCounsellorName.Text     = CounsellorInfoEntity.scounsellorName;
            if (CounsellorInfoEntity.scounsellorSex == "男")
            {
                RBMale.Checked = true;
            }
            else
            {
                RBFemale.Checked = true;
            }
            for (iCounsellorAge = 18; iCounsellorAge < 126; iCounsellorAge++)
            {
                DDLCounsellorAge.Items.Add(iCounsellorAge.ToString());
            }
            DDLCounsellorAge.SelectedValue = CounsellorInfoEntity.icounsellorAge.ToString();
            TBCounsellorEmail.Text         = CounsellorInfoEntity.scounsellorEmail;
            TBCounsellorPhoneNumber.Text   = CounsellorInfoEntity.lcounsellorPhoneNumber.ToString();
            IMGCounsellorImage.ImageUrl    = CounsellorInfoEntity.scounsellorImage;
            LBLCounsellorWallet.Text       = CounsellorInfoEntity.lcounsellorWallet.ToString();
            LBLCounsellorLevel.Text        = CounsellorInfoEntity.icounsellorLevel.ToString();
            for (int iCounter = 0; iCounter < saCounsellorAdvantageFields.Length; iCounter++)
            {
                saCounsellorAdvantageFields[iCounter] = CounsellorInfoEntity.sacounsellorAdvantageField[iCounter];
            }
            CounsellorAdvantageFieldsBonding(saCounsellorAdvantageFields, saDefaultCounsellorAdvantageFields);

            QuestionInfoDisplay(CounsellorInfoEntity.icounsellorLevel);//第三页等级提升的相关信息


            BoardInfoBusiness BoardInfo        = new BoardInfoBusiness();
            int iCounsellorApplyExistJudgement = (int)BoardInfo.CounsellorApplyExistJudgement(lCounsellorID);
            int iBoardExistJudgement           = (int)BoardInfo.BoardExistJudgement(lCounsellorID);

            if (CounsellorInfoEntity.icounsellorLevel != 3)
            {
                LBLBoardAccessAlert.Text    = "请提升您的等级,以获取准入资格!";
                BTNBoardAccessApply.Visible = false;
            }
            else if (iBoardExistJudgement > 0)
            {
                BTNBoardAccessApply.Visible = false;

                LBLBoardAccessAlert.Text = "申请已通过!请借助如下信息以登录董事会";
                BoardInfoEntity BoardInfoEntity = new BoardInfoEntity();
                BoardInfoEntity            = BoardInfo.GetBoardInfoByCounsellorID(lCounsellorID);
                LBLBoardSequenceID.Visible = true;
                LBLBoardSequenceID.Text    = "您的董事会账号为:" + BoardInfoEntity.boadrMemberSequenceID.ToString();
                if (BoardInfoEntity.boardMemberLoginPassword == "password")
                {
                    LBLBoardPassword.Visible = true;
                    LBLBoardPassword.Text    = "初始密码为:" + BoardInfoEntity.boardMemberLoginPassword + ",请务必更改密码";
                }
            }
            else if (iCounsellorApplyExistJudgement > 0)
            {
                LBLBoardAccessAlert.Text    = "您已申请加入董事会,请耐心等待结果!!";
                BTNBoardAccessApply.Visible = false;
            }
            else
            {
                LBLBoardAccessAlert.Text = "您的能力通过审核!请点击下方按钮以申请加入董事会";
            }
        }

        //差评警告系统
        double dBlackListAlert;
        double dCounsellorArticleLikedAmount         = 0;
        double dCounsellorArticleDislikedAmount      = 0;
        double dCounsellorRespondLikedCountAmount    = 0;
        double dCounsellorRespondDislikedCountAmount = 0;

        if (CounsellorInfoBusiness.CounsellorArticleLikedAmount(lCounsellorID).ToString() == "" || CounsellorInfoBusiness.CounsellorArticleDislikedAmount(lCounsellorID).ToString() == "" || CounsellorInfoBusiness.CounsellorRespondLikedCountAmount(lCounsellorID).ToString() == "" || CounsellorInfoBusiness.CounsellorRespondDislikedCountAmount(lCounsellorID).ToString() == "")
        {
            LBLBlackListAlert.Visible = false;
        }
        else
        {
            dCounsellorArticleLikedAmount         = double.Parse(CounsellorInfoBusiness.CounsellorArticleLikedAmount(lCounsellorID).ToString());
            dCounsellorArticleDislikedAmount      = double.Parse(CounsellorInfoBusiness.CounsellorArticleDislikedAmount(lCounsellorID).ToString());
            dCounsellorRespondLikedCountAmount    = double.Parse(CounsellorInfoBusiness.CounsellorRespondLikedCountAmount(lCounsellorID).ToString());
            dCounsellorRespondDislikedCountAmount = double.Parse(CounsellorInfoBusiness.CounsellorRespondDislikedCountAmount(lCounsellorID).ToString());
            if (dCounsellorArticleDislikedAmount + dCounsellorRespondDislikedCountAmount > 500)
            {
                dBlackListAlert = (dCounsellorArticleLikedAmount + dCounsellorRespondLikedCountAmount) / (dCounsellorArticleDislikedAmount + dCounsellorRespondDislikedCountAmount);
                if (dBlackListAlert < 1)
                {
                    LBLBlackListAlert.Text = "警告!您的差评比过低!";
                }
                else
                {
                    LBLBlackListAlert.Visible = false;
                }
            }
            else
            {
                LBLBlackListAlert.Visible = false;
            }
        }
    }