/// <summary>
/// 修改资料信息
/// </summary>
/// <param name="matInfo"></param>
public bool UpdateMatInfo(BookInfo_Table matInfo)
{
if (bookInfo_DAL.UpdateMatInfo(matInfo) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加资料信息
/// </summary>
/// <param name="bookInfo"></param>
public bool AddBookInfo(BookInfo_Table bookInfo)
{
if (bookInfo_DAL.AddBookInfo(bookInfo) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加图书信息
/// </summary>
private void AddBookInfo()
{
//图书编号必须唯一
if (tb_BookISBN.Text.Trim() == "")
{
MessageBox.Show("图书ISBN不能为空！！！");
}
else if (tb_BookRawName.Text.Trim() == "")
{
MessageBox.Show("图书原名称不能为空！！！");
}
else if (tb_BookNumber.Text == "")
{
MessageBox.Show("图书份数不能为空！！！");
}
else
{
//创建添加的对象
BookInfo_Table bookInfo = new BookInfo_Table(
Guid.NewGuid().ToString(),
tb_BookISBN.Text.Trim().ToString(),
tb_BookRawName.Text.Trim().ToString(),
tb_BookCNName.Text.Trim().ToString(),
tb_BookAuthorName.Text.Trim().ToString(),
tb_BookPress.Text.Trim().ToString(),
dtp_BookPubDate.Value,
Convert.ToInt32(tb_BookNumber.Text.Trim().ToString()),
dtp_BookBuyDate.Value,
tb_BookBuyPerson.Text.Trim().ToString(),
tb_BookBuyShop.Text.Trim().ToString(),
cbb_BookType.SelectedValue.ToString(),
cbb_BookLanType.Text.Trim().ToString(),
tb_BookAnno.Text.Trim().ToString(),
false);
if (true == bookInfo_BLL.AddBookInfo(bookInfo))
{
//返回添加成功
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("添加失败！！！");
}
}
}
/// <summary>
/// 修改图书信息
/// </summary>
private void AlterBookInfo()
{
if ((MessageBox.Show("是否确定修改？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) == DialogResult.No)
{
return;
}
if (tb_BookISBN.Text.Trim() == "")//资料编号必须唯一
{
MessageBox.Show("图书编号不能为空！！！");
return;
}
else if (tb_BookRawName.Text.Trim() == "")
{
MessageBox.Show("图书名称不能为空！！！");
return;
}
//创建修改的对象
BookInfo_Table bookInfo_T = new BookInfo_Table(
Guid.NewGuid().ToString(),
tb_BookISBN.Text.Trim().ToString(),
tb_BookRawName.Text.Trim().ToString(),
tb_BookCNName.Text.Trim().ToString(),
tb_BookAuthorName.Text.Trim().ToString(),
tb_BookPress.Text.Trim().ToString(),
dtp_BookPubDate.Value,
Convert.ToInt32(tb_BookNumber.Text.Trim().ToString()),
dtp_BookBuyDate.Value,
tb_BookBuyPerson.Text.Trim().ToString(),
tb_BookBuyShop.Text.Trim().ToString(),
cbb_BookType.SelectedValue.ToString(),
cbb_BookLanType.SelectedText.Trim().ToString(),
tb_BookAnno.Text.Trim().ToString(),
false);
if (bookInfo_BLL.UpdateMatInfo(bookInfo_T))
{
MessageBox.Show("修改信息成功！");
DialogResult = DialogResult.OK;//返回添加成功
}
else
{
MessageBox.Show("修改信息失败！");
}
}
/// <summary>
/// 修改资料信息
/// tb_MatInfo
/// </summary>
/// <param name="bookInfo"></param>
/// <returns></returns>
public int UpdateMatInfo(BookInfo_Table bookInfo)
{
string sqlStr = @"UPDATE [db_RMS].[dbo].[tb_BookInfo] "
+ "SET [BookGuid] ='" + bookInfo.BookGuid + "'"
+ ",[BookISBN]='" + bookInfo.BookISBN + "'"
+ ",[BookRawName]='" + bookInfo.BookRawName + "'"
+ ",[BookCNName]='" + bookInfo.BookCNName + "'"
+ ",[BookPubDate]='" + bookInfo.BookPubDate + "'"
+ ",[BookNumber] ='" + bookInfo.BookNumber + "'"
+ ",[BookBuyDate] ='" + bookInfo.BookBuyDate + "'"
+ ",[BookBuyPerson] ='" + bookInfo.BookBuyPerson + "'"
+ ",[BookBuyShop] = '" + bookInfo.BookBuyShop + "'"
+ ",[BookTypeGuid] ='" + bookInfo.BookTypeGuid + "'"
+ ",[BookLanType]='" + bookInfo.BookLanType + "'"
+ ",[BookAnnotation] ='" + bookInfo.BookAnnotation + "'"
+ ",[BookIsDelete]='" + bookInfo.BookIsDelete + "'"
+ " WHERE [BookGuid] = '" + bookInfo.BookGuid + "'";
return(DBhelp.Create().ExecuteNonQuery(sqlStr));
}
/// <summary>
/// 添加图书信息
/// </summary>
/// <param name="bookInfo"></param>
/// <returns></returns>
public int AddBookInfo(BookInfo_Table bookInfo)
{
string sql = @"INSERT INTO tb_BookInfo ([BookGuid],[BookISBN],[BookRawName],[BookCNName],[BookAuthor],[BookPress],[BookPubDate],"
+ "[BookNumber],[BookBuyDate],[BookBuyPerson],[BookBuyShop],[BookTypeGuid],[BookLanType],[BookAnnotation],[BookIsDelete]) "
+ "VALUES ('"
+ bookInfo.BookGuid + "','"
+ bookInfo.BookISBN + "','"
+ bookInfo.BookRawName + "','"
+ bookInfo.BookCNName + "','"
+ bookInfo.BookAuthor + "','"
+ bookInfo.BookPress + "','"
+ bookInfo.BookPubDate + "','"
+ bookInfo.BookNumber + "','"
+ bookInfo.BookBuyDate + "','"
+ bookInfo.BookBuyPerson + "','"
+ bookInfo.BookBuyShop + "','"
+ bookInfo.BookTypeGuid + "','"
+ bookInfo.BookLanType + "','"
+ bookInfo.BookAnnotation + "','"
+ bookInfo.BookIsDelete + "')";
return(DBhelp.Create().ExecuteNonQuery(sql));
}
