/// <summary>
/// 从数据库中读取资源数据 ,在程序初始化的时候执行,模块内部会执行，其他地方不允许执行
/// </summary>
private void InnerLoad()
{
DicClassic.Clear();
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'menu_classic'").
Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'menu_classic' ('id' integer PRIMARY KEY,'name' text,'" +
"content' text)");
}
try
{
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from menu_classic", null);
if (ds == null)
{
return;
}
int mCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < mCount; i++)
{
try
{
// (id integer NOT NULL,tag text,name text NOT NULL,tooltips text)
int id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString().Trim());
if (id >= MenuIdControlAssign.MenuClassicIdMin &&
id <= MenuIdControlAssign.MenuClassicIdMax)
{
string name = ds.Tables[0].Rows[i]["name"].ToString().Trim();
string content = ds.Tables[0].Rows[i]["content"].ToString().Trim();
this.UpdateMneu(id, name, content);
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class SupperClassicDataHoldingExtend Function loadItem from SQLlite table menu_classic Occer an Error:" +
ex.ToString());
}
var args = new PublishEventArgs()
{
EventId =
EventIdAssign.ClassicMenuLoadUpdate,
EventType = PublishEventType.Core
};
EventPublish.PublishEvent(args);
}
