/// <summary> /// 获取列的信息 /// </summary> /// <returns></returns> public static void InitColumn(Data_Source item, bool IsLoad, string tableName) { var key = string.Format(AppEtl.CacheKey.Column, item.Host, tableName); if (RedisInfo.Exists(key, AppEtl.CacheDb) && IsLoad) { return; } var list = new List <CacheColumn>(); var dt = new DataTable(); using (var conn = DbProviderFactories.GetFactory(item.Type).CreateConnection()) { conn.ConnectionString = AppCommon.GetConnStr(item); conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = ColumnSql(item, tableName); if (cmd.CommandText == "") { return; } var rd = cmd.ExecuteReader(); dt.Load(rd); rd.Close(); } foreach (DataRow row in dt.Rows) { var column = new CacheColumn(); column.Name = (row.ItemArray[0] == DBNull.Value ? "" : row.ItemArray[0].ToString()); column.Type = row.ItemArray[1] == DBNull.Value ? "" : row.ItemArray[1].ToString(); column.Length = row.ItemArray[2] == DBNull.Value ? 0 : int.Parse(row.ItemArray[2].ToString()); column.Comments = row.ItemArray[3] == DBNull.Value ? "" : row.ItemArray[3].ToString(); column.IsKey = row.ItemArray[4].ToString() != "0" ? true : false; column.Precision = row.ItemArray[7] == DBNull.Value ? 0 : int.Parse(row.ItemArray[7].ToString()); column.ShowName = string.Format("{0}({1})", column.Name, column.Comments); list.Add(column); } RedisInfo.Set <List <CacheColumn> >(key, list, 8640, AppEtl.CacheDb); }
/// <summary> /// 表说明 /// </summary> /// <returns></returns> public static void InitTable(Data_Source item, bool IsLoad) { var key = string.Format(AppEtl.CacheKey.Table, item.Host); if (RedisInfo.Exists(key, AppEtl.CacheDb) && IsLoad) { return; } var list = new List <CacheTable>(); var dt = new DataTable(); using (var conn = DbProviderFactories.GetFactory(item.Type).CreateConnection()) { conn.ConnectionString = AppCommon.GetConnStr(item); conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = TableSql(item); if (cmd.CommandText == "") { return; } var rd = cmd.ExecuteReader(); dt.Load(rd); rd.Close(); } foreach (DataRow row in dt.Rows) { var table = new CacheTable(); table.Comments = row.ItemArray[1] == DBNull.Value ? "" : row.ItemArray[1].ToString(); table.Name = row.ItemArray[0] == DBNull.Value ? "" : row.ItemArray[0].ToString(); list.Add(table); Parallel.Invoke(() => { InitColumn(item, IsLoad, table.Name); }); } RedisInfo.Set <List <CacheTable> >(key, list, 8640, AppEtl.CacheDb); }