ASP.NET中实体数据库模型的增删改查的用法。

来源：互联网发布：cms 上海交通大学编辑：程序博客网时间：2024/06/10 01:12
                   using (CSEntities ce = new CSEntities())                    {                        ///查找///                        var login = ce.Admins.Select(p => new {p.Admin_ID,p.Area_ID,p.Addtime,p.State}).Where(p=>p.State=="可用"&&p.Admin_ID==8).ToList();                        //模糊查询                        var login = ce.Addresses.Select(p => new { p.Name, p.Phone, p.Area_ID }).Where(a => a.Area_ID == 1 && a.Phone.Contains("138")).ToList();                       //多表查询                            //var p_id = Convert.ToInt32(context.Request["id"]);                            var p_id = 111;                            int i = 0;                            var list = ce.Order_Goods.Where(p => p.P_ID == p_id).ToList().Select(p => new                            {                                xuhao = ++i,                                p.Product.Product_Name,                                p.Product.Guige,                                p.Product_Num,                                p.Product.Price,                                zhongliang = p.Product_Num * p.Product.zhongliang                            });                            var porder = ce.Porders.Where(p => p.P_ID == p_id).Select(p => new                            {                                ShouhuoName = p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Name,                                p.User.Yewu.name,                                p.Price,                                p.porder_no,                                p.orderStatus,                                p.payStatus,                                p.deliveryStatus,                                YewuPhone = p.User.Yewu.phone,                                UserPhone = p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Phone,                                p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Address1,                               //p.Siji.Area.Area_Name,                                                              FuWuPhone = ce.System_Setting.FirstOrDefault().tel                            });                            JObject jo = new JObject();                            JProperty head = new JProperty("head", JsonConvert.DeserializeObject(JsonConvert.SerializeObject(porder)));                            jo.Add(head);                            JProperty body = new JProperty("body", JsonConvert.DeserializeObject(JsonConvert.SerializeObject(list)));                            jo.Add(body);                            context.Response.Write(jo);                        }                        ///修改                       var login = ce.Admins.FirstOrDefault(p => p.Admin_ID == 20 && p.State == "可用");                        ogin.State = "不可用";                        int s = ce.SaveChanges();                        ///增加                        string ss = context.Request["username"];                        ce.Admins.Add(new Data.Admin()                        {                           Username = ss,                          Area_ID = 1,                          Img = "../uploadImg/20151116190727629388240.png",                            State = "可用",                          power = true,                            Addtime = DateTime.Now,                          Nickname = "liuk",                          Password = "dddddddd"                       });                        ///删除                        var login = ce.Admins.Remove(ce.Admins.FirstOrDefault(a => a.Admin_ID == 20 && a.Username == "admindfd"));                        int s = ce.SaveChanges();                        if (login.Count > 0)                        {                            context.Response.Write("OK");                            context.Response.Write(JsonConvert.SerializeObject(login));                        }                        else                        {                            context.Response.Write("wrong");                        }
0 0