private void WriteUpdateDbByPrivate(int keyId) { SqlLiteHelper.ExecuteNonQuery("delete from menu_classic where id=" + keyId); if (!DicClassic.ContainsKey(keyId)) { return; } string content = ""; foreach (var t in DicClassic[keyId].Items) { content += t; content += "#"; } string strUpdateDirectroy = "insert into menu_classic(id,name,content) values"; strUpdateDirectroy += "(" + keyId + ",'" + DicClassic[keyId].Name + "','" + content + "')"; try { SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy); } catch (Exception ex) { ex.ToString(); } }
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()); } } }
private void WriteUpdateDbByPrivate() { SqlLiteHelper.ExecuteNonQuery("delete from menu_instances "); foreach (var t in DicInstances) { string strUpdateDirectroy = "insert into menu_instances(id,name,key,id_classic) values"; strUpdateDirectroy += "(" + t.Key + ",'" + t.Value.Name + "','" + t.Value.Key + "'," + t.Value.IdClassic + ")"; try { SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy); } catch (Exception ex) { ex.ToString(); } } }
private void WriteUpdateDbByPrivate() { SqlLiteHelper.ExecuteNonQuery("delete from menu_shortcuts "); foreach (var t in DicClassic) { if (string.IsNullOrEmpty(t.Value)) { continue; } string strUpdateDirectroy = "insert into menu_shortcuts(id,shortcut) values"; strUpdateDirectroy += "(" + t.Key + ",'" + t.Value + "')"; try { SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy); } catch (Exception ex) { ex.ToString(); } } }
private void WriteUpdateDbByPrivate(int id) { SqlLiteHelper.ExecuteNonQuery("delete from menu_instances where id=" + id); if (!DicInstances.ContainsKey(id)) { return; } var t = DicInstances[id]; string strUpdateDirectroy = "insert into menu_instances(id,name,key,id_classic) values"; strUpdateDirectroy += "(" + t.Id + ",'" + t.Name + "','" + t.Key + "'," + t.IdClassic + ")"; try { SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy); } catch (Exception ex) { ex.ToString(); } }
private void WriteUpdateDbByPrivate(int id) { SqlLiteHelper.ExecuteNonQuery("delete from menu_shortcuts where id=" + id); if (DicClassic.ContainsKey(id)) { var t = DicClassic[id]; if (!string.IsNullOrEmpty(t)) { string strUpdateDirectroy = "insert into menu_shortcuts(id,shortcut) values"; strUpdateDirectroy += "(" + id + ",'" + t + "')"; try { SqlLiteHelper.ExecuteNonQueryInThread(strUpdateDirectroy); } catch (Exception ex) { ex.ToString(); } } } }