/// <summary>
/// 处理BookRfidIsbnMapping表逻辑信息
/// </summary>
/// <param name="bookRfidIsbnMapping"></param>
/// <returns></returns>
public static bool ProcessBookRfidIsbnMappingLogical(BookRfidIsbnMapping bookRfidIsbnMapping)
{
//查询isbn记录是否存在，存在则记录为多本，不存在则记录为单本
var sql = "update book_rfid_isbn_mapping set isbn_sequence=@isbn_sequence,isbn_type=@isbn_type where rfid_tag_id=@rfid_tag_id";
List <BookRfidIsbnMapping> listBookRfidIsbnMapping = GetBookRfidIsbnMappingByIsbn(bookRfidIsbnMapping.isbn);
if (listBookRfidIsbnMapping == null || listBookRfidIsbnMapping.Count == 1)
{
bookRfidIsbnMapping.isbn_sequence = 1;
bookRfidIsbnMapping.isbn_type = 1;
}
else
{
bookRfidIsbnMapping.isbn_sequence = listBookRfidIsbnMapping.Count;
bookRfidIsbnMapping.isbn_type = 2;
string update_sql = $"update book_rfid_isbn_mapping set isbn='{bookRfidIsbnMapping.isbn}'";
Utility.MySqlInstance.ExecuteNonQueryText(update_sql, null);
}
//更新BookRfidIsbnMapping中isbn对应图书信息
var res = Utility.MySqlInstance.ExecuteNonQuery(CommandType.Text, sql, new System.Data.Common.DbParameter[] {
new MySqlParameter("@isbn_sequence", bookRfidIsbnMapping.isbn_sequence),
new MySqlParameter("@isbn_type", bookRfidIsbnMapping.isbn_type),
new MySqlParameter("@rfid_tag_id", bookRfidIsbnMapping.rfid_tag_id)
});
return(res > 0);
}
/// <summary>
/// 保存BookRfidIsbnMapping
/// </summary>
/// <param name="bookRfidIsbnMapping"></param>
/// <returns></returns>
public static bool InsertBookRfidIsbnMapping(BookRfidIsbnMapping bookRfidIsbnMapping)
{
string sql = "insert into book_rfid_isbn_mapping(isbn,rfid_tag_id,isbn_sequence,isbn_type,status) values(@isbn,@rfid_tag_id,@isbn_sequence,@isbn_type,@status)";
var res = MySqlInstance.ExecuteNonQuery(CommandType.Text, sql, new System.Data.Common.DbParameter[] {
new MySqlParameter("@isbn", bookRfidIsbnMapping.isbn),
new MySqlParameter("@rfid_tag_id", bookRfidIsbnMapping.rfid_tag_id),
new MySqlParameter("@isbn_sequence", bookRfidIsbnMapping.isbn_sequence),
new MySqlParameter("@isbn_type", bookRfidIsbnMapping.isbn_type),
new MySqlParameter("@status", bookRfidIsbnMapping.status)
});
return(res > 0);
}
/// <summary>
/// 异步保存BookRfidIsbnMapping
/// </summary>
/// <param name="bookRfidIsbnMapping"></param>
/// <returns></returns>
public async static Task <bool> InsertBookRfidIsbnMappingAsync(BookRfidIsbnMapping bookRfidIsbnMapping)
{
return(await Task.Run(() => InsertBookRfidIsbnMapping(bookRfidIsbnMapping)));
}
