public static int UpdateMenu(Entity.Menu entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@FatherID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FatherID.GetType().ToString()), entity.FatherID, 32), dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuName.GetType().ToString()), entity.MenuName, 50), dbFactory.MakeInParam("@ImageUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ImageUrl.GetType().ToString()), entity.ImageUrl, 0), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuUrl.GetType().ToString()), entity.MenuUrl, 50), dbFactory.MakeInParam("@MenuOrder", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuOrder.GetType().ToString()), entity.MenuOrder, 32), dbFactory.MakeInParam("@MenuFile", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuFile.GetType().ToString()), entity.MenuFile, 50) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Menu_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="MenuID"> </param> /// <returns></returns> public static List <Entity.Menu> GetMenuByUser(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(UserID.GetType().ToString()), UserID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Menu_GetByUser", prams); while (dataReader.Read()) { Entity.Menu entity = new Entity.Menu(); //entity.MenuID = DataHelper.ParseToInt(dataReader["MenuID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); //entity.MenuDescription = dataReader["MenuDescription"].ToString(); //entity.ParentID = DataHelper.ParseToInt(dataReader["ParentID"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static List <Entity.Menu> GetMenuByUserEx(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vUserMenu] where UserID='" + UserID + "'", null); while (dataReader.Read()) { Entity.Menu entity = new Entity.Menu(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.FatherID = DataHelper.ParseToInt(dataReader["FatherID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.ImageUrl = dataReader["ImageUrl"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); entity.MenuOrder = DataHelper.ParseToInt(dataReader["MenuOrder"].ToString()); entity.MenuFile = dataReader["MenuFile"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <returns></returns> public static Entity.RoleMenu GetRoleMenu(string RoleID) { Entity.RoleMenu roleMenu = new Entity.RoleMenu(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from vRoleMenu where RoleID='" + RoleID + "'", null); while (dataReader.Read()) { roleMenu.role.RoleName = dataReader["RoleName"].ToString(); roleMenu.role.Description = dataReader["Description"].ToString(); //roleMenu.role.IsAudit = bool.Parse(dataReader["IsAudit"].ToString()); Entity.Menu entity = new Entity.Menu(); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.ID = DataHelper.ParseToInt(dataReader["MenuID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); roleMenu.menuList.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(roleMenu); }