/// <summary>
/// Récupération de la liste des modules en fonction du logiciel donné
/// </summary>
/// <param name="logiciel">Logiciel lié aux modules</param>
/// <returns>Liste de de module</returns>
public static List <Module> RecupererModules(string logiciel)
{
List <Module> listModule = new List <Module>();
var connectString = Properties.Settings.Default.JobOverviewConnectionString;
string queryString = @"select CodeModule,Libelle from jo.Module
where CodeLogiciel=@logiciel
order by 2";
var param = new SqlParameter("@logiciel", DbType.String);
param.Value = logiciel;
using (var connect = new SqlConnection(connectString))
{
var command = new SqlCommand(queryString, connect);
command.Parameters.Add(param);
connect.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Module mod = new Entity.Module();
mod.CodeModule = (string)reader["CodeModule"];
mod.NomModule = (string)reader["Libelle"];
listModule.Add(mod);
}
}
}
return(listModule);
}
public List <Module> GetCurrentModuleList(List <Module> listModel, Entity.Module currentModule)
{
if (listModel == null)
{
listModel = new List <Module>();
}
if (CurrentModule != null)
{
Entity.Module parentModule = ServiceHelper.GetModuleService.GetEntity(currentModule.ParentID);
if (currentModule.ParentID != 0)
{
GetCurrentModuleList(listModel, parentModule);
}
listModel.Add(currentModule);
}
//listModel.Reverse(0, listModel.Count);
return(listModel);
}
public JsonResult AddMenu(Entity.Module model)
{
IModuleService moduleService = ServiceFactory.Create <IModuleService>();
bool hasExists = false;
//如果Area，Controller,Action都不为空的时候则要检查数据库中是否已经含有这条数据
if (!string.IsNullOrWhiteSpace(model.Area) &&
!string.IsNullOrWhiteSpace(model.Controller) &&
!string.IsNullOrWhiteSpace(model.Action))
{
hasExists = moduleService.Exists(t => t.LinkUrl == model.LinkUrl ||
(t.Area == model.Area &&
t.Controller == model.Controller &&
t.Action == model.Action)
);
}
if (hasExists)
{
return(Json(new Result(false, "添加失败，数据库中已经含有相同Area，Controller,Action的菜单"), JsonRequestBehavior.AllowGet));
}
//如果数据库中没有相同的数据，则添加到数据库中
model.ParentID = string.IsNullOrEmpty(model.ParentID.ToString()) ? 0 : model.ParentID;
model.CreateUserID = CurrentInfo.CurrentUser.ID;
model.CreateTime = DateTime.Now;
model.IsMenu = true;
var addSuccess = moduleService.AddEntity(model);
//返回是否成功
Result result = new Result(addSuccess != null, ResultType.Add);
return(Json(result, JsonRequestBehavior.AllowGet));
}
