Example #1
0
        public void saveResource(SimpleSQLManager dbManager, ResourceResp response)
        {
            ConfigRow configRow = LoadConfig(dbManager);

            if (response.latestVersion > configRow.ResourceVersion)
            {
                dbManager.BeginTransaction();

                dbManager.Execute("UPDATE ConfigRow SET ResourceVersion = ? WHERE Id = ?", response.latestVersion, 1);

                Resource   r;
                Resource[] list = response.list;
                for (int i = 0; i < list.Length; i++)
                {
                    r = list[i];
                    dbManager.Execute("DELETE FROM ResourceRow WHERE Code = ? AND Lan = ?", r.code, r.lan);
                    dbManager.Insert(new ResourceRow
                    {
                        Code = r.code,
                        Lan  = r.lan,
                        Desc = r.desc
                    });
                }

                dbManager.Commit();
                Debug.Log(list.Length + " ResourceRow records updated.");
            }
        }
Example #2
0
        public void SaveProfile(SimpleSQLManager dbManager, LoginResp response)
        {
            dbManager.BeginTransaction();
            dbManager.Execute("DELETE FROM SessionRow WHERE Id = 1");
            SessionRow row = new SessionRow();

            row.Id       = 1;
            row.Token    = response.token;
            row.Mobile   = response.mobile;
            row.Status   = response.status;
            row.NickName = response.nickName;
            dbManager.Insert(row);
            dbManager.Commit();
        }