/// <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);
}
