Esempio n. 1
0
        public bool xiugaiquanxian(int id, List <int> ids)
        {
            HashSet <int> ha = new HashSet <int>(ids);

            try
            {
                Power p1 = new Power()
                {
                    RoleID = id
                };
                DBHelp.CUD(string.Format(@"delete Power where RoleID = {0}", id));
                foreach (var item in ha)
                {
                    Power p2 = new Power()
                    {
                        RoleID = id,
                        MenuID = item,
                    };
                    DALBase.Insert(p2);
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
Esempio n. 2
0
        public bool upCustomServices(int id, string name)
        {
            string sql = string.Format(@"select userid from dbo.Users where username = '******'", name);

            int idt = Convert.ToInt32(DBHelp.ExecuteObject(sql));
            //int idd = Convert.ToInt32(idt);
            //CustomServices s = new CustomServices() { CSID = id, CSDueID = idt };
            string sql2 = string.Format(@"update CustomServices set CSDueID = {0} where CSID={1}", idt, id);

            return(Convert.ToBoolean(DBHelp.CUD(sql2)));
        }