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