/// <summary>
/// 保存适读年龄
/// </summary>
/// <param name="bookReadable"></param>
/// <returns></returns>
public static bool InsertBookReadable(BookReadable bookReadable)
{
string sql = "insert into Book_readable(isbn,min_age,max_age,create_time)value(@isbn,@min_age,@max_age,@create_time)";
int res = MySqlInstance.ExecuteNonQuery(CommandType.Text, sql, new MySqlParameter[] {
new MySqlParameter("@isbn", bookReadable.isbn),
new MySqlParameter("@min_age", bookReadable.min_age),
new MySqlParameter("@max_age", bookReadable.max_age),
new MySqlParameter("@create_time", bookReadable.create_time)
});
return(res > 0);
}
/// <summary>
/// 批量保存图书信息
/// </summary>
/// <param name="bookInfos"></param>
/// <param name="enableUpdate"></param>
public static void BatchInsertBookInfo(List <BookInfoExt> bookInfos, out List <BookInfoExt> failBookList, out List <BookInfoExt> existsBookList, out List <BookInfoExt> successBookListbool, bool enableUpdate = false)
{
failBookList = new List <BookInfoExt>();
existsBookList = new List <BookInfoExt>();
successBookListbool = new List <BookInfoExt>();
using (MySqlConnection con = new MySqlConnection(Utility.MysqlDES3DecryptConnctionString))
{
con.Open();
using (MySqlTransaction trans = con.BeginTransaction())
{
List <BooktopicalMappings> listBooktopicalMappings = GetBookTopicalMappingList();
Func <BookInfoExt, bool> funcInsertBookTopic = bookinfo =>
{
//保存图书主题标签信息
if (!string.IsNullOrEmpty(bookinfo.topical_name))
{
string[] topicalNames = bookinfo.topical_name.Replace("，", ",").Replace(" ", "").Trim().Split(',');
if (topicalNames.Count() > 0)
{
topicalNames.ToList().ForEach(topicalName =>
{
var bookTopical = GetBookTopical(bookinfo.isbn_no, topicalName);
if (bookTopical == null)
{
var topical_code = listBooktopicalMappings.Where(item => item.topical_name == topicalName.Trim()).Select(item => item.topical_code).DefaultIfEmpty(null);
if (topical_code != null)
{
var toppic = new BookTopical
{
create_time = DateTime.Now,
isbn = bookinfo.isbn_no,
topical_code = topical_code.FirstOrDefault()
};
InsertBookTopical(toppic);
}
}
});
}
}
return(false);
};
for (int i = 0; i < bookInfos.Count; i++)
{
var bookinfo = bookInfos[i];
var res = MySqlInstance.ExecuteList <BookInfo>(CommandType.Text, $"select * from book_info where isbn_no='{bookinfo.isbn_no}'", null);
if (res != null && res.Count == 1)
{
//是否更新图书信息
if (enableUpdate)
{
try
{
string sql = $"update book_info set book_name='{bookinfo.book_name}',brief='{bookinfo.brief}',`describe`='{bookinfo.describe}' where isbn_no='{bookinfo.isbn_no.Trim()}';";
sql += $"update Book_readable set min_age='{bookinfo.min_age}',max_age='{bookinfo.max_age}',create_time='{DateTime.Now}' where isbn='{bookinfo.isbn_no}'";
int updateResult = MySqlInstance.ExecuteNonQuery(CommandType.Text, sql, null);
if (updateResult > 0)
{
//更新图书主题时，先删除再插入记录
sql = $" delete from book_topical where isbn='{bookinfo.isbn_no}'";
if (MySqlInstance.ExecuteNonQuery(CommandType.Text, sql, null) > 0)
{
funcInsertBookTopic(bookinfo);
}
}
existsBookList.Add(bookinfo);
}
catch (Exception ee) {
failBookList.Add(bookinfo);
}
}
}
else
{
try
{
string sql = "insert into book_info(isbn_no, book_name, author, press, publication_date, category, price, readable, imgurl, brief, `describe`, create_time, modify_time)values(@isbn_no, @book_name, @author, @press, @publication_date, @category, @price, @readable, @imgurl, @brief, @describe, @create_time, @modify_time)";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@isbn_no", bookinfo.isbn_no),
new MySqlParameter("@book_name", bookinfo.book_name),
new MySqlParameter("@author", bookinfo.author),
new MySqlParameter("@press", bookinfo.press),
new MySqlParameter("@publication_date", bookinfo.publication_date),
new MySqlParameter("@category", bookinfo.category),
new MySqlParameter("@price", bookinfo.price),
new MySqlParameter("@readable", bookinfo.readable),
new MySqlParameter("@imgurl", bookinfo.imgurl),
new MySqlParameter("@brief", bookinfo.brief),
new MySqlParameter("@describe", bookinfo.describe),
new MySqlParameter("@create_time", bookinfo.create_time),
new MySqlParameter("@modify_time", bookinfo.modify_time)
};
int result = MySqlInstance.ExecuteNonQuery(trans, CommandType.Text, sql, param);
if (result > 0)
{
//保存适读年龄
if (GetBookReadable(bookinfo.isbn_no) == null)
{
var bookReadable = new BookReadable()
{
create_time = DateTime.Now,
isbn = bookinfo.isbn_no,
min_age = bookinfo.min_age != null ? bookinfo.min_age : null,
max_age = bookinfo.max_age != null ? bookinfo.max_age : null,
};
InsertBookReadable(bookReadable);
}
//写入图书主题标签信息
funcInsertBookTopic(bookinfo);
}
successBookListbool.Add(bookinfo);
}
catch {
failBookList.Add(bookinfo);
trans.Rollback();
}
}
}
trans.Commit();
}
}
}