private void ClientGiftPurchase(int iGiftPrice)
{
ClientInfoBusiness ClientRemainPoints = new ClientInfoBusiness();
ClientInfoEntity ClientInfo = new ClientInfoEntity();
ClientInfo = ClientRemainPoints.GetClientInfoByID(long.Parse(Session["UsersID"].ToString()));
if ((long)iGiftPrice - (long)ClientInfo.lclientPoints < 0)
{
GiftTradeBusiness GiftTrade = new GiftTradeBusiness();
GiftTrade.ClientGiftPurchase(long.Parse(Request.QueryString["GiftID"].ToString()), long.Parse(Session["UsersID"].ToString()));
int iReturnValue = ClientRemainPoints.ClientGiftPurchaseByPoints(iGiftPrice, long.Parse(Session["UsersID"].ToString()));
if (iReturnValue > 0)
{
Response.Write("<script>alert('感谢您的兑换！')</script>");
}
else
{
Response.Write("<script>alert('程序出错，兑换失败！')</script>");
}
}
else
{
Response.Write("<script>alert('您的剩余积分不足!')</script>");
}
}
public HttpResponseMessage AddClientInfo([FromBody] ClientInfoEntity clientinfo)
{
if (clientinfo != null)
{
var entity = new ClientInfoEntity
{
Clientname = clientinfo.Clientname,
Houses = clientinfo.Houses,
Housetype = clientinfo.Housetype,
Note = clientinfo.Note,
Phone = clientinfo.Phone,
Uptime = DateTime.Now,
Addtime = DateTime.Now,
Adduser = clientinfo.Adduser,
Upuser = clientinfo.Upuser
};
try
{
if (_clientInfoService.Create(entity) != null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(true, "数据添加成功！")));
}
}
catch
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据添加失败！")));
}
}
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误！")));
}
public ClientInfoEntity GetClientInfoByID(long lClientID)//展示客户全部信息方法
{
string sSQLText = "select * from ClientInfo where ClientID='" + lClientID + "'";
DataTable dataTable = DAL.DataBaseAccess.GetDataSet(sSQLText); //得到多值
ClientInfoEntity ClientInfo = new ClientInfoEntity(); //实体化Entity层的ClientInfoEntity
if (dataTable.Rows.Count > 0)
{
ClientInfo.lclientID = long.Parse("" + dataTable.Rows[0][0]);
ClientInfo.sclientPassword = "" + dataTable.Rows[0][1];
ClientInfo.sclientName = "" + dataTable.Rows[0][2];
ClientInfo.sclientSex = "" + dataTable.Rows[0][3];
ClientInfo.iclientAge = int.Parse("" + dataTable.Rows[0][4]);
ClientInfo.sclientEmail = "" + dataTable.Rows[0][5];
ClientInfo.lclientPhoneNumber = long.Parse("" + dataTable.Rows[0][6]);
ClientInfo.lclientDepositingMoney = long.Parse("" + dataTable.Rows[0][7]);
ClientInfo.lclientWallet = long.Parse("" + dataTable.Rows[0][8]);
ClientInfo.lclientTotalDepositedMoney = long.Parse("" + dataTable.Rows[0][9]);
ClientInfo.sclientImage = "" + dataTable.Rows[0][10];
ClientInfo.sclientAddress = "" + dataTable.Rows[0][11];
ClientInfo.lclientPoints = long.Parse("" + dataTable.Rows[0][12]);
ClientInfo.iclientLevel = int.Parse("" + dataTable.Rows[0][13]);
}
return(ClientInfo);
}
public int ClientInfoRegister(ClientInfoEntity ClientInfo)//客户信息注册方法
{
string sSQLText = "insert into ClientInfo values('" + ClientInfo.lclientID + "','" + ClientInfo.sclientPassword + "','" + ClientInfo.sclientName + "','" + ClientInfo.sclientSex + "','" + ClientInfo.iclientAge + "','" + ClientInfo.sclientEmail + "','" + ClientInfo.lclientPhoneNumber + "','" + ClientInfo.lclientDepositingMoney + "','" + ClientInfo.lclientWallet + "','" + ClientInfo.lclientTotalDepositedMoney + "','" + ClientInfo.sclientImage + "','" + ClientInfo.sclientAddress + "','" + ClientInfo.lclientPoints + "','" + ClientInfo.iclientLevel + "')";
int iReturnedValue = DAL.DataBaseAccess.ExecuteSql(sSQLText);
return(iReturnedValue);
}
public ClientInfoEntity GetByID(int id)
{
ClientInfoEntity resultClient = null;
var clients = from ClientInfoEntity c in _mockClients where c.ClientInfoID == id select c;
if (clients != null && clients.Count() > 0)
{
resultClient = clients.FirstOrDefault();
}
return(resultClient);
}
public ClientInfoEntity Update(ClientInfoEntity entity)
{
try
{
_clientinfoRepository.Update(entity);
return(entity);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(null);
}
}
public bool Delete(ClientInfoEntity entity)
{
try
{
_clientinfoRepository.Delete(entity);
return(true);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(false);
}
}
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 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>");
}
}
}
}
public HttpResponseMessage Add([FromBody] BrokerRECClientModel brokerrecclient)
{
if (brokerrecclient.Adduser == 0)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "经济人ID不能为空！")));
}
if (brokerrecclient.Broker == 0)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "经纪人ID不能为空")));
}
if (string.IsNullOrEmpty(brokerrecclient.Clientname))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "客户名不能为空")));
}
if (string.IsNullOrEmpty(brokerrecclient.Phone))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "客户电话不能为空！")));
}
//查询客户信息
var sech = new BrokerRECClientSearchCondition
{
Clientname = brokerrecclient.Clientname,
Phone = brokerrecclient.Phone,
Projectids = new[] { brokerrecclient.Projectid },
DelFlag = EnumDelFlag.默认
};
var cmodel = _brokerRecClientService.GetBrokerRECClientsByCondition(sech);
//检测客户是否存在于数据库
if (!cmodel.Any())
{
//客户信息
var client = new ClientInfoEntity
{
Clientname = brokerrecclient.Clientname,
Phone = brokerrecclient.Phone.ToString(CultureInfo.InvariantCulture),
Housetype = brokerrecclient.HouseType,
Houses = brokerrecclient.Houses,
Note = brokerrecclient.Note,
Adduser = brokerrecclient.Broker,
Addtime = DateTime.Now,
Upuser = brokerrecclient.Broker,
Uptime = DateTime.Now
};
_clientInfoService.Create(client);
}
else
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "该客户正在被推荐！")));
}
//查询客户信息
var sech2 = new ClientInfoSearchCondition
{
Clientname = brokerrecclient.Clientname,
Phone = brokerrecclient.Phone.ToString(CultureInfo.InvariantCulture),
};
var cmodel2 = _clientInfoService.GetClientInfosByCondition(sech2).FirstOrDefault();
//查询经纪人信息
var broker = _brokerService.GetBrokerByUserId(brokerrecclient.Adduser);
//创建推荐流程
var model = new BrokerRECClientEntity();
model.Broker = _brokerService.GetBrokerById(brokerrecclient.Adduser);
model.ClientInfo = cmodel2;
model.Clientname = brokerrecclient.Clientname;
//model.Qq = Convert.ToInt32(brokerrecclient.Qq);
model.Phone = brokerrecclient.Phone; //客户电话
model.Brokername = broker.Brokername;
model.Brokerlevel = broker.Level.Name;
model.Broker = broker;
model.Adduser = brokerrecclient.Adduser;
model.Addtime = DateTime.Now;
model.Upuser = brokerrecclient.Adduser;
model.Uptime = DateTime.Now;
model.Projectid = brokerrecclient.Projectid;
model.Projectname = brokerrecclient.Projectname;
model.Status = EnumBRECCType.审核中;
model.DelFlag = EnumDelFlag.默认;
model.RecOrder = (int)EnumOrderType.推荐订单;
_brokerRecClientService.Create(model);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "提交成功")));
}
private void ClientInfoDisplayPage()
{
/**
* 展示客户的一些信息
*/
int iClientAge;
int iClientDepositingMoney;
long lClientID = long.Parse(Session["UsersID"].ToString()); //接收Login页面传来的Session
ClientInfoBusiness ClientInfoBusiness = new ClientInfoBusiness(); //实体化BLL层中的ClientInfoBusiness类
ClientInfoEntity ClientInfoEntity = new ClientInfoEntity();
if (!IsPostBack)
{
ClientInfoEntity = ClientInfoBusiness.GetClientInfoByID(lClientID);
if (ClientInfoEntity.sclientSex == "男")
{
LBLClientSexPolitely.Text = "先生";
}
else
{
LBLClientSexPolitely.Text = "女士";
}
LBLClientID.Text = ClientInfoEntity.lclientID.ToString();
TBClientPassword.Text = ClientInfoEntity.sclientPassword;
LBLClientNameGreeting.Text = ClientInfoEntity.sclientName;
TBClientName.Text = ClientInfoEntity.sclientName;
if (ClientInfoEntity.sclientSex == "男")
{
RBMale.Checked = true;
}
else
{
RBFemale.Checked = true;
}
for (iClientAge = 18; iClientAge < 126; iClientAge++)//绑定18~120岁
{
DDLClientAge.Items.Add(iClientAge.ToString());
}
DDLClientAge.SelectedValue = ClientInfoEntity.iclientAge.ToString();
TBClientEmail.Text = ClientInfoEntity.sclientEmail;
TBClientPhoneNumber.Text = ClientInfoEntity.lclientPhoneNumber.ToString();
for (iClientDepositingMoney = 0; iClientDepositingMoney < 101; iClientDepositingMoney += 5)//绑定1~x万元
{
DDLClientDepositingMoney.Items.Add(iClientDepositingMoney.ToString());
}
LBLClientWallet.Text = ClientInfoEntity.lclientWallet.ToString();
IMGClientImage.ImageUrl = ClientInfoEntity.sclientImage;
TBClientAddress.Text = ClientInfoEntity.sclientAddress;
LBLClientPoints.Text = ClientInfoEntity.lclientPoints.ToString();
LBLClientLevel.Text = ClientInfoEntity.iclientLevel.ToString();
for (int iWantedOfferMoney = 5; iWantedOfferMoney < 101; iWantedOfferMoney += 5) //绑定1~x万元
{ //悬赏金额
DDLWantedOfferMoney.Items.Add(iWantedOfferMoney.ToString());
}
}
}
