Ejemplos de CategoryUsers.Where en C# (CSharp)

Ejemplo n.º 1

        object delete(string userId)
        {
            var site = (Site)jc["site"];

            using (ILinqContext <SiteUsers> cx = SiteUsers.CreateContext())
            {
                var relation = (from q in cx
                                where q.SiteId == site.Id && q.UserId == userId
                                select q).FirstOrDefault();

                if (relation == null)
                {
                    return new { code = -1, msg = "指定的用户在该站点下不存在" }
                }
                ;

                if (relation.UserId == jc.UserName)
                {
                    return new { code = -2, msg = "不能删除自己的账号" }
                }
                ;

                //删除栏目与用户的关系
                CategoryUsers.Where("SiteId = {0}", site.Id).Where("UserId = {0}", relation.UserId).Delete();

                //删除站点用户关系

                cx.Remove(relation);
                cx.SubmitChanges();
            }

            return(new { code = 1, msg = "删除成功" });
        }