/// <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));
}
