增删查改

DAL-------------------------------------------DAL-----------------------------DAL
/// 添加

        public int add(info i)
        {
           InfoContext ctx = new InfoContext();
            ctx.info.Add(i);
            return ctx.SaveChanges();
        }

/// 批量删除

        public int alldel(string Id)
        {
            string[] ids = Id.Split(',');
            //var ids = Id.Split(',').ToList().ConvertAll(c => int.Parse(c)); //转Int
            InfoContext ctx = new InfoContext();
            var Model = ctx.info.Where(c => ids.Contains(c.Id.ToString()));
            ctx.info.RemoveRange(Model);
            return ctx.SaveChanges();
        }

/// 反填

        public info Upd(int id)
        {
            InfoContext ctx = new InfoContext();
            var Model = ctx.info.Where(c => c.Id == id).FirstOrDefault();
            return Model;
        }

/// 修改

        public int update(info i)
        {
            InfoContext ctx = new InfoContext();
            ctx.Entry(i).State = System.Data.Entity.EntityState.Modified;
            return ctx.SaveChanges();
        }

/// 查询

        public List<info> selete(string name)
        {
            InfoContext ctx = new InfoContext();
            return ctx.info.Where(c => c.Name.Contains(name)).ToList();
        }

/// 下拉

        public List<Types> bindin ()
        {
            InfoContext ctx = new InfoContext();
            return ctx.Types.ToList();
        }

/// 查询全部

        public List<info> all()
        {

            InfoContext ctx = new InfoContext();
            var Model = ctx.info.ToList();
            return Model;
        }
DAL-------------------------------------------DAL-----------------------------------DAL
控制器-------------------------------------------控制器-----------------------------------控制器
        InBll bll = new InBll();
        // GET: Default
        public ActionResult Index()
        {
            return View();
        }
        [HttpGet]
        public JsonResult IndexJson()
        {
            var json = JsonConvert.SerializeObject(bll.all());
            return Json(json,JsonRequestBehavior.AllowGet);
        }

        public ActionResult Add()
        {
            var list = bll.bindin();
            ViewBag.Tid = new SelectList(list, "Tid", "Tname");
            return View();
        }
        [HttpPost]
        public int Add(HttpPostedFileBase img,info i)
        {
            if (img!=null)
            {
                string path = Server.MapPath(@"/Content/");
                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }
                var newfilename = Guid.NewGuid() + img.FileName + "_.jpg";
                img.SaveAs(path + newfilename);
                i.ImgUrl = "/Content/" + newfilename;
                return bll.add(i);
            }
            return 0;
        }
        [HttpGet]
        public int AllDel(string Id)
        {
            return bll.alldel(Id);
        }
        public ActionResult upda(int id)
        {
            var list = bll.bindin();
            var model = bll.Upd(id);
            ViewBag.get = new SelectList(list,"Tid", "Tname",model.Tid);
            return View(bll.Upd(id));

        }
   public int upda(HttpPostedFileBase img,info i)
        {

            if (img != null)
            {
                string path = Server.MapPath(@"/Content/");
                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }
                var newfilename = Guid.NewGuid() + img.FileName + "_.jpg";
                img.SaveAs(path + newfilename);
                i.ImgUrl = "/Content/" + newfilename;

            }
return bll.update(i);
        }
控制器-------------------------------------------控制器-----------------------------------控制器
ADD-------------------------------------------ADD-----------------------------------ADD
$(function () {
            $("#btn").click(function () {
                $("#form0").ajaxSubmit({
                    type: "post",
                    url: "/Default/Add",
                    success: function (data)
                    {
                        if (data>0) {
                            alert("上传成功")
                        }
                    }
                })
            })
            $("#img").change(
                function () {
                    var reader = new FileReader();
                    reader.onload=function(e)
                    {
                        $("#img1").prop("src", e.target.result)
                    }
                    reader.readAsDataURL(this.files[0])
                }
                )
        })
    </script>
</head>
<body>
    <div>
        @using (Ajax.BeginForm("","",new AjaxOptions { },new { @enctype = "multipart/form-data" }))
        {
            <table>
                <tr>
                    <td></td>
                    <td>@Html.TextBox("Name")</td>
                </tr>
                <tr>
                    <td></td>
                    <td>@Html.DropDownList("Tid","亲选择")</td>
                </tr>
                <tr>
                    <td></td>
                    <td><input type="file" name="img" id="img"/></td>
                    <td><img id="img1" width="200" height="200" /></td>
                </tr>
                <tr>
                    <td>
                        <input type="button" id="btn" />
                    </td>
                </tr>
            </table>
        }
    </div>
</body>
ADD-------------------------------------------ADD-----------------------------------ADD
index-------------------------------------------index-----------------------------------index
    <script src="~/jquery-1.10.2.js"></script>
    <script src="~/jquery-form.js"></script>
    <script>
        $(function () {
            $("#che_All").click(function () {
                $("[name='che_chk']").prop("checked", $("#che_All").prop("checked"))

            })
            Load()
        })

                        })
                    }

                }
                else {
                    alert("选择一个")
                }
            }

    </script>
</head>
<body>
    <div>
        <input type="button" value="批量删除" onclick="delall()" />
        <table>
            <thead>
                <tr>
                    <td><input type="checkbox" name="che_All" id="che_All" /></td>
                    <td>ID</td>
                    <td>姓名</td>
                    <td>类别</td>
                    <td>头像</td>
                    <td>操作</td>
                </tr>
            </thead>
            <tbody></tbody>
        </table>
    </div>
</body>
index-------------------------------------------index-----------------------------------index
Update-------------------------------------------Update-----------------------------------Update

            }
            else
            {
                using (classtu z = new classtu())
                {
                    List<stu> q = z.stu.Include("grad").Where(s => string.IsNullOrEmpty(nn) ? true : s.name.Contains(nn)).ToList();
                    return View(q.ToPagedList(index, 3));
                }
            }

        }
        [HttpPost]
        public ActionResult Index(string name,int index=1)
        {
            if (name!=null||name!="")
            {
                nn = name;
            }
            using (classtu z = new classtu())
            {
                List<stu> q = z.stu.Include("grad").Where(s=>string .IsNullOrEmpty(nn)?true:s.name.Contains(name)).ToList();
                return View(q.ToPagedList(index, 3));
            }

}

posted @ 2018-08-22 20:30 JA~Wang 阅读(214) 评论(0) 收藏举报

刷新页面返回顶部

JA~Wang

增删查改

公告