/// <summary>
/// 查詢
/// </summary>
/// <returns></returns>
public List <Models.serch> GetbooksByCondtioin(Models.serch arg)
{
DataTable dt = new DataTable();
string sql = @"SELECT BD.BOOK_ID, BD.BOOK_NAME, BC.BOOK_CLASS_NAME, BD.BOOK_BOUGHT_DATE, BCODE.CODE_NAME, M.USER_ENAME
FROM BOOK_DATA BD
JOIN BOOK_CLASS BC ON BD.BOOK_CLASS_ID = BC.BOOK_CLASS_ID
JOIN BOOK_CODE BCODE ON (BD.BOOK_STATUS = BCODE.CODE_ID AND CODE_TYPE = 'BOOK_STATUS')
LEFT JOIN MEMBER_M M ON BD.BOOK_KEEPER = M.[USER_ID]
WHERE (BD.BOOK_NAME LIKE ('%' + @BOOK_NAME + '%') OR @BOOK_NAME='')AND (BD.BOOK_CLASS_ID = @BOOK_CLASS_ID OR @BOOK_CLASS_ID='')
AND (M.USER_ID = @USER_ID OR @USER_ID='') AND (BCODE.CODE_ID = @CODE_ID OR @CODE_ID='')";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", arg.Bookname == null ? string.Empty : arg.Bookname));
cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", arg.bookcatorory == null ? string.Empty : arg.bookcatorory));
cmd.Parameters.Add(new SqlParameter("@USER_ID", arg.bookuser == null ? string.Empty : arg.bookuser));
cmd.Parameters.Add(new SqlParameter("@CODE_ID", arg.status == null ? string.Empty : arg.status));
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
sqlAdapter.Fill(dt);
conn.Close();
}
return(this.MapserchDataToList(dt));
}
public JsonResult Getdetials(Models.serch arg)
{
List <Models.serch> detials = new List <Models.serch>();
Models.service serch = new Models.service();
detials = serch.GetbooksByCondtioin(arg);
return(Json(detials));
}
public ActionResult serch(Models.serch arg)
{
Models.service serch = new Models.service();
ViewBag.SearchResult = serch.GetbooksByCondtioin(arg);
ViewBag.BOOK_CLASS_NAME = this.codeservice.GetBOOK_CLASS_NAME();
ViewBag.USER_ENAME = this.codeservice.GetUSER_ENAME();
ViewBag.CODE_NAME = this.codeservice.GetCODE_NAME();
return(View( ));
//return Json(this.codeservice.GetBOOK_CLASS_NAME("BOOK_CLASS_NAME"));
}
