public ResponseICRegisterGetByUser GetByUser(RequestICRegisterGetByUser request) { var res = new ResponseICRegisterGetByUser(); using (this.cnn = this.GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); string sql = @"select * from TKS_FAS_ICRegisterOrder where create_user=@create_user order by create_date desc"; var data = cnn.Query <TKS_FAS_ICRegisterOrder>(sql, new { create_user = user.User.UserName }, ts).ToList(); ts.Commit(); res.Data = data; res.IsSuccess = true; res.Message = ""; return(res); } catch (Exception ex) { ts.Rollback(); return(this.DealException(res, ex) as ResponseICRegisterGetByUser); } } }
public ResponseICRegisterGetByUser GetByUser([FromBody] RequestICRegisterGetByUser request) { try { ICRegisterBLL bll = new ICRegisterBLL(); return(bll.GetByUser(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }