/// <summary> /// 获取可操作的账套列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseOPAccountListGet WX_GetAccountList(RequestOPAccountListGet request) { ResponseOPAccountListGet response = new ResponseOPAccountListGet(); using (cnn = this.GetConnection()) { var ts = cnn.BeginTransaction(); try { //var user = this.UserInfoGetButAccount(request.Token, ts); var user = this.UserInfoGet(request.Token, ts); List <TKS_FAS_AccountInfoExt> data = new List <TKS_FAS_AccountInfoExt>(); string sql = string.Empty; sql = @"SELECT b.* FROM TKS_FAS_Account2User a INNER JOIN TKS_FAS_AccountInfo b ON a.AccountId = b.Id WHERE a.UserId = @UserId"; data = cnn.Query <TKS_FAS_AccountInfoExt>(sql, new { UserId = user.User.Id }, ts).ToList(); sql = @"select * from TKS_FAS_UserCurrentAccount where userid=@UserId"; var curAccount = cnn.Query <TKS_FAS_UserCurrentAccount>(sql, new { UserId = user.User.Id }, ts).ToList(); if (curAccount.Count() == 0 && data.Count() > 0) { data[0].Active = 0; //TKS_FAS_MonthPeriodInfo period = GetActivePeriod(data[0].Id, ts); response.IsSelected = false; //response.Year = period.Year; //response.Month = period.Month; } else if (curAccount.Count() > 0) { for (int i = 0; i < data.Count(); i++) { if (data[i].Id == curAccount[0].AccountId) { data[i].Active = 1; //var period = GetActivePeriod(data[i].Id, ts); response.IsSelected = true; //response.Year = period.Year; //response.Month = period.Month; break; } } } ts.Commit(); response.IsSuccess = true; response.Data = data; //response.SelectAccount = data.Where(x => x.Active == 1).FirstOrDefault(); //response.UserCreditCode = user.Node.CreditCode; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseOPAccountListGet); } } }
public ResponseOPAccountListGet OPAccountListGet([FromBody] RequestOPAccountListGet request) { try { AccountSetBLL bll = new AccountSetBLL(); return(bll.OPAccountListGet(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }