/// <summary> /// 修改[数据同步记录]数据 /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <param name="dataSyncRecord"></param> /// <returns></returns> internal int Update_DataSyncRecord(IDbConnection connection, IDbTransaction transaction, DataSyncRecord dataSyncRecord) { var insert = connection.Update("SysAccount") .Set("PK_ID", DbType.AnsiString, dataSyncRecord.PK_ID) .Set("WeChatSynced", DbType.Int32, dataSyncRecord.WeChatSynced) .Set("EmailSynced", DbType.Int32, dataSyncRecord.EmailSynced) .Set("DataType", DbType.Int32, dataSyncRecord.DataType) .Set("WeChatSyncDate", DbType.DateTime, dataSyncRecord.WeChatSyncDate) .Set("EmailSyncDate", DbType.DateTime, dataSyncRecord.EmailSyncDate) .Where(WhereMySQL.Equal("PK_ID", DbType.AnsiString, dataSyncRecord.PK_ID)) .Execute(); return insert; }
/// <summary> /// 新增[数据同步记录]数据 /// </summary> /// <param name="connection"></param> /// <param name="transaction"></param> /// <param name="dataSyncRecord"></param> /// <returns></returns> internal int Insert_DataSyncRecord(IDbConnection connection, IDbTransaction transaction, DataSyncRecord dataSyncRecord) { var insert = connection.Insert("SysAccount") .Value("PK_ID", DbType.AnsiString, dataSyncRecord.PK_ID) .Value("WeChatSynced", DbType.Int32, dataSyncRecord.WeChatSynced) .Value("EmailSynced", DbType.Int32, dataSyncRecord.EmailSynced) .Value("DataType", DbType.Int32, dataSyncRecord.DataType) .Value("WeChatSyncDate", DbType.DateTime, dataSyncRecord.WeChatSyncDate) .Value("EmailSyncDate", DbType.DateTime, dataSyncRecord.EmailSyncDate) .Value("T_CreateTime", DbType.DateTime, dataSyncRecord.T_CreateTime) .Execute(); return insert; }