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