public ActionResult AddMaintenanceRecord(AddMaintenanceRecordModel model) { if (ModelState.IsValid) { var result = MaintenanceRecordBLL.AddMaintenanceRecord(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Add, result, "VehicleName:" + model.VehicleName); return(Json(result)); } else { return(PartialView("_AddMaintenanceRecord", model)); } }
public static OperationResult AddMaintenanceRecord(AddMaintenanceRecordModel model, int currentUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@VehicleID", SqlDbType.BigInt), new SqlParameter("@RecordDetails", SqlDbType.NVarChar), new SqlParameter("@CreateUser", SqlDbType.Int), new SqlParameter("@CreateTime", SqlDbType.DateTime), }; paras[0].Value = model.VehicleID; if (model.RecordDetails == null) { paras[1].Value = DBNull.Value; } else { paras[1].Value = model.RecordDetails; } paras[2].Value = currentUserID; paras[3].Value = DateTime.Now; string sql = @"INSERT INTO dbo.MaintenanceRecord ( [VehicleID] ,[RecordDetails] ,[CreateUser] ,[CreateTime] ) VALUES ( @VehicleID , @RecordDetails, @CreateUser, @CreateTime )"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult AddMaintenanceRecord() { AddMaintenanceRecordModel model = new AddMaintenanceRecordModel(); return(PartialView("_AddMaintenanceRecord", model)); }