MvcCRUD

DAL层：

//实例化dbhelper
DBHelper db = new DBHelper();
//添加图书信息
public int GetAdd(infoModel m)
{
string sql = "insert into Bookinfos values('" + m.BookName + "','" + m.BookPrice + "','" + m.BookAuthor + "','" + m.BookPress + "','" + m.BookTypeID + "')";
return db.NonQuery(sql);
}
//获取图书信息
public List<infoModel> GetDataInfo(string name)
{
string sql = "select * from Bookinfos inner join BookTypes on Bookinfos.BookTypeID=BookTypes.TypeID where 1=1";
if(!string.IsNullOrWhiteSpace(name))
{
sql += " and BookName like '%" + name + "%'";
}
// else if (!string.IsNullOrWhiteSpace(name))
// {
// sql += " and BookAuthor like '%" + name + "%'";
// }
// if (!string.IsNullOrWhiteSpace(name))
// {
// sql += " and BookPress like '%" + name + "%'";
// }
var data = db.GetDataTable(sql);
var tab = from a in data.AsEnumerable()
select new infoModel()
{
BookID = a.Field<int>("BookID"),
BookPrice = a.Field<decimal>("BookPrice"),
BookAuthor = a.Field<string>("BookAuthor"),
BookName = a.Field<string>("BookName"),
BookPress = a.Field<string>("BookPress"),
BookTypeID = a.Field<int>("BookTypeID"),
TypeID=a.Field<int>("TypeID"),
TypeName=a.Field<string>("TypeName")

};
return tab.ToList();

}
//单条删除图书信息
public int GetDel(int id)
{
string sql = "delete from Bookinfos where BookID=" + id;
return db.NonQuery(sql);
}

 

BLL层：

 

//实例化dal
infoDAL dal = new infoDAL();
//添加图书信息
public int GetAdd(infoModel m)
{
return dal.GetAdd(m);
}
//获取图书信息
public List<infoModel> GetDataInfo(string name)
{
return dal.GetDataInfo(name);
}
//单条删除图书信息
public int GetDel(int id)
{
return dal.GetDel(id);
}

 

//con控制器：

// GET: ManAge
//获取图书信息
public ActionResult Index(string name,int index=1)
{
//实例化bll
infoBLL bll = new infoBLL();
var result = bll.GetDataInfo(name);
return View(result.ToPagedList(index,4));
}
//添加图书信息
public ActionResult AddBookinfo()
{
//实例化bll
typeBLL tbll = new typeBLL();
var drops = tbll.GetDrop();
SelectList sels = new SelectList(drops, "TypeID", "TypeName");
ViewBag.list = sels;
return View();
}
//添加图书信息
[HttpPost]
public ActionResult AddBookinfo(infoModelVM model)
{
infoModel m = new infoModel()
{
BookName = model.BookName,
BookAuthor = model.BookAuthor,
BookID = model.BookID,
BookPress = model.BookPress,
BookPrice = model.BookPrice,
BookTypeID = model.TypeID
};
//实例化bll
infoBLL bll = new infoBLL();
var infos = bll.GetAdd(m);
if (infos > 0)
{
return Content("<script>alert('添加图书信息成功');location.href='/ManAge/Index'</script>");
}
else
{
return Content("<script>alert('添加失败')</script>");
}

}

//删除单条信息
public ActionResult Delinfo(int id)
{
//实例化bll
infoBLL bll = new infoBLL();
var dels = bll.GetDel(id);
if(dels>0)
{
return Content("<script>alert('删除成功');location.href='/ManAge/Index'</script>");
}
else
{
return Content("<script>alert('删除失败')</script>");
}

}
//添加类别
public ActionResult AddBookType()
{
return View();
}
//添加类别
[HttpPost]
public ActionResult AddBookType(bookTypeModelVM book)
{
//实例化model
typeModel t = new typeModel()
{
TypeName = book.TypeName,
TypeID = book.TypeID
};
//实例化bll
typeBLL bll = new typeBLL();
var types = bll.GetAddType(t);
if(types>0)
{
return Content("<script>alert('添加类别成功');location.href='/ManAge/AddBookinfo'</script>");
}
else
{
return Content("<script>alert('添加类别失败')</script>");
}

}