/// <summary> /// Create a new Menu /// </summary> /// <param name="menu"></param> public void AddMenu(Entity.Menu menu) { var query = "INSERT INTO Menu VALUES(\"" + null + "\"" + ",\"" + menu.DateElaboration.ToString("yyyy-MM-dd") + "\"" + ",\"" + menu.Categorie + "\"" + ",\"" + menu.Nom + "\"" + ",\"" + menu.Observation + "\"" + ",\"" + menu.IdGerant + "\"" + ")"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
/// <summary> /// Delete an existing Menu /// </summary> /// <param name="menu"></param> public void DeleteMenu(Entity.Menu menu) { var query = "DELETE FROM CompositionMenu WHERE CodeMenu = " + "\"" + menu.CodeMenu + "\"" + ";" + "DELETE FROM Menu WHERE CodeMenu = " + "\"" + menu.CodeMenu + "\""; MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
public Entity.Menu GetTheLastInsertedMenu() { var query = "SELECT * FROM Menu Where CodeMenu=(SELECT MAX(CodeMenu) FROM Menu)"; var mySqlDataReader = _sQLService.Load(query); try { mySqlDataReader.Read(); Entity.Menu menu = new Entity.Menu((int)mySqlDataReader["idGerant"], (DateTime)mySqlDataReader["DateElaboration"], mySqlDataReader["Categorie"] as string, mySqlDataReader["Nom"] as string, mySqlDataReader["Observation"] as string, (int)mySqlDataReader["CodeMenu"]); return(menu); } catch { throw new Exception("Problème lors du chargement du dernier menu !"); } finally { mySqlDataReader.Close(); } }
public void AddPlatToMenu(Entity.Plat plat, Entity.Menu menu) { var query = "INSERT INTO CompositionMenu VALUES(\"" + plat.CodePlat + "\"" + ",\"" + menu.CodeMenu + "\"" + ",\"" + menu.DateElaboration + "\"" + ")"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
/// <summary> /// Get List of Plat by Menu ID /// </summary> /// <param name="menuID"></param> /// <returns></returns> public List <Entity.Plat> GetPlatByMenu(Entity.Menu menu) { var query = "SELECT pl.CodePlat, pl.Prix, pl.DateEffet, pl.DateFin, pl.Categorie, pl.Nom " + "FROM Plat pl, Menu m, CompositionMenu cpm " + "WHERE m.CodeMenu =" + "\"" + menu.CodeMenu + "\"" + "and pl.CodePlat = cpm.CodePlat and m.CodeMenu = cpm.CodeMenu"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { List <Entity.Plat> list = new List <Entity.Plat>(); while (mySqlDataReader.Read()) { Entity.Plat plat = new Entity.Plat((int)mySqlDataReader["CodePlat"], (DateTime)mySqlDataReader["DateEffet"], (DateTime)mySqlDataReader["DateFin"], mySqlDataReader["Categorie"] as string, mySqlDataReader["Nom"] as string, (float)mySqlDataReader["Prix"]); list.Add(plat); } return(list); } catch { throw new Exception("Pas de plats !"); } finally { mySqlDataReader.Close(); } }
/// <summary> /// Get all avalaible Menu /// </summary> /// <returns></returns> public List <Entity.Menu> GetAllMenus() { var query = "SELECT * FROM Menu"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { List <Entity.Menu> list = new List <Entity.Menu>(); while (mySqlDataReader.Read()) { Entity.Menu produit = new Entity.Menu((int)mySqlDataReader["idGerant"], (DateTime)mySqlDataReader["DateElaboration"], mySqlDataReader["Categorie"] as string, mySqlDataReader["Nom"] as string, mySqlDataReader["Observation"] as string, (int)mySqlDataReader["CodeMenu"]); list.Add(produit); } return(list); } catch { throw new Exception("Pas de menus !"); } finally { mySqlDataReader.Close(); } }
/// <summary> /// Modify an existing Menu /// </summary> /// <param name="menu"></param> public void ModifyMenu(Entity.Menu menu) { var query = "UPDATE Menu SET DateElaboration=" + "\"" + menu.DateElaboration.ToString("yyyy-MM-dd") + "\"" + ", Categorie=" + "\"" + menu.Categorie + "\"" + ", Nom=" + "\"" + menu.Nom + "\"" + ", Observation=" + "\"" + menu.Observation + "\"" + ", idGerant=" + "\"" + menu.IdGerant + "\"" + " WHERE CodeMenu= " + "\"" + menu.CodeMenu + "\""; Debug.WriteLine(query); MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
public void DeletePlatfromMenu(Entity.Menu menu, Entity.Plat plat) { var query = "DELETE FROM CompositionMenu WHERE CodePlat=" + "\"" + plat.CodePlat + "\"" + " AND CodeMenu=" + "\"" + menu.CodeMenu + "\""; Debug.Write(query); MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); }
///// <summary> ///// 获取用户菜单 ///// </summary> ///// <param name="cName">用户名</param> ///// <param name="iIsShow">是否显示</param> ///// <param name="iLevle">菜单级别</param> ///// <returns></returns> //public List<Entity.Menu> GetUserMenus(string cName, int iParentID, int iIsShow, int iLevle) //{ // List<Entity.Menu> list = new List<Entity.Menu>(); // Entity.Menu menu = null; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()),cName, 50), // dbFactory.MakeInParam("@iIsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(iIsShow.GetType().ToString()),iIsShow, 0), // dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(iLevle.GetType().ToString()),iLevle, 0), // dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(iParentID.GetType().ToString()),iParentID, 0) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_Query", prams); // while (dataReader.Read()) // { // menu = new Entity.Menu(); // menu.ID = int.Parse(dataReader["ID"].ToString()); // menu.CName = dataReader["CName"].ToString(); // menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); // menu.CDescription = dataReader["cDescription"].ToString(); // menu.CImage = dataReader["cImage"].ToString(); // menu.CUrlPath = dataReader["CUrlPath"].ToString(); // menu.CCode = dataReader["cCode"].ToString(); // menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); // menu.IOrderID = dataReader["iOrderID"].ToString(); // menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); // menu.CRole = dataReader["CRole"].ToString(); // menu.IRight = int.Parse(dataReader["IRight"].ToString()); // menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); // menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); // menu.CCreateUser = dataReader["cCreateUser"].ToString(); // menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); // list.Add(menu); // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return list; //} //public List<Entity.Menu> GetMenuByRole(string cRole) //{ // List<Entity.Menu> list = new List<Entity.Menu>(); // Entity.Menu menu = null; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cRole", DBTypeConverter.ConvertCsTypeToOriginDBType(cRole.GetType().ToString()),cRole, 4000) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_GetByRole", prams); // while (dataReader.Read()) // { // menu = new Entity.Menu(); // menu.ID = int.Parse(dataReader["ID"].ToString()); // menu.CName = dataReader["CName"].ToString(); // menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); // menu.CDescription = dataReader["cDescription"].ToString(); // menu.CImage = dataReader["cImage"].ToString(); // menu.CUrlPath = dataReader["cUrlPath"].ToString(); // menu.CCode = dataReader["cCode"].ToString(); // menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); // menu.IOrderID = dataReader["iOrderID"].ToString(); // menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); // menu.CRole = dataReader["CRole"].ToString(); // menu.IRight = int.Parse(dataReader["IRight"].ToString()); // menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); // menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); // menu.CCreateUser = dataReader["cCreateUser"].ToString(); // menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); // list.Add(menu); // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return list; //} ///// <summary> ///// 增加菜单 ///// </summary> ///// <param name="menu">菜单</param> ///// <returns></returns> //public int AddMenu(Entity.Menu menu) //{ // int iReturn = 0; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // //@cName ,@iParentID ,@cDescription ,@cImage ,@cCode ,@iLevle ,@iOrderID ,@iIsShow ,@dCreateDate ,@cCreateUser ,@dUpdateDate ,@cUpdateUser // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CName.GetType().ToString()),menu.CName, 50), // dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IParentID.GetType().ToString()), menu.IParentID,0), // dbFactory.MakeInParam("@cDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CDescription.GetType().ToString()), menu.CDescription, 0), // dbFactory.MakeInParam("@cImage", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CImage.GetType().ToString()), menu.CImage,500), // dbFactory.MakeInParam("@cUrlPath", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CUrlPath.GetType().ToString()), menu.CUrlPath,0), // dbFactory.MakeInParam("@cCode", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CCode.GetType().ToString()), menu.CCode, 50), // dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.ILevle.GetType().ToString()), menu.ILevle, 0), // dbFactory.MakeInParam("@iOrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IOrderID.GetType().ToString()), menu.IOrderID, 50), // dbFactory.MakeInParam("@iIsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IIsShow.GetType().ToString()), menu.IIsShow, 0), // dbFactory.MakeInParam("@dCreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.DCreateDate.GetType().ToString()), menu.DCreateDate, 0), // dbFactory.MakeInParam("@cCreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CUpdateUser.GetType().ToString()), menu.CUpdateUser, 50), // dbFactory.MakeInParam("@dUpdateDate ", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.DUpdateDate.GetType().ToString()), menu.DUpdateDate, 0), // dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CUpdateUser.GetType().ToString()), menu.CUpdateUser, 50) // }; // iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "[proc_Menu_Add]", prams); // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return iReturn; //} ///// <summary> ///// 删除菜单 ///// </summary> ///// <param name="id">菜单id</param> ///// <returns></returns> //public int DeleteMenu(int id) //{ // int iReturn = 0; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(id.GetType().ToString()),id, 0) // }; // iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "[proc_Menu_Delete]", prams); // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return iReturn; //} ///// <summary> ///// 修改菜单 ///// </summary> ///// <param name="id"></param> ///// <returns></returns> //public int UpdateMenu(Entity.Menu menu) //{ // int iReturn = 0; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CName.GetType().ToString()),menu.CName, 50), // dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IParentID.GetType().ToString()), menu.IParentID,0), // dbFactory.MakeInParam("@cDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CDescription.GetType().ToString()), menu.CDescription, 0), // dbFactory.MakeInParam("@cImage", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CImage.GetType().ToString()), menu.CImage,500), // dbFactory.MakeInParam("@CUrlPath", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CUrlPath.GetType().ToString()), menu.CUrlPath,0), // dbFactory.MakeInParam("@cCode", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CCode.GetType().ToString()), menu.CCode, 50), // dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.ILevle.GetType().ToString()), menu.ILevle, 0), // dbFactory.MakeInParam("@iOrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IOrderID.GetType().ToString()), menu.IOrderID, 50), // dbFactory.MakeInParam("@iIsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.IIsShow.GetType().ToString()), menu.IIsShow, 0), // dbFactory.MakeInParam("@dUpdateDate ", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.DUpdateDate.GetType().ToString()), menu.DUpdateDate, 0), // dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(menu.CUpdateUser.GetType().ToString()), menu.CUpdateUser, 50) // }; // iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "[proc_Menu_Update]", prams); // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return iReturn; //} ///// <summary> ///// 获取子菜单 ///// </summary> ///// <param name="cUserName">用户名</param> ///// <param name="iLevle"></param> ///// <param name="id"></param> ///// <returns></returns> //public List<Entity.Menu> GetMenu(string cUserName, int iLevle, int iParentID, string cRole) //{ // List<Entity.Menu> list = new List<Entity.Menu>(); // Entity.Menu menu = null; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(iLevle.GetType().ToString()),iLevle, 0), // dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(iParentID.GetType().ToString()),iParentID, 0), // dbFactory.MakeInParam("@cRole", DBTypeConverter.ConvertCsTypeToOriginDBType(cRole.GetType().ToString()),cRole, 50) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_Get", prams); // while (dataReader.Read()) // { // menu = new Entity.Menu(); // menu.ID = int.Parse(dataReader["ID"].ToString()); // menu.CName = dataReader["CName"].ToString(); // menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); // menu.CDescription = dataReader["cDescription"].ToString(); // menu.CImage = dataReader["cImage"].ToString(); // menu.CUrlPath = dataReader["CUrlPath"].ToString(); // menu.CCode = dataReader["cCode"].ToString(); // menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); // menu.IOrderID = dataReader["iOrderID"].ToString(); // menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); // menu.CRole = dataReader["CRole"].ToString(); // menu.IRight = int.Parse(dataReader["IRight"].ToString()); // menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); // menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); // menu.CCreateUser = dataReader["cCreateUser"].ToString(); // menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); // menu.BState = IsExistsUsers(cUserName, menu.ID, 0) == true ? 1 : 0; // list.Add(menu); // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return list; //} //public List<Entity.Menu> GetMenu(int iLevle, int iParentID) //{ // List<Entity.Menu> list = new List<Entity.Menu>(); // Entity.Menu menu = null; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(iLevle.GetType().ToString()),iLevle, 0), // dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(iParentID.GetType().ToString()),iParentID, 0) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_Get", prams); // while (dataReader.Read()) // { // menu = new Entity.Menu(); // menu.ID = int.Parse(dataReader["ID"].ToString()); // menu.CName = dataReader["CName"].ToString(); // menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); // menu.CDescription = dataReader["cDescription"].ToString(); // menu.CImage = dataReader["cImage"].ToString(); // menu.CUrlPath = dataReader["CUrlPath"].ToString(); // menu.CCode = dataReader["cCode"].ToString(); // menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); // menu.IOrderID = dataReader["iOrderID"].ToString(); // menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); // menu.CRole = dataReader["CRole"].ToString(); // menu.IRight = int.Parse(dataReader["IRight"].ToString()); // menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); // menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); // menu.CCreateUser = dataReader["cCreateUser"].ToString(); // menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); // list.Add(menu); // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return list; //} //public bool IsExistsUsers(string cUserName, int MenuID, int iType) //{ // int iReturn = 0; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()),cUserName, 50), // dbFactory.MakeInParam("@MenuID", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuID.GetType().ToString()),MenuID, 0), // dbFactory.MakeInParam("@iType", DBTypeConverter.ConvertCsTypeToOriginDBType(iType.GetType().ToString()),iType, 0) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_IsExists", prams); // if (dataReader.Read()) // { // iReturn = 1; // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return iReturn == 1 ? true : false; //} //public Entity.Menu GetUserMenu(string cUserName, string cCode) //{ // Entity.Menu menu = null; // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // IDbDataParameter[] prams = { // dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()),cUserName, 50), // dbFactory.MakeInParam("@cCode", DBTypeConverter.ConvertCsTypeToOriginDBType(cCode.GetType().ToString()),cCode, 50) // }; // IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_GetUser", prams); // while (dataReader.Read()) // { // menu = new Entity.Menu(); // menu.ID = int.Parse(dataReader["ID"].ToString()); // menu.CName = dataReader["CName"].ToString(); // menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); // menu.CDescription = dataReader["cDescription"].ToString(); // menu.CImage = dataReader["cImage"].ToString(); // menu.CUrlPath = dataReader["CUrlPath"].ToString(); // menu.CCode = dataReader["cCode"].ToString(); // menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); // menu.IOrderID = dataReader["iOrderID"].ToString(); // menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); // menu.CRole = dataReader["CRole"].ToString(); // menu.BLuRu = DataHelper.ParseToBoolean(dataReader["BLuRu"].ToString()); // menu.BCheck = DataHelper.ParseToBoolean(dataReader["BCheck"].ToString()); // menu.IRight = int.Parse(dataReader["IRight"].ToString()); // menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); // menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); // menu.CCreateUser = dataReader["cCreateUser"].ToString(); // menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); // } // } // catch (Exception ex) // { // Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); // } // finally // { // db.Conn.Close(); // } // return menu; //} #endregion #region 现用 /// <summary> /// 根据用户名和用户角色获取用户菜单 /// </summary> /// <param name="cName">用户名</param> /// <param name="iIsShow">是否显示</param> /// <param name="iLevle">菜单级别</param> /// <param name="iRole">用户角色</param> /// <returns></returns> public List <Entity.Menu> GetUserRoleMenus(string cUserName, int iParentID, int iIsShow, int iLevle, int iRole) { List <Entity.Menu> list = new List <Entity.Menu>(); Entity.Menu menu = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()), cUserName, 50), dbFactory.MakeInParam("@iIsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(iIsShow.GetType().ToString()), iIsShow, 0), dbFactory.MakeInParam("@iLevle", DBTypeConverter.ConvertCsTypeToOriginDBType(iLevle.GetType().ToString()), iLevle, 0), dbFactory.MakeInParam("@iParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(iParentID.GetType().ToString()), iParentID, 0), dbFactory.MakeInParam("@iRole", DBTypeConverter.ConvertCsTypeToOriginDBType(iRole.GetType().ToString()), iRole, 0), }; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_Menu_QueryRole", prams); while (dataReader.Read()) { menu = new Entity.Menu(); menu.ID = int.Parse(dataReader["ID"].ToString()); menu.CName = dataReader["CName"].ToString(); menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); menu.CDescription = dataReader["cDescription"].ToString(); menu.CImage = dataReader["cImage"].ToString(); menu.CUrlPath = dataReader["CUrlPath"].ToString(); menu.CCode = dataReader["cCode"].ToString(); menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); menu.IOrderID = dataReader["iOrderID"].ToString(); menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); menu.CUrlPath = dataReader["cUrlPath"].ToString(); menu.CRole = dataReader["CRole"].ToString(); menu.IRight = int.Parse(dataReader["IRight"].ToString()); menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); menu.CCreateUser = dataReader["cCreateUser"].ToString(); menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); list.Add(menu); } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(list); }
public List <Entity.Plat> GetPlatByMenu(Entity.Menu menu) { try { return(_platDAL.GetPlatByMenu(menu)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void AddPlatToMenu(Entity.Plat plat, Entity.Menu menu) { try { _menuDAL.AddPlatToMenu(plat, menu); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void DeleteMenu(Entity.Menu menu) { try { _menuDAL.DeleteMenu(menu); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void DeletePlatfromMenu(Entity.Menu menu, Entity.Plat plat) { try { _menuDAL.DeletePlatfromMenu(menu, plat); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void SetMenuDuJour(Entity.Menu menu) { try { _menuDAL.SetMenuDuJour(menu); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 根据用户名和用户角色获取用户菜单 /// </summary> /// <param name="cName">用户名</param> /// <param name="iIsShow">是否显示</param> /// <param name="iLevle">菜单级别</param> /// <param name="iRole">用户角色</param> /// <returns></returns> public List <Entity.Menu> GetUserRoleListMenus(int iRole, int fatherid, int ishow, int checkstr) { List <Entity.Menu> list = new List <Entity.Menu>(); Entity.Menu menu = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; string strSql = "select t_R_Menu.*,t_R_Role.LevelID,t_R_RoleMenu.roleid from t_R_Role,t_R_Menu,t_R_RoleMenu " + " where t_R_Role.RoleID=t_R_RoleMenu.RoleID and " + " t_R_RoleMenu.MenuID=t_R_Menu.ID and " + " t_R_Role.RoleID='" + iRole + "' and " + "t_R_Menu.iParentID='" + fatherid + "' and t_R_Menu.iIsShow='" + ishow + "' and t_R_RoleMenu.checked='" + checkstr + "' order by t_R_Menu.iOrderID"; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams); while (dataReader.Read()) { menu = new Entity.Menu(); menu.ID = int.Parse(dataReader["ID"].ToString()); menu.CName = dataReader["CName"].ToString(); menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); menu.CDescription = dataReader["cDescription"].ToString(); menu.CImage = dataReader["cImage"].ToString(); menu.CUrlPath = dataReader["CUrlPath"].ToString(); menu.CCode = dataReader["cCode"].ToString(); menu.ILevle = int.Parse(dataReader["LevelID"].ToString()); menu.IOrderID = dataReader["iOrderID"].ToString(); menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); menu.CUrlPath = dataReader["cUrlPath"].ToString(); menu.CRole = dataReader["roleid"].ToString(); menu.IRight = int.Parse(dataReader["IRight"].ToString()); //menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); //menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); //menu.CCreateUser = dataReader["cCreateUser"].ToString(); //menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); list.Add(menu); } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(list); }
private void ucEditEvent1_VisibleChanged(object sender, EventArgs e) { try { ucEditEvent21.Visible = true; ucEditEvent21.mcbArtEvent.Items.Clear(); ucEditEvent21.mcbMenuEvent.Items.Clear(); ArtistDAO adao = new ArtistDAO(); foreach (var a in adao.List()) { ucEditEvent21.mcbArtEvent.Items.Add(a.Id + "-" + a.Name); } Artist artista = adao.FindId(int.Parse(global.idarteve)); art = artista.Id.ToString() + "-" + artista.Name.ToString(); MenuDAO mdao = new MenuDAO(); foreach (var m in mdao.List()) { ucEditEvent21.mcbMenuEvent.Items.Add(m.Id + "-" + m.Name); } Entity.Menu menu = mdao.FindId(int.Parse(global.idmenueve)); men = menu.Id.ToString() + "-" + menu.Name.ToString(); subdatebegin = global.begineve.Substring(0, 10); subdateend = global.endeve.Substring(0, 10); subtimebegin1 = global.begineve.Substring(11, 2); subtimebegin2 = global.begineve.Substring(13, 3); subtimebeginf = subtimebegin1 + subtimebegin2; subtimeend1 = global.endeve.Substring(11, 2); subtimeend2 = global.endeve.Substring(13, 3); subtimeendf = subtimeend1 + subtimeend2; ucEditEvent21.txtNameEvent.Text = global.nameeve; ucEditEvent21.txtDescEvent.Text = global.desceve; ucEditEvent21.mdtDateBegin.Text = subdatebegin; ucEditEvent21.mdtDateEnd.Text = subdateend; ucEditEvent21.txtTimeBegin.Text = subtimebeginf; ucEditEvent21.txtTimeEnd.Text = subtimeendf; ucEditEvent21.mcbArtEvent.SelectedItem = art; ucEditEvent21.mcbMenuEvent.SelectedItem = men; } catch (NullReferenceException) { ucEditEvent21.Visible = false; } catch (ArgumentNullException) { ucEditEvent21.Visible = false; } }
/// <summary> /// 根据用户获取菜单可写权限列表 /// </summary> /// <param name="RoleID"></param> /// <returns></returns> public List <Entity.Menu> GetMenusByUserID(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); Entity.Menu menu = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; string sqlStr = "select * from t_R_Menu inner join [t_R_User_IsWrite] on [t_R_User_IsWrite].menuid=t_R_Menu.ID where [t_R_User_IsWrite].userid ='" + UserID + "' and isWrite=1 order by iParentID,iOrderID ASC"; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, sqlStr, prams); while (dataReader.Read()) { menu = new Entity.Menu(); menu.ID = int.Parse(dataReader["ID"].ToString()); menu.CName = dataReader["CName"].ToString(); menu.IParentID = int.Parse(dataReader["iParentID"].ToString()); menu.CDescription = dataReader["cDescription"].ToString(); menu.CImage = dataReader["cImage"].ToString(); menu.CUrlPath = dataReader["CUrlPath"].ToString(); menu.CCode = dataReader["cCode"].ToString(); menu.ILevle = int.Parse(dataReader["iLevle"].ToString()); menu.IOrderID = dataReader["iOrderID"].ToString(); menu.IIsShow = int.Parse(dataReader["iIsShow"].ToString()); menu.CUrlPath = dataReader["cUrlPath"].ToString(); menu.IRight = int.Parse(dataReader["IRight"].ToString()); menu.CUpdateUser = dataReader["cUpdateUser"].ToString(); menu.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString()); menu.CCreateUser = dataReader["cCreateUser"].ToString(); menu.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString()); list.Add(menu); } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(list); }
public void MapTo(Entity.Menu entity) { entity.Name = this.Name; entity.Icon = this.Icon; entity.Level = 1; entity.ParentId = 1; entity.Sort = this.Sort; entity.Url = this.Url; entity.UpdateByUserId = 1; entity.UpdateByUserName = "******"; entity.UpdateTime = DateTime.Now; entity.Description = this.Description; entity.ParentName = this.ParentName; entity.Alias = this.Alias; }
public void SetMenuDuJour(Entity.Menu menu) { try { DateTime today = DateTime.Today; var query = "INSERT INTO DateUtilisation VALUES(\"" + menu.CodeMenu + "\"" + ",\"" + today.ToString("yyyy-MM-dd") + "\"" + ")"; MySqlDataReader mySqlDataReader = _sQLService.Load(query); mySqlDataReader.Close(); } catch { throw new Exception("Menu déjà présent en menu du jour"); } }
public MenuModel(Entity.Menu entity) { this.Id = entity.Id; this.Name = entity.Name; this.Url = entity.Url; this.Alias = entity.Alias; this.Icon = entity.Icon; this.ParentName = entity.ParentName; this.Level = entity.Level; this.Description = entity.Description; this.Sort = entity.Sort; this.CreateTime = entity.CreateTime; this.CreateByUserName = entity.CreateByUserName; this.UpdateTime = entity.UpdateTime; this.UpdateByUserName = entity.UpdateByUserName; }
public async Task <ApiResponse> Add(Entity.Menu entity) { var serviceStatus = await this.menuService.Add(entity); if (serviceStatus.Status == Core.Util.Enums.Status.Success) { return(new ApiResponse { Data = serviceStatus.Data, Message = serviceStatus.Message, StatusCode = 200 }); } else { return(new ApiResponse { Message = serviceStatus.Message, StatusCode = 500 }); } }
public async Task <ApiResponse> Update(Entity.Menu entity) { var searchInContext = await this.menuService.Get(x => x.Id == entity.Id); if (searchInContext.Status == Status.Empty) { return(new ApiResponse { Message = searchInContext.Message, StatusCode = 203, DataStatus = false }); } else if (searchInContext.Status == Status.Error) { return(new ApiResponse { Message = searchInContext.Message, StatusCode = 500, DataStatus = false }); } else if (searchInContext.Status == Status.Success) { var orginalUpdate = await this.menuService.Update(entity); if (orginalUpdate.Status == Core.Util.Enums.Status.Success) { return(new ApiResponse { Data = orginalUpdate.Data, Message = orginalUpdate.Message, StatusCode = 200, DataStatus = true }); } else { return(new ApiResponse { Message = orginalUpdate.Message, StatusCode = 500, DataStatus = false }); } } else { return(new ApiResponse { Message = "Servis Erişim Hatası", StatusCode = 500, DataStatus = false }); } }
public List <Entity.Menu> GetMenusDuJour() { DateTime today = DateTime.Today; var query = "SELECT m.CodeMenu, DateElaboration, Categorie, Nom, Observation, idGerant " + "FROM Menu m, DateUtilisation du " + "WHERE m.CodeMenu=du.CodeMenu AND du.DateUtilisation=" + "\"" + today.ToString("yyyy-MM-dd") + "\""; MySqlDataReader mySqlDataReader = _sQLService.Load(query); try { List <Entity.Menu> list = new List <Entity.Menu>(); while (mySqlDataReader.Read()) { Entity.Menu produit = new Entity.Menu((int)mySqlDataReader["idGerant"], (DateTime)mySqlDataReader["DateElaboration"], mySqlDataReader["Categorie"] as string, mySqlDataReader["Nom"] as string, mySqlDataReader["Observation"] as string, (int)mySqlDataReader["CodeMenu"]); list.Add(produit); } return(list); } catch { throw new Exception("Problème lors du chargement des menus du jour !"); } finally { mySqlDataReader.Close(); } }
protected void btn_save_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(sGuid)) { //Add Entity.RoleMenu roleMenu = new Entity.RoleMenu(); roleMenu.role.RoleName = txt_RoleName.Text; roleMenu.role.Description = txt_Description.Text; string[] checkmenus = Tree2.GetCheckedNodeIDs(); foreach (string checkID in checkmenus) { Entity.Menu menu = new Entity.Menu(); menu.ID = int.Parse(checkID.ToString()); roleMenu.menuList.Add(menu); } int success = DAL.RoleMenu.AddRoleMenu(roleMenu); if (success == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop("保存失败!", MessageBoxIcon.Warning); } } else { //Update Entity.RoleMenu roleMenu = new Entity.RoleMenu(); roleMenu.role.ID = int.Parse(sGuid); roleMenu.role.RoleName = txt_RoleName.Text; roleMenu.role.Description = txt_Description.Text; string[] checkmenus = Tree2.GetCheckedNodeIDs(); int[] check = new int[checkmenus.Length]; for (int i = 0; i < checkmenus.Length; i++) { check[i] = int.Parse(checkmenus[i]); } StringBuilder sb = new StringBuilder(); Entity.RoleMenu rolemenu = DAL.RoleMenu.GetRoleMenu(sGuid); txt_RoleName.Text = rolemenu.role.RoleName; txt_Description.Text = rolemenu.role.Description; foreach (Entity.Menu menu in rolemenu.menuList) { int menuID = menu.ID; FineUI.TreeNode tn = Tree2.FindNode(menuID.ToString()); tn.Checked = true; sb.Append(menuID.ToString() + ","); } old = sb.ToString().Substring(0, sb.Length - 1); string[] oldIds = old.Split(','); int[] oldid = new int[oldIds.Length]; for (int s = 0; s < oldIds.Length; s++) { oldid[s] = int.Parse(oldIds[s]); } List <int> Checked = new List <int>(); for (int i = 0; i < checkmenus.Length; i++) { Checked.Add(int.Parse(checkmenus[i])); } List <int> OldID = new List <int>(); for (int i = 0; i < oldIds.Length; i++) { OldID.Add(int.Parse(oldIds[i])); } List <int> Delete = ListHelper.ExceptList(OldID, Checked); List <int> Add = ListHelper.ExceptList(Checked, OldID); foreach (int a in Delete) { roleMenu.Delete.Add(a.ToString()); } foreach (int b in Add) { roleMenu.NewAdd.Add(b.ToString()); } //var c = oldid.Intersect(check); //var d = oldid.Except(check); //var f = check.Except(oldid); //foreach (var q in d) //{ // roleMenu.Delete.Add(q.ToString()); //} //foreach (var w in f) //{ // roleMenu.NewAdd.Add(w.ToString()); //} int success = DAL.RoleMenu.UpdateRoleMenu(roleMenu); if (success == 1) { Alert.ShowInTop(" 修改成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop("修改失败!", MessageBoxIcon.Warning); } } }
/// <summary> /// UpdateMenu /// </summary> /// <param name="m"></param> /// <returns></returns> public int UpdateMenu(Entity.Menu m) { try { int code = -1; using (SqlConnection connection = new SqlConnection(connectString)) { connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandTimeout = Constants.TIMOUT_CONNECT_SQL; cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_Menu_Update"; cmd.Parameters.Add("@MenuId", SqlDbType.Int); cmd.Parameters["@MenuId"].Value = m.menuId; cmd.Parameters.Add("@MenuName", SqlDbType.NVarChar, 150); cmd.Parameters["@MenuName"].Value = m.menuName; cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 500); cmd.Parameters["@Description"].Value = m.description; cmd.Parameters.Add("@Icon", SqlDbType.VarChar, 50); cmd.Parameters["@Icon"].Value = m.icon; cmd.Parameters.Add("@Onclick", SqlDbType.VarChar, 1000); cmd.Parameters["@Onclick"].Value = m.onclick; cmd.Parameters.Add("@DisplayIndex", SqlDbType.Int); cmd.Parameters["@DisplayIndex"].Value = m.dislayIndex; cmd.Parameters.Add("@Status", SqlDbType.TinyInt); cmd.Parameters["@Status"].Value = m.status; cmd.Parameters.Add("@Creator", SqlDbType.BigInt); cmd.Parameters["@Creator"].Value = m.creator; cmd.Parameters.Add("@CSS", SqlDbType.NVarChar, -1); cmd.Parameters["@CSS"].Value = m.css; cmd.Parameters.Add("@JS", SqlDbType.NVarChar, -1); cmd.Parameters["@JS"].Value = m.js; cmd.Parameters.Add("@HTML", SqlDbType.NVarChar, -1); cmd.Parameters["@HTML"].Value = m.html; cmd.Parameters.Add("@DatabaseID", SqlDbType.VarChar, 100); cmd.Parameters["@DatabaseID"].Value = m.databaseId != null ? m.databaseId : ""; cmd.Parameters.Add("@SQL_Query", SqlDbType.NVarChar, -1); cmd.Parameters["@SQL_Query"].Value = m.sql_query; cmd.Parameters.Add("@SQL_DataType", SqlDbType.VarChar, 2000); cmd.Parameters["@SQL_DataType"].Value = m.sql_dataType; cmd.Parameters.Add("@Type_Query", SqlDbType.TinyInt); cmd.Parameters["@Type_Query"].Value = m.type_query; cmd.Parameters.Add("@Key", SqlDbType.VarChar, 100); cmd.Parameters["@Key"].Value = Lib.Constants.KEY_SQL; cmd.Parameters.Add("@Code", SqlDbType.Int); cmd.Parameters["@Code"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); code = int.Parse(cmd.Parameters["@Code"].Value.ToString()); } } return(code); } catch (Exception ex) { Lib.Logs.SaveError("Error UpdateMenu", ex); throw new Exception(ex.Message); } }
public static MenuModel Convert(Entity.Menu item) { return(new MenuModel(item)); }