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