public IActionResult CreateNavBarItem()
{
ResponseModel Result = new ResponseModel();
NavBarItemModel model = new NavBarItemModel()
{
ItemName = Request.Form["ItemName"],
ItemController = Request.Form["ItemController"],
ItemAction = Request.Form["ItemAction"],
ItemStatus = Int32.Parse(Request.Form["ItemStatus"])
};
try{
navBarBl = new NavBarBl();
if (navBarBl.CreateNavBarItem(model, ConfigHelper.ConnectionString))
{
Result.HttpStatus = "1";
Result.Message = "OK";
}
else
{
Result.HttpStatus = "0";
Result.Message = "NOK";
}
}
catch (Exception ex) {
Result.HttpStatus = "0";
Result.Message = ex.Message;
}
return(Json(Result));
}
public bool ModifyNavBarItem(NavBarItemModel model, string conn)
{
if (string.IsNullOrWhiteSpace(model.ItemName))
{
throw new System.Exception("名稱未填");
}
if (string.IsNullOrWhiteSpace(model.ItemController))
{
throw new System.Exception("控制器未填");
}
if (string.IsNullOrWhiteSpace(model.ItemAction))
{
throw new System.Exception("方法未填");
}
return(_navBarData.ModifyNavBarItem(model, conn));
}
public virtual async Task <NavBarItemModel> PrepareNavBarItemModelAsync(TblNavBarItems item)
{
NavBarItemModel result;
if (item == null)
{
result = new NavBarItemModel();
}
else
{
result = item.Adapt <NavBarItemModel>();
await item.LoadAllLocalizedStringsToModelAsync(result);
}
return(result);
}
public bool CreateNavBarItem(NavBarItemModel model, string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
bool result = false;
SQLs.Clear();
SQLs.AppendLine("INSERT INTO CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("(ItemName,ItemController,ItemAction,ItemStatus) ");
SQLs.AppendLine("Values ");
SQLs.AppendLine("(@ItemName,'NavBar',@ItemAction,@ItemStatus) ");
object param = new{
ItemName = model.ItemName,
ItemAction = model.ItemAction,
ItemStatus = model.ItemStatus
};
result = sConn.Execute(SQLs.ToString(), param) == 0?false:true;
return(result);
}
}
public virtual async Task <ActionResult> Save(NavBarItemModel model)
{
if (!ModelState.IsValid)
{
return(PartialView("Editor", model));
}
var record = _navBarItemModelFactory.PrepareTblNavBarItems(model);
try
{
if (model.Id == null)
{
//Add new record
await _navBarService.AddAsync(record);
}
else
{
//Edit record
await _navBarService.UpdateAsync(record);
}
await _localizedEntityService.SaveAllLocalizedStringsAsync(record, model);
}
catch (Exception e)
{
var errorCode = ErrorLog.GetDefault(System.Web.HttpContext.Current).Log(new Error(e, System.Web.HttpContext.Current));
ModelState.AddModelError("", string.Format(_localizationService.GetResource("ErrorOnOperation"), e.Message, errorCode));
return(PartialView("Editor", model));
}
return(Content(@"<script language='javascript' type='text/javascript'>
refreshNavBarTreeView();
DestroyEditor();
</script>"));
}
public bool ModifyNavBarItem(NavBarItemModel model, string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
bool result = false;
SQLs.Clear();
SQLs.AppendLine("UPDATE CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("SET ItemName=@ItemName,ItemController=@ItemController, ");
SQLs.AppendLine("ItemAction=@ItemAction,ItemStatus=@ItemStatus ");
SQLs.AppendLine("WHERE ");
SQLs.AppendLine("ID=@ID ");
object param = new{
ID = model.ID,
ItemName = model.ItemName,
ItemController = model.ItemController,
ItemAction = model.ItemAction,
ItemStatus = model.ItemStatus
};
result = sConn.Execute(SQLs.ToString(), param) == 0?false:true;
return(result);
}
}
public virtual TblNavBarItems PrepareTblNavBarItems(NavBarItemModel item)
{
var result = item.Adapt <TblNavBarItems>();
return(result);
}
