public ActionResult AddExceptionType(ExceptionTypeAddModel model) { if (ModelState.IsValid) { var result = ExceptionTypeBLL.AddExceptionType(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "ID:" + model.ID); return(Json(result)); } else { return(PartialView("_AddExceptionType", model)); } }
public static OperationResult AddExceptionType(ExceptionTypeAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ExName", SqlDbType.NVarChar, 10), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.NVarChar, 10) }; paras[0].Value = model.ExName; if (string.IsNullOrWhiteSpace(model.Remark)) { paras[1].Value = DBNull.Value; } else { paras[1].Value = model.Remark; } paras[2].Value = CreateUserID; paras[3].Value = model.ID; #region SQL string sql; #endregion sql = @"INSERT INTO dbo.ExceptionType(ID,ExName,Remark,CreateUserID) VALUES (@ID,@ExName,@Remark,@CreateUserID)"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }