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);
}
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();
}
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;
}
}
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();
}
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>");
}
}
}
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());
}
}
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);
}
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;
}
}
}
