コード例 #1
0
 public IActionResult GetMobileDB([FromBody] GetMobileDbModel model)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest());
     }
     return(Ok(repo.GetMobileDB(model)));
 }
コード例 #2
0
        public List <OutMobileDbModel> GetMobileDB(GetMobileDbModel input)
        {
            var res = new List <OutMobileDbModel>();

            using (IDbConnection db = new SqlConnection(Global.Connection))
            {
                res = db.Query <OutMobileDbModel>("sp_GetMobileDB", new
                {
                    AppCode    = input.AppCode,
                    tablename  = input.TableName,
                    CodeMobile = input.CodeMobile,
                },
                                                  commandType: CommandType.StoredProcedure).ToList();
            }
            return(res);
        }