private SmartDeviceHelper() { Table = "t_device"; InsertSql = "INSERT INTO `t_device` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Code`, `CategoryId`, `ModelId`, `Remark`, `Priority`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Code, @CategoryId, @ModelId, @Remark, @Priority);"; UpdateSql = "UPDATE `t_device` SET `MarkedDateTime` = @MarkedDateTime, `State` = @State, `Code` = @Code, `CategoryId` = @CategoryId, `ModelId` = @ModelId, `Remark` = @Remark, `Priority` = @Priority WHERE `Id` = @Id;"; SameField = "Code"; MenuFields.AddRange(new[] { "Id", "Code" }); //MenuQueryFields.AddRange(new[] { "Id", "WorkshopId" }); }
private MonitoringProcessHelper() { Table = "npc_monitoring_process"; InsertSql = "INSERT INTO `npc_monitoring_process` (`Time`, `DeviceId`, `State`, `ProcessCount`, `TotalProcessCount`, `ProcessTime`, `TotalProcessTime`, `RunTime`, `TotalRunTime`, `Use`, `Total`, `Rate`) " + "VALUES (@Time, @DeviceId, @State, @ProcessCount, @TotalProcessCount, @ProcessTime, @TotalProcessTime, @RunTime, @TotalRunTime, @Use, @Total, @Rate);"; UpdateSql = "UPDATE `npc_monitoring_process` SET `State` = @State, `ProcessCount` = @ProcessCount, `TotalProcessCount` = @TotalProcessCount, `ProcessTime` = @ProcessTime, " + "`TotalProcessTime` = @TotalProcessTime, `RunTime` = @RunTime, `TotalRunTime` = @TotalRunTime, `Use` = @Use, `Total` = @Total, `Rate` = @Rate WHERE `Time` = @Time AND `DeviceId` = @DeviceId;"; SameField = "Time"; MenuFields.AddRange(new[] { "Id", "Time", "DeviceId" }); }
private WorkshopHelper() { Table = "workshop"; InsertSql = "INSERT INTO `workshop` (`CreateUserId`, `MarkedDateTime`, `Name`, `Abbrev`, `Shifts`, `ShiftNames`, `ShiftTimes`) " + "VALUES (@CreateUserId, @MarkedDateTime, @Name, @Abbrev, @Shifts, @ShiftNames, @ShiftTimes);"; UpdateSql = "UPDATE `workshop` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `Abbrev` = @Abbrev, `Shifts` = @Shifts, " + "`ShiftNames` = @ShiftNames, `ShiftTimes` = @ShiftTimes, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private SmartProcessCodeHelper() { Table = "t_process_code"; InsertSql = "INSERT INTO `t_process_code` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Code`, `CategoryId`, `List`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Code, @CategoryId, @List, @Remark);"; UpdateSql = "UPDATE `t_process_code` SET `MarkedDateTime` = @MarkedDateTime, `Code` = @Code, `CategoryId` = @CategoryId, `List` = @List, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Code"; MenuFields.AddRange(new[] { "Id", "Code" }); }
private AccountInfoHelper() { Table = "account"; InsertSql = "INSERT INTO account (`Account`, `Password`, `Name`, `Enable`, `Role`, `Belong`, `Platform`, `Phone`, `EmailType`, `EmailAddress`, `SelfPermissions`, `AllDevice`, `DeviceIds`, `Default`) " + "VALUES (@Account, @Password, @Name, @Enable, @Role, @Belong, @Platform, @Phone, @EmailType, @EmailAddress, @SelfPermissions, @AllDevice, @DeviceIds, @Default);"; UpdateSql = "UPDATE account SET `Password` = @Password, `Name` = @Name, `Role` = @Role, `Belong` = @Belong, `Platform` = @Platform, `Phone` = @Phone, `EmailType` = @EmailType, `EmailAddress` = @EmailAddress, " + "`SelfPermissions` = @SelfPermissions, `AllDevice` = @AllDevice, `DeviceIds` = @DeviceIds, `Default` = @Default WHERE `Id` = @Id;"; SameField = "Account"; MenuFields.AddRange(new[] { "Id", "Account", "Name", "Phone", "Number" }); }
private UsuallyDictionaryTypeHelper() { Table = "usually_dictionary_type"; InsertSql = "INSERT INTO usually_dictionary (`CreateUserId`, `MarkedDateTime`, `ScriptId`, `VariableNameId`, `VariableTypeId`, `DictionaryId`) " + "VALUES (@CreateUserId, @MarkedDateTime, @ScriptId, @VariableNameId, @VariableTypeId, @DictionaryId);"; UpdateSql = "UPDATE usually_dictionary SET `MarkedDateTime` = @MarkedDateTime, `VariableName` = @VariableName, `StatisticType` = @StatisticType WHERE `Id` = @Id;"; SameField = "VariableNameId"; MenuFields.AddRange(new[] { "Id", "ScriptId", "VariableNameId", "DictionaryId", "VariableTypeId" }); }
private AccountInfoHelper() { Table = "accounts"; InsertSql = "INSERT INTO accounts (`Account`, `Password`, `Name`, `Role`, `Phone`, `EmailType`, `EmailAddress`, `MarkedDelete`, `SelfPermissions`, `AllDevice`, `DeviceIds`, `Default`, `ProductionRole`, `MaxProductionRole`) " + "VALUES (@Account, @Password, @Name, @Role, @Phone, @EmailType, @EmailAddress, @MarkedDelete, @SelfPermissions, @AllDevice, @DeviceIds, @Default, @ProductionRole, @MaxProductionRole);"; UpdateSql = "UPDATE accounts SET `Password` = @Password, `Name` = @Name, `Role` = @Role, `Phone` = @Phone, `EmailType` = @EmailType, `EmailAddress` = @EmailAddress, `MarkedDelete` = @MarkedDelete, " + "`SelfPermissions` = @SelfPermissions, `AllDevice` = @AllDevice, `DeviceIds` = @DeviceIds, `Default` = @Default, `ProductionRole` = @ProductionRole, `MaxProductionRole` = @MaxProductionRole WHERE `Id` = @Id;"; SameField = "Account"; MenuFields.AddRange(new[] { "Id", "WorkshopId", "Account", "Name", "Phone", "Number" }); }
private MaterialPriceHelper() { Table = ""; InsertSql = ""; UpdateSql = ""; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private SmartProductHelper() { Table = "t_product"; InsertSql = "INSERT INTO `t_product` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Product`, `CategoryId`, `CapacityId`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Product, @CategoryId, @CapacityId, @Remark);"; UpdateSql = "UPDATE `t_product` SET `MarkedDateTime` = @MarkedDateTime, `Product` = @Product, `CategoryId` = @CategoryId, `CapacityId` = @CapacityId, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Product"; MenuFields.AddRange(new[] { "Id", "Product" }); }
private SmartProcessHelper() { Table = "t_process"; InsertSql = "INSERT INTO `t_process` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Process`, `CategoryId`, `Order`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Process, @CategoryId, @Order, @Remark);"; UpdateSql = "UPDATE `t_process` SET `MarkedDateTime` = @MarkedDateTime, `Process` = @Process, `CategoryId` = @CategoryId, `Order` = @Order, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Process"; MenuFields.AddRange(new[] { "Id", "Process", "Order" }); }
private DeviceFirmwareHelper() { Table = "device_firmware"; InsertSql = "INSERT INTO `device_firmware` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `VarNumber`, `Protocol`, `FilePath`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @VarNumber, @Protocol, @FilePath, @Remark);"; UpdateSql = "UPDATE `device_firmware` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `VarNumber` = @VarNumber, `Protocol` = @Protocol, `FilePath` = @FilePath, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private DeviceCategoryHelper() { Table = "device_category"; InsertSql = "INSERT INTO `device_category` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @Remark);"; UpdateSql = "UPDATE `device_category` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private OrderHelper() { Table = "order"; InsertSql = "INSERT INTO `order` (`CreateUserId`, `MarkedDateTime`, `Number`, `ExNumber`, `State`, `List`, `CreatorId`, `CreateTime`, `DeliveryTime`, `Count`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @Number, @ExNumber, @State, @List, @CreatorId, @CreateTime, IF(@DeliveryTime = '0001-01-01 00:00:00', NULL, @DeliveryTime), @Count, @Remark);"; UpdateSql = "UPDATE `order` SET `MarkedDateTime` = @MarkedDateTime, `ExNumber` = @ExNumber, `List` = @List, `DeliveryTime` = IF(@DeliveryTime = '0001-01-01 00:00:00', `DeliveryTime`, @DeliveryTime), `Count` = @Count, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "ExNumber"; MenuFields.AddRange(new[] { "Id", "Number", "ExNumber" }); }
private NotifyGroupHelper() { Table = "notify_group"; InsertSql = "INSERT INTO `notify_group` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `Remark`, `IsEnable`, `Users`, `Notifies`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @Remark, @IsEnable, @Users, @Notifies);"; UpdateSql = "UPDATE `notify_group` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `Remark` = @Remark, `IsEnable` = @IsEnable, `Users` = @Users, `Notifies` = @Notifies WHERE `Id` = @Id;"; SameField = "Category"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private ProcessManagementHelper() { Table = "process_management"; InsertSql = "INSERT INTO `process_management` (`CreateUserId`, `MarkedDateTime`, `ProcessNumber`, `RawMaterial`, `DeviceModels`, `Productions`, `DeviceIds`, `Params`) " + "VALUES (@CreateUserId, @MarkedDateTime, @ProcessNumber, @RawMaterial, @DeviceModels, @Productions, @DeviceIds, @Params);"; UpdateSql = "UPDATE `process_management` SET `MarkedDateTime` = @MarkedDateTime, `ProcessNumber` = @ProcessNumber, `RawMaterial` = @RawMaterial, " + "`DeviceModels` = @DeviceModels, `Productions` = @Productions, `DeviceIds` = @DeviceIds, `Params` = @Params WHERE `Id` = @Id;"; SameField = "ProcessNumber"; MenuFields.AddRange(new[] { "Id", "ProcessNumber" }); }
private ProductionHelper() { Table = "production"; InsertSql = "INSERT INTO production (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `Enable`, `CapacityId`, `TypeId`, `List`, `RateList`, `CostList`, `FlowList`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @Enable, @TypeId, @CapacityId, @List, @RateList, @CostList, @FlowList, @Remark);"; UpdateSql = "UPDATE production SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `TypeId` = @TypeId, `CapacityId` = @CapacityId, `List` = @List, `RateList` = @RateList, `CostList` = @CostList, `FlowList` = @FlowList, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private CapacityHelper() { Table = "capacity"; InsertSql = "INSERT INTO `capacity` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `Enable`, `TypeId`, `List`, `VList`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @Enable, @TypeId, @List, @VList, @Remark);"; UpdateSql = "UPDATE `capacity` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `TypeId` = @TypeId, `List` = @List, `VList` = @VList, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private SmartTaskOrderHelper() { Table = "t_task_order"; InsertSql = "INSERT INTO `t_task_order` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `TaskOrder`, `WorkOrderId`, `ProductId`, `Target`, `DeliveryTime`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @TaskOrder, @WorkOrderId, @ProductId, @Target, @DeliveryTime, @Remark);"; UpdateSql = "UPDATE `t_task_order` SET `MarkedDateTime` = @MarkedDateTime, `TaskOrder` = @TaskOrder, " + "`WorkOrderId` = @WorkOrderId, `ProductId` = @ProductId, `Target` = @Target, `DeliveryTime` = @DeliveryTime, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "TaskOrder"; MenuFields.AddRange(new[] { "Id", "TaskOrder" }); }
/// <summary> /// 计划号生产计划 /// </summary> private ProductionOtherStepHelper() { Table = "production_other_step"; InsertSql = "INSERT INTO `production_other_step` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `StepName`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @StepName);"; UpdateSql = "UPDATE `production_other_step` SET `MarkedDateTime` = @MarkedDateTime, `WorkshopId` = @WorkshopId, `StepName` = @StepName WHERE `Id` = @Id;"; SameField = "Date"; MenuFields.AddRange(new[] { "Id", "WorkshopId", "StepName" }); }
private SmartCapacityHelper() { Table = "t_capacity"; InsertSql = "INSERT INTO `t_capacity` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Capacity`, `CategoryId`, `Number`, `Last`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Capacity, @CategoryId, @Number, @Last, @Remark);"; UpdateSql = "UPDATE `t_capacity` SET `MarkedDateTime` = @MarkedDateTime, `Capacity` = @Capacity, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Capacity"; MenuFields.AddRange(new[] { "Id", "Capacity", "CategoryId", "Category" }); }
/// <summary> /// /// </summary> private ProductionSpecificationHelper() { Table = "production_specification"; InsertSql = "INSERT INTO flowcard_specification (`CreateUserId`, `MarkedDateTime`, `FlowCardId`, `SpecificationName`, `SpecificationValue`) " + "VALUES (@CreateUserId, @MarkedDateTime, @FlowCardId, @SpecificationName, @SpecificationValue);"; UpdateSql = "UPDATE `production_specification` SET `MarkedDateTime` = @MarkedDateTime, `SpecificationName` = @SpecificationName, `SpecificationValue` = @SpecificationValue WHERE `Id` = @Id;"; ParentField = "FlowCardId"; SameField = "Date"; MenuFields.AddRange(new[] { "Id", "FlowCardId", "SpecificationName", "SpecificationValue" }); }
private WorkHelper() { Table = "work"; InsertSql = "INSERT INTO `work` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `WoNumber`, `State`, `CreatorId`, `CreateTime`, `OProductionId`, `EstimatedTime`, `Target`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @WoNumber, @State, @CreatorId, @CreateTime, @OProductionId, IF(@EstimatedTime = '0001-01-01 00:00:00', NULL, @EstimatedTime), @Target, @Remark);"; UpdateSql = "UPDATE `work` SET `MarkedDateTime` = @MarkedDateTime, `EstimatedTime` = IF(@EstimatedTime = '0001-01-01 00:00:00', `EstimatedTime`, @EstimatedTime), `Target` = @Target, `Remark` = @Remark WHERE `Id` = @Id;"; ParentField = "AccountId"; SameField = "AccountId"; MenuFields.AddRange(new[] { "Id", "AccountId" }); }
/// <summary> /// 计划号生产计划 /// </summary> private ProductionStepHelper() { Table = "production_step"; InsertSql = "INSERT INTO `production_step` (`CreateUserId`, `MarkedDateTime`, `ProductionId`, `StepOrder`, `StepId`, `StepRequirements`, `StepRequirementMid`, `StepRequirementMin`, `StepRequirementMax`) " + "VALUES(@CreateUserId, @MarkedDateTime, @ProductionId, @StepOrder, @StepId, @StepRequirements, @StepRequirementMid, @StepRequirementMin, @StepRequirementMax); "; UpdateSql = "UPDATE `production_step` SET `MarkedDateTime` = @MarkedDateTime, `StepOrder` = @StepOrder, `StepRequirements` = @StepRequirements, " + "`StepRequirementMid` = @StepRequirementMid, `StepRequirementMin` = @StepRequirementMin, `StepRequirementMax` = @StepRequirementMax WHERE `Id` = @Id;"; SameField = "Date"; MenuFields.AddRange(new[] { "Id", "StepId", "StepName" }); }
/// <summary> /// 计划号生产计划 /// </summary> private ProductionPlanHelper() { Table = "production_plan"; InsertSql = "INSERT INTO `production_plan` (`Date`, `Production`, `ProductionId`, `StepName`, `StepId`, `CreateUserId`, `MarkedDateTime`, `Plan`, `Change`, `Final`, `Reason`, `Remark`) " + "VALUES (@Date, @Production, @ProductionId, @StepName, @StepId, @CreateUserId, @MarkedDateTime, @Plan, @Change, @Final, @Reason, @Remark);"; UpdateSql = "UPDATE `production_plan` SET `MarkedDateTime` = @MarkedDateTime, `ProductionId` = IF(`ProductionId` = 0, @ProductionId, `ProductionId`), `StepId` = IF(`StepId` = 0, @StepId, `StepId`), `Plan` = @Plan, `Change` = @Change, `Final` = @Final, `Reason` = @Reason, `Remark` = @Remark " + "WHERE `Id` = @Id;"; SameField = "Date"; MenuFields.AddRange(new[] { "Date", "ProductionId", "StepId", "Plan", "Change", "Final" }); }
private DeviceHardwareHelper() { Table = "device_hardware"; InsertSql = "INSERT INTO `device_hardware` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `Name`, `InputNumber`, `OutputNumber`, `DacNumber`, `AdcNumber`, `AxisNumber`, `ComNumber`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @Name, @InputNumber, @OutputNumber, @DacNumber, @AdcNumber, @AxisNumber, @ComNumber, @Remark);"; UpdateSql = "UPDATE `device_hardware` SET `MarkedDateTime` = @MarkedDateTime, `Name` = @Name, `InputNumber` = @InputNumber, `OutputNumber` = @OutputNumber, " + "`DacNumber` = @DacNumber, `AdcNumber` = @AdcNumber, `AxisNumber` = @AxisNumber, `ComNumber` = @ComNumber, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Name"; MenuFields.AddRange(new[] { "Id", "Name" }); }
private FlowCardReportUpdateHelper() { Table = "flowcard_report_update"; InsertSql = "INSERT INTO `flowcard_report_update` (`MarkedDateTime`, `OtherId`, `InsertTime`, `UpdateTime`, `Time`, `Step`, `StepName`, `StepAbbrev`, `FlowCardId`, `FlowCard`, `OldFlowCardId`, `OldFlowCard`, `ProductionId`, `Production`, `DeviceId`, `Code`, `Back`, `ProcessorId`, `Processor`, `Number`, `Total`, `HeGe`, `LiePian`, `Reason`, `State`, `IsUpdate`, `OldData`) " + "VALUES (@MarkedDateTime, @OtherId, @InsertTime, @UpdateTime, @Time, @Step, @StepName, @StepAbbrev, @FlowCardId, @FlowCard, @OldFlowCardId, @OldFlowCard, @ProductionId, @Production, @DeviceId, @Code, @Back, @ProcessorId, @Processor, @Number, @Total, @HeGe, @LiePian, @Reason, @State, @IsUpdate, @OldData);"; UpdateSql = "UPDATE `flowcard_report_update` SET `MarkedDateTime` = @MarkedDateTime, `Total` = @Total, `HeGe` = @HeGe, `LiePian` = @LiePian, `Reason` = @Reason WHERE `Id` = @Id;"; SameField = "FlowCard"; MenuFields.AddRange(new[] { "Id", "FlowCard" }); }
private ProductPlanHelper() { Table = "production_plan"; InsertSql = "INSERT INTO `production_plan` (`CreateUserId`, `MarkedDateTime`, `Plan`, `Order`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @Plan, @Order, @Remark);"; UpdateSql = "UPDATE `production_plan` SET `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `Plan` = @Plan, `Order` = @Order, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Plan"; MenuFields.AddRange(new[] { "Id", "Plan" }); }
private MaterialValuerHelper() { Table = "material_valuer"; InsertSql = "INSERT INTO material_valuer (`CreateUserId`, `MarkedDateTime`, `Valuer`, `Remark`) " + "VALUES (@CreateUserId, @MarkedDateTime, @Valuer, @Remark);"; UpdateSql = "UPDATE `material_valuer` SET `MarkedDateTime` = @MarkedDateTime, `Valuer` = @Valuer, `Remark` = @Remark WHERE `Id` = @Id;"; SameField = "Valuer"; MenuFields.AddRange(new[] { "Id", "Valuer" }); }
private ProductionArgHelper() { Table = "production_arg"; InsertSql = "INSERT INTO `production_arg` (`CreateUserId`, `MarkedDateTime`, `WorkshopId`, `ProductionId`, `FlowId`, `StepId`, `Repeat`, `Para`, `Other`) " + "VALUES (@CreateUserId, @MarkedDateTime, @WorkshopId, @ProductionId, @FlowId, @StepId, @Repeat, @Para, @Other);"; UpdateSql = "UPDATE `production_arg` SET `MarkedDateTime` = @MarkedDateTime, `Repeat` = @Repeat, `Para` = @Para, `Other` = @Other WHERE `Id` = @Id;"; ParentField = "ProductionId"; SameField = "StepId"; MenuFields.AddRange(new[] { "Id", "ProductionId", "StepId" }); }
private ProcessDataHelper() { Table = "process_data"; InsertSql = "INSERT INTO `process_data` (`CreateUserId`, `MarkedDateTime`, `ProcessManagementId`, `ProcessOrder`, `PressurizeMinute`, `PressurizeSecond`, `ProcessMinute`, `ProcessSecond`, `Pressure`, `Speed`) " + "VALUES (@CreateUserId, @MarkedDateTime, @ProcessManagementId, @ProcessOrder, @PressurizeMinute, @PressurizeSecond, @ProcessMinute, @ProcessSecond, @Pressure, @Speed);"; UpdateSql = "UPDATE `process_data` SET `MarkedDateTime` = @MarkedDateTime, `PressurizeMinute` = @PressurizeMinute, `PressurizeSecond` = @PressurizeSecond, " + "`ProcessMinute` = @ProcessMinute, `ProcessSecond` = @ProcessSecond, `Pressure` = @Pressure, `Speed` = @Speed WHERE `Id` = @Id;"; ParentField = "ProcessManagementId"; SameField = ""; MenuFields.AddRange(new[] { "*" }); }