Exemple #1
0
        int ISync.SyncData()
        {
            int count = 0;

            Init();

            SyncHelper syncHelper;

            foreach (DataRow dr in Global.sync_tb.Rows)
            {
                string table_name = dr["表名"].ToString();
                string key_field  = dr["主键"].ToString();
                int    sync_type  = dr["同步方式"].ToInt32();

                if (string.IsNullOrEmpty(table_name) || string.IsNullOrEmpty(key_field) || table_name.Contains("*"))
                {
                    continue;
                }

                syncHelper = new SyncHelper(table_name, key_field, sync_type);

                if (SyncHelper.IsSync(table_name))
                {
                    count += syncHelper.SyncDataOfTmp();
                }
                SyncHelper.SyncIntervalAddLess(table_name);
            }


            return(count);
        }
Exemple #2
0
        SyncResult ISync.SyncDataBackResult()
        {
            SyncResult    result = new SyncResult();
            StringBuilder sb     = new StringBuilder();

            Init();
            SyncHelper syncHelper;

            foreach (DataRow dr in Global.sync_tb.Rows)
            {
                string table_name = dr["表名"].ToString();
                string key_field  = dr["主键"].ToString();
                int    sync_type  = dr["同步方式"].ToInt32();

                if (string.IsNullOrEmpty(table_name) || string.IsNullOrEmpty(key_field) || table_name.Contains("*"))
                {
                    continue;
                }

                syncHelper = new SyncHelper(table_name, key_field, sync_type);

                if (SyncHelper.IsSync(table_name))
                {
                    int count = syncHelper.SyncDataOfTmp();

                    if (dr != Global.sync_tb.Rows[Global.sync_tb.Rows.Count - 1])
                    {
                        sb.AppendLine("* " + String.Format("{0,-31}", table_name) + " | " + String.Format("{0,-30}", count) + " *");
                    }
                    else
                    {
                        sb.Append("* " + String.Format("{0,-31}", table_name) + " | " + String.Format("{0,-30}", count) + " *");
                    }
                }

                SyncHelper.SyncIntervalAddLess(table_name);
            }

            result.flag    = true;
            result.Message = sb.ToString();
            return(result);
        }