linq

添加

public int Add(Votes model) {
            context.Votes.Add(model);
            return context.SaveChanges() == 1 ? true : false;
        }

查询列表

public List<Votes> getList(int? groupID) {
            var models = from m in context.Votes
                         select m;

            if (groupID != null)
            {
                models = models.Where(t => groupID == t.GroupID);
            }
            return models.ToList();
        }

查询对象

public Votes getVotes(int? votesID)
        {
            Votes model = context.Votes.FirstOrDefault(m => votesID == m.ID);
            return model;
        }

添加返回主键

public int Add(Check_ApplyOvertime model) {
            context.Check_ApplyOvertime.Add(model);
            context.SaveChanges();
            return model.ID;
        }

删除对象

public bool Delete(int id)
        {
            IQueryable<KeHu_Customer> models = context.KeHu_Customer.Where(m => m.ID == id);
            context.KeHu_Customer.RemoveRange(models);
            int i = context.SaveChanges();
            return i > 0 ? true : false;
        }

分页查询

public List<Fms_Project> Find(int page, int pageSize)
        {
            IQueryable<Fms_Project> data = context.Fms_Project.OrderBy(m => m.SortID);
            
            if (page > 0 && pageSize > 0)
            {
                data = data.Skip((page - 1) * pageSize).Take(pageSize);
            }

            return data.ToList();
        }

统计

public int Find(int page, int pageSize)
        {
            IQueryable<Fms_Project> data = context.Fms_Project.OrderBy(m => m.SortID);

            return data.Count();
        }

级联查询

public User_Group_Link GetUserGroupLink(int UserID, int GroupID)
        {
            var data = (from m in context.User_Group_Link
                        join n in context.User on m.UserID equals n.ID
                        join g in context.User_Group on m.GroupID equals g.ID
                        join o in context.User_Group_Organization on m.OrganizationID equals o.ID
                        into Emp
                        from o in Emp.DefaultIfEmpty()
                        where m.UserID == UserID && m.GroupID == GroupID
                        select new
                        {
                            m,
                            n,
                            g
                        }).Distinct().FirstOrDefault();

            if (data == null)
            {
                return null;
            }

            User_Group_Link model = data.m;
            model.User = data.n;
            model.User_Group = data.g;
            return model;
        }

修改

public bool Edit(Check_RecordSet model)
        {
            try
            {
                var entry = context.Entry<Check_RecordSet>(model);
                entry.State = System.Data.Entity.EntityState.Modified;
                context.SaveChanges();
                return true;
            }
            catch (Exception)
            {
                return false;
                throw;
            }
        }