之前学习asp课程设计,总之非常的简单,之前做的案列分享一下,文件里数据库文件(附加即可)
适合新手小白学习讨论,会很有帮助的
附项目源码,需要5积分下载。
环境:Windows10 + VS2012 + EF
看一下效果:
- 登录界面
- 添加界面
3.删除
- 编辑
下面看看关键代码:
①前台界面设计页面Index.cshtml
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
}
<script>
function addTabs(menu, url) {
if ($("#tab").tabs('exists', menu))
{
$("#tab").tabs('select', menu)
}
else
{
$("#tab").tabs('add', {
title: menu,
href: url,
closable:true
})
}
}
</script>
<div data-options="region:'north',border:true,split:true" style="height:100px;"></div>
<div data-options="region:'south',border:true,split:true" style="height:20px;"></div>
<div data-options="region:'west',title:'导航菜单',split:true" style="width:150px;">
<ul id="tt" class="easyui-tree">
<li>
<span>系统设置</span>
<ul>
<li>
<span>用户管理</span>
<ul>
<li>
<span><a href="#" onclick="addTabs('用户列表','/User/Index')">用户列表</a></span>
</li>
<li>
<span>修改密码</span>
</li>
<li>
<span>查询用户</span>
</li>
</ul>
</li>
<li>
<span>File 2</span>
</li>
<li>
<span>File 3</span>
</li>
</ul>
</li>
<li>
<span>业务管理</span>
<ul>
<li>
<span>商品管理</span>
<ul>
<li>
<span><a href="#">商品列表</a></span>
</li>
<li>
<span>添加商品</span>
</li>
<li>
<span>查询商品</span>
</li>
</ul>
</li>
<li>
<span>File 2</span>
</li>
<li>
<span>File 3</span>
</li>
</ul>
</li>
</ul>
</div>
<div data-options="region:'center',border:true" style="padding:5px;background:#eee;">
<div id="tab" data-options="fit:true" class="easyui-tabs" style="width:500px;height:250px;">
<div title="首页" style="padding:20px;display:none;">
</div>
</div>
</div>
引入母版页
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width" />
<title>@ViewBag.Title</title>
<link href="~/Content/themes/icon.css" rel="stylesheet" />
<link href="~/Content/themes/default/easyui.css" rel="stylesheet" />
<script src="~/Scripts/jquery-1.7.1.js"></script>
<script src="~/Scripts/jquery.easyui.min.js"></script>
<script src="~/Scripts/easyui-lang-zh_CN.js"></script>
</head>
<body class="easyui-layout">
@RenderBody()
</body>
</html>
后台逻辑代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Mvc11_4.Models;
using System.Data.Objects;
namespace Mvc11_4.Controllers
{
public class UserController : Controller
{
//
// GET: /User/
//展现页面
public ActionResult Index()
{
return View();
}
//提取数据
public ActionResult GetUserList(string email,string sort="id",string order="desc",int page=1,int rows=5)
{
IQueryable<m_user> users=null;
using(TestEntities db=new TestEntities()){
//模糊查询
if (email == null)
{
users = db.m_user.AsQueryable();
}
else
{
users = db.m_user.Where(x=>x.email.Contains(email)).AsQueryable();
}
if (order == "desc")
{
switch (sort)
{
case "id":
users=users.OrderByDescending(x => x.id);
break;
case "email":
users = users.OrderByDescending(x => x.email);
break;
case "pwd":
users = users.OrderByDescending(x => x.pwd);
break;
default:
users = users.OrderByDescending(x => x.logintime);
break;
}
}
else
{
switch (sort)
{
case "id":
users = users.OrderBy(x => x.id);
break;
case "email":
users = users.OrderBy(x => x.email);
break;
case "pwd":
users = users.OrderBy(x => x.pwd);
break;
default:
users = users.OrderBy(x => x.logintime);
break;
}
}
int i = users.Count();
//提取第2页上的5条数据
users=users.Skip((page - 1) * rows).Take(rows);
var obj = new
{
total=i,
rows = users.ToList()
};
return Json(obj,JsonRequestBehavior.AllowGet);
}
}
public ActionResult Add(m_user u)
{
using(TestEntities db=new TestEntities()){
u.logintime = DateTime.Now;
db.m_user.Add(u);
int i= db.SaveChanges();
if (i == 1)
return Content("1");
else
return Content("0");
}
}
public ActionResult Mod(m_user u)
{
using (TestEntities db = new TestEntities())
{
var db_u= db.m_user.Find(u.id);
db_u.email = u.email;
db_u.pwd = u.pwd;
int i = db.SaveChanges();
if (i == 1)
return Content("1");
else
return Content("0");
}
}
public ActionResult Del(string ids)//4,5,6,7
{
//delete from m_user where id in (4,5,6,7)
string[] str_arr;
str_arr = ids.Split(',');
using (TestEntities db = new TestEntities())
{
//int i=0;
//ObjectParameter par = new ObjectParameter("ids", typeof(string));
//i = db.Del_M_User(ids,par);
foreach (var item in str_arr)
{
var db_u = db.m_user.Find(int.Parse(item));
db.m_user.Remove(db_u);
}
int i = db.SaveChanges();
return Content(i.ToString());
}
}
public ActionResult Login(m_user u)
{
using (TestEntities db = new TestEntities())
{
var user= db.m_user.Where(x=>x.email==u.email&&x.pwd==u.pwd).FirstOrDefault();
if (user !=null)
return Content("1");
else
return Content("0");
}
}
}
}