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