/// <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;
}
