GameFramework.DataDML.BatchSaveTableMailStateInfo C# (CSharp) Method

        private static int BatchSaveTableMailStateInfo(List<bool> validList, List<byte[]> dataList, int dataVersion)
        {
            if (dataList.Count <= 0) {
              return 0;
            }
            StringBuilder sbSql = new StringBuilder("insert into TableMailStateInfo ", 4096);
            sbSql.Append("(IsValid,DataVersion,MailGuid,UserGuid,IsRead,IsReceived,IsDeleted,ExpiryDate)");
            sbSql.Append(" values ");
            for (int i = 0; i < validList.Count; ++i) {
              Byte valid = 1;
              if (validList[i] == false) {
                valid = 0;
              }
              StringBuilder sbValue = new StringBuilder();
              sbValue.AppendFormat("({0},{1}", valid, dataVersion);
              object _msg;
              if (DbDataSerializer.Decode(dataList[i], typeof(TableMailStateInfo), out _msg)) {
                TableMailStateInfo msg = _msg as TableMailStateInfo;
                sbValue.Append(',');
                sbValue.AppendFormat("'{0}'", msg.MailGuid);
                sbValue.Append(',');
                sbValue.AppendFormat("'{0}'", msg.UserGuid);
                sbValue.Append(',');
                sbValue.Append(msg.IsRead);
                sbValue.Append(',');
                sbValue.Append(msg.IsReceived);
                sbValue.Append(',');
                sbValue.Append(msg.IsDeleted);
                sbValue.Append(',');
                sbValue.AppendFormat("'{0}'", msg.ExpiryDate);
                sbValue.Append(')');
                sbSql.Append(sbValue.ToString());
                sbSql.Append(',');
              }
            }
            sbSql.Remove(sbSql.Length - 1, 1);
            sbSql.Append(" on duplicate key update ");
            sbSql.AppendFormat(" IsValid = if(DataVersion < {0}, values(IsValid), IsValid),", dataVersion);
            sbSql.AppendFormat(" MailGuid = if(DataVersion < {0}, values(MailGuid), MailGuid),", dataVersion);
            sbSql.AppendFormat(" UserGuid = if(DataVersion < {0}, values(UserGuid), UserGuid),", dataVersion);
            sbSql.AppendFormat(" IsRead = if(DataVersion < {0}, values(IsRead), IsRead),", dataVersion);
            sbSql.AppendFormat(" IsReceived = if(DataVersion < {0}, values(IsReceived), IsReceived),", dataVersion);
            sbSql.AppendFormat(" IsDeleted = if(DataVersion < {0}, values(IsDeleted), IsDeleted),", dataVersion);
            sbSql.AppendFormat(" ExpiryDate = if(DataVersion < {0}, values(ExpiryDate), ExpiryDate),", dataVersion);
            sbSql.AppendFormat(" DataVersion = if(DataVersion < {0}, {0}, DataVersion),", dataVersion);
            sbSql.Remove(sbSql.Length - 1, 1);
            string statement = sbSql.ToString();
            int count = 0;
            try {
              using (MySqlCommand cmd = new MySqlCommand()) {
                cmd.Connection = DBConn.MySqlConn;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = statement;
                count = cmd.ExecuteNonQuery();
              }
            } catch (Exception ex) {
              if (dataList.Count < 200) {
                LogSys.Log(LOG_TYPE.ERROR, "Error Sql statement:{0}", statement);
              }
              DBConn.Close();
              throw ex;
            }
            return count;
        }