/// <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);
}
private void WriteUpdateDbByPrivate(int instancesId)
{
//menu_instances_relation id(father_id,id,sort_index,name,instances_id)
SqlLiteHelper.ExecuteNonQuery("delete from menu_instances_relation where instances_id=" + instancesId);
if (!DicInstanceRelation.ContainsKey(instancesId))
{
return;
}
foreach (var t in DicInstanceRelation[instancesId])
{
try
{
string strUpdateDirectroy =
"insert into menu_instances_relation(father_id,id,sort_index,name,instances_id) values";
strUpdateDirectroy += "(" + t.Value.FatherId + "," + t.Value.Id + "," + t.Value.SortIndex + ",'" +
t.Value.Name + "'," + t.Value.InstancesId + ")";
SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy);
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuInstanceRelationHoldingExtend Function WriteUpdateDbByPrivate from SQLlite table menu_instances_relation Occer an Error:" +
ex.ToString());
}
}
}
/// <summary>
/// 从数据库中读取资源数据
/// 在程序初始化的时候执行
/// </summary>
private void InnerLoad()
{
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'menu_shortcuts'").
Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'menu_shortcuts' ('id' integer PRIMARY KEY,'shortcut' text)");
}
try
{
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from menu_shortcuts", 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());
string shortcut = ds.Tables[0].Rows[i]["shortcut"].ToString().Trim();
this.AddShortCut(id, shortcut);
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuShortCutsHoldingExtend Function loadItem from SQLlite table menu_shortcuts Occer an Error:" +
ex.ToString());
}
var args = new PublishEventArgs()
{
EventId =
EventIdAssign.MenuShourtCutsLoadUpdate,
EventType = PublishEventType.Core
};
EventPublish.PublishEvent(args);
}
private void GetValueFromDb()
{
try
{
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'login_setting'")
.Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'login_setting' ('key' text, 'value' text)");
}
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from login_setting", null);
if (ds == null)
{
return;
}
int mCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < mCount; i++)
{
try
{
string key = ds.Tables[0].Rows[i]["key"].ToString().Trim();
string value = ds.Tables[0].Rows[i]["value"].ToString().Trim();
UpdateKeyVaule(key, value);
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError("Class login GetValueFromDb has an Error:" + ex.ToString());
}
}
private void LoadBase()
{
TreeItems.Clear();
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'menu_instances_relation'").
Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'menu_instances_relation' ('father_id' integer,'id' integer,'sort_index' integer,'name' text,'" +
"instances_id' integer)");
}
try
{
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from menu_instances_relation", 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 fatherId = Convert.ToInt32(ds.Tables[0].Rows[i]["father_id"].ToString().Trim());
int id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString().Trim());
if ((id >= MenuIdControlAssign.MenuFileGroupIdMin &&
id <= MenuIdControlAssign.MenuFileGroupIdMax) ||
(id >= MenuIdControlAssign.MenuIdMin &&
id <= MenuIdControlAssign.MenuIdMax))
{
int sortIndex = Convert.ToInt32(ds.Tables[0].Rows[i]["sort_index"].ToString().Trim());
string name = ds.Tables[0].Rows[i]["name"].ToString().Trim();
int instancesId = Convert.ToInt32(ds.Tables[0].Rows[i]["instances_id"].ToString().Trim());
if (instancesId == 2920022) //moban weizhi
{
if (fatherId == 0)
{
if (!DicType.ContainsKey(id))
{
DicType.Add(id, name);
}
else
{
DicType[id] = name;
}
}
else
{
if (DicType.ContainsKey(fatherId))
{
TreeItems.Add(new TreeItemViewMode()
{
Id = id,
Name = name,
IsChecked = false,
Description = DicType[fatherId],
FatherId = fatherId
});
}
}
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuInstanceRelationHoldingExtend Function loadItem from SQLlite table menu_instances_relation Occer an Error:" +
ex.ToString());
}
var args = new PublishEventArgs()
{
EventId =
EventIdAssign.MenuInstanceRelationLoadUpdate,
EventType = PublishEventType.Core
};
EventPublish.PublishEvent(args);
//var lst = new List<MenuInstancesRelation>();
//foreach (var f in TreeItems)
// lst.Add(new MenuInstancesRelation()
// {
// FatherId = f.FatherId,
// Id = f.Id,
// InstancesId = 2920022,
// Name = f.Name,
// SortIndex =0,
// });
//ServerInstanceRelation.UpdateMenuInstanceRelation(2920022, "MainMenuMa", lst);
}
private void LoadNow()
{
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'menu_instances_relation'").
Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'menu_instances_relation' ('father_id' integer,'id' integer,'sort_index' integer,'name' text,'" +
"instances_id' integer)");
}
try
{
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from menu_instances_relation", null);
if (ds == null)
{
return;
}
int mCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < mCount; i++)
{
try
{
int fatherId = Convert.ToInt32(ds.Tables[0].Rows[i]["father_id"].ToString().Trim());
int id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString().Trim());
if ((id >= MenuIdControlAssign.MenuFileGroupIdMin &&
id <= MenuIdControlAssign.MenuFileGroupIdMax) ||
(id >= MenuIdControlAssign.MenuIdMin &&
id <= MenuIdControlAssign.MenuIdMax))
{
int sortIndex = Convert.ToInt32(ds.Tables[0].Rows[i]["sort_index"].ToString().Trim());
string name = ds.Tables[0].Rows[i]["name"].ToString().Trim();
int instancesId = Convert.ToInt32(ds.Tables[0].Rows[i]["instances_id"].ToString().Trim());
if (instancesId == 2920002)
{
foreach (var t in TreeItems)
{
if (t.Id == id && t.FatherId == fatherId)
{
t.IsChecked = true;
break;
}
}
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuInstanceRelationHoldingExtend Function loadItem from SQLlite table menu_instances_relation Occer an Error:" +
ex.ToString());
}
var args = new PublishEventArgs()
{
EventId =
EventIdAssign.MenuInstanceRelationLoadUpdate,
EventType = PublishEventType.Core
};
EventPublish.PublishEvent(args);
}
/// <summary>
/// 从数据库中读取资源数据
/// 在程序初始化的时候执行
/// </summary>
private void InnerLoad()
{
DicInstanceRelation.Clear();
var ssss = Convert.ToInt32(SqlLiteHelper.ExecuteQuery(
"SELECT COUNT(*) as count FROM sqlite_master WHERE type='table' and name= 'menu_instances_relation'").
Tables[0].Rows[0][0].ToString().Trim());
if (ssss < 1)
{
SqlLiteHelper.ExecuteQuery(
"CREATE TABLE 'menu_instances_relation' ('father_id' integer,'id' integer,'sort_index' integer,'name' text,'" +
"instances_id' integer)");
}
try
{
DataSet ds = SqlLiteHelper.ExecuteQuery("select * from menu_instances_relation", 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 fatherId = Convert.ToInt32(ds.Tables[0].Rows[i]["father_id"].ToString().Trim());
int id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString().Trim());
if ((id >= MenuIdControlAssign.MenuFileGroupIdMin &&
id <= MenuIdControlAssign.MenuFileGroupIdMax) ||
(id >= MenuIdControlAssign.MenuIdMin &&
id <= MenuIdControlAssign.MenuIdMax))
{
int sortIndex = Convert.ToInt32(ds.Tables[0].Rows[i]["sort_index"].ToString().Trim());
string name = ds.Tables[0].Rows[i]["name"].ToString().Trim();
int instancesId = Convert.ToInt32(ds.Tables[0].Rows[i]["instances_id"].ToString().Trim());
this.UpdateMenuInstanceRelation(fatherId, id, sortIndex, name, instancesId);
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(ex.ToString());
}
}
}
catch (Exception ex)
{
WriteLog.WriteLogError(
"Class MenuInstanceRelationHoldingExtend Function loadItem from SQLlite table menu_instances_relation Occer an Error:" +
ex.ToString());
}
var args = new PublishEventArgs()
{
EventId =
EventIdAssign.MenuInstanceRelationLoadUpdate,
EventType = PublishEventType.Core
};
EventPublish.PublishEvent(args);
}
