public async Task <ActionResult> InfoChange(InfoChangeViewModel viewModel) { ExtensionInformationParameter model = new ExtensionInformationParameter(); viewModel.CopyTo(model); if (ModelState.IsValid) { bool flag = await _memberService.ModifyMemberExtensionInformation(model); assignMessage(flag ? "保存成功" : "保存失败", flag); #region 日志记录 if (flag == true) { LogService.WriteLogInfo(new Log { UserName = HttpContext.User.Identity.Name, Contents = string.Format("修改了用户{0}信息", (await _memberService.GetMemberInfo(model.MemberID)).MemberName) }); } #endregion } buildSelectList(viewModel); return(View(viewModel)); }
public async Task <JsonResult <dynamic> > CommitExtensionInformation(ExtensionInformationParameter model) { //int MemberID = Convert.ToInt32(HttpContext.Current.Request.Form["MemberID"]); bool flag = await _memberService.ModifyMemberExtensionInformation(model); return(new JsonResult <dynamic> { status = flag, Message = flag ? "补充信息成功" : "补充信息失败" }); }
public async Task <ActionResult> InfoChange() { ExtensionInformationParameter model = await _memberService.GetMemberExtensionInformation(CommonHelper.CurrentUser.MemberID); InfoChangeViewModel viewModel = new InfoChangeViewModel(); model.CopyTo(viewModel); //获取下拉列表的数据 buildSelectList(viewModel); return(View(viewModel)); }
/// <summary> /// 获取补充信息 /// </summary> /// <param name="MemberID"></param> /// <returns></returns> public async Task <ExtensionInformationParameter> GetMemberExtensionInformation(int MemberID) { string sql = "select MemberID, TrueName," + " CertificateType,CertificateNo," + " PoliticalStatus,Education,Birthday," + " Sex,Address,Phone,Email,QQ,Alipay," + " BankCardNo,BankAccount,UserAccount," + " SecondContact,SecondContactPhone,InsuranceArea," + " HouseholdType from Members " + $" where MemberID={MemberID}"; ExtensionInformationParameter model = await DbHelper.QuerySingleAsync <ExtensionInformationParameter>(sql); return(model); }
public async Task <ActionResult> EditMemberExtensionInformation(ExtensionInformationParameter model) { model.HouseholdType = EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)Convert.ToInt32(model.HouseholdType)); bool flag = await _memberService.ModifyMemberExtensionInformation(model); TempData["Message"] = flag ? "保存成功" : "保存失败"; #region 日志记录 if (flag == true) { LogService.WriteLogInfo(new Log { UserName = HttpContext.User.Identity.Name, Contents = string.Format("修改了用户{0}信息", (await _memberService.GetMemberInfo(model.MemberID)).MemberName) }); } #endregion return(RedirectToAction("GetMemberList")); }
/// <summary> /// 更新会员补充信息 /// </summary> /// <param name="MemberID"></param> /// <param name="model"></param> /// <returns></returns> public async Task <bool> ModifyMemberExtensionInformation(ExtensionInformationParameter model) { string sql = "update Members set TrueName=@TrueName," + " CertificateType=@CertificateType,CertificateNo=@CertificateNo," + " PoliticalStatus=@PoliticalStatus,Education=@Education,Birthday=@Birthday," + " Sex=@Sex,Address=@Address,Phone=@Phone,Email=@Email,QQ=@QQ,Alipay=@Alipay," + " BankCardNo=@BankCardNo,BankAccount=@BankAccount,UserAccount=@UserAccount," + " SecondContact=@SecondContact,SecondContactPhone=@SecondContactPhone,InsuranceArea=@InsuranceArea," + " HouseholdType=@HouseholdType,IsComplete= 1 " + " where MemberID=@MemberID"; DbParameter[] parameters = new DbParameter[] { new SqlParameter("@TrueName", model.TrueName ?? ""), new SqlParameter("@CertificateType", model.CertificateType ?? ""), new SqlParameter("@CertificateNo", model.CertificateNo ?? ""), new SqlParameter("@PoliticalStatus", model.PoliticalStatus ?? ""), new SqlParameter("@Education", model.Education ?? ""), new SqlParameter("@Birthday", model.Birthday ?? (object)DBNull.Value), new SqlParameter("@Sex", model.Sex ?? ""), new SqlParameter("@Address", model.Address ?? ""), new SqlParameter("@Phone", model.Phone ?? ""), new SqlParameter("@Email", model.Email ?? ""), new SqlParameter("@QQ", model.QQ ?? ""), new SqlParameter("@Alipay", model.Alipay ?? ""), new SqlParameter("@BankCardNo", model.BankCardNo ?? ""), new SqlParameter("@BankAccount", model.BankAccount ?? ""), new SqlParameter("@UserAccount", model.UserAccount ?? ""), new SqlParameter("@SecondContact", model.SecondContact ?? ""), new SqlParameter("@SecondContactPhone", model.SecondContactPhone ?? ""), new SqlParameter("@InsuranceArea", model.InsuranceArea ?? ""), new SqlParameter("@HouseholdType", model.HouseholdType ?? ""), new SqlParameter("@MemberID", model.MemberID) }; int result = await DbHelper.ExecuteSqlCommandAsync(sql, parameters); return(result > 0); }
public async Task <ActionResult> EditMemberExtensionInformation(int MemberID, int type) { ExtensionInformationParameter model = await _memberService.GetMemberExtensionInformation(MemberID); #region 证件类型 var CertificateTypeList = new List <string> { "请选择" }.Concat(GetCertificateType()).Select( item => new SelectListItem { Text = item, Value = item == "请选择" ? "" : item, Selected = item == model.CertificateType }).ToList(); //ViewData["CertificateType"] = new SelectList(CertificateTypeList, "Value", "Text"); ViewBag.CertificateType = new SelectList(CertificateTypeList, "Value", "Text"); #endregion #region 政治面貌 var PoliticalStatusList = new List <string> { "请选择" }.Concat(GetPoliticalStatus()).Select( item => new SelectListItem { Text = item, Value = item == "请选择" ? "" : item }).ToList(); ViewData["PoliticalStatus"] = new SelectList(PoliticalStatusList, "Value", "Text", model.PoliticalStatus); #endregion #region 学历 var EducationList = new List <string> { "请选择" }.Concat(GetEducation()).Select( item => new SelectListItem { Text = item, Value = item == "请选择" ? "" : item }).ToList(); ViewData["Education"] = new SelectList(EducationList, "Value", "Text", model.Education); #endregion #region 户口性质 List <SelectListItem> UserTypeList = EnumExt.GetSelectList(typeof(HouseholdPropertyEnum)); UserTypeList.Insert(0, new SelectListItem { Text = "请选择", Value = "" }); int householdType = 0; foreach (var item in UserTypeList) { if (item.Text == model.HouseholdType) { householdType = Convert.ToInt32(item.Value); break; } } model.HouseholdType = householdType.ToString(); ViewData["HouseholdType"] = new SelectList(UserTypeList, "Value", "Text"); #endregion if (type == 1) { ViewData["SocialSecurityList"] = _socialSecurityService.GetSocialSecurityList(MemberID); ViewData["AccumulationFundList"] = _accumulationFundService.GetAccumulationFundList(MemberID); } return(View(model)); }