/// <summary> /// 将数据库或内存下的一张图层表以这个表名添加到MainDataSet中 /// </summary> /// <param name="tablename">表名</param> /// <param name="DataSourceType">数据源类型</param> public static void AddLayerTable(string tablename, int DataSourceType) { try { DataTable table = new DataTable(); switch (DataSourceType) { case 0: //数据库数据源 table = DB_Service.GetTable(tablename, "select * from " + tablename); break; case 1: //内存数据源 if (tablename == "PositionTable") { //定位信息表 table = DataTableFactory_Service.MakePositionTable(tablename); } else { //地图文字表 table = DataTableFactory_Service.MakeMapTextTable(tablename); } break; } //添加到MainDataSet DB_Service.MainDataSet.Tables.Add(table); } catch (Exception e) { throw e; } }
/// <summary> /// 初始化全局数据库缓存MainDataSet /// </summary> public static void InitMainDataSet() { try { if (MainDataSet == null) { MainDataSet = new DataSet("MainDataSet"); ////添加 系统表(数据库) MainDataSet.Tables.Add(GetTable("CardTable", "Select * from CardTable")); MainDataSet.Tables.Add(GetTable("CardTypeTable", "Select * from CardTypeTable")); MainDataSet.Tables.Add(GetTable("ClassTable", "Select * from ClassTable")); MainDataSet.Tables.Add(GetTable("DepartmentTable", "Select * from DepartmentTable")); MainDataSet.Tables.Add(GetTable("LayerSortTable", "Select * from LayerSortTable order by ViewOrder ASC")); MainDataSet.Tables.Add(GetTable("LayerTable", "Select * from LayerTable order by ViewOrder ASC")); MainDataSet.Tables.Add(GetTable("MapTable", "Select * from MapTable")); MainDataSet.Tables.Add(GetTable("MapAreaTable", "Select * from MapAreaTable")); MainDataSet.Tables.Add(GetTable("PersonTable", "Select * from PersonTable")); MainDataSet.Tables.Add(GetTable("UserTable", "Select * from UserTable")); MainDataSet.Tables.Add(GetTable("WorkTypeTable", "Select * from WorkTypeTable")); MainDataSet.Tables.Add(GetTable("WPTable", "Select * from WPTable")); MainDataSet.Tables.Add(GetTable("CollectChannelTable", "Select * from CollectChannelTable")); ////添加 系统表(内存库) MainDataSet.Tables.Add(DataTableFactory_Service.MakeCollectChannelValueTable("CollectChannelValueTable")); } } catch (Exception e) { MainDataSet = null; throw new Exception("数据库初始化失败。\n\n" + e.Message); } }