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