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();
         }
     }
 }
Exemple #4
0
 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();
            }
        }
Exemple #6
0
        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();
                    }
                }
            }
        }