public ResponseKSPZTPLsGet KSPZCheckTPLsGet([FromBody] RequestKSPZTPLsGet request) { try { KSPZBLL bll = new KSPZBLL(); return(bll.KSPZTPLsGet(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
/// <summary> /// 获取快速凭证模板 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseKSPZTPLsGet KSPZTPLsGet(RequestKSPZTPLsGet request) { var res = new ResponseKSPZTPLsGet(); using (cnn = this.GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGet(request.Token, ts); AccountSetBLL accountBll = new AccountSetBLL(cnn); var period = accountBll.GetActivePeriod(user.AccountId, ts); //获取期末检查模板 是否已经生成凭证 //update by Hero.Zhang 按照原始模板查询 string sql = @"select A.*,0 as IsGenPZ from TKS_FAS_DocTPL A where A.tplTarget=1 and A.isCustom=0 and a.AccountId='-' "; var data = cnn.Query <TKS_FAS_DocTPLExt>(sql, new { AccountId = user.AccountId, //账套 PeriodId = period.Id //当前 期间 }, ts).ToList(); res.IsSuccess = true; res.Data = data; res.Message = ""; return(res); } catch (Exception ex) { ts.Rollback(); return(this.DealException(res, ex) as ResponseKSPZTPLsGet); } } }