数据库获取所有的表,所有的视图,字段说明,字段类型,字段名

//表、视图 绑定给下拉
public void BindDropName() { string sql = "Select Name FROM SysObjects Where XType='U' orDER BY Name";// DataTable dt = SqlOP.ExecuteDataset(sql).Tables[0]; DataSet dv=SqlOP.ExecuteDataset("select [name] as Name from sys.views ");//视图 foreach (DataRow dr in dv.Tables[0].Rows) { DataRow row = dt.NewRow(); row["Name"] = dr[0]; dt.Rows.Add(row);//这样就可以添加了 } DropDownList1.DataSource = dt; DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "Name"; DropDownList1.DataBind(); }

生成实体

      protected void ToEity()
        {
            string sql = "SELECT   CAST(g.value AS nvarchar)as notes,  a.name,b.name as ztype ,c.isnullable FROM     systypes b,    sys.columns AS a LEFT OUTER JOIN  sys.syscolumns AS c ON a.name = c.name AND a.object_id = c.id left join sys.extended_properties g on (a.object_id = g.major_id AND a.column_id=g.minor_id) WHERE   (a.object_id = OBJECT_ID('" + DropDownList1.SelectedValue + "'))and c.xtype=b.xusertype order by object_id,a.column_id";

            DataSet ds = SqlOP.ExecuteDataset(sql);
            string json = "using System;\n using System.Text;\n using System.Collections; \n using System.Collections.Generic;\n namespace mode \n {\n public  class  " + DropDownList1.SelectedValue + "\n{ ";

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                json += " /// <summary> \n ///   " + dr[0].ToString() + " \n /// </summary> \n public " + sqlType(dr[2].ToString(), dr[3].ToString()) + " " + dr[1].ToString() + " \n{ \n get;\n set;\n }\n";
            }
            json += "} \n}";
            txtVaule.Text = json;
        }


        protected string sqlType(string xtpye, string isnullable)
        {

            switch (xtpye)
            {
                case "uniqueidentifier":
                    if (isnullable.Equals("1"))
                    {
                        return "Guid?";
                    }
                    else
                    {
                        return "Guid";
                    }
                    break;
                case "nvarchar":
                    return "String";
                    break;
                case "varchar":
                    return "String";
                    break;
                case "sysname":
                    return "String";
                    break;
                case "text":
                    return "String";
                    break;
                case "char":
                    return "String";
                    break;
                case "int":
                    if (isnullable.Equals("1"))
                    {
                        return "Int32?";
                    }
                    else
                    {
                        return "Int32";
                    }
                    break;
                case "tinyint":
                    if (isnullable.Equals("1"))
                    {
                        return "Byte?";
                    }
                    else
                    {
                        return "Byte";
                    }
                    break;

                case "bit":
                    if (isnullable.Equals("1"))
                    {
                        return "Byte?";
                    }
                    else
                    {
                        return "Byte";
                    }
                    break;
                case "datetime":
                    if (isnullable.Equals("1"))
                    {
                        return "DateTime?";
                    }
                    else
                    {
                        return "DateTime";
                    }

                    break;

                case "float":
                    if (isnullable.Equals("1"))
                    {
                        return "Double?";
                    }
                    else
                    {
                        return "Double";
                    }

                    break;
                case "decimal":
                    if (isnullable.Equals("1"))
                    {
                        return "Decimal?";
                    }
                    else
                    {
                        return "Decimal";
                    }

                    break;
                default:
                    return "String";
                    break;
            }


        }

 

posted @ 2015-12-18 13:00  文艺流浪汉  阅读(667)  评论(0编辑  收藏  举报