/// <summary>
/// Find and by BkID/BkName/TypeID Find
/// </summary>
/// <param name="bkFilter">Model_BookIngo_View</param>
/// <returns>List</returns>
public static List <BookInfo_View> Find(BookInfo_View bkFilter)
{
try
{
using (BookDB_Model BkDB = new BookDB_Model())
{
var list = from data in BkDB.BookInfo_View
select data;
if (bkFilter.BkId > 0)
{
list = list.Where(data => data.BkId == bkFilter.BkId).Select(data => data);
}
if (!string.IsNullOrEmpty(bkFilter.BkName))
{
list = list.Where(data => data.BkName.Contains(bkFilter.BkName)).Select(data => data);
}
if (bkFilter.TypeId > 0)
{
list = list.Where(data => data.TypeId == bkFilter.TypeId).Select(data => data);
}
return(list.ToList());
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// Find and by BkID/BkName/TypeID Find
/// </summary>
/// <param name="bkFilter">Model_BookIngo_View</param>
/// <returns>List</returns>
public static List <BookInfo_View> Find(BookInfo_View bkFilter)
{
try
{
return(BookInfoDAL.Find(bkFilter));
}
catch (Exception error)
{
throw error;
}
}
public ActionResult FindPostData(FormCollection fc)
{
BookInfo_View bkFilter = new BookInfo_View();
bkFilter.BkName = fc["BookName"].ToString();
if (fc["seleList"].ToString() != "")
{
bkFilter.TypeId = Convert.ToInt32(fc["seleList"]);
}
var list = BookInfoBLL.Find(bkFilter);
FindSele();
return(View("Index", list));
}
// 写下拉框 主页开始的
private void FindSele(BookInfo_View bk = null)
{
if (bk == null)
{
var listSele = BookTypeBLL.Find();
SelectList seleList = new SelectList(listSele, "TypeId", "TypeName");
ViewBag.seleList = seleList;
}
else
{
var listSele = BookTypeBLL.Find();
SelectList seleList = new SelectList(listSele, "TypeId", "TypeName", bk.TypeId);
ViewBag.seleList = seleList;
}
}
/// <summary>
///
/// </summary>
/// <param name="matID"></param>
/// <returns></returns>
public BookInfo_View SelectBookInfo_V(string bookGuid)
{
BookInfo_View bookInfo_V = new BookInfo_View();
string sqlStr = @"SELECT [BookGuid],[BookISBN],[BookRawName],[BookCNName],[BookAuthor],"
+ "[BookPress],[BookPubDate],[BookNumber],[BookBuyDate],[BookBuyPerson],[BookBuyShop],"
+ "[BookTypeName],[BookLanType],[BookAnnotation],[BookIsDelete] FROM [db_RMS].[dbo].[View_BookInfo] "
+ "where BookGuid='" + bookGuid + "'";
SqlDataReader reader = DBhelp.Create().ExecuteReader(sqlStr);
if (reader.Read())
{
return(new BookInfo_View(reader.GetGuid(0).ToString(), reader.GetString(1).Trim().ToString(), reader.GetString(2).Trim().ToString(),
reader.GetString(3).ToString(), reader.GetString(4).Trim().ToString(), reader.GetString(5).Trim().ToString(), reader.GetDateTime(6),
reader.GetInt32(7), reader.GetDateTime(8), reader.GetString(9).Trim().ToString(), reader.GetString(10).Trim().ToString(),
reader.GetString(11).Trim().ToString(), reader.GetString(12).Trim().ToString(), reader.GetString(13).Trim().ToString(), reader.GetBoolean(14)));
}
return(bookInfo_V);
}
/// <summary>
/// 初始化其他相关信息
/// </summary>
private void Init_BookInfo()
{
BookInfo_View bookInfo_V = bookInfo_BLL.SelectBookInfo_V(BookGuid);
tb_BookISBN.Text = bookInfo_V.BookISBN;
tb_BookRawName.Text = bookInfo_V.BookRawName;
tb_BookCNName.Text = bookInfo_V.BookCNName;
tb_BookAuthorName.Text = bookInfo_V.BookAuthor;
tb_BookPress.Text = bookInfo_V.BookPress;
tb_BookNumber.Text = (bookInfo_V.BookNumber).ToString();
dtp_BookPubDate.Value = bookInfo_V.BookPubDate;
dtp_BookBuyDate.Value = bookInfo_V.BookBuyDate;
tb_BookBuyPerson.Text = bookInfo_V.BookBuyPerson;
tb_BookBuyShop.Text = bookInfo_V.BookBuyShop;
cbb_BookType.Text = bookInfo_V.BookTypeName;
cbb_BookLanType.Text = bookInfo_V.BookLanType;
tb_BookAnno.Text = bookInfo_V.BookAnnotation;
}
