不通过model获取数据库数据

[HttpGet]
    [ActionName("getViewData")]
    public HttpResponseMessage GetView(string view_name)
    {

        HttpResponseMessage response;
        try
        {
            string sql = " IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID (N'" + view_name + "', N'V'))   SELECT * FROM " + view_name + "";
            SqlConnection sqlConn = new SqlConnection();
            sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
            SqlCommand sqlCmd = new SqlCommand(sql, sqlConn);
            SqlDataAdapter sqlAdp = new SqlDataAdapter(sqlCmd);
            DataSet ds = new DataSet();
            sqlAdp.Fill(ds);
            if ( ds.Tables.Count == 0)
            {
                var resp = new
                {
                    response = 1,
                    error = "这个视图没找到或者不存在"
                };
                response = Request.CreateResponse(HttpStatusCode.NotFound, resp);
            }
            else
            {
                DataTable dt = ds.Tables[0];
                var dept = dt.AsEnumerable()
                    .Select(r => r.Table.Columns.Cast<DataColumn>()
                            .Select(c => new KeyValuePair<string, object>(c.ColumnName, r[c.Ordinal])
                           ).ToDictionary(z => z.Key, z => z.Value)
                    ).ToList();


                var resp = new
                {
                    response = 1,
                    error = "",
                    result = dept
                };

                response = Request.CreateResponse(HttpStatusCode.OK, resp);

            }
        }
        catch (Exception ex)
        {
            var resp = new
            {
                response = 0,
                error = ex.Message

            };

            response = Request.CreateResponse(HttpStatusCode.OK, resp);
        }

        response.Headers.CacheControl = new CacheControlHeaderValue()
        {
            MaxAge = TimeSpan.FromMinutes(1)
        };
        response.Headers.Add("Access-Control-Allow-Origin", "*");
        return response;
    }
©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成,浏览时请结合常识与多方信息审慎甄别。
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

友情链接更多精彩内容