Beispiel #1
0
        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);
                }
            }
        }
Beispiel #2
0
 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));
     }
 }