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[] { "*" });
}
