//根据菜单的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);
}
