public static string DelMenuNode(string Menu_id)
{
string result = "false";
TSysMenuVo objMenuVo = new TSysMenuVo();
objMenuVo = (TSysMenuVo)BindControlsToObject(objMenuVo);
if (new TSysMenuLogic().Delete(Menu_id))
{
result = "true";
new PageBase().WriteLog("删除菜单", "", new UserLogInfo().UserInfo.USER_NAME + "删除菜单" + Menu_id);
}
return(result);
}
/// <summary>
/// 根据父ID 获取子孙 无限极
/// </summary>
/// <param name="ParentId">父ID</param>
public void GetMenuChild(string ParentId, string strMenuType)
{
DataTable dtUserMenu = new DataTable();
TSysMenuVo menuvo = new TSysMenuVo();
menuvo.IS_DEL = "0";
menuvo.IS_USE = "1";
menuvo.MENU_TYPE = strMenuType;
DataTable dtMenu = new TSysMenuLogic().SelectByTable(menuvo);
menuvo.PARENT_ID = ParentId;
if (new PageBase().LogInfo.UserInfo.ID == "000000001")
{
dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo);
}
else
{
menuvo.IS_HIDE = "0";
//dtUserMenu = new TSysMenuLogic().GetMenuByUserName(menuvo, LogInfo.UserInfo.USER_NAME);
dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, new PageBase().LogInfo.UserInfo.ID);
}
DataView dv = new DataView(dtUserMenu);
dv.Sort = " PARENT_ID,ORDER_ID ASC";
//排序结果 重载dtUserMenu
dtUserMenu = dv.ToTable();
for (int i = 0; i < dtUserMenu.Rows.Count; i++)
{
//nodes = "{ id:" + Convert.ToInt32(dtUserMenu.Rows[i]["ID"]) + ", pId:" + Convert.ToInt32(dtUserMenu.Rows[i]["PARENT_ID"]) + ", name:'" + dtUserMenu.Rows[i]["MENU_TEXT"] + "',icon:'../../Images/Menu/" + dtUserMenu.Rows[i]["MENU_IMGURL"] + "',IS_SHORTCUT:" + dtUserMenu.Rows[i]["IS_SHORTCUT"] + "";
//有图标，貌似和加载速度关系不大
nodes = "{ id:'" + dtUserMenu.Rows[i]["ID"] + "', pId:'" + dtUserMenu.Rows[i]["PARENT_ID"] + "', name:'" + dtUserMenu.Rows[i]["MENU_TEXT"] + "',icon:'../../Images/Menu/" + dtUserMenu.Rows[i]["MENU_IMGURL"] + "',IS_SHORTCUT:" + dtUserMenu.Rows[i]["IS_SHORTCUT"] + "";
if (dtUserMenu.Rows[i]["PARENT_ID"].ToString() == "0" && i == 0)
{
nodes += ", open:true";
}
if (!String.IsNullOrEmpty(dtUserMenu.Rows[i]["MENU_URL"].ToString()))
{
nodes += ", url:'" + dtUserMenu.Rows[i]["MENU_URL"] + "'";
}
nodes += "}";
treenodes.Add(nodes);
//循环方法，取当前行的ID值作为父ID 查找儿子，依次循环 达到无限
GetMenuChild(dtUserMenu.Rows[i]["ID"].ToString(), strMenuType);
}
//根节点
string rootNode = "{id:'0',pId:'-1',name:'系统菜单管理',icon:'../../Images/Menu/home.gif',open:true},\r\n";
varNodes = "[" + rootNode + String.Join(",\r\n", treenodes.ToArray()) + "]";
}
/// <summary>
/// 特定方法
/// 根据指定用户获取合法菜单
/// </summary>
/// <param name="strUserID"></param>
/// <returns></returns>
public DataTable GetMenuByUserID(TSysMenuVo tSysMenu, string strUserID)
{
string strSQL = @"select * from (select * from T_SYS_MENU {1}) m
where m.id in (
select MENU_ID from T_SYS_MENU_POST where (RIGHT_TYPE='1' and POST_ID = '{0}'
)
or (RIGHT_TYPE='2' and POST_ID in
(select POST_ID from T_SYS_USER_POST where USER_ID = '{0}')
)
)
order by m.id desc";
strSQL = string.Format(strSQL, strUserID, BuildWhereStatement(tSysMenu));
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 根据父ID 获取子孙 无限极
/// </summary>
/// <param name="ParentId">父ID</param>
private void GetMenuChild(string ParentId)
{
DataTable dtUserMenu = new DataTable();
TSysMenuVo menuvo = new TSysMenuVo();
menuvo.IS_DEL = "0";
menuvo.IS_USE = "1";
menuvo.IS_SHORTCUT = "0";
menuvo.MENU_TYPE = "Menu";
menuvo.PARENT_ID = ParentId;
if (LogInfo.UserInfo.ID == "000000001")
{
dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo);
}
else
{
menuvo.IS_HIDE = "0";
//dtUserMenu = new TSysMenuLogic().GetMenuByUserName(menuvo, LogInfo.UserInfo.USER_NAME);
dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, LogInfo.UserInfo.ID);
}
DataView dv = new DataView(dtUserMenu);
dv.Sort = " PARENT_ID,ORDER_ID ASC";
//排序结果 重载dtUserMenu
dtUserMenu = dv.ToTable();
for (int i = 0; i < dtUserMenu.Rows.Count; i++)
{
nodes = "{ id:" + Convert.ToInt32(dtUserMenu.Rows[i]["ID"]) + ", pId:" + Convert.ToInt32(dtUserMenu.Rows[i]["PARENT_ID"]) + ", name:'" + dtUserMenu.Rows[i]["MENU_TEXT"] + "'";
if (!String.IsNullOrEmpty(dtUserMenu.Rows[i]["MENU_URL"].ToString()))
{
nodes += ", menuurl:'../" + dtUserMenu.Rows[i]["MENU_URL"] + "'";
//指定在什么地方打开链接 默认 _ablak（新窗口)、 _selft(当前窗口)
//nodes += ", target:'mainFrm'";
}
if (i == 0)
{
nodes += ", open:true";
}
nodes += "}";
treenodes.Add(nodes);
//循环方法，取当前行的ID值作为父ID 查找儿子，依次循环 达到无限
GetMenuChild(dtUserMenu.Rows[i]["ID"].ToString());
}
}
public static string EditMenuNode(string Menu_id, string ParentId, string MenuText, string StrUrl, string Icon, string IsShutCut)
{
string result = "false";
TSysMenuVo objMenuVo = new TSysMenuVo();
//objMenuVo = (TSysMenuVo)BindControlsToObject(objMenuVo);
objMenuVo.ID = Menu_id;
objMenuVo.PARENT_ID = ParentId;
objMenuVo.MENU_TEXT = MenuText;
objMenuVo.MENU_URL = StrUrl;
objMenuVo.MENU_IMGURL = Icon;
objMenuVo.IS_SHORTCUT = IsShutCut;
if (new TSysMenuLogic().EditData(objMenuVo))
{
result = "true";
new PageBase().WriteLog("编辑菜单", "", new UserLogInfo().UserInfo.USER_NAME + "编辑菜单" + objMenuVo.ID);
}
return(result);
}
public static string getMenuInfo()
{
string strUserID = new PageBase().LogInfo.UserInfo.ID;
DataTable dtUserMenu = null;
TSysMenuVo menuvo = new TSysMenuVo();
menuvo.IS_DEL = "0";
menuvo.IS_USE = "1";
menuvo.IS_SHORTCUT = "0";
menuvo.MENU_TYPE = "Menu";
if (strUserID == "000000001")
{
dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo);
}
else
{
menuvo.IS_HIDE = "0";
dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, strUserID);
}
return(DataTableToJson(dtUserMenu));;
}
/// <summary>
/// 绑定菜单树，获取json数据
/// </summary>
private void BindMenuTree()
{
TSysMenuVo objMenuVo = new TSysMenuVo();
objMenuVo.IS_DEL = "0";
objMenuVo.IS_HIDE = "0";
objMenuVo.IS_USE = "1";
objMenuVo.SORT_FIELD = TSysMenuVo.ORDER_ID_FIELD;
objMenuVo.SORT_TYPE = ConstValues.SortType.ASC;
DataTable dt = new TSysMenuLogic().SelectByTable(objMenuVo, 0, 0);
if (dt.Rows.Count < 1)
{
return;
}
string MenuIconPath = "../../Images/Menu/";
MenuData.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
MenuData.Append("{");
MenuData.Append("id:\"" + dr[TSysMenuVo.ID_FIELD].ToString() + "\",");
MenuData.Append("pId:\"" + dr[TSysMenuVo.PARENT_ID_FIELD].ToString() + "\",");
MenuData.Append("name:\"" + dr[TSysMenuVo.MENU_TEXT_FIELD].ToString() + "\",");
MenuData.Append("icon:\"" + MenuIconPath + dr[TSysMenuVo.MENU_IMGURL_FIELD].ToString() + "\",");
MenuData.Append("open:false");
MenuData.Append("}");
if (i != dt.Rows.Count - 1)
{
MenuData.Append(",");
}
}
MenuData.Append("]");
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TSysMenuVo> SelectByObject(TSysMenuVo tSysMenu, int iIndex, int iCount)
{
return(access.SelectByObject(tSysMenu, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tSysMenu">对象条件</param>
/// <returns>对象</returns>
public TSysMenuVo Details(TSysMenuVo tSysMenu)
{
return(access.Details(tSysMenu));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TSysMenuVo tSysMenu)
{
return(access.GetSelectResultCount(tSysMenu));
}
/// <summary>
/// 扩展方法
/// 获得查询结果总行数，用于分页
/// 创建日期：2011-04-20 21:20
/// 创建人 ：郑义
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <param name="strMainMenuID">主菜单ID</param>
/// <returns>返回行数</returns>
public int GetSelectResultCountEx(TSysMenuVo tSysMenu, string strMainMenuID)
{
return(access.GetSelectResultCountEx(tSysMenu, strMainMenuID));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TSysMenuVo> SelectByObject(TSysMenuVo tSysMenu, int iIndex, int iCount)
{
string strSQL = String.Format("select t.* from T_SYS_MENU t " + this.BuildWhereStatement(tSysMenu));
return(SqlHelper.ExecuteObjectList(tSysMenu, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 条件修改系统菜单配置
/// </summary>
/// <param name="tSysMenu"></param>
/// <returns></returns>
public bool EditData(TSysMenuVo tSysMenu)
{
string strSQL = String.Format("UPDATE T_SYS_MENU SET IS_SHORTCUT='{0}',MENU_URL='{1}',MENU_TEXT='{2}',MENU_IMGURL='{3}',PARENT_ID='{4}' WHERE ID='{5}'", tSysMenu.IS_SHORTCUT, tSysMenu.MENU_URL, tSysMenu.MENU_TEXT, tSysMenu.MENU_IMGURL, tSysMenu.PARENT_ID, tSysMenu.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tSysMenu"></param>
/// <returns></returns>
public string BuildWhereStatement(TSysMenuVo tSysMenu)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tSysMenu)
{
//页面中重点显示(9宫格)1为重点展示
if (!String.IsNullOrEmpty(tSysMenu.IS_IMPORTANT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_IMPORTANT = '{0}'", tSysMenu.IS_IMPORTANT.ToString()));
}
//启用标记,1为启用
if (!String.IsNullOrEmpty(tSysMenu.IS_USE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_USE = '{0}'", tSysMenu.IS_USE.ToString()));
}
//删除标记,1为删除
if (!String.IsNullOrEmpty(tSysMenu.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tSysMenu.IS_DEL.ToString()));
}
//隐藏标记,1为隐藏，对用户屏蔽
if (!String.IsNullOrEmpty(tSysMenu.IS_HIDE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_HIDE = '{0}'", tSysMenu.IS_HIDE.ToString()));
}
//备注
if (!String.IsNullOrEmpty(tSysMenu.REMARK.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tSysMenu.REMARK.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tSysMenu.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tSysMenu.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tSysMenu.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tSysMenu.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tSysMenu.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tSysMenu.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tSysMenu.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tSysMenu.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tSysMenu.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tSysMenu.REMARK5.ToString()));
}
//菜单编号
if (!String.IsNullOrEmpty(tSysMenu.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tSysMenu.ID.ToString()));
}
//显示名称
if (!String.IsNullOrEmpty(tSysMenu.MENU_TEXT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_TEXT = '{0}'", tSysMenu.MENU_TEXT.ToString()));
}
//超链接或地址
if (!String.IsNullOrEmpty(tSysMenu.MENU_URL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_URL = '{0}'", tSysMenu.MENU_URL.ToString()));
}
//菜单说明
if (!String.IsNullOrEmpty(tSysMenu.MENU_COMMENT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_COMMENT = '{0}'", tSysMenu.MENU_COMMENT.ToString()));
}
//图片位置(小图标)
if (!String.IsNullOrEmpty(tSysMenu.MENU_IMGURL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_IMGURL = '{0}'", tSysMenu.MENU_IMGURL.ToString()));
}
//重点展示图片位置
if (!String.IsNullOrEmpty(tSysMenu.MENU_BIGIMGURL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_BIGIMGURL = '{0}'", tSysMenu.MENU_BIGIMGURL.ToString()));
}
//父节点ID(如果为0,为主节点)
if (!String.IsNullOrEmpty(tSysMenu.PARENT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PARENT_ID = '{0}'", tSysMenu.PARENT_ID.ToString()));
}
//排序(本父节点内)
if (!String.IsNullOrEmpty(tSysMenu.ORDER_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ORDER_ID = '{0}'", tSysMenu.ORDER_ID.ToString()));
}
//菜单类型
if (!String.IsNullOrEmpty(tSysMenu.MENU_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MENU_TYPE = '{0}'", tSysMenu.MENU_TYPE.ToString()));
}
//是否快捷菜单
if (!String.IsNullOrEmpty(tSysMenu.IS_SHORTCUT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_SHORTCUT = '{0}'", tSysMenu.IS_SHORTCUT.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 加载左侧菜单Div项,节点JSON数据， 加载tree数据方法 By Castle (胡方扬) 2012-10-24
/// </summary>
private void LoadDivModle()
{
if (LogInfo.UserInfo.USER_NAME == "" && LogInfo.UserInfo.ID != "000000001")
{
return;
}
DataTable dtUserMenu = null;
TSysMenuVo menuvo = new TSysMenuVo();
menuvo.IS_DEL = "0";
menuvo.IS_USE = "1";
menuvo.IS_SHORTCUT = "0";
menuvo.MENU_TYPE = "Menu";
if (LogInfo.UserInfo.ID == "000000001")
{
dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo);
}
else
{
menuvo.IS_HIDE = "0";
//dtUserMenu = new TSysMenuLogic().GetMenuByUserName(menuvo, LogInfo.UserInfo.USER_NAME);
dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, LogInfo.UserInfo.ID);
}
DataTable dt = new DataTable();
dt = dtUserMenu.Copy();
dt.Clear();
DataRow[] drlist = dtUserMenu.Select(" PARENT_ID='0'", "ORDER_ID ASC");
foreach (DataRow dr in drlist)
{
for (int i = 0; i < dtUserMenu.Rows.Count; i++)
{
if (dtUserMenu.Rows[i]["PARENT_ID"].ToString() == dr["ID"].ToString())
{
//dt.Rows.Add(dtUserMenu.Rows[i].ItemArray);
dt.Rows.Add(dr.ItemArray);
}
}
}
DataView dv = new DataView(dt);
dt = dv.ToTable(true);
int dtCount = dt.Rows.Count;
if (dtCount > 0)
{
//LoadDiv="<div class=\"leftInner\" id=\"mainLeft\"><ul>";
LoadDiv = "<div class=\"leftInner\" id=\"mainLeft\"><ul>\r\n";
for (int i = 0; i < dtCount; i++)
{
string openclass = "", Strstyle = "";
if (i == 0)
{
openclass = "class=\"open\"";
Strstyle = "style=\"display: block;\"";
}
LoadDiv += "<li " + openclass + "> \r\n <p><b>" + dt.Rows[i]["MENU_TEXT"] + "</b></p> \r\n";
LoadDiv += " <div class=\"leftCo\" " + Strstyle + "> \r\n";
LoadDiv += " <ul id=\"tree" + Convert.ToInt32(dt.Rows[i]["ID"]) + "\" class=\"ztree\"></ul> \r\n";
LoadDiv += " </div></li> \r\n";
TreeLoad += "$.fn.zTree.init($(\"#tree" + Convert.ToInt32(dt.Rows[i]["ID"]) + "\"), setting, zNodes" + Convert.ToInt32(dt.Rows[i]["ID"]) + "); \r\n";
GetMenuChild(dt.Rows[i]["ID"].ToString());
NodesData = string.Join(",\r\n", treenodes.ToArray());
LoadNodesData += " var zNodes" + Convert.ToInt32(dt.Rows[i]["ID"]) + "=[" + NodesData + "];\r\n";
treenodes.Clear();
}
LoadDiv += "</ul></div> \r\n";
LoadDiv += "<div class=\"arrow\" id=\"mainMiddle\"><span></span></div> \r\n";
}
}
///// <summary>
///// 功能描述：特定方法 根据指定用户获取合法地图菜单
///// 创建日期：2011-05-09 11:20
///// 创建人 ：郑义
///// </summary>
///// <param name="strUserName">用户名</param>
///// <returns></returns>
//public DataTable GetMapMenuByUserName(string strUserName)
//{
// return access.GetMapMenuByUserName(strUserName);
//}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <returns></returns>
public TSysMenuVo SelectByObject(TSysMenuVo tSysMenu)
{
return(access.SelectByObject(tSysMenu));
}
public string GetMenuByUserIDForLogin(string strUserID)
{
string strToJson = "";
DataTable dtUserMenu = null;
TSysMenuVo menuvo = new TSysMenuVo();
menuvo.IS_DEL = "0";
menuvo.IS_USE = "1";
menuvo.IS_SHORTCUT = "0";
menuvo.MENU_TYPE = "Menu";
if (strUserID == "000000001")
{
dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo);
}
else
{
menuvo.IS_HIDE = "0";
dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, strUserID);
}
var user = new TSysUserLogic().SelectByObject(new TSysUserVo {
ID = strUserID
});
DataRow[] drlist = dtUserMenu.Select(" PARENT_ID='0'", "ORDER_ID ASC");
if (drlist.Length == 0)
{
return("");
}
foreach (DataRow dr in drlist)
{
string strPID = dr["ID"].ToString();
string strMenuText = dr["MENU_TEXT"].ToString();
strToJson += strToJson.Length > 0 ? "," : "";
strToJson += "{";
strToJson += "\"id\":\"" + strPID + "\",";
strToJson += "\"MenuName\":\"" + strMenuText + "\",";
strToJson += "\"MenuID\":\"" + strPID + "\",";
strToJson += "\"text\":\"" + strMenuText + "\",";
strToJson += "\"MenuUrl\":null,";
strToJson += "\"MenuNo\":\"" + strPID + "\",";
strToJson += "\"MenuParentNo\":null,";
DataRow[] drChileList = dtUserMenu.Select(" PARENT_ID='" + strPID + "'", "ORDER_ID ASC");
if (drChileList.Length > 0)
{
strToJson += "\"children\":[";
for (int i = 0; i < drChileList.Length; i++)
{
DataRow drchild = drChileList[i];
if (i > 0)
{
strToJson += ",";
}
string strChildID = drchild["ID"].ToString();
string strChildMenuText = drchild["MENU_TEXT"].ToString();
string strChildMenuUrl = drchild["MENU_URL"].ToString();
strToJson += "{";
strToJson += "\"id\":\"" + strChildID + "\",";
strToJson += "\"MenuName\":\"" + strChildMenuText + "\",";
strToJson += "\"MenuID\":\"" + strChildID + "\",";
strToJson += "\"text\":\"" + strChildMenuText + "\",";
//strToJson += "\"MenuUrl\":\"" + strChildMenuUrl + "\",";
strToJson += "\"MenuUrl\":\"" + AddUrlUserParams(strChildMenuUrl, user) + "\",";
strToJson += "\"MenuNo\":\"" + strChildID + "\",";
strToJson += "\"MenuParentNo\":\"" + strPID + "\"";
strToJson += "}";
}
strToJson += "]";
}
strToJson += "}";
}
return(strToJson);
}
/// <summary>
/// 特定方法
/// 根据指定用户获取合法菜单
/// </summary>
/// <param name="strUserID"></param>
/// <returns></returns>
public DataTable GetMenuByUserID(TSysMenuVo tSysMenu, string strUserID)
{
return(access.GetMenuByUserID(tSysMenu, strUserID));
}
/// <summary>
/// 特定方法
/// 根据指定用户获取合法菜单
/// </summary>
/// <param name="tSysMenu"></param>
/// <param name="strUserName"></param>
/// <returns></returns>
public DataTable GetMenuByUserName(TSysMenuVo tSysMenu, string strUserName)
{
return(access.GetMenuByUserName(tSysMenu, strUserName));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TSysMenuVo tSysMenu, int iIndex, int iCount)
{
return(access.SelectByTable(tSysMenu, iIndex, iCount));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <returns>是否成功</returns>
public bool Create(TSysMenuVo tSysMenu)
{
string strSQL = SqlHelper.BuildInsertExpress(tSysMenu, TSysMenuVo.T_SYS_MENU_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tSysMenu"></param>
/// <returns></returns>
public DataTable SelectByTable(TSysMenuVo tSysMenu)
{
return(access.SelectByTable(tSysMenu));
}
/// <summary>
/// 条件修改系统菜单配置
/// </summary>
/// <param name="tSysMenu"></param>
/// <returns></returns>
public bool EditData(TSysMenuVo tSysMenu)
{
return(access.EditData(tSysMenu));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TSysMenuVo tSysMenu)
{
string strSQL = "select Count(*) from T_SYS_MENU " + this.BuildWhereStatement(tSysMenu);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 扩展方法
/// 获取对象DataTable
/// 创建日期：2011-04-19 13:40
/// 创建人 ：郑义
/// 修改日期：2011-04-20 21:10
/// 修改人 ：郑义
/// 修改内容:添加菜单ID查询下级(所有下级)
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <param name="strMainMenuID">主菜单ID</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTableEx(TSysMenuVo tSysMenu, string strMainMenuID, int iIndex, int iCount)
{
return(access.SelectByTableEx(tSysMenu, strMainMenuID, iIndex, iCount));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TSysMenuVo tSysMenu)
{
return(access.Create(tSysMenu));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tSysMenu">对象条件</param>
/// <returns>对象</returns>
public TSysMenuVo Details(TSysMenuVo tSysMenu)
{
string strSQL = String.Format("select * from T_SYS_MENU " + this.BuildWhereStatement(tSysMenu));
return(SqlHelper.ExecuteObject(new TSysMenuVo(), strSQL));
}
public TSysMenuLogic(TSysMenuVo _tSysMenu)
{
tSysMenu = _tSysMenu;
access = new TSysMenuAccess();
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tSysMenu">对象</param>
/// <returns></returns>
public TSysMenuVo SelectByObject(TSysMenuVo tSysMenu)
{
string strSQL = "select * from T_SYS_MENU " + this.BuildWhereStatement(tSysMenu);
return(SqlHelper.ExecuteObject(new TSysMenuVo(), strSQL));
}
