/// <summary>
/// 添加同级节点
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddRoot_Click(object sender, EventArgs e)
{
SysMenuInfo menuInfo = new SysMenuInfo();
if (string.Equals(treelstMenu.FocusedNode.GetValue("Pgid").ToString(), Const.Num_MinusOne.ToString()))
{
menuInfo.Gid = Guid.NewGuid().ToString();
menuInfo.Pgid = Const.Num_MinusOne.ToString();
menuInfo.IsDelete = 0;
menuInfo.IsVisable = 1;
menuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
treelstMenu.FocusedNode = treelstMenu.AppendNode(menuInfo, null);
treelstMenu.FocusedNode.SetValue("Gid", menuInfo.Gid);
treelstMenu.FocusedNode.SetValue("Pgid", menuInfo.Pgid);
treelstMenu.FocusedNode.SetValue("IsDelete", menuInfo.IsDelete);
treelstMenu.FocusedNode.SetValue("IsVisable", menuInfo.IsVisable);
treelstMenu.FocusedNode.SetValue("lstInfo", menuInfo.lstInfo);
}
else
{
menuInfo.Gid = Guid.NewGuid().ToString();
menuInfo.Pgid = treelstMenu.FocusedNode.GetValue("Pgid").ToString();
menuInfo.IsDelete = 0;
menuInfo.IsVisable = 1;
menuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
treelstMenu.FocusedNode = treelstMenu.AppendNode(menuInfo, treelstMenu.FocusedNode.ParentNode);
treelstMenu.FocusedNode.SetValue("Gid", menuInfo.Gid);
treelstMenu.FocusedNode.SetValue("Pgid", menuInfo.Pgid);
treelstMenu.FocusedNode.SetValue("IsDelete", menuInfo.IsDelete);
treelstMenu.FocusedNode.SetValue("IsVisable", menuInfo.IsVisable);
treelstMenu.FocusedNode.SetValue("lstInfo", menuInfo.lstInfo);
}
xmlhelper.InsertElement("datatype/dataitem", "item", string.Format(xmlModel, menuInfo.Gid, menuInfo.Pgid, string.Empty, string.Empty, string.Empty, string.Empty, Const.Num_One.ToString(), string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, Const.Num_Zero.ToString()));
xmlhelper.Save(false);
}
/// <summary>
/// 添加同级节点
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddRoot_Click(object sender, EventArgs e)
{
SysMenuInfo menuInfo = new SysMenuInfo();
if (string.Equals(treelstMenu.FocusedNode.GetValue("PID").ToString(), Const.MinusOne.ToString()))
{
menuInfo.ID = Guid.NewGuid().ToString();
menuInfo.PID = Const.MinusOne.ToString();
menuInfo.Is_Deleted = false;
menuInfo.Visible = true;
menuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
treelstMenu.FocusedNode = treelstMenu.AppendNode(menuInfo, null);
treelstMenu.FocusedNode.SetValue("ID", menuInfo.ID);
treelstMenu.FocusedNode.SetValue("PID", menuInfo.PID);
treelstMenu.FocusedNode.SetValue("Is_Deleted", menuInfo.Is_Deleted);
treelstMenu.FocusedNode.SetValue("Visible", menuInfo.Visible);
treelstMenu.FocusedNode.SetValue("lstInfo", menuInfo.lstInfo);
}
else
{
menuInfo.ID = Guid.NewGuid().ToString();
menuInfo.PID = treelstMenu.FocusedNode.GetValue("PID").ToString();
menuInfo.Is_Deleted = false;
menuInfo.Visible = true;
menuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
treelstMenu.FocusedNode = treelstMenu.AppendNode(menuInfo, treelstMenu.FocusedNode.ParentNode);
treelstMenu.FocusedNode.SetValue("ID", menuInfo.ID);
treelstMenu.FocusedNode.SetValue("PID", menuInfo.PID);
treelstMenu.FocusedNode.SetValue("Is_Deleted", menuInfo.Is_Deleted);
treelstMenu.FocusedNode.SetValue("Visible", menuInfo.Visible);
treelstMenu.FocusedNode.SetValue("lstInfo", menuInfo.lstInfo);
}
xmlhelper.InsertElement("datatype", "item", string.Format(xmlModel, menuInfo.ID, menuInfo.PID, string.Empty, string.Empty, string.Empty, string.Empty, Const.One.ToString(), string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, Const.Zero.ToString()));
xmlhelper.Save(false);
}
public virtual IList <SysMenuInfo> GetSysMenus(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SysMenuInfo> entitys = null;
SysMenuInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Sys_Menu";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SysMenuInfo>();
while (RdrList.Read())
{
entity = new SysMenuInfo();
entity.Sys_Menu_ID = Tools.NullInt(RdrList["Sys_Menu_ID"]);
entity.Sys_Menu_Channel = Tools.NullInt(RdrList["Sys_Menu_Channel"]);
entity.Sys_Menu_Name = Tools.NullStr(RdrList["Sys_Menu_Name"]);
entity.Sys_Menu_ParentID = Tools.NullInt(RdrList["Sys_Menu_ParentID"]);
entity.Sys_Menu_Privilege = Tools.NullStr(RdrList["Sys_Menu_Privilege"]);
entity.Sys_Menu_Icon = Tools.NullStr(RdrList["Sys_Menu_Icon"]);
entity.Sys_Menu_Url = Tools.NullStr(RdrList["Sys_Menu_Url"]);
entity.Sys_Menu_Target = Tools.NullInt(RdrList["Sys_Menu_Target"]);
entity.Sys_Menu_IsSystem = Tools.NullInt(RdrList["Sys_Menu_IsSystem"]);
entity.Sys_Menu_IsDefault = Tools.NullInt(RdrList["Sys_Menu_IsDefault"]);
entity.Sys_Menu_IsCommon = Tools.NullInt(RdrList["Sys_Menu_IsCommon"]);
entity.Sys_Menu_IsActive = Tools.NullInt(RdrList["Sys_Menu_IsActive"]);
entity.Sys_Menu_Sort = Tools.NullInt(RdrList["Sys_Menu_Sort"]);
entity.Sys_Menu_Site = Tools.NullStr(RdrList["Sys_Menu_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditSysMenu(SysMenuInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "7daf4ba3-15af-4c7f-a9f5-ab0f9413ff08"))
{
return(MyDAL.EditSysMenu(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：7daf4ba3-15af-4c7f-a9f5-ab0f9413ff08错误");
}
}
/// <summary>
/// 删除菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DeleteMenus(SysMenuInfo model)
{
try
{
return(sysMenu_Dal.delete(model));
}
catch
{
throw;
}
}
/// <summary>
/// 新增菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMenus(SysMenuInfo model)
{
try
{
return(sysMenu_Dal.Add(model));
}
catch
{
throw;
}
}
public virtual bool AddSysMenu(SysMenuInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "c9ce4dd0-6391-4fb9-aa99-f37c23c04a8a"))
{
return(MyDAL.AddSysMenu(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：c9ce4dd0-6391-4fb9-aa99-f37c23c04a8a错误");
}
}
public virtual IList <SysMenuInfo> GetSysMenusSub(int Menu_ParentID)
{
IList <SysMenuInfo> entitys = null;
SysMenuInfo entity = null;
string SqlList;
SqlDataReader RdrList = null;
try
{
SqlList = "Select * From Sys_Menu Where Sys_Menu_ParentID=" + Menu_ParentID + " order by Sys_Menu_Sort";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SysMenuInfo>();
while (RdrList.Read())
{
entity = new SysMenuInfo();
entity.Sys_Menu_ID = Tools.NullInt(RdrList["Sys_Menu_ID"]);
entity.Sys_Menu_Channel = Tools.NullInt(RdrList["Sys_Menu_Channel"]);
entity.Sys_Menu_Name = Tools.NullStr(RdrList["Sys_Menu_Name"]);
entity.Sys_Menu_ParentID = Tools.NullInt(RdrList["Sys_Menu_ParentID"]);
entity.Sys_Menu_Privilege = Tools.NullStr(RdrList["Sys_Menu_Privilege"]);
entity.Sys_Menu_Icon = Tools.NullStr(RdrList["Sys_Menu_Icon"]);
entity.Sys_Menu_Url = Tools.NullStr(RdrList["Sys_Menu_Url"]);
entity.Sys_Menu_Target = Tools.NullInt(RdrList["Sys_Menu_Target"]);
entity.Sys_Menu_IsSystem = Tools.NullInt(RdrList["Sys_Menu_IsSystem"]);
entity.Sys_Menu_IsDefault = Tools.NullInt(RdrList["Sys_Menu_IsDefault"]);
entity.Sys_Menu_IsCommon = Tools.NullInt(RdrList["Sys_Menu_IsCommon"]);
entity.Sys_Menu_IsActive = Tools.NullInt(RdrList["Sys_Menu_IsActive"]);
entity.Sys_Menu_Sort = Tools.NullInt(RdrList["Sys_Menu_Sort"]);
entity.Sys_Menu_Site = Tools.NullStr(RdrList["Sys_Menu_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
private void map(SysMenuInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.MenuID = Util.TrimIntNull(tempdr["MenuID"]);
oParam.ParentID = Util.TrimIntNull(tempdr["ParentID"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
oParam.SubOrder = Util.TrimIntNull(tempdr["SubOrder"]);
oParam.Name = Util.TrimNull(tempdr["Name"]);
oParam.Description = Util.TrimNull(tempdr["Description"]);
oParam.href = Util.TrimNull(tempdr["href"]);
oParam.help = Util.TrimNull(tempdr["help"]);
oParam.Icon = Util.TrimNull(tempdr["Icon"]);
oParam.Privilege = Util.TrimNull(tempdr["Privilege"]);
}
/// <summary>
/// 列转换成moel
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private SysMenuInfo DataRowTableToSysMenu(DataRow dr)
{
SysMenuInfo sm = new SysMenuInfo();
//ROLEID, ROLENAME, MenuLv, MCaption, Mainnum, ModSeq, MenuLink, MenuImagePath, ItemSeq
sm.MenuID = int.Parse(dr["MenuID"].ToString());
sm.MainNum = dr["Mainnum"].ToString();
sm.MenuName = dr["MCaption"].ToString();
sm.FuncPageNum = dr["ModSeq"].ToString();
sm.Index = int.Parse(dr["ItemSeq"].ToString());
sm.MenuLv = int.Parse(dr["MenuLv"].ToString());
sm.ImageUrl = dr["MenuImagePath"].ToString();
return(sm);
}
private void map(SysMenuInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.MenuID = Util.TrimIntNull(tempdr["MenuID"]);
oParam.ParentID = Util.TrimIntNull(tempdr["ParentID"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
oParam.SubOrder = Util.TrimIntNull(tempdr["SubOrder"]);
oParam.Name = Util.TrimNull(tempdr["Name"]);
oParam.Description = Util.TrimNull(tempdr["Description"]);
oParam.href = Util.TrimNull(tempdr["href"]);
oParam.help = Util.TrimNull(tempdr["help"]);
oParam.Icon = Util.TrimNull(tempdr["Icon"]);
oParam.Privilege = Util.TrimNull(tempdr["Privilege"]);
}
public virtual bool EditSysMenu(SysMenuInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Sys_Menu WHERE Sys_Menu_ID = " + entity.Sys_Menu_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Sys_Menu_ID"] = entity.Sys_Menu_ID;
DrAdd["Sys_Menu_Channel"] = entity.Sys_Menu_Channel;
DrAdd["Sys_Menu_Name"] = entity.Sys_Menu_Name;
DrAdd["Sys_Menu_ParentID"] = entity.Sys_Menu_ParentID;
DrAdd["Sys_Menu_Privilege"] = entity.Sys_Menu_Privilege;
DrAdd["Sys_Menu_Icon"] = entity.Sys_Menu_Icon;
DrAdd["Sys_Menu_Url"] = entity.Sys_Menu_Url;
DrAdd["Sys_Menu_Target"] = entity.Sys_Menu_Target;
DrAdd["Sys_Menu_IsSystem"] = entity.Sys_Menu_IsSystem;
DrAdd["Sys_Menu_IsDefault"] = entity.Sys_Menu_IsDefault;
DrAdd["Sys_Menu_IsCommon"] = entity.Sys_Menu_IsCommon;
DrAdd["Sys_Menu_IsActive"] = entity.Sys_Menu_IsActive;
DrAdd["Sys_Menu_Sort"] = entity.Sys_Menu_Sort;
DrAdd["Sys_Menu_Site"] = entity.Sys_Menu_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindData()
{
XmlNodeList xmlNodeLst = xmlhelper.Read("datatype/dataitem");
List <SysMenuInfo> menuInfoList = new List <SysMenuInfo>();
foreach (XmlNode xn1 in xmlNodeLst)
{
SysMenuInfo menuInfo = new SysMenuInfo();
// 将节点转换为元素，便于得到节点的属性值
XmlElement xe = (XmlElement)xn1;
// 得到DataTypeInfo节点的所有子节点
XmlNodeList xnl0 = xe.ChildNodes;
menuInfo.Gid = xnl0.Item(0).InnerText;
menuInfo.Pgid = xnl0.Item(1).InnerText;
menuInfo.Name = xnl0.Item(2).InnerText;
menuInfo.Icon = xnl0.Item(3).InnerText;
menuInfo.Seq = xnl0.Item(4).InnerText;
menuInfo.AuthGid = xnl0.Item(5).InnerText;
menuInfo.IsVisable = (short)(xnl0.Item(6).InnerText == Const.Num_One.ToString() ? 1 : 0);
menuInfo.WinformClass = xnl0.Item(7).InnerText;
menuInfo.Url = xnl0.Item(8).InnerText;
menuInfo.WebIcon = xnl0.Item(9).InnerText;
menuInfo.SystemtypeId = xnl0.Item(10).InnerText;
menuInfo.CreatorId = string.IsNullOrEmpty(xnl0.Item(11).InnerText) ? 0 : xnl0.Item(11).InnerText.ToInt32();
menuInfo.CreatorTime = string.IsNullOrEmpty(xnl0.Item(12).InnerText) ? DateTimeHelper.GetServerDateTime2() : Convert.ToDateTime(xnl0.Item(12).InnerText);
menuInfo.EditorId = string.IsNullOrEmpty(xnl0.Item(13).InnerText) ? 0 : xnl0.Item(13).InnerText.ToInt32();
menuInfo.LastUpdateTime = string.IsNullOrEmpty(xnl0.Item(14).InnerText) ? DateTimeHelper.GetServerDateTime2() : Convert.ToDateTime(xnl0.Item(14).InnerText);
menuInfo.IsDelete = (short)(xnl0.Item(15).InnerText == Const.Num_One.ToString() ? 1 : 0);
menuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
menuInfoList.Add(menuInfo);
}
treelstMenu.KeyFieldName = "Gid";
treelstMenu.ParentFieldName = "Pgid";
treelstMenu.DataSource = menuInfoList;
treelstMenu.Columns["lstInfo"].Visible = false;
treelstMenu.OptionsBehavior.DragNodes = true;
treelstMenu.ForceInitialize();
treelstMenu.BestFitColumns();
}
public virtual SysMenuInfo GetSysMenuByID(int ID)
{
SysMenuInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Sys_Menu WHERE Sys_Menu_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new SysMenuInfo();
entity.Sys_Menu_ID = Tools.NullInt(RdrList["Sys_Menu_ID"]);
entity.Sys_Menu_Channel = Tools.NullInt(RdrList["Sys_Menu_Channel"]);
entity.Sys_Menu_Name = Tools.NullStr(RdrList["Sys_Menu_Name"]);
entity.Sys_Menu_ParentID = Tools.NullInt(RdrList["Sys_Menu_ParentID"]);
entity.Sys_Menu_Privilege = Tools.NullStr(RdrList["Sys_Menu_Privilege"]);
entity.Sys_Menu_Icon = Tools.NullStr(RdrList["Sys_Menu_Icon"]);
entity.Sys_Menu_Url = Tools.NullStr(RdrList["Sys_Menu_Url"]);
entity.Sys_Menu_Target = Tools.NullInt(RdrList["Sys_Menu_Target"]);
entity.Sys_Menu_IsSystem = Tools.NullInt(RdrList["Sys_Menu_IsSystem"]);
entity.Sys_Menu_IsDefault = Tools.NullInt(RdrList["Sys_Menu_IsDefault"]);
entity.Sys_Menu_IsCommon = Tools.NullInt(RdrList["Sys_Menu_IsCommon"]);
entity.Sys_Menu_IsActive = Tools.NullInt(RdrList["Sys_Menu_IsActive"]);
entity.Sys_Menu_Sort = Tools.NullInt(RdrList["Sys_Menu_Sort"]);
entity.Sys_Menu_Site = Tools.NullStr(RdrList["Sys_Menu_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool AddSysMenu(SysMenuInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Sys_Menu";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Sys_Menu_ID"] = entity.Sys_Menu_ID;
DrAdd["Sys_Menu_Channel"] = entity.Sys_Menu_Channel;
DrAdd["Sys_Menu_Name"] = entity.Sys_Menu_Name;
DrAdd["Sys_Menu_ParentID"] = entity.Sys_Menu_ParentID;
DrAdd["Sys_Menu_Privilege"] = entity.Sys_Menu_Privilege;
DrAdd["Sys_Menu_Icon"] = entity.Sys_Menu_Icon;
DrAdd["Sys_Menu_Url"] = entity.Sys_Menu_Url;
DrAdd["Sys_Menu_Target"] = entity.Sys_Menu_Target;
DrAdd["Sys_Menu_IsSystem"] = entity.Sys_Menu_IsSystem;
DrAdd["Sys_Menu_IsDefault"] = entity.Sys_Menu_IsDefault;
DrAdd["Sys_Menu_IsCommon"] = entity.Sys_Menu_IsCommon;
DrAdd["Sys_Menu_IsActive"] = entity.Sys_Menu_IsActive;
DrAdd["Sys_Menu_Sort"] = entity.Sys_Menu_Sort;
DrAdd["Sys_Menu_Site"] = entity.Sys_Menu_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
/// <summary>
/// 获取功能菜单
/// </summary>
/// <returns></returns>
public List <SysMenuInfo> GetMenusList()
{
try
{
DataSet ds = sysMenu_Dal.GetList(null);
if (ds.Tables[0].Rows.Count > 0)
{
List <SysMenuInfo> lsm = new List <SysMenuInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SysMenuInfo sm = DataRowTableToSysMenu(dr);
if (sm.MenuLv == 1)
{
foreach (DataRow cdr in ds.Tables[0].Rows)
{
SysMenuInfo csm = DataRowTableToSysMenu(cdr);
if (csm.MenuLv == 2 && csm.MainNum == sm.MainNum)
{
sm.ChildMenu.Add(csm);
}
}
lsm.Add(sm);
}
}
return(lsm);
}
else
{
return(null);
}
}
catch
{
throw;
}
}
/// <summary>
/// 根据MenuID获取功能菜单
/// </summary>
/// <returns></returns>
public List <SysMenuInfo> GetMenusListByMenuId(string menuId)
{
string strWhere = " MenuID=" + menuId;
try
{
DataSet ds = sysMenu_Dal.GetList(strWhere);
if (ds.Tables[0].Rows.Count > 0)
{
List <SysMenuInfo> lsm = new List <SysMenuInfo>();
SysMenuInfo sm = DataRowTableToSysMenu(ds.Tables[0].Rows[0]);
lsm.Add(sm);
return(lsm);
}
else
{
return(null);
}
}
catch
{
throw;
}
}
public void Update(SysMenuInfo oParam)
{
new SysMenuDac().Update(oParam);
}
public void Insert(SysMenuInfo oParam)
{
new SysMenuDac().Insert(oParam);
}
/// <summary>
/// 根据用户ID获取菜单
/// </summary>
/// <param name="LoginID"></param>
/// <returns></returns>
public List <SysMenuInfo> GetUserMenus(string LoginID)
{
try
{
List <int> rolelist = GetRoleID(LoginID);
if (rolelist.Count > 0)
{
StringBuilder strWhere = new StringBuilder();
for (int i = 0; i < rolelist.Count; i++)
{
if (i == 0)
{
strWhere.Append(string.Format(" RoleID in ('{0}'", rolelist[i]));
}
else if (i != rolelist.Count - 1)
{
strWhere.Append(string.Format(",'{0}'", rolelist[i]));
//continue;
}
if (i == rolelist.Count - 1)
{
strWhere.Append(string.Format(",'{0}' ) ", rolelist[i]));
}
}
DataSet ds = sysMenu_Dal.GetRoleMenuList(strWhere.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
List <SysMenuInfo> lsm = new List <SysMenuInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SysMenuInfo sm = DataRowViewToSysMenu(dr);
if (sm.MenuLv == 1)
{
bool newitem = true;
foreach (SysMenuInfo item in lsm)
{
if (item.MenuID == sm.MenuID)
{
newitem = false;
break;
}
}
if (newitem)
{
foreach (DataRow cdr in ds.Tables[0].Rows)
{
SysMenuInfo csm = DataRowViewToSysMenu(cdr);
if (csm.MenuLv == 2 && csm.MainNum == sm.MainNum)
{
bool newchilditem = true;
foreach (SysMenuInfo childitem in sm.ChildMenu)
{
if (childitem.MenuID == csm.MenuID)
{
newchilditem = false;
break;
}
}
if (newchilditem)
{
sm.ChildMenu.Add(csm);
}
}
}
lsm.Add(sm);
}
}
}
return(lsm);
}
else
{
return(new List <SysMenuInfo>());
}
}
else
{
return(new List <SysMenuInfo>());
}
}
catch
{
throw;
}
}
public int Insert(SysMenuInfo oParam)
{
string sql = @"INSERT INTO Sys_Menu
(MenuID, ParentID, OrderNum, SubOrder, Name, Description, href, help, Icon,
Privilege)
VALUES (@MenuID, @ParentID, @OrderNum, @SubOrder, @Name, @Description, @href, @help, @Icon,
@Privilege)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramMenuID = new SqlParameter("@MenuID", SqlDbType.Int, 4);
SqlParameter paramParentID = new SqlParameter("@ParentID", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramSubOrder = new SqlParameter("@SubOrder", SqlDbType.Int, 4);
SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.NVarChar, 255);
SqlParameter paramhref = new SqlParameter("@href", SqlDbType.NVarChar, 255);
SqlParameter paramhelp = new SqlParameter("@help", SqlDbType.NVarChar, 255);
SqlParameter paramIcon = new SqlParameter("@Icon", SqlDbType.NVarChar, 50);
SqlParameter paramPrivilege = new SqlParameter("@Privilege", SqlDbType.NVarChar, 500);
if (oParam.MenuID != AppConst.IntNull)
{
paramMenuID.Value = oParam.MenuID;
}
else
{
paramMenuID.Value = System.DBNull.Value;
}
if (oParam.ParentID != AppConst.IntNull)
{
paramParentID.Value = oParam.ParentID;
}
else
{
paramParentID.Value = System.DBNull.Value;
}
if (oParam.OrderNum != AppConst.IntNull)
{
paramOrderNum.Value = oParam.OrderNum;
}
else
{
paramOrderNum.Value = System.DBNull.Value;
}
if (oParam.SubOrder != AppConst.IntNull)
{
paramSubOrder.Value = oParam.SubOrder;
}
else
{
paramSubOrder.Value = System.DBNull.Value;
}
if (oParam.Name != AppConst.StringNull)
{
paramName.Value = oParam.Name;
}
else
{
paramName.Value = System.DBNull.Value;
}
if (oParam.Description != AppConst.StringNull)
{
paramDescription.Value = oParam.Description;
}
else
{
paramDescription.Value = System.DBNull.Value;
}
if (oParam.href != AppConst.StringNull)
{
paramhref.Value = oParam.href;
}
else
{
paramhref.Value = System.DBNull.Value;
}
if (oParam.help != AppConst.StringNull)
{
paramhelp.Value = oParam.help;
}
else
{
paramhelp.Value = System.DBNull.Value;
}
if (oParam.Icon != AppConst.StringNull)
{
paramIcon.Value = oParam.Icon;
}
else
{
paramIcon.Value = System.DBNull.Value;
}
if (oParam.Privilege != AppConst.StringNull)
{
paramPrivilege.Value = oParam.Privilege;
}
else
{
paramPrivilege.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramMenuID);
cmd.Parameters.Add(paramParentID);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramSubOrder);
cmd.Parameters.Add(paramName);
cmd.Parameters.Add(paramDescription);
cmd.Parameters.Add(paramhref);
cmd.Parameters.Add(paramhelp);
cmd.Parameters.Add(paramIcon);
cmd.Parameters.Add(paramPrivilege);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Update(SysMenuInfo oParam)
{
string sql = @"UPDATE Sys_Menu
SET MenuID = @MenuID, ParentID = @ParentID, OrderNum = @OrderNum, SubOrder = @SubOrder, Name = @Name,
Description = @Description, href = @href, help = @help, Icon = @Icon, Privilege = @Privilege
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramMenuID = new SqlParameter("@MenuID", SqlDbType.Int, 4);
SqlParameter paramParentID = new SqlParameter("@ParentID", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramSubOrder = new SqlParameter("@SubOrder", SqlDbType.Int, 4);
SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.NVarChar, 255);
SqlParameter paramhref = new SqlParameter("@href", SqlDbType.NVarChar, 255);
SqlParameter paramhelp = new SqlParameter("@help", SqlDbType.NVarChar, 255);
SqlParameter paramIcon = new SqlParameter("@Icon", SqlDbType.NVarChar, 50);
SqlParameter paramPrivilege = new SqlParameter("@Privilege", SqlDbType.NVarChar, 500);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.MenuID != AppConst.IntNull)
{
paramMenuID.Value = oParam.MenuID;
}
else
{
paramMenuID.Value = System.DBNull.Value;
}
if (oParam.ParentID != AppConst.IntNull)
{
paramParentID.Value = oParam.ParentID;
}
else
{
paramParentID.Value = System.DBNull.Value;
}
if (oParam.OrderNum != AppConst.IntNull)
{
paramOrderNum.Value = oParam.OrderNum;
}
else
{
paramOrderNum.Value = System.DBNull.Value;
}
if (oParam.SubOrder != AppConst.IntNull)
{
paramSubOrder.Value = oParam.SubOrder;
}
else
{
paramSubOrder.Value = System.DBNull.Value;
}
if (oParam.Name != AppConst.StringNull)
{
paramName.Value = oParam.Name;
}
else
{
paramName.Value = System.DBNull.Value;
}
if (oParam.Description != AppConst.StringNull)
{
paramDescription.Value = oParam.Description;
}
else
{
paramDescription.Value = System.DBNull.Value;
}
if (oParam.href != AppConst.StringNull)
{
paramhref.Value = oParam.href;
}
else
{
paramhref.Value = System.DBNull.Value;
}
if (oParam.help != AppConst.StringNull)
{
paramhelp.Value = oParam.help;
}
else
{
paramhelp.Value = System.DBNull.Value;
}
if (oParam.Icon != AppConst.StringNull)
{
paramIcon.Value = oParam.Icon;
}
else
{
paramIcon.Value = System.DBNull.Value;
}
if (oParam.Privilege != AppConst.StringNull)
{
paramPrivilege.Value = oParam.Privilege;
}
else
{
paramPrivilege.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramMenuID);
cmd.Parameters.Add(paramParentID);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramSubOrder);
cmd.Parameters.Add(paramName);
cmd.Parameters.Add(paramDescription);
cmd.Parameters.Add(paramhref);
cmd.Parameters.Add(paramhelp);
cmd.Parameters.Add(paramIcon);
cmd.Parameters.Add(paramPrivilege);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public void Insert(SysMenuInfo oParam)
{
new SysMenuDac().Insert(oParam);
}
public int Insert(SysMenuInfo oParam)
{
string sql = @"INSERT INTO Sys_Menu
(MenuID, ParentID, OrderNum, SubOrder, Name, Description, href, help, Icon,
Privilege)
VALUES (@MenuID, @ParentID, @OrderNum, @SubOrder, @Name, @Description, @href, @help, @Icon,
@Privilege)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramMenuID = new SqlParameter("@MenuID", SqlDbType.Int, 4);
SqlParameter paramParentID = new SqlParameter("@ParentID", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramSubOrder = new SqlParameter("@SubOrder", SqlDbType.Int, 4);
SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.NVarChar, 255);
SqlParameter paramhref = new SqlParameter("@href", SqlDbType.NVarChar, 255);
SqlParameter paramhelp = new SqlParameter("@help", SqlDbType.NVarChar, 255);
SqlParameter paramIcon = new SqlParameter("@Icon", SqlDbType.NVarChar, 50);
SqlParameter paramPrivilege = new SqlParameter("@Privilege", SqlDbType.NVarChar, 500);
if (oParam.MenuID != AppConst.IntNull)
paramMenuID.Value = oParam.MenuID;
else
paramMenuID.Value = System.DBNull.Value;
if (oParam.ParentID != AppConst.IntNull)
paramParentID.Value = oParam.ParentID;
else
paramParentID.Value = System.DBNull.Value;
if (oParam.OrderNum != AppConst.IntNull)
paramOrderNum.Value = oParam.OrderNum;
else
paramOrderNum.Value = System.DBNull.Value;
if (oParam.SubOrder != AppConst.IntNull)
paramSubOrder.Value = oParam.SubOrder;
else
paramSubOrder.Value = System.DBNull.Value;
if (oParam.Name != AppConst.StringNull)
paramName.Value = oParam.Name;
else
paramName.Value = System.DBNull.Value;
if (oParam.Description != AppConst.StringNull)
paramDescription.Value = oParam.Description;
else
paramDescription.Value = System.DBNull.Value;
if (oParam.href != AppConst.StringNull)
paramhref.Value = oParam.href;
else
paramhref.Value = System.DBNull.Value;
if (oParam.help != AppConst.StringNull)
paramhelp.Value = oParam.help;
else
paramhelp.Value = System.DBNull.Value;
if (oParam.Icon != AppConst.StringNull)
paramIcon.Value = oParam.Icon;
else
paramIcon.Value = System.DBNull.Value;
if (oParam.Privilege != AppConst.StringNull)
paramPrivilege.Value = oParam.Privilege;
else
paramPrivilege.Value = System.DBNull.Value;
cmd.Parameters.Add(paramMenuID);
cmd.Parameters.Add(paramParentID);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramSubOrder);
cmd.Parameters.Add(paramName);
cmd.Parameters.Add(paramDescription);
cmd.Parameters.Add(paramhref);
cmd.Parameters.Add(paramhelp);
cmd.Parameters.Add(paramIcon);
cmd.Parameters.Add(paramPrivilege);
return SqlHelper.ExecuteNonQuery(cmd);
}
public void Update(SysMenuInfo oParam)
{
new SysMenuDac().Update(oParam);
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
if (treelstMenu.Nodes.Count != Const.Num_Zero)
{
if (MessageDxUtil.ShowYesNoAndTips("系统菜单有原始数据，此次导入会清空原始数据，是否继续？") == System.Windows.Forms.DialogResult.No)
{
return;
}
}
string importFile = FileDialogHelper.OpenExcel(false);
if (!string.IsNullOrEmpty(importFile))
{
// 判断文件是否被占用
if (FileUtil.FileIsUsing(importFile))
{
MessageDxUtil.ShowWarning(string.Format("文件[{0}]被占用，请先关闭文件后再重试!", importFile));
return;
}
DataTable dt = MyXlsHelper.Import(importFile, "系统菜单", 2, 1);
List <SysMenuInfo> lstsysMenuInfo = new List <SysMenuInfo>();
// 如果没有结果集就不在继续
if (dt == null)
{
return;
}
Int32 addRows = 0;
List <String> pushMenu = new List <string>();
pushMenu.Add("-1");
// 先清除全部节点
Int32 rowCount = xmlhelper.Read("datatype/dataitem").Count;
for (Int32 i = 0; i < rowCount; i++)
{
xmlhelper.DeleteByPathNode("datatype/dataitem/item");
xmlhelper.Save(false);
}
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
var sysMenuInfo = new SysMenuInfo();
sysMenuInfo.Gid = Guid.NewGuid().ToString();
sysMenuInfo.Pgid = pushMenu.Last <string>();
sysMenuInfo.Name = dt.Rows[i][0].ToString().TrimStart('﹂');
sysMenuInfo.Icon = dt.Rows[i][1].ToString();
sysMenuInfo.Seq = dt.Rows[i][2].ToString();
sysMenuInfo.AuthGid = dt.Rows[i][3].ToString();
sysMenuInfo.IsVisable = (short)(dt.Rows[i][4].ToString() == "是" ? 1 : 0);
sysMenuInfo.WinformClass = dt.Rows[i][5].ToString();
sysMenuInfo.Url = dt.Rows[i][6].ToString();
sysMenuInfo.WebIcon = dt.Rows[i][7].ToString();
sysMenuInfo.SystemtypeId = dt.Rows[i][8].ToString();
sysMenuInfo.CreatorId = Convert.ToInt32(dt.Rows[i][9]);
sysMenuInfo.CreatorTime = Convert.ToDateTime(dt.Rows[i][10]);
sysMenuInfo.EditorId = Convert.ToInt32(dt.Rows[i][11]);
sysMenuInfo.LastUpdateTime = Convert.ToDateTime(dt.Rows[i][12]);
sysMenuInfo.IsDelete = (short)(dt.Rows[i][13].ToString() == "是" ? 1 : 0);
sysMenuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") < dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
pushMenu.Add(sysMenuInfo.Gid);
}
// 返回到了某个父节点
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") > dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
// 需要多次弹出操作
for (Int32 j = 0; j < (dt.Rows[i][0].ToString().LastIndexOf("﹂") - dt.Rows[i + 1][0].ToString().LastIndexOf("﹂")); j++)
{
pushMenu.RemoveAt(pushMenu.Count - 1);
}
}
addRows++;
lstsysMenuInfo.Add(sysMenuInfo);
xmlhelper.InsertElement("datatype/dataitem", "item", string.Format(xmlModel, sysMenuInfo.Gid, sysMenuInfo.Pgid, sysMenuInfo.Name, sysMenuInfo.Icon, sysMenuInfo.Seq, sysMenuInfo.AuthGid, sysMenuInfo.IsVisable, sysMenuInfo.WinformClass, sysMenuInfo.Url, sysMenuInfo.WebIcon, sysMenuInfo.SystemtypeId, sysMenuInfo.CreatorId, sysMenuInfo.CreatorTime, sysMenuInfo.EditorId, sysMenuInfo.LastUpdateTime, sysMenuInfo.IsDelete));
xmlhelper.Save(false);
}
treelstMenu.DataSource = lstsysMenuInfo;
treelstMenu.Refresh();
ClearValidate();
treelstMenu.ForceInitialize();
treelstMenu.BestFitColumns();
MessageDxUtil.ShowTips(string.Format("成功导入菜单数据{0}条数据", addRows));
}
}
public int Update(SysMenuInfo oParam)
{
string sql = @"UPDATE Sys_Menu
SET MenuID = @MenuID, ParentID = @ParentID, OrderNum = @OrderNum, SubOrder = @SubOrder, Name = @Name,
Description = @Description, href = @href, help = @help, Icon = @Icon, Privilege = @Privilege
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramMenuID = new SqlParameter("@MenuID", SqlDbType.Int, 4);
SqlParameter paramParentID = new SqlParameter("@ParentID", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramSubOrder = new SqlParameter("@SubOrder", SqlDbType.Int, 4);
SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.NVarChar, 255);
SqlParameter paramhref = new SqlParameter("@href", SqlDbType.NVarChar, 255);
SqlParameter paramhelp = new SqlParameter("@help", SqlDbType.NVarChar, 255);
SqlParameter paramIcon = new SqlParameter("@Icon", SqlDbType.NVarChar, 50);
SqlParameter paramPrivilege = new SqlParameter("@Privilege", SqlDbType.NVarChar, 500);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.MenuID != AppConst.IntNull)
paramMenuID.Value = oParam.MenuID;
else
paramMenuID.Value = System.DBNull.Value;
if (oParam.ParentID != AppConst.IntNull)
paramParentID.Value = oParam.ParentID;
else
paramParentID.Value = System.DBNull.Value;
if (oParam.OrderNum != AppConst.IntNull)
paramOrderNum.Value = oParam.OrderNum;
else
paramOrderNum.Value = System.DBNull.Value;
if (oParam.SubOrder != AppConst.IntNull)
paramSubOrder.Value = oParam.SubOrder;
else
paramSubOrder.Value = System.DBNull.Value;
if (oParam.Name != AppConst.StringNull)
paramName.Value = oParam.Name;
else
paramName.Value = System.DBNull.Value;
if (oParam.Description != AppConst.StringNull)
paramDescription.Value = oParam.Description;
else
paramDescription.Value = System.DBNull.Value;
if (oParam.href != AppConst.StringNull)
paramhref.Value = oParam.href;
else
paramhref.Value = System.DBNull.Value;
if (oParam.help != AppConst.StringNull)
paramhelp.Value = oParam.help;
else
paramhelp.Value = System.DBNull.Value;
if (oParam.Icon != AppConst.StringNull)
paramIcon.Value = oParam.Icon;
else
paramIcon.Value = System.DBNull.Value;
if (oParam.Privilege != AppConst.StringNull)
paramPrivilege.Value = oParam.Privilege;
else
paramPrivilege.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramMenuID);
cmd.Parameters.Add(paramParentID);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramSubOrder);
cmd.Parameters.Add(paramName);
cmd.Parameters.Add(paramDescription);
cmd.Parameters.Add(paramhref);
cmd.Parameters.Add(paramhelp);
cmd.Parameters.Add(paramIcon);
cmd.Parameters.Add(paramPrivilege);
return SqlHelper.ExecuteNonQuery(cmd);
}
/// <summary>
/// 获取角色功能菜单
/// </summary>
/// <param name="RoleID">角色ID</param>
/// <returns></returns>
public List <SysMenuInfo> GetUserRoleMenus(string RoleID)
{
if (string.IsNullOrEmpty(RoleID))
{
return(null);
}
string strWhere = "RoleID='" + RoleID + "'";
try
{
DataSet ds = sysMenu_Dal.GetRoleMenuList(strWhere);
if (ds.Tables[0].Rows.Count > 0)
{
List <SysMenuInfo> lsm = new List <SysMenuInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SysMenuInfo sm = DataRowViewToSysMenu(dr);
if (sm.MenuLv == 1)
{
bool newitem = true;
foreach (SysMenuInfo item in lsm)
{
if (item.MenuID == sm.MenuID)
{
newitem = false;
break;
}
}
if (newitem)
{
foreach (DataRow cdr in ds.Tables[0].Rows)
{
SysMenuInfo csm = DataRowViewToSysMenu(cdr);
if (csm.MenuLv == 2 && csm.MainNum == sm.MainNum)
{
bool newchilditem = true;
foreach (SysMenuInfo childitem in sm.ChildMenu)
{
if (childitem.MenuID == csm.MenuID)
{
newchilditem = false;
break;
}
}
if (newchilditem)
{
sm.ChildMenu.Add(csm);
}
}
}
lsm.Add(sm);
}
}
}
return(lsm);
}
else
{
return(null);
}
}
catch
{
throw;
}
}
