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