public async Task <ActionResult> GetInsurance() { AppFormPayService appFormPayService = new AppFormPayService(); BaseListResult <GetInsuranceOutput> result = await appFormPayService.GetInsurance(); return(this.Json(result)); }
/// <summary> /// 获取用户基本信息 好友列表等 /// </summary> /// <param name="userId"></param> /// <returns></returns> public override CommonResult GetInitInfo(long userId) { return(_storage.UseConnection <CommonResult>(connection => { string sql = @"SELECT pk_id AS id,name AS username,[sign],avatar FROM dbo.[user] WHERE pk_id=@uid SELECT pk_id AS id,name AS groupname FROM dbo.friend_group WHERE [user_id]=@uid SELECT a.pk_id AS gid,c.pk_id AS id,c.name as username,c.[sign],c.avatar FROM dbo.friend_group A INNER JOIN dbo.friend_group_detail B ON a.pk_id=B.group_id LEFT JOIN dbo.[user] C ON B.[user_id]=c.pk_id WHERE a.[user_id]=@uid SELECT b.pk_id AS id,name AS groupname,avatar FROM dbo.big_group_detail A LEFT JOIN dbo.big_group B ON A.group_id=b.pk_id WHERE [user_id]=@uid"; SqlMapper.GridReader reader = connection.QueryMultiple(sql, new { uid = userId }); var result = new BaseListResult(); result.mine = reader.ReadFirstOrDefault <UserModel>(); //处理friend逻辑 start var friend = reader.Read <FriendGroupModel>(); var groupUsers = reader.Read <GroupUserModel>(); friend.ToList().ForEach(f => { //每一组的人分配给各个组 f.list = groupUsers?.Where(x => x.gid == f.id); }); result.friend = friend; //处理friend逻辑 end //读取用户所在群 result.group = reader.Read <BigGroupModel>(); return new CommonResult { code = result.mine == null ? 1 : 0, msg = result.mine == null ? "用户不存在" : "", data = result }; })); }
private BaseListResult ToBaseListResult(DataSet ds) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count == 0) { return(new BaseListResult()); } //当前用户的信息 var rowMine = ds.Tables[0].Rows[0]; //用户组信息 var rowFriendDetails = ds.Tables[2].Rows.Cast <DataRow>().Select(x => new GroupUserEntity { id = x["uid"].ToInt(), avatar = x["avatar"].ToString(), groupid = x["gid"].ToInt(), remarkname = x["remarkname"].ToString(), username = x["nickname"].ToString(), sign = x["sign"].ToString(), //status之前的字段是为空的,现在我们把他的在线状态加上,IsOnline方法接收一个userid参数,从Redis缓存中读取该用户是否在线并返回 status = LayIMCache.Instance.IsOnline(x["uid"].ToInt()) ? "online" : "hide" }).OrderByDescending(x => x.status);//这里要根据用户是否在线这个字段排序,保证在线用户都在好友列表最上边 //用户组信息,执行分组 var friend = ds.Tables[1].Rows.Cast <DataRow>().Select(x => new FriendGroupEntity { id = x["id"].ToInt(), groupname = x["name"].ToString(), online = 0, list = rowFriendDetails.Where(f => f.groupid == x["id"].ToInt()) }); //群组信息 var group = ds.Tables[3].Rows.Cast <DataRow>().Select(x => new GroupEntity { id = x["id"].ToInt(), groupname = x["name"].ToString(), avatar = x["avatar"].ToString(), groupdesc = x["groupdesc"].ToString() }); //用户皮肤,第一个是默认正在使用的 List <string> skin = ds.Tables[4].Rows.Cast <DataRow>().Select(x => x[0].ToString()).ToList(); BaseListResult result = new BaseListResult { mine = new UserEntity { id = rowMine["id"].ToInt(), avatar = rowMine["avatar"].ToString(), sign = rowMine["sign"].ToString(), username = rowMine["nickname"].ToString(), status = "online" }, friend = friend, group = group, skin = skin }; return(result); } return(null); }
/// <summary> /// 取得往來明細清單(未繳/逾期) /// </summary> /// <param name="model">取得標的物資料(繳款紀錄) Input</param> /// <returns>取得往來明細清單(未繳/逾期) Output</returns> public async Task <BaseListResult <GetArRecLvNewOutput> > GetArLv1New(GetArRecLvInput model) { // 透過 Api 把資料送出去 string apiUrl = "V2/APP_FORM_PAY/GET_AR_LV1_NEW"; BaseListResult <GetArRecLvNewOutput> result = await ApiService.Instance.ApiGetArLv1New(model, apiUrl); return(result); }
/// <summary> /// 取得保險列表 /// </summary> /// <param name="model">取得標的物資料(繳款紀錄) Input</param> /// <returns>銀行列表 Output</returns> public async Task <BaseListResult <GetInsuranceOutput> > GetInsurance() { // 透過 Api 把資料送出去 string apiUrl = "/api/AppBack/GetInsurance"; BaseListResult <GetInsuranceOutput> result = await ApiService.Instance.ApiGetInsurance(null, apiUrl); return(result); }
/// <summary> /// 取得繳款紀錄(含已繳項目) /// </summary> /// <param name="model">取得標的物資料(繳款紀錄) Input</param> /// <returns>取得標的物資料(繳款紀錄) Output</returns> public async Task <BaseListResult <GetArRecOutput> > GetArRec(GetArRecInput model) { // 透過 Api 把資料送出去 string apiUrl = "APP_FORM_PAY/GET_AR_REC"; BaseListResult <GetArRecOutput> result = await ApiService.Instance.ApiGetArRec(model, apiUrl); return(result); }
public async Task <ActionResult> GetArRecLv1() { GetCustInfoInput cusModel = new GetCustInfoInput(); GetCustInfoOutput cusResult = new GetCustInfoOutput(); if (this.TokenVerify.Id == string.Empty) { cusModel = new GetCustInfoInput { MBR_ID = this.TokenVerify.MbrId, MbrId = this.TokenVerify.MbrId, DevId = this.TokenVerify.DevId, Token = this.TokenVerify.Token }; // 取得會員資料 HomeService homeService = new HomeService(); cusResult = await homeService.GetCustInfo(cusModel); if (cusResult.ID != string.Empty) { // 取得全資料 InitOutput initOutput = await homeService.INIT(cusResult.ID); System.Web.HttpCookie AridCookie = this.AirdCookie(cusResult.ID ?? string.Empty, this.TokenVerify.MbrId, this.TokenVerify.DevId, this.TokenVerify.Token, initOutput?.CUST_ID ?? string.Empty, initOutput?.CNTRT_NO ?? string.Empty); this.Response.Cookies.Add(AridCookie); } } GetArRecLvInput model = new GetArRecLvInput { //ID = this.TokenVerify.Id, ID = !string.IsNullOrEmpty(cusResult.ID) ? cusResult.ID : this.TokenVerify.Id, COMP_ID = this.TokenVerify.CustId, MbrId = this.TokenVerify.MbrId, DevId = this.TokenVerify.DevId, Token = this.TokenVerify.Token, SYS_ID = Common.GetSysId() }; AppFormPayService appFormPayService = new AppFormPayService(); BaseListResult <GetArRecLvOutput> result = await appFormPayService.GetArRecLv1(model); return(this.Json(result)); }
public async Task <ActionResult> GetArRec(string cntrtNo) { GetArRecInput model = new GetArRecInput { ID = this.TokenVerify.Id, CNTRT_NO = cntrtNo, COMP_ID = this.TokenVerify.CustId, MbrId = this.TokenVerify.MbrId, DevId = this.TokenVerify.DevId, Token = this.TokenVerify.Token, SYS_ID = Common.GetSysId() }; AppFormPayService appFormPayService = new AppFormPayService(); BaseListResult <GetArRecOutput> result = await appFormPayService.GetArRec(model); return(this.Json(result)); }
/// <summary> /// 取得全資料(已繳/未繳/逾期) /// </summary> /// <param name="model">取得會員資訊 Input</param> /// <returns>取得會員資訊 Output</returns> public async Task <InitOutput> INIT(string id) { // 透過 Api 把資料送出去 string apiUrl = "APP_FORM_PAY/INIT"; InitInput model = new InitInput { ID = id }; BaseListResult <InitOutput> baseListResult = await ApiService.Instance.ApiINIT(model, apiUrl); InitOutput result = new InitOutput(); if (baseListResult.Result.ReturnCode == 0 && baseListResult.Data != null) { result = baseListResult.Data.FirstOrDefault(); } return(result); }
/// <summary> /// 取得標的物資料(繳款紀錄) /// </summary> /// <param name="model">param</param> /// <param name="apiUrl">Api 路徑</param> /// <returns>result</returns> public async Task <BaseListResult <GetArRecOutput> > ApiGetArRec(GetArRecInput model, string apiUrl) { BaseListResult <GetArRecOutput> result = await this.GetApiResultAsync <BaseListResult <GetArRecOutput> >(apiUrl, model); return(result); }
/// <summary> /// 取得往來明細清單(未繳/逾期) /// </summary> /// <param name="model">param</param> /// <param name="apiUrl">Api 路徑</param> /// <returns>result</returns> public async Task <BaseListResult <GetArRecLvNewOutput> > ApiGetArLv1New(object model, string apiUrl) { BaseListResult <GetArRecLvNewOutput> result = await this.GetApiResultAsync <BaseListResult <GetArRecLvNewOutput> >(apiUrl, model); return(result); }
/// <summary> /// 取得保險列表 /// </summary> /// <param name="model">param</param> /// <param name="apiUrl">Api 路徑</param> /// <returns>result</returns> public async Task <BaseListResult <GetInsuranceOutput> > ApiGetInsurance(object model, string apiUrl) { BaseListResult <GetInsuranceOutput> result = await this.GetApiResultAsync <BaseListResult <GetInsuranceOutput> >(apiUrl, model, true); return(result); }
/// <summary> /// 取得全資料(已繳/未繳/逾期) /// </summary> /// <param name="model">param</param> /// <param name="apiUrl">Api 路徑</param> /// <returns>result</returns> public async Task <BaseListResult <InitOutput> > ApiINIT(object model, string apiUrl) { BaseListResult <InitOutput> result = await this.GetApiResultAsync <BaseListResult <InitOutput> >(apiUrl, model); return(result); }
public async Task <ActionResult> GetArLv1New() { var dataList = new List <GetArRecLvNewOutput>(); var data = new GetArRecLvNewOutput(); var ar = new ArList(); var arList = new List <ArList>(); GetArRecLvInput model = new GetArRecLvInput { ID = this.TokenVerify.Id, COMP_ID = this.TokenVerify.CustId, MbrId = this.TokenVerify.MbrId, DevId = this.TokenVerify.DevId, Token = this.TokenVerify.Token, SYS_ID = Common.GetSysId() }; AppFormPayService appFormPayService = new AppFormPayService(); BaseListResult <GetArRecLvNewOutput> result = await appFormPayService.GetArLv1New(model); foreach (var item in result.Data) { data = new GetArRecLvNewOutput(); arList = new List <ArList>(); data.IS_PROXY = item.IS_PROXY; data.PAYABLE_AMT = item.PAYABLE_AMT; data.CNTRT_NO = item.CNTRT_NO; data.OBJ_ITEMS = item.OBJ_ITEMS; data.PAYMENT_DESC = item.PAYMENT_DESC; data.AR_DT = item.AR_DT; data.AR_AMT = item.AR_AMT; data.TTL_AMT = item.TTL_AMT; data.OBJ_NAME = item.OBJ_NAME; data.VENDER_NME = item.VENDER_NME; data.BUY_DT = item.BUY_DT; data.IS_FINISH = item.IS_FINISH; foreach (var itemList in item.AR_LIST) { ar = new ArList(); ar.AR_AMT = itemList.AR_AMT; ar.AR_CNT = itemList.AR_CNT; ar.AR_DESC = itemList.AR_DESC; ar.AR_DT = itemList.AR_DT; ar.AR_ID = itemList.AR_ID; ar.AR_PAYDT = itemList.AR_PAYDT; ar.AR_PK = itemList.AR_PK; ar.ISCURRENT = itemList.ISCURRENT; ar.OVERDUE = itemList.OVERDUE; ar.PAYMENT_STATUS = itemList.PAYMENT_STATUS; if (item.IS_PROXY == "Y" && itemList.PAYMENT_STATUS == "1" && itemList.ISCURRENT == "Y") { data.PAYABLE_AMT = 0; data.AR_DT = itemList.AR_DT; } arList.Add(ar); } data.AR_LIST = arList; dataList.Add(data); } result.Data = dataList; return(this.Json(result)); }