/// <summary> /// 新增动作信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static OperationResult AddAction(ActionAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ActionName", SqlDbType.NVarChar, 50), new SqlParameter("@ControllerID", SqlDbType.Int), new SqlParameter("@Description", SqlDbType.NVarChar, 50), new SqlParameter("@CreateUserID", SqlDbType.Int) }; paras[0].Value = model.ActionName.Trim(); paras[1].Value = model.ControllerID; if (string.IsNullOrWhiteSpace(model.Description)) { paras[2].Value = DBNull.Value; } else { paras[2].Value = model.Description; } paras[3].Value = CreateUserID; string sql = @"INSERT INTO dbo.Actions( ActionName, ControllerID,Description,CreateUserID )VALUES ( @ActionName, @ControllerID,@Description,@CreateUserID )"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult AddActionInfo(ActionAddModel model) { if (ModelState.IsValid) { var result = ActionBLL.AddAction(model, base.UserIDForLog); base.DoLog(Model.OperationTypeEnum.Add, result, "ActionName:" + model.ActionName); return(Json(result)); } else { int areaID = model.AreaID; var aList = AreaBLL.GetAreas(); model.AreasSelectList = new SelectList(aList, "ID", "AreaName", areaID); var cList = ControllerBLL.GetControllersByAreaID(areaID); model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName", model.ControllerID); return(PartialView("_AddActionInfo", model)); } }