/// <summary> /// 获取表字段 /// </summary> /// <param name="tableName"></param> /// <returns></returns> public IList <KingTop.Model.SysManage.TableInfo> GetFields(string tableName) { IList <KingTop.Model.SysManage.TableInfo> Fields = new List <KingTop.Model.SysManage.TableInfo>(); string Sql = "select top 1 * from " + tableName + " where 1=0"; IDataReader rd = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, Sql, null); for (int i = 0; i < rd.FieldCount; i++) { string fdnm = rd.GetName(i); KingTop.Model.SysManage.TableInfo model = new KingTop.Model.SysManage.TableInfo(); model.TableName = fdnm; model.TableDescription = fdnm; model.TableType = rd.GetDataTypeName(i); Fields.Add(model); } if (rd.IsClosed == false) { rd.Close(); } return(Fields); }
/// <summary> /// 数据源的数据表 /// </summary> /// <returns></returns> public IList <Model.SysManage.TableInfo> GetDbTable() { IList <Model.SysManage.TableInfo> ltb = new List <Model.SysManage.TableInfo>(); SqlConnection sc = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction); sc.Open(); DataTable dt = sc.GetSchema("Tables"); DataView dv = new DataView(dt); dv.Sort = "TABLE_NAME"; //按表名排序 foreach (DataRow dr in dv.ToTable().Rows) { if (dr.ItemArray[3].ToString() == "BASE TABLE") { Model.SysManage.TableInfo model = new KingTop.Model.SysManage.TableInfo(); model.TableName = dr[2].ToString(); model.TableDescription = dr[2].ToString(); model.TableType = ""; ltb.Add(model); } } return(ltb); }