public async Task <JsonResult <ExtensionInformation> > GetExtensionInformation(int MemberID) { //获取补充信息 ExtensionInformation model = await _memberService.GetExtensionInformation(MemberID); return(new JsonResult <ExtensionInformation> { status = true, Message = "获取成功", Data = model }); }
/// <summary> /// 获取补充信息 /// </summary> /// <param name="MemberID"></param> /// <returns></returns> public async Task <ExtensionInformation> GetExtensionInformation(int MemberID) { string sql = "select TrueName," + " CertificateType,CertificateNo," + " PoliticalStatus,Education,Birthday," + " Sex,Address,Phone,Email,QQ,Alipay," + " BankCardNo,BankAccount,UserAccount," + " SecondContact,SecondContactPhone,InsuranceArea," + " HouseholdType from Members " + $" where MemberID={MemberID}"; ExtensionInformation model = await DbHelper.QuerySingleAsync <ExtensionInformation>(sql); return(model); }