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); } }
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))); }