//根据菜单的id修改菜单的状态 private void SetMenuState(Bill_SysMenu s, SqlTransaction trans) { string UpMenuStateSql = "update bill_sysMenu set menustate=@menustate where menuid=@menuid"; SqlParameter[] patamter = { new SqlParameter("@menustate", s.MenuState), new SqlParameter("@menuid", s.MenuId) }; DataHelper.ExcuteNonQuery(UpMenuStateSql, trans, patamter, false); }
private IList <Bill_SysMenu> ListMaker(string sql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(sql, sps, false); IList <Bill_SysMenu> list = new List <Bill_SysMenu>(); foreach (DataRow dr in dt.Rows) { Bill_SysMenu menu = new Bill_SysMenu(); menu.MenuId = Convert.ToString(dr["MenuId"]); menu.MenuName = Convert.ToString(dr["MenuName"]); menu.ShowName = Convert.ToString(dr["ShowName"]); menu.MenuOrder = Convert.ToString(dr["MenuOrder"]); menu.MenuSm = Convert.ToString(dr["MenuSm"]); menu.MenuState = Convert.ToString(dr["MenuState"]); menu.MenuUrl = Convert.ToString(dr["MenuUrl"]); list.Add(menu); } return(list); }