public SM.YuQing.Model.Menu GetModelAndChildren(int ID)
{
SM.YuQing.Model.Menu menu = dal.GetModel(ID);
//加载子菜单
List <SM.YuQing.Model.Menu> list = new List <SM.YuQing.Model.Menu>();
DataTable dt = dal.GetList(0, "ParentID='" + menu.ID + "'", "Sort").Tables[0];
foreach (DataRow row in dt.Rows)
{
list.Add(GetModelAndChildren(Convert.ToInt32(row["ID"])));
}
menu.children = list;
//加载操作
string Operation = "";
string sql = "select OperationID,Name from MenuOperation mo "
+ "inner join Operation o on mo.OperationID = o.ID "
+ "where mo.MenuID='" + menu.ID + "'";
DataTable dtOpe = DbHelperSQL.Query(sql).Tables[0];
foreach (DataRow row in dtOpe.Rows)
{
Operation += row["OperationID"] + "^" + row["Name"] + ",";
}
if (Operation.Length > 0)
{
Operation = Operation.Substring(0, Operation.Length - 1);
}
menu.Operation = Operation;
return(menu);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SM.YuQing.Model.Menu model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SM.YuQing.Model.Menu model)
{
return(dal.Add(model));
}
