/// <summary>
/// List Of Books
/// </summary>
/// <returns></returns>
public ActionResult List()
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
//List<MODEL.T_DIC_Book> lst=new List<MODEL.T_DIC_Book>();
//lst = bll.GETALL();
int PageSize = 10;//默认值
int PageIndex = 1;
string keywords = Convert.ToString(Request.Form["keywords"]);
if (keywords == "" || keywords == null)
{
keywords = null;
}
else
{
keywords = " and Name like'%" + Convert.ToString(Request.Form["keywords"]) + "%'";
}
if (Request.Form["pageNum"] != null)
{
PageSize = Convert.ToInt32(Request.Form["numPerPage"]);
PageIndex = Convert.ToInt32(Request.Form["pageNum"]);
}
List <MODEL.T_DIC_Book> lst = bll.GetBookByPage(PageSize, PageIndex, keywords);
int totalcount = bll.GetUserTotalCount(keywords);
ViewBag.pagesize = PageSize;
ViewBag.pageindex = PageIndex;
ViewBag.lst = lst;
ViewBag.totalcount = totalcount;
return(View());
}
/// <summary>
/// EditBook
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public ActionResult EditBook(int uid)
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
MODEL.T_DIC_Book model = bll.GetModel(uid);
ViewBag.lst = model;
return(View());
}
public JsonResult AddBookSave(MODEL.T_DIC_Book book)
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
if (bll.AddBook(book))
{
MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "增加书籍成功！");
return(Json(message));
}
else
{
MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "增加书籍失败！");
return(Json(message));
}
}
/// <summary>
/// DeleteBook
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public JsonResult Delete(int uid)
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
bool result = bll.Delete(uid);
if (result)
{
MODEL.Message message = BookProject.Public.U_CloseSMess("BookList", "BookList", "删除书籍成功！");
return(Json(message));
}
else
{
MODEL.Message message = BookProject.Public.U_CloseFMess("BookList", "BookList", "删除书籍失败！");
return(Json(message));
}
}
public JsonResult EditBookSave(MODEL.T_DIC_Book book)
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
bool result = bll.Update(book);
if (result)
{
MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "编辑书籍成功！");
return(Json(message));
}
else
{
MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "编辑书籍失败！");
return(Json(message));
}
}
public ActionResult getjson2()
{
BLL.T_DIC_Book bll = new BLL.T_DIC_Book();
List <MODEL.T_DIC_Book> lst = bll.GETALL();
string json2 = "[";
for (int i = 0; i < lst.Count; i++)
{
if (i == lst.Count - 1)
{
json2 += " {\"ID\":\"" + lst[i].ID + "\", \"Name\":\"" + lst[i].Name + "\", \"Price\":\"" + lst[i].Pricing + "\"}";
}
else
{
json2 += " {\"ID\":\"" + lst[i].ID + "\", \"Name\":\"" + lst[i].Name + "\", \"Price\":\"" + lst[i].Pricing + "\"},";
}
}
json2 += "]";
return(Content(json2));
}
