public IActionResult Add()
{
FunctionAddModel model = new FunctionAddModel();
var dal = new FunctionDal();
model.Functions = dal.QueryParentOrderByName();
model.Display = true;
model.Pages = GetPages();
return(View(model));
}
public ActionResult AddFunctionInfo(FunctionAddModel model)
{
if (ModelState.IsValid)
{
var result = FunctionBLL.AddFunction(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Add, result, "FunctionName:" + model.FunctionName);
return(Json(result));
}
else
{
if (model.FunctionIsMenu)
{
var aList = AreaBLL.GetAreas();
model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
model.ActionsSelectList = actionList.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFuncList = FunctionBLL.GetFunctions();
model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName");
return(PartialView("_AddFunctionInfo", model));
}
else
{
int areaID = model.AreaID.Value;
int controllerID = model.ControllerID.Value;
var aList = AreaBLL.GetAreas();
model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
var cList = ControllerBLL.GetControllersByAreaID(areaID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
var actionList = ActionBLL.GetActionsByControllerID(controllerID);
model.ActionsSelectList = actionList.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFuncList = FunctionBLL.GetFunctions();
model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName");
return(PartialView("_AddFunctionInfo", model));
}
}
}
//public ActionResult AddFunctionInfo()
//{
// var aList = AreaBLL.GetAreas();
// FunctionAddModel model = new FunctionAddModel();
// model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
// var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
// model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
// var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
// model.ActionsSelectList = new SelectList(actionList, "ID", "ActionName");
// var parentFuncList = FunctionBLL.GetFunctions();
// model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName");
// return PartialView("_AddFunctionInfo", model);
//}
public ActionResult AddFunctionInfo()
{
var aList = AreaBLL.GetAreas();
FunctionAddModel model = new FunctionAddModel();
model.OrderIndex = Int32.MaxValue;//默认新增的处于最后的位置
model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
//model.ActionsSelectList = actionList.ToSelectListWithEmpty(m => GetSelectListItem(m.ID, m.ActionName));
model.ActionsSelectList = actionList.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFuncList = FunctionBLL.GetFunctions();
model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName", parentFuncList.First().ID);
return(PartialView("_AddFunctionInfo", model));
}
public IActionResult Add(FunctionAddModel model)
{
var dal = new FunctionDal();
FunctionDefinition function = new FunctionDefinition();
function.FunctionId = Guid.NewGuid().ToString("N");
function.ParentId = model.ParentId;
function.Name = model.Name;
function.Icon = model.Icon;
function.Page = model.Page;
function.Display = model.Display;
function.Postion = model.Postion;
try
{
dal.Add(function);
return(Json(1));
}
catch
{
//ViewBag.Message = "";
return(Json(0));
}
}
/// <summary>
/// 新增功能信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static OperationResult AddFunction(FunctionAddModel model, int CreateUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@FunctionName", SqlDbType.NVarChar, 20),
new SqlParameter("@ActionID", SqlDbType.Int),
new SqlParameter("@IsBackground", SqlDbType.Bit),
new SqlParameter("@ParentID", SqlDbType.Int),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderIndex", SqlDbType.Int),
new SqlParameter("CreateUserID", SqlDbType.Int),
new SqlParameter("IsAppFeatures", SqlDbType.Bit),
new SqlParameter("FeaturesCode", SqlDbType.VarChar),
new SqlParameter("IsAppHomeModule", SqlDbType.Bit),
new SqlParameter("IsAppShortcutMenu", SqlDbType.Bit),
};
paras[0].Value = model.FunctionName.Trim();
if (model.FunctionIsMenu)
{
paras[1].Value = DBNull.Value;
}
else
{
paras[1].Value = model.ActionID;
}
paras[2].Value = model.IsBackground;
if (model.IsTopFunction)
{
paras[3].Value = DBNull.Value;
}
else
{
paras[3].Value = model.ParentID;
}
if (string.IsNullOrWhiteSpace(model.Description))
{
paras[4].Value = DBNull.Value;
}
else
{
paras[4].Value = model.Description;
}
paras[5].Value = model.OrderIndex;
paras[6].Value = CreateUserID;
paras[7].Value = model.IsAppFeatures;
if (string.IsNullOrWhiteSpace(model.FeaturesCode))
{
paras[8].Value = DBNull.Value;
}
else
{
paras[8].Value = model.FeaturesCode.Trim();
}
paras[9].Value = model.IsAppHomeModule;
paras[10].Value = model.IsAppShortcutMenu;
string sql = @"INSERT INTO dbo.Functions( FunctionName, ActionID,ParentID,IsBackground,Description,
OrderIndex,CreateUserID, IsAppFeatures,FeaturesCode,IsAppHomeModule,IsAppShortcutMenu)
VALUES ( @FunctionName, @ActionID,@ParentID,@IsBackground,@Description,
@OrderIndex ,@CreateUserID,@IsAppFeatures,@FeaturesCode,@IsAppHomeModule,@IsAppShortcutMenu)";
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
