public BasPackageApplianceInfo() : base("V_TM_BAS_PACKAGE_APPLIANCE") { List <string> keys = new List <string>(); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField PACKAGE_NOField = new DataSchemaField(); PACKAGE_NOField.Name = "PACKAGE_NO"; PACKAGE_NOField.Type = typeof(string).ToString(); PACKAGE_NOField.Index = 0; fields.Add(PACKAGE_NOField); DataSchemaField PACKAGE_TYPEField = new DataSchemaField(); PACKAGE_TYPEField.Name = "PACKAGE_TYPE"; PACKAGE_TYPEField.Type = typeof(int).ToString(); PACKAGE_TYPEField.Index = 1; fields.Add(PACKAGE_TYPEField); DataSchemaField PACKAGE_CNAMEField = new DataSchemaField(); PACKAGE_CNAMEField.Name = "PACKAGE_CNAME"; PACKAGE_CNAMEField.Type = typeof(string).ToString(); PACKAGE_CNAMEField.Index = 2; fields.Add(PACKAGE_CNAMEField); Schema.Fields = fields.ToArray(); }
public DataItemField(DataSchemaField field) { Name = field.Name; Source = field.Source; Destination = field.Destination; Index = field.Index; Type = field.Type; Skip = field.Skip; AnyAttr = field.AnyAttr; _value = null; }
public WmRfidDoorInfo() : base("TT_CMM_WM_RFID_DOOR") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField WM_NOField = new DataSchemaField(); WM_NOField.Name = "WM_NO"; WM_NOField.Type = typeof(string).ToString(); WM_NOField.Index = 0; fields.Add(WM_NOField); DataSchemaField ZONE_NOField = new DataSchemaField(); ZONE_NOField.Name = "ZONE_NO"; ZONE_NOField.Type = typeof(string).ToString(); ZONE_NOField.Index = 1; fields.Add(ZONE_NOField); DataSchemaField RFID_DOOR_NOField = new DataSchemaField(); RFID_DOOR_NOField.Name = "RFID_DOOR_NO"; RFID_DOOR_NOField.Type = typeof(string).ToString(); RFID_DOOR_NOField.Index = 2; fields.Add(RFID_DOOR_NOField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 3; fields.Add(COMMENTSField); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(int).ToString(); IDField.Index = 4; fields.Add(IDField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 5; fields.Add(PLANTField); Schema.Fields = fields.ToArray(); }
public WmsVmiInboundDataInfo() : base("TI_IFM_WMS_VMI_INBOUND_DATA") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField WERKSField = new DataSchemaField(); WERKSField.Name = "WERKS"; WERKSField.Type = typeof(string).ToString(); WERKSField.Index = 3; fields.Add(WERKSField); DataSchemaField SOURCE_ORDER_CODEField = new DataSchemaField(); SOURCE_ORDER_CODEField.Name = "SOURCE_ORDER_CODE"; SOURCE_ORDER_CODEField.Type = typeof(string).ToString(); SOURCE_ORDER_CODEField.Index = 4; fields.Add(SOURCE_ORDER_CODEField); DataSchemaField SOURCE_ORDER_TYPEField = new DataSchemaField(); SOURCE_ORDER_TYPEField.Name = "SOURCE_ORDER_TYPE"; SOURCE_ORDER_TYPEField.Type = typeof(int).ToString(); SOURCE_ORDER_TYPEField.Index = 5; fields.Add(SOURCE_ORDER_TYPEField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 6; fields.Add(PART_NOField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 7; fields.Add(SUPPLIER_NUMField); DataSchemaField SUPPLIER_NAMEField = new DataSchemaField(); SUPPLIER_NAMEField.Name = "SUPPLIER_NAME"; SUPPLIER_NAMEField.Type = typeof(string).ToString(); SUPPLIER_NAMEField.Index = 8; fields.Add(SUPPLIER_NAMEField); DataSchemaField DELIVERY_QTYField = new DataSchemaField(); DELIVERY_QTYField.Name = "DELIVERY_QTY"; DELIVERY_QTYField.Type = typeof(decimal).ToString(); DELIVERY_QTYField.Index = 9; fields.Add(DELIVERY_QTYField); DataSchemaField WMSSOURCEKEYField = new DataSchemaField(); WMSSOURCEKEYField.Name = "WMSSOURCEKEY"; WMSSOURCEKEYField.Type = typeof(string).ToString(); WMSSOURCEKEYField.Index = 10; fields.Add(WMSSOURCEKEYField); DataSchemaField WMSLINENUMBERField = new DataSchemaField(); WMSLINENUMBERField.Name = "WMSLINENUMBER"; WMSLINENUMBERField.Type = typeof(string).ToString(); WMSLINENUMBERField.Index = 11; fields.Add(WMSLINENUMBERField); DataSchemaField VMIWAREHOUSECODEField = new DataSchemaField(); VMIWAREHOUSECODEField.Name = "VMIWAREHOUSECODE"; VMIWAREHOUSECODEField.Type = typeof(string).ToString(); VMIWAREHOUSECODEField.Index = 12; fields.Add(VMIWAREHOUSECODEField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 13; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 14; fields.Add(PROCESS_TIMEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 15; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 16; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 17; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 18; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 19; fields.Add(MODIFY_USERField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 20; fields.Add(COMMENTSField); Schema.Fields = fields.ToArray(); }
public CostCenterInfo() : base("TM_BAS_COST_CENTER") { List <string> keys = new List <string>(); keys.Add("COST_ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField COST_IDField = new DataSchemaField(); COST_IDField.Name = "COST_ID"; COST_IDField.Type = typeof(long).ToString(); COST_IDField.Index = 0; fields.Add(COST_IDField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 1; fields.Add(PLANTField); DataSchemaField COST_CODEField = new DataSchemaField(); COST_CODEField.Name = "COST_CODE"; COST_CODEField.Type = typeof(string).ToString(); COST_CODEField.Index = 2; fields.Add(COST_CODEField); DataSchemaField COST_NAMEField = new DataSchemaField(); COST_NAMEField.Name = "COST_NAME"; COST_NAMEField.Type = typeof(string).ToString(); COST_NAMEField.Index = 3; fields.Add(COST_NAMEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 4; fields.Add(COMMENTSField); DataSchemaField UPDATE_DATEField = new DataSchemaField(); UPDATE_DATEField.Name = "UPDATE_DATE"; UPDATE_DATEField.Type = typeof(DateTime).ToString(); UPDATE_DATEField.Index = 5; fields.Add(UPDATE_DATEField); DataSchemaField UPDATE_USERField = new DataSchemaField(); UPDATE_USERField.Name = "UPDATE_USER"; UPDATE_USERField.Type = typeof(string).ToString(); UPDATE_USERField.Index = 6; fields.Add(UPDATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 7; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 8; fields.Add(CREATE_USERField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 9; fields.Add(ASSEMBLY_LINEField); DataSchemaField PLANT_ZONEField = new DataSchemaField(); PLANT_ZONEField.Name = "PLANT_ZONE"; PLANT_ZONEField.Type = typeof(string).ToString(); PLANT_ZONEField.Index = 10; fields.Add(PLANT_ZONEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 11; fields.Add(WORKSHOPField); Schema.Fields = fields.ToArray(); }
public PorderLackMaterialInfo() : base("TT_ATP_PORDER_LACK_MATERIAL") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 2; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 3; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 4; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 5; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 6; fields.Add(MODIFY_DATEField); DataSchemaField LACK_ORDER_FIDField = new DataSchemaField(); LACK_ORDER_FIDField.Name = "LACK_ORDER_FID"; LACK_ORDER_FIDField.Type = typeof(Guid).ToString(); LACK_ORDER_FIDField.Index = 7; fields.Add(LACK_ORDER_FIDField); DataSchemaField PRODUCTION_ORDER_FIDField = new DataSchemaField(); PRODUCTION_ORDER_FIDField.Name = "PRODUCTION_ORDER_FID"; PRODUCTION_ORDER_FIDField.Type = typeof(Guid).ToString(); PRODUCTION_ORDER_FIDField.Index = 8; fields.Add(PRODUCTION_ORDER_FIDField); DataSchemaField PRODUCTION_ORDER_NOField = new DataSchemaField(); PRODUCTION_ORDER_NOField.Name = "PRODUCTION_ORDER_NO"; PRODUCTION_ORDER_NOField.Type = typeof(string).ToString(); PRODUCTION_ORDER_NOField.Index = 9; fields.Add(PRODUCTION_ORDER_NOField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 10; fields.Add(PLANTField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 11; fields.Add(ASSEMBLY_LINEField); DataSchemaField LACK_FLAGField = new DataSchemaField(); LACK_FLAGField.Name = "LACK_FLAG"; LACK_FLAGField.Type = typeof(bool).ToString(); LACK_FLAGField.Index = 12; fields.Add(LACK_FLAGField); DataSchemaField ORDER_DATEField = new DataSchemaField(); ORDER_DATEField.Name = "ORDER_DATE"; ORDER_DATEField.Type = typeof(DateTime).ToString(); ORDER_DATEField.Index = 13; fields.Add(ORDER_DATEField); DataSchemaField STATUSField = new DataSchemaField(); STATUSField.Name = "STATUS"; STATUSField.Type = typeof(int).ToString(); STATUSField.Index = 14; fields.Add(STATUSField); Schema.Fields = fields.ToArray(); }
public JisPullOrderDetailInfo() : base("TT_MPM_JIS_PULL_ORDER_DETAIL") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField ORDER_FIDField = new DataSchemaField(); ORDER_FIDField.Name = "ORDER_FID"; ORDER_FIDField.Type = typeof(Guid).ToString(); ORDER_FIDField.Index = 2; fields.Add(ORDER_FIDField); DataSchemaField ORDER_CODEField = new DataSchemaField(); ORDER_CODEField.Name = "ORDER_CODE"; ORDER_CODEField.Type = typeof(string).ToString(); ORDER_CODEField.Index = 3; fields.Add(ORDER_CODEField); DataSchemaField ROW_NOField = new DataSchemaField(); ROW_NOField.Name = "ROW_NO"; ROW_NOField.Type = typeof(int).ToString(); ROW_NOField.Index = 4; fields.Add(ROW_NOField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 5; fields.Add(SUPPLIER_NUMField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 6; fields.Add(PART_NOField); DataSchemaField PART_VERSIONField = new DataSchemaField(); PART_VERSIONField.Name = "PART_VERSION"; PART_VERSIONField.Type = typeof(string).ToString(); PART_VERSIONField.Index = 7; fields.Add(PART_VERSIONField); DataSchemaField PART_CNAMEField = new DataSchemaField(); PART_CNAMEField.Name = "PART_CNAME"; PART_CNAMEField.Type = typeof(string).ToString(); PART_CNAMEField.Index = 8; fields.Add(PART_CNAMEField); DataSchemaField PART_ENAMEField = new DataSchemaField(); PART_ENAMEField.Name = "PART_ENAME"; PART_ENAMEField.Type = typeof(string).ToString(); PART_ENAMEField.Index = 9; fields.Add(PART_ENAMEField); DataSchemaField MEASURING_UNIT_NOField = new DataSchemaField(); MEASURING_UNIT_NOField.Name = "MEASURING_UNIT_NO"; MEASURING_UNIT_NOField.Type = typeof(string).ToString(); MEASURING_UNIT_NOField.Index = 10; fields.Add(MEASURING_UNIT_NOField); DataSchemaField REQUIRED_PART_QTYField = new DataSchemaField(); REQUIRED_PART_QTYField.Name = "REQUIRED_PART_QTY"; REQUIRED_PART_QTYField.Type = typeof(decimal).ToString(); REQUIRED_PART_QTYField.Index = 11; fields.Add(REQUIRED_PART_QTYField); DataSchemaField ACTUAL_PART_QTYField = new DataSchemaField(); ACTUAL_PART_QTYField.Name = "ACTUAL_PART_QTY"; ACTUAL_PART_QTYField.Type = typeof(decimal).ToString(); ACTUAL_PART_QTYField.Index = 12; fields.Add(ACTUAL_PART_QTYField); DataSchemaField VEHICHE_MODEL_NOField = new DataSchemaField(); VEHICHE_MODEL_NOField.Name = "VEHICHE_MODEL_NO"; VEHICHE_MODEL_NOField.Type = typeof(string).ToString(); VEHICHE_MODEL_NOField.Index = 13; fields.Add(VEHICHE_MODEL_NOField); DataSchemaField DAY_VEHICHE_SEQ_NOField = new DataSchemaField(); DAY_VEHICHE_SEQ_NOField.Name = "DAY_VEHICHE_SEQ_NO"; DAY_VEHICHE_SEQ_NOField.Type = typeof(int).ToString(); DAY_VEHICHE_SEQ_NOField.Index = 14; fields.Add(DAY_VEHICHE_SEQ_NOField); DataSchemaField PRODUCTION_NOField = new DataSchemaField(); PRODUCTION_NOField.Name = "PRODUCTION_NO"; PRODUCTION_NOField.Type = typeof(string).ToString(); PRODUCTION_NOField.Index = 15; fields.Add(PRODUCTION_NOField); DataSchemaField INSPECTION_MODEField = new DataSchemaField(); INSPECTION_MODEField.Name = "INSPECTION_MODE"; INSPECTION_MODEField.Type = typeof(int).ToString(); INSPECTION_MODEField.Index = 16; fields.Add(INSPECTION_MODEField); DataSchemaField INSPECTION_FLAGField = new DataSchemaField(); INSPECTION_FLAGField.Name = "INSPECTION_FLAG"; INSPECTION_FLAGField.Type = typeof(bool).ToString(); INSPECTION_FLAGField.Index = 17; fields.Add(INSPECTION_FLAGField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 18; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 19; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 20; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 21; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 22; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 23; fields.Add(MODIFY_USERField); Schema.Fields = fields.ToArray(); }
public PrinterConfigInfo() : base("TM_AUTO_PRINTER_CONFIG") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 2; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 3; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 4; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 5; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 6; fields.Add(MODIFY_DATEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 7; fields.Add(COMMENTSField); DataSchemaField PULL_MODELField = new DataSchemaField(); PULL_MODELField.Name = "PULL_MODEL"; PULL_MODELField.Type = typeof(int).ToString(); PULL_MODELField.Index = 8; fields.Add(PULL_MODELField); DataSchemaField PART_BOX_CODEField = new DataSchemaField(); PART_BOX_CODEField.Name = "PART_BOX_CODE"; PART_BOX_CODEField.Type = typeof(string).ToString(); PART_BOX_CODEField.Index = 9; fields.Add(PART_BOX_CODEField); DataSchemaField PRINT_CONFIG_CODEField = new DataSchemaField(); PRINT_CONFIG_CODEField.Name = "PRINT_CONFIG_CODE"; PRINT_CONFIG_CODEField.Type = typeof(string).ToString(); PRINT_CONFIG_CODEField.Index = 10; fields.Add(PRINT_CONFIG_CODEField); DataSchemaField PRINTER_NAMEField = new DataSchemaField(); PRINTER_NAMEField.Name = "PRINTER_NAME"; PRINTER_NAMEField.Type = typeof(string).ToString(); PRINTER_NAMEField.Index = 11; fields.Add(PRINTER_NAMEField); DataSchemaField PRINTER_IPADDRESSField = new DataSchemaField(); PRINTER_IPADDRESSField.Name = "PRINTER_IPADDRESS"; PRINTER_IPADDRESSField.Type = typeof(string).ToString(); PRINTER_IPADDRESSField.Index = 12; fields.Add(PRINTER_IPADDRESSField); DataSchemaField IS_AUTO_PRINTERField = new DataSchemaField(); IS_AUTO_PRINTERField.Name = "IS_AUTO_PRINTER"; IS_AUTO_PRINTERField.Type = typeof(bool).ToString(); IS_AUTO_PRINTERField.Index = 13; fields.Add(IS_AUTO_PRINTERField); DataSchemaField PAPER_SIZEField = new DataSchemaField(); PAPER_SIZEField.Name = "PAPER_SIZE"; PAPER_SIZEField.Type = typeof(string).ToString(); PAPER_SIZEField.Index = 14; fields.Add(PAPER_SIZEField); DataSchemaField PRINT_DIRECTIONField = new DataSchemaField(); PRINT_DIRECTIONField.Name = "PRINT_DIRECTION"; PRINT_DIRECTIONField.Type = typeof(string).ToString(); PRINT_DIRECTIONField.Index = 15; fields.Add(PRINT_DIRECTIONField); Schema.Fields = fields.ToArray(); }
public TwdPullOrderDetailInfo() : base("TT_MPM_TWD_PULL_ORDER_DETAIL") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField ORDER_FIDField = new DataSchemaField(); ORDER_FIDField.Name = "ORDER_FID"; ORDER_FIDField.Type = typeof(Guid).ToString(); ORDER_FIDField.Index = 2; fields.Add(ORDER_FIDField); DataSchemaField ORDER_CODEField = new DataSchemaField(); ORDER_CODEField.Name = "ORDER_CODE"; ORDER_CODEField.Type = typeof(string).ToString(); ORDER_CODEField.Index = 3; fields.Add(ORDER_CODEField); DataSchemaField ROW_NOField = new DataSchemaField(); ROW_NOField.Name = "ROW_NO"; ROW_NOField.Type = typeof(int).ToString(); ROW_NOField.Index = 4; fields.Add(ROW_NOField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 5; fields.Add(SUPPLIER_NUMField); DataSchemaField WORKSHOP_SECTIONField = new DataSchemaField(); WORKSHOP_SECTIONField.Name = "WORKSHOP_SECTION"; WORKSHOP_SECTIONField.Type = typeof(string).ToString(); WORKSHOP_SECTIONField.Index = 6; fields.Add(WORKSHOP_SECTIONField); DataSchemaField LOCATIONField = new DataSchemaField(); LOCATIONField.Name = "LOCATION"; LOCATIONField.Type = typeof(string).ToString(); LOCATIONField.Index = 7; fields.Add(LOCATIONField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 8; fields.Add(PART_NOField); DataSchemaField PART_VERSIONField = new DataSchemaField(); PART_VERSIONField.Name = "PART_VERSION"; PART_VERSIONField.Type = typeof(string).ToString(); PART_VERSIONField.Index = 9; fields.Add(PART_VERSIONField); DataSchemaField PART_CNAMEField = new DataSchemaField(); PART_CNAMEField.Name = "PART_CNAME"; PART_CNAMEField.Type = typeof(string).ToString(); PART_CNAMEField.Index = 10; fields.Add(PART_CNAMEField); DataSchemaField PART_ENAMEField = new DataSchemaField(); PART_ENAMEField.Name = "PART_ENAME"; PART_ENAMEField.Type = typeof(string).ToString(); PART_ENAMEField.Index = 11; fields.Add(PART_ENAMEField); DataSchemaField MEASURING_UNIT_NOField = new DataSchemaField(); MEASURING_UNIT_NOField.Name = "MEASURING_UNIT_NO"; MEASURING_UNIT_NOField.Type = typeof(string).ToString(); MEASURING_UNIT_NOField.Index = 12; fields.Add(MEASURING_UNIT_NOField); DataSchemaField PACKAGEField = new DataSchemaField(); PACKAGEField.Name = "PACKAGE"; PACKAGEField.Type = typeof(decimal).ToString(); PACKAGEField.Index = 13; fields.Add(PACKAGEField); DataSchemaField PACKAGE_MODELField = new DataSchemaField(); PACKAGE_MODELField.Name = "PACKAGE_MODEL"; PACKAGE_MODELField.Type = typeof(string).ToString(); PACKAGE_MODELField.Index = 14; fields.Add(PACKAGE_MODELField); DataSchemaField REQUIRED_PACKAGE_QTYField = new DataSchemaField(); REQUIRED_PACKAGE_QTYField.Name = "REQUIRED_PACKAGE_QTY"; REQUIRED_PACKAGE_QTYField.Type = typeof(int).ToString(); REQUIRED_PACKAGE_QTYField.Index = 15; fields.Add(REQUIRED_PACKAGE_QTYField); DataSchemaField REQUIRED_PART_QTYField = new DataSchemaField(); REQUIRED_PART_QTYField.Name = "REQUIRED_PART_QTY"; REQUIRED_PART_QTYField.Type = typeof(decimal).ToString(); REQUIRED_PART_QTYField.Index = 16; fields.Add(REQUIRED_PART_QTYField); DataSchemaField ASN_DRAFT_QTYField = new DataSchemaField(); ASN_DRAFT_QTYField.Name = "ASN_DRAFT_QTY"; ASN_DRAFT_QTYField.Type = typeof(decimal).ToString(); ASN_DRAFT_QTYField.Index = 17; fields.Add(ASN_DRAFT_QTYField); DataSchemaField ASN_CONFIRM_QTYField = new DataSchemaField(); ASN_CONFIRM_QTYField.Name = "ASN_CONFIRM_QTY"; ASN_CONFIRM_QTYField.Type = typeof(decimal).ToString(); ASN_CONFIRM_QTYField.Index = 18; fields.Add(ASN_CONFIRM_QTYField); DataSchemaField ACTUAL_PACKAGE_QTYField = new DataSchemaField(); ACTUAL_PACKAGE_QTYField.Name = "ACTUAL_PACKAGE_QTY"; ACTUAL_PACKAGE_QTYField.Type = typeof(int).ToString(); ACTUAL_PACKAGE_QTYField.Index = 19; fields.Add(ACTUAL_PACKAGE_QTYField); DataSchemaField ACTUAL_PART_QTYField = new DataSchemaField(); ACTUAL_PART_QTYField.Name = "ACTUAL_PART_QTY"; ACTUAL_PART_QTYField.Type = typeof(decimal).ToString(); ACTUAL_PART_QTYField.Index = 20; fields.Add(ACTUAL_PART_QTYField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 21; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 22; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 23; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 24; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 25; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 26; fields.Add(MODIFY_USERField); Schema.Fields = fields.ToArray(); }
public PullOrdersInfo() : base("TT_BAS_PULL_ORDERS") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField ORDER_NOField = new DataSchemaField(); ORDER_NOField.Name = "ORDER_NO"; ORDER_NOField.Type = typeof(string).ToString(); ORDER_NOField.Index = 2; fields.Add(ORDER_NOField); DataSchemaField WERKField = new DataSchemaField(); WERKField.Name = "WERK"; WERKField.Type = typeof(string).ToString(); WERKField.Index = 3; fields.Add(WERKField); DataSchemaField MODEL_YEARField = new DataSchemaField(); MODEL_YEARField.Name = "MODEL_YEAR"; MODEL_YEARField.Type = typeof(string).ToString(); MODEL_YEARField.Index = 4; fields.Add(MODEL_YEARField); DataSchemaField MODELField = new DataSchemaField(); MODELField.Name = "MODEL"; MODELField.Type = typeof(string).ToString(); MODELField.Index = 5; fields.Add(MODELField); DataSchemaField VEHICLE_ORDERField = new DataSchemaField(); VEHICLE_ORDERField.Name = "VEHICLE_ORDER"; VEHICLE_ORDERField.Type = typeof(string).ToString(); VEHICLE_ORDERField.Index = 6; fields.Add(VEHICLE_ORDERField); DataSchemaField ORDER_DATEField = new DataSchemaField(); ORDER_DATEField.Name = "ORDER_DATE"; ORDER_DATEField.Type = typeof(DateTime).ToString(); ORDER_DATEField.Index = 7; fields.Add(ORDER_DATEField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 8; fields.Add(ASSEMBLY_LINEField); DataSchemaField VINField = new DataSchemaField(); VINField.Name = "VIN"; VINField.Type = typeof(string).ToString(); VINField.Index = 9; fields.Add(VINField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 10; fields.Add(PART_NOField); DataSchemaField VORSERIEField = new DataSchemaField(); VORSERIEField.Name = "VORSERIE"; VORSERIEField.Type = typeof(bool).ToString(); VORSERIEField.Index = 11; fields.Add(VORSERIEField); DataSchemaField SPJField = new DataSchemaField(); SPJField.Name = "SPJ"; SPJField.Type = typeof(string).ToString(); SPJField.Index = 12; fields.Add(SPJField); DataSchemaField KNRField = new DataSchemaField(); KNRField.Name = "KNR"; KNRField.Type = typeof(string).ToString(); KNRField.Index = 13; fields.Add(KNRField); DataSchemaField FARBAUField = new DataSchemaField(); FARBAUField.Name = "FARBAU"; FARBAUField.Type = typeof(string).ToString(); FARBAUField.Index = 14; fields.Add(FARBAUField); DataSchemaField FARBINField = new DataSchemaField(); FARBINField.Name = "FARBIN"; FARBINField.Type = typeof(string).ToString(); FARBINField.Index = 15; fields.Add(FARBINField); DataSchemaField PNR_STRINGField = new DataSchemaField(); PNR_STRINGField.Name = "PNR_STRING"; PNR_STRINGField.Type = typeof(string).ToString(); PNR_STRINGField.Index = 16; fields.Add(PNR_STRINGField); DataSchemaField PNR_STRING_COMPUTEField = new DataSchemaField(); PNR_STRING_COMPUTEField.Name = "PNR_STRING_COMPUTE"; PNR_STRING_COMPUTEField.Type = typeof(string).ToString(); PNR_STRING_COMPUTEField.Index = 17; fields.Add(PNR_STRING_COMPUTEField); DataSchemaField DEAL_FLAGField = new DataSchemaField(); DEAL_FLAGField.Name = "DEAL_FLAG"; DEAL_FLAGField.Type = typeof(int).ToString(); DEAL_FLAGField.Index = 18; fields.Add(DEAL_FLAGField); DataSchemaField STATUS_FLAGField = new DataSchemaField(); STATUS_FLAGField.Name = "STATUS_FLAG"; STATUS_FLAGField.Type = typeof(string).ToString(); STATUS_FLAGField.Index = 19; fields.Add(STATUS_FLAGField); DataSchemaField SIGNATUREField = new DataSchemaField(); SIGNATUREField.Name = "SIGNATURE"; SIGNATUREField.Type = typeof(string).ToString(); SIGNATUREField.Index = 20; fields.Add(SIGNATUREField); DataSchemaField ORDER_FILE_NAMEField = new DataSchemaField(); ORDER_FILE_NAMEField.Name = "ORDER_FILE_NAME"; ORDER_FILE_NAMEField.Type = typeof(string).ToString(); ORDER_FILE_NAMEField.Index = 21; fields.Add(ORDER_FILE_NAMEField); DataSchemaField ORDER_TYPEField = new DataSchemaField(); ORDER_TYPEField.Name = "ORDER_TYPE"; ORDER_TYPEField.Type = typeof(string).ToString(); ORDER_TYPEField.Index = 22; fields.Add(ORDER_TYPEField); DataSchemaField RECALCULATE_FLAGField = new DataSchemaField(); RECALCULATE_FLAGField.Name = "RECALCULATE_FLAG"; RECALCULATE_FLAGField.Type = typeof(int).ToString(); RECALCULATE_FLAGField.Index = 23; fields.Add(RECALCULATE_FLAGField); DataSchemaField CHANGE_FLAGField = new DataSchemaField(); CHANGE_FLAGField.Name = "CHANGE_FLAG"; CHANGE_FLAGField.Type = typeof(int).ToString(); CHANGE_FLAGField.Index = 24; fields.Add(CHANGE_FLAGField); DataSchemaField PROCESS_LINE_SNField = new DataSchemaField(); PROCESS_LINE_SNField.Name = "PROCESS_LINE_SN"; PROCESS_LINE_SNField.Type = typeof(int).ToString(); PROCESS_LINE_SNField.Index = 25; fields.Add(PROCESS_LINE_SNField); DataSchemaField INIT_STSTUSField = new DataSchemaField(); INIT_STSTUSField.Name = "INIT_STSTUS"; INIT_STSTUSField.Type = typeof(int).ToString(); INIT_STSTUSField.Index = 26; fields.Add(INIT_STSTUSField); DataSchemaField VERSIONField = new DataSchemaField(); VERSIONField.Name = "VERSION"; VERSIONField.Type = typeof(int).ToString(); VERSIONField.Index = 27; fields.Add(VERSIONField); DataSchemaField ORDER_STATUSField = new DataSchemaField(); ORDER_STATUSField.Name = "ORDER_STATUS"; ORDER_STATUSField.Type = typeof(int).ToString(); ORDER_STATUSField.Index = 28; fields.Add(ORDER_STATUSField); DataSchemaField QTYField = new DataSchemaField(); QTYField.Name = "QTY"; QTYField.Type = typeof(decimal).ToString(); QTYField.Index = 29; fields.Add(QTYField); DataSchemaField MEASURING_UNITField = new DataSchemaField(); MEASURING_UNITField.Name = "MEASURING_UNIT"; MEASURING_UNITField.Type = typeof(string).ToString(); MEASURING_UNITField.Index = 30; fields.Add(MEASURING_UNITField); DataSchemaField ZCOLORIField = new DataSchemaField(); ZCOLORIField.Name = "ZCOLORI"; ZCOLORIField.Type = typeof(string).ToString(); ZCOLORIField.Index = 31; fields.Add(ZCOLORIField); DataSchemaField ZCOLORI_DField = new DataSchemaField(); ZCOLORI_DField.Name = "ZCOLORI_D"; ZCOLORI_DField.Type = typeof(string).ToString(); ZCOLORI_DField.Index = 32; fields.Add(ZCOLORI_DField); DataSchemaField PLAN_FLAGField = new DataSchemaField(); PLAN_FLAGField.Name = "PLAN_FLAG"; PLAN_FLAGField.Type = typeof(string).ToString(); PLAN_FLAGField.Index = 33; fields.Add(PLAN_FLAGField); DataSchemaField PLAN_EXECUTE_TIMEField = new DataSchemaField(); PLAN_EXECUTE_TIMEField.Name = "PLAN_EXECUTE_TIME"; PLAN_EXECUTE_TIMEField.Type = typeof(DateTime).ToString(); PLAN_EXECUTE_TIMEField.Index = 34; fields.Add(PLAN_EXECUTE_TIMEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 35; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 36; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 37; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 38; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 39; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 40; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public ScanPointInfo() : base("TM_BAS_SCAN_POINT") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField SCAN_POINT_CODEField = new DataSchemaField(); SCAN_POINT_CODEField.Name = "SCAN_POINT_CODE"; SCAN_POINT_CODEField.Type = typeof(string).ToString(); SCAN_POINT_CODEField.Index = 2; fields.Add(SCAN_POINT_CODEField); DataSchemaField SCAN_POINT_NAMEField = new DataSchemaField(); SCAN_POINT_NAMEField.Name = "SCAN_POINT_NAME"; SCAN_POINT_NAMEField.Type = typeof(string).ToString(); SCAN_POINT_NAMEField.Index = 3; fields.Add(SCAN_POINT_NAMEField); DataSchemaField MES_SCAN_POINT_CODEField = new DataSchemaField(); MES_SCAN_POINT_CODEField.Name = "MES_SCAN_POINT_CODE"; MES_SCAN_POINT_CODEField.Type = typeof(string).ToString(); MES_SCAN_POINT_CODEField.Index = 4; fields.Add(MES_SCAN_POINT_CODEField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 5; fields.Add(PLANTField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 6; fields.Add(WORKSHOPField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 7; fields.Add(ASSEMBLY_LINEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 8; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 9; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 10; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 11; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 12; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 13; fields.Add(MODIFY_USERField); Schema.Fields = fields.ToArray(); }
public MesInboundLogInfo() : base("TI_IFM_MES_INBOUND_LOG") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField TRANS_NOField = new DataSchemaField(); TRANS_NOField.Name = "TRANS_NO"; TRANS_NOField.Type = typeof(string).ToString(); TRANS_NOField.Index = 2; fields.Add(TRANS_NOField); DataSchemaField SOURCE_SYSTEMField = new DataSchemaField(); SOURCE_SYSTEMField.Name = "SOURCE_SYSTEM"; SOURCE_SYSTEMField.Type = typeof(string).ToString(); SOURCE_SYSTEMField.Index = 3; fields.Add(SOURCE_SYSTEMField); DataSchemaField TARGET_SYSTEMField = new DataSchemaField(); TARGET_SYSTEMField.Name = "TARGET_SYSTEM"; TARGET_SYSTEMField.Type = typeof(string).ToString(); TARGET_SYSTEMField.Index = 4; fields.Add(TARGET_SYSTEMField); DataSchemaField METHOD_CODEField = new DataSchemaField(); METHOD_CODEField.Name = "METHOD_CODE"; METHOD_CODEField.Type = typeof(string).ToString(); METHOD_CODEField.Index = 5; fields.Add(METHOD_CODEField); DataSchemaField EXECUTE_START_TIMEField = new DataSchemaField(); EXECUTE_START_TIMEField.Name = "EXECUTE_START_TIME"; EXECUTE_START_TIMEField.Type = typeof(DateTime).ToString(); EXECUTE_START_TIMEField.Index = 6; fields.Add(EXECUTE_START_TIMEField); DataSchemaField EXECUTE_END_TIMEField = new DataSchemaField(); EXECUTE_END_TIMEField.Name = "EXECUTE_END_TIME"; EXECUTE_END_TIMEField.Type = typeof(DateTime).ToString(); EXECUTE_END_TIMEField.Index = 7; fields.Add(EXECUTE_END_TIMEField); DataSchemaField EXECUTE_RESULTField = new DataSchemaField(); EXECUTE_RESULTField.Name = "EXECUTE_RESULT"; EXECUTE_RESULTField.Type = typeof(int).ToString(); EXECUTE_RESULTField.Index = 8; fields.Add(EXECUTE_RESULTField); DataSchemaField EXECUTE_TIMESField = new DataSchemaField(); EXECUTE_TIMESField.Name = "EXECUTE_TIMES"; EXECUTE_TIMESField.Type = typeof(int).ToString(); EXECUTE_TIMESField.Index = 9; fields.Add(EXECUTE_TIMESField); DataSchemaField KEY_VALUEField = new DataSchemaField(); KEY_VALUEField.Name = "KEY_VALUE"; KEY_VALUEField.Type = typeof(string).ToString(); KEY_VALUEField.Index = 10; fields.Add(KEY_VALUEField); DataSchemaField MSG_CONTENTField = new DataSchemaField(); MSG_CONTENTField.Name = "MSG_CONTENT"; MSG_CONTENTField.Type = typeof(string).ToString(); MSG_CONTENTField.Index = 11; fields.Add(MSG_CONTENTField); DataSchemaField ERROR_CODEField = new DataSchemaField(); ERROR_CODEField.Name = "ERROR_CODE"; ERROR_CODEField.Type = typeof(string).ToString(); ERROR_CODEField.Index = 12; fields.Add(ERROR_CODEField); DataSchemaField ERROR_MSGField = new DataSchemaField(); ERROR_MSGField.Name = "ERROR_MSG"; ERROR_MSGField.Type = typeof(string).ToString(); ERROR_MSGField.Index = 13; fields.Add(ERROR_MSGField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 14; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 15; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 16; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 17; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 18; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public ActionInfo() : base("TS_SYS_ACTION") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField ACTION_NAMEField = new DataSchemaField(); ACTION_NAMEField.Name = "ACTION_NAME"; ACTION_NAMEField.Type = typeof(string).ToString(); ACTION_NAMEField.Index = 2; fields.Add(ACTION_NAMEField); DataSchemaField ACTION_NAME_CNField = new DataSchemaField(); ACTION_NAME_CNField.Name = "ACTION_NAME_CN"; ACTION_NAME_CNField.Type = typeof(string).ToString(); ACTION_NAME_CNField.Index = 3; fields.Add(ACTION_NAME_CNField); DataSchemaField ACTION_TYPEField = new DataSchemaField(); ACTION_TYPEField.Name = "ACTION_TYPE"; ACTION_TYPEField.Type = typeof(int).ToString(); ACTION_TYPEField.Index = 4; fields.Add(ACTION_TYPEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 5; fields.Add(COMMENTSField); DataSchemaField ICON_URLField = new DataSchemaField(); ICON_URLField.Name = "ICON_URL"; ICON_URLField.Type = typeof(string).ToString(); ICON_URLField.Index = 6; fields.Add(ICON_URLField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 7; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 8; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 9; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 10; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 11; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public VmiDeliveryNoteInfo() : base("IFM_SRM_VMI_DELIVERY_NOTE") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField ORDERCODEField = new DataSchemaField(); ORDERCODEField.Name = "ORDERCODE"; ORDERCODEField.Type = typeof(string).ToString(); ORDERCODEField.Index = 3; fields.Add(ORDERCODEField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 4; fields.Add(PLANTField); DataSchemaField SOURCEORDERTYPEField = new DataSchemaField(); SOURCEORDERTYPEField.Name = "SOURCEORDERTYPE"; SOURCEORDERTYPEField.Type = typeof(int).ToString(); SOURCEORDERTYPEField.Index = 5; fields.Add(SOURCEORDERTYPEField); DataSchemaField DOCKField = new DataSchemaField(); DOCKField.Name = "DOCK"; DOCKField.Type = typeof(string).ToString(); DOCKField.Index = 6; fields.Add(DOCKField); DataSchemaField PUBLISHTIMEField = new DataSchemaField(); PUBLISHTIMEField.Name = "PUBLISHTIME"; PUBLISHTIMEField.Type = typeof(DateTime).ToString(); PUBLISHTIMEField.Index = 7; fields.Add(PUBLISHTIMEField); DataSchemaField SUPPLIERCODEField = new DataSchemaField(); SUPPLIERCODEField.Name = "SUPPLIERCODE"; SUPPLIERCODEField.Type = typeof(string).ToString(); SUPPLIERCODEField.Index = 8; fields.Add(SUPPLIERCODEField); DataSchemaField SUPPLIERNAMEField = new DataSchemaField(); SUPPLIERNAMEField.Name = "SUPPLIERNAME"; SUPPLIERNAMEField.Type = typeof(string).ToString(); SUPPLIERNAMEField.Index = 9; fields.Add(SUPPLIERNAMEField); DataSchemaField SOURCEZONENOField = new DataSchemaField(); SOURCEZONENOField.Name = "SOURCEZONENO"; SOURCEZONENOField.Type = typeof(string).ToString(); SOURCEZONENOField.Index = 10; fields.Add(SOURCEZONENOField); DataSchemaField TARGETZONENOField = new DataSchemaField(); TARGETZONENOField.Name = "TARGETZONENO"; TARGETZONENOField.Type = typeof(string).ToString(); TARGETZONENOField.Index = 11; fields.Add(TARGETZONENOField); DataSchemaField KEEPERField = new DataSchemaField(); KEEPERField.Name = "KEEPER"; KEEPERField.Type = typeof(string).ToString(); KEEPERField.Index = 12; fields.Add(KEEPERField); DataSchemaField PLANSHIPPINGTIMEField = new DataSchemaField(); PLANSHIPPINGTIMEField.Name = "PLANSHIPPINGTIME"; PLANSHIPPINGTIMEField.Type = typeof(DateTime).ToString(); PLANSHIPPINGTIMEField.Index = 13; fields.Add(PLANSHIPPINGTIMEField); DataSchemaField PLANDELIVERYTIMEField = new DataSchemaField(); PLANDELIVERYTIMEField.Name = "PLANDELIVERYTIME"; PLANDELIVERYTIMEField.Type = typeof(DateTime).ToString(); PLANDELIVERYTIMEField.Index = 14; fields.Add(PLANDELIVERYTIMEField); DataSchemaField REMARKField = new DataSchemaField(); REMARKField.Name = "REMARK"; REMARKField.Type = typeof(string).ToString(); REMARKField.Index = 15; fields.Add(REMARKField); DataSchemaField EMERGENCYFLAGField = new DataSchemaField(); EMERGENCYFLAGField.Name = "EMERGENCYFLAG"; EMERGENCYFLAGField.Type = typeof(bool).ToString(); EMERGENCYFLAGField.Index = 16; fields.Add(EMERGENCYFLAGField); DataSchemaField DELETEFLAGField = new DataSchemaField(); DELETEFLAGField.Name = "DELETEFLAG"; DELETEFLAGField.Type = typeof(bool).ToString(); DELETEFLAGField.Index = 17; fields.Add(DELETEFLAGField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 18; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 19; fields.Add(PROCESS_TIMEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 20; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 21; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 22; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 23; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 24; fields.Add(MODIFY_USERField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 25; fields.Add(COMMENTSField); Schema.Fields = fields.ToArray(); }
public MesMissingpartsMainInfo() : base("TI_IFM_MES_MISSINGPARTS_MAIN") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField ENTERPRISEField = new DataSchemaField(); ENTERPRISEField.Name = "ENTERPRISE"; ENTERPRISEField.Type = typeof(string).ToString(); ENTERPRISEField.Index = 3; fields.Add(ENTERPRISEField); DataSchemaField SITE_NOField = new DataSchemaField(); SITE_NOField.Name = "SITE_NO"; SITE_NOField.Type = typeof(string).ToString(); SITE_NOField.Index = 4; fields.Add(SITE_NOField); DataSchemaField AREA_NOField = new DataSchemaField(); AREA_NOField.Name = "AREA_NO"; AREA_NOField.Type = typeof(string).ToString(); AREA_NOField.Index = 5; fields.Add(AREA_NOField); DataSchemaField DMS_NOField = new DataSchemaField(); DMS_NOField.Name = "DMS_NO"; DMS_NOField.Type = typeof(string).ToString(); DMS_NOField.Index = 6; fields.Add(DMS_NOField); DataSchemaField SEND_TIMEField = new DataSchemaField(); SEND_TIMEField.Name = "SEND_TIME"; SEND_TIMEField.Type = typeof(DateTime).ToString(); SEND_TIMEField.Index = 7; fields.Add(SEND_TIMEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 8; fields.Add(VALID_FLAGField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 9; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 10; fields.Add(PROCESS_TIMEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 11; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 12; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 13; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 14; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public SrmVmiSupplierPartInfo() : base("TI_IFM_SRM_VMI_SUPPLIER_PART") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 3; fields.Add(PLANTField); DataSchemaField VMI_WAREHOUSE_CODEField = new DataSchemaField(); VMI_WAREHOUSE_CODEField.Name = "VMI_WAREHOUSE_CODE"; VMI_WAREHOUSE_CODEField.Type = typeof(string).ToString(); VMI_WAREHOUSE_CODEField.Index = 4; fields.Add(VMI_WAREHOUSE_CODEField); DataSchemaField VMI_WAREHOUSE_NAMEField = new DataSchemaField(); VMI_WAREHOUSE_NAMEField.Name = "VMI_WAREHOUSE_NAME"; VMI_WAREHOUSE_NAMEField.Type = typeof(string).ToString(); VMI_WAREHOUSE_NAMEField.Index = 5; fields.Add(VMI_WAREHOUSE_NAMEField); DataSchemaField SUPPLIER_CODEField = new DataSchemaField(); SUPPLIER_CODEField.Name = "SUPPLIER_CODE"; SUPPLIER_CODEField.Type = typeof(string).ToString(); SUPPLIER_CODEField.Index = 6; fields.Add(SUPPLIER_CODEField); DataSchemaField SUPPLIER_NAMEField = new DataSchemaField(); SUPPLIER_NAMEField.Name = "SUPPLIER_NAME"; SUPPLIER_NAMEField.Type = typeof(string).ToString(); SUPPLIER_NAMEField.Index = 7; fields.Add(SUPPLIER_NAMEField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 8; fields.Add(PART_NOField); DataSchemaField PART_CNAMEField = new DataSchemaField(); PART_CNAMEField.Name = "PART_CNAME"; PART_CNAMEField.Type = typeof(string).ToString(); PART_CNAMEField.Index = 9; fields.Add(PART_CNAMEField); DataSchemaField DELETE_FLAGField = new DataSchemaField(); DELETE_FLAGField.Name = "DELETE_FLAG"; DELETE_FLAGField.Type = typeof(bool).ToString(); DELETE_FLAGField.Index = 10; fields.Add(DELETE_FLAGField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 11; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 12; fields.Add(PROCESS_TIMEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 13; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 14; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 15; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 16; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 17; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 18; fields.Add(MODIFY_USERField); Schema.Fields = fields.ToArray(); }
public PackageTranDetailInfo() : base("TT_PCM_PACKAGE_TRAN_DETAIL") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField TRAN_NOField = new DataSchemaField(); TRAN_NOField.Name = "TRAN_NO"; TRAN_NOField.Type = typeof(string).ToString(); TRAN_NOField.Index = 2; fields.Add(TRAN_NOField); DataSchemaField TRAN_TYPEField = new DataSchemaField(); TRAN_TYPEField.Name = "TRAN_TYPE"; TRAN_TYPEField.Type = typeof(int).ToString(); TRAN_TYPEField.Index = 3; fields.Add(TRAN_TYPEField); DataSchemaField BARCODE_DATAField = new DataSchemaField(); BARCODE_DATAField.Name = "BARCODE_DATA"; BARCODE_DATAField.Type = typeof(string).ToString(); BARCODE_DATAField.Index = 4; fields.Add(BARCODE_DATAField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 5; fields.Add(PART_NOField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 6; fields.Add(PLANTField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 7; fields.Add(ASSEMBLY_LINEField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 8; fields.Add(SUPPLIER_NUMField); DataSchemaField WM_NOField = new DataSchemaField(); WM_NOField.Name = "WM_NO"; WM_NOField.Type = typeof(string).ToString(); WM_NOField.Index = 9; fields.Add(WM_NOField); DataSchemaField ZONE_NOField = new DataSchemaField(); ZONE_NOField.Name = "ZONE_NO"; ZONE_NOField.Type = typeof(string).ToString(); ZONE_NOField.Index = 10; fields.Add(ZONE_NOField); DataSchemaField DLOCField = new DataSchemaField(); DLOCField.Name = "DLOC"; DLOCField.Type = typeof(string).ToString(); DLOCField.Index = 11; fields.Add(DLOCField); DataSchemaField TARGET_WMField = new DataSchemaField(); TARGET_WMField.Name = "TARGET_WM"; TARGET_WMField.Type = typeof(string).ToString(); TARGET_WMField.Index = 12; fields.Add(TARGET_WMField); DataSchemaField TARGET_ZONEField = new DataSchemaField(); TARGET_ZONEField.Name = "TARGET_ZONE"; TARGET_ZONEField.Type = typeof(string).ToString(); TARGET_ZONEField.Index = 13; fields.Add(TARGET_ZONEField); DataSchemaField TARGET_DLOCField = new DataSchemaField(); TARGET_DLOCField.Name = "TARGET_DLOC"; TARGET_DLOCField.Type = typeof(string).ToString(); TARGET_DLOCField.Index = 14; fields.Add(TARGET_DLOCField); DataSchemaField PACKAGE_NOField = new DataSchemaField(); PACKAGE_NOField.Name = "PACKAGE_NO"; PACKAGE_NOField.Type = typeof(string).ToString(); PACKAGE_NOField.Index = 15; fields.Add(PACKAGE_NOField); DataSchemaField PACKAGE_CNAMEField = new DataSchemaField(); PACKAGE_CNAMEField.Name = "PACKAGE_CNAME"; PACKAGE_CNAMEField.Type = typeof(string).ToString(); PACKAGE_CNAMEField.Index = 16; fields.Add(PACKAGE_CNAMEField); DataSchemaField PACKAGE_ENAMEField = new DataSchemaField(); PACKAGE_ENAMEField.Name = "PACKAGE_ENAME"; PACKAGE_ENAMEField.Type = typeof(string).ToString(); PACKAGE_ENAMEField.Index = 17; fields.Add(PACKAGE_ENAMEField); DataSchemaField PACKAGEField = new DataSchemaField(); PACKAGEField.Name = "PACKAGE"; PACKAGEField.Type = typeof(decimal).ToString(); PACKAGEField.Index = 18; fields.Add(PACKAGEField); DataSchemaField PACKAGE_QTYField = new DataSchemaField(); PACKAGE_QTYField.Name = "PACKAGE_QTY"; PACKAGE_QTYField.Type = typeof(int).ToString(); PACKAGE_QTYField.Index = 19; fields.Add(PACKAGE_QTYField); DataSchemaField STATUSField = new DataSchemaField(); STATUSField.Name = "STATUS"; STATUSField.Type = typeof(int).ToString(); STATUSField.Index = 20; fields.Add(STATUSField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 21; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 22; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 23; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 24; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 25; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 26; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public RepackageScheduleInfo() : base("TT_WMM_REPACKAGE_SCHEDULE") { List <string> keys = new List <string>(); keys.Add("SCHEDULE_IDENTITY"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField SCHEDULE_IDENTITYField = new DataSchemaField(); SCHEDULE_IDENTITYField.Name = "SCHEDULE_IDENTITY"; SCHEDULE_IDENTITYField.Type = typeof(int).ToString(); SCHEDULE_IDENTITYField.Index = 0; fields.Add(SCHEDULE_IDENTITYField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 1; fields.Add(PLANTField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 2; fields.Add(ASSEMBLY_LINEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 3; fields.Add(WORKSHOPField); DataSchemaField PLANT_ZONEField = new DataSchemaField(); PLANT_ZONEField.Name = "PLANT_ZONE"; PLANT_ZONEField.Type = typeof(string).ToString(); PLANT_ZONEField.Index = 4; fields.Add(PLANT_ZONEField); DataSchemaField ROUTESField = new DataSchemaField(); ROUTESField.Name = "ROUTES"; ROUTESField.Type = typeof(string).ToString(); ROUTESField.Index = 5; fields.Add(ROUTESField); DataSchemaField WINDOWS_TIMEField = new DataSchemaField(); WINDOWS_TIMEField.Name = "WINDOWS_TIME"; WINDOWS_TIMEField.Type = typeof(string).ToString(); WINDOWS_TIMEField.Index = 6; fields.Add(WINDOWS_TIMEField); DataSchemaField IS_ACTIVEField = new DataSchemaField(); IS_ACTIVEField.Name = "IS_ACTIVE"; IS_ACTIVEField.Type = typeof(int).ToString(); IS_ACTIVEField.Index = 7; fields.Add(IS_ACTIVEField); DataSchemaField LAST_RUNField = new DataSchemaField(); LAST_RUNField.Name = "LAST_RUN"; LAST_RUNField.Type = typeof(DateTime).ToString(); LAST_RUNField.Index = 8; fields.Add(LAST_RUNField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 9; fields.Add(COMMENTSField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 10; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 11; fields.Add(CREATE_DATEField); DataSchemaField UPDATE_USERField = new DataSchemaField(); UPDATE_USERField.Name = "UPDATE_USER"; UPDATE_USERField.Type = typeof(string).ToString(); UPDATE_USERField.Index = 12; fields.Add(UPDATE_USERField); DataSchemaField UPDATE_DATEField = new DataSchemaField(); UPDATE_DATEField.Name = "UPDATE_DATE"; UPDATE_DATEField.Type = typeof(DateTime).ToString(); UPDATE_DATEField.Index = 13; fields.Add(UPDATE_DATEField); Schema.Fields = fields.ToArray(); }
public RepackageHeadInfo() : base("TT_WMM_REPACKAGE_HEAD") { List <string> keys = new List <string>(); keys.Add("REPACKAGE_ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField REPACKAGE_IDField = new DataSchemaField(); REPACKAGE_IDField.Name = "REPACKAGE_ID"; REPACKAGE_IDField.Type = typeof(int).ToString(); REPACKAGE_IDField.Index = 0; fields.Add(REPACKAGE_IDField); DataSchemaField REPACKAGE_NOField = new DataSchemaField(); REPACKAGE_NOField.Name = "REPACKAGE_NO"; REPACKAGE_NOField.Type = typeof(string).ToString(); REPACKAGE_NOField.Index = 1; fields.Add(REPACKAGE_NOField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 2; fields.Add(PLANTField); DataSchemaField WM_NOField = new DataSchemaField(); WM_NOField.Name = "WM_NO"; WM_NOField.Type = typeof(string).ToString(); WM_NOField.Index = 3; fields.Add(WM_NOField); DataSchemaField ZONE_NOField = new DataSchemaField(); ZONE_NOField.Name = "ZONE_NO"; ZONE_NOField.Type = typeof(string).ToString(); ZONE_NOField.Index = 4; fields.Add(ZONE_NOField); DataSchemaField REPACKAGE_TIMEField = new DataSchemaField(); REPACKAGE_TIMEField.Name = "REPACKAGE_TIME"; REPACKAGE_TIMEField.Type = typeof(DateTime).ToString(); REPACKAGE_TIMEField.Index = 5; fields.Add(REPACKAGE_TIMEField); DataSchemaField REPACKAGE_BTIMEField = new DataSchemaField(); REPACKAGE_BTIMEField.Name = "REPACKAGE_BTIME"; REPACKAGE_BTIMEField.Type = typeof(DateTime).ToString(); REPACKAGE_BTIMEField.Index = 6; fields.Add(REPACKAGE_BTIMEField); DataSchemaField REPACKAGE_ETIMEField = new DataSchemaField(); REPACKAGE_ETIMEField.Name = "REPACKAGE_ETIME"; REPACKAGE_ETIMEField.Type = typeof(DateTime).ToString(); REPACKAGE_ETIMEField.Index = 7; fields.Add(REPACKAGE_ETIMEField); DataSchemaField REPACKAGE_PICKUP_TIMEField = new DataSchemaField(); REPACKAGE_PICKUP_TIMEField.Name = "REPACKAGE_PICKUP_TIME"; REPACKAGE_PICKUP_TIMEField.Type = typeof(DateTime).ToString(); REPACKAGE_PICKUP_TIMEField.Index = 8; fields.Add(REPACKAGE_PICKUP_TIMEField); DataSchemaField REPACKAGE_ROUTEField = new DataSchemaField(); REPACKAGE_ROUTEField.Name = "REPACKAGE_ROUTE"; REPACKAGE_ROUTEField.Type = typeof(string).ToString(); REPACKAGE_ROUTEField.Index = 9; fields.Add(REPACKAGE_ROUTEField); DataSchemaField APPLY_KEEPERField = new DataSchemaField(); APPLY_KEEPERField.Name = "APPLY_KEEPER"; APPLY_KEEPERField.Type = typeof(string).ToString(); APPLY_KEEPERField.Index = 10; fields.Add(APPLY_KEEPERField); DataSchemaField BOOK_KEEPERField = new DataSchemaField(); BOOK_KEEPERField.Name = "BOOK_KEEPER"; BOOK_KEEPERField.Type = typeof(string).ToString(); BOOK_KEEPERField.Index = 11; fields.Add(BOOK_KEEPERField); DataSchemaField PUBLISH_KEEPERField = new DataSchemaField(); PUBLISH_KEEPERField.Name = "PUBLISH_KEEPER"; PUBLISH_KEEPERField.Type = typeof(string).ToString(); PUBLISH_KEEPERField.Index = 12; fields.Add(PUBLISH_KEEPERField); DataSchemaField PUBLISH_TIMEField = new DataSchemaField(); PUBLISH_TIMEField.Name = "PUBLISH_TIME"; PUBLISH_TIMEField.Type = typeof(DateTime).ToString(); PUBLISH_TIMEField.Index = 13; fields.Add(PUBLISH_TIMEField); DataSchemaField COUNT_STATUSField = new DataSchemaField(); COUNT_STATUSField.Name = "COUNT_STATUS"; COUNT_STATUSField.Type = typeof(int).ToString(); COUNT_STATUSField.Index = 14; fields.Add(COUNT_STATUSField); DataSchemaField REPACKAGE_COUNTField = new DataSchemaField(); REPACKAGE_COUNTField.Name = "REPACKAGE_COUNT"; REPACKAGE_COUNTField.Type = typeof(int).ToString(); REPACKAGE_COUNTField.Index = 15; fields.Add(REPACKAGE_COUNTField); DataSchemaField EMERGENCY_TYPEField = new DataSchemaField(); EMERGENCY_TYPEField.Name = "EMERGENCY_TYPE"; EMERGENCY_TYPEField.Type = typeof(int).ToString(); EMERGENCY_TYPEField.Index = 16; fields.Add(EMERGENCY_TYPEField); DataSchemaField COUNT_REASONField = new DataSchemaField(); COUNT_REASONField.Name = "COUNT_REASON"; COUNT_REASONField.Type = typeof(string).ToString(); COUNT_REASONField.Index = 17; fields.Add(COUNT_REASONField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 18; fields.Add(ASSEMBLY_LINEField); DataSchemaField PLANT_ZONEField = new DataSchemaField(); PLANT_ZONEField.Name = "PLANT_ZONE"; PLANT_ZONEField.Type = typeof(string).ToString(); PLANT_ZONEField.Index = 19; fields.Add(PLANT_ZONEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 20; fields.Add(WORKSHOPField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 21; fields.Add(COMMENTSField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 22; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 23; fields.Add(CREATE_DATEField); DataSchemaField UPDATE_USERField = new DataSchemaField(); UPDATE_USERField.Name = "UPDATE_USER"; UPDATE_USERField.Type = typeof(string).ToString(); UPDATE_USERField.Index = 24; fields.Add(UPDATE_USERField); DataSchemaField UPDATE_DATEField = new DataSchemaField(); UPDATE_DATEField.Name = "UPDATE_DATE"; UPDATE_DATEField.Type = typeof(DateTime).ToString(); UPDATE_DATEField.Index = 25; fields.Add(UPDATE_DATEField); DataSchemaField REPACKAGE_PICKUP_ETIMEField = new DataSchemaField(); REPACKAGE_PICKUP_ETIMEField.Name = "REPACKAGE_PICKUP_ETIME"; REPACKAGE_PICKUP_ETIMEField.Type = typeof(DateTime).ToString(); REPACKAGE_PICKUP_ETIMEField.Index = 26; fields.Add(REPACKAGE_PICKUP_ETIMEField); DataSchemaField REPACKAGE_TYPEField = new DataSchemaField(); REPACKAGE_TYPEField.Name = "REPACKAGE_TYPE"; REPACKAGE_TYPEField.Type = typeof(string).ToString(); REPACKAGE_TYPEField.Index = 27; fields.Add(REPACKAGE_TYPEField); Schema.Fields = fields.ToArray(); }
public SupplyPlanInfo() : base("TT_ATP_SUPPLY_PLAN") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 2; fields.Add(PART_NOField); DataSchemaField PART_CNAMEField = new DataSchemaField(); PART_CNAMEField.Name = "PART_CNAME"; PART_CNAMEField.Type = typeof(string).ToString(); PART_CNAMEField.Index = 3; fields.Add(PART_CNAMEField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 4; fields.Add(SUPPLIER_NUMField); DataSchemaField SUPPLIER_NAMEField = new DataSchemaField(); SUPPLIER_NAMEField.Name = "SUPPLIER_NAME"; SUPPLIER_NAMEField.Type = typeof(string).ToString(); SUPPLIER_NAMEField.Index = 5; fields.Add(SUPPLIER_NAMEField); DataSchemaField PART_PURCHASERField = new DataSchemaField(); PART_PURCHASERField.Name = "PART_PURCHASER"; PART_PURCHASERField.Type = typeof(string).ToString(); PART_PURCHASERField.Index = 6; fields.Add(PART_PURCHASERField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 7; fields.Add(PLANTField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 8; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 9; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 10; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 11; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 12; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public ProcessScheduleInfo() : base("TS_SYS_PROCESS_SCHEDULE") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField PROCESS_CODEField = new DataSchemaField(); PROCESS_CODEField.Name = "PROCESS_CODE"; PROCESS_CODEField.Type = typeof(string).ToString(); PROCESS_CODEField.Index = 2; fields.Add(PROCESS_CODEField); DataSchemaField PROCESS_NAMEField = new DataSchemaField(); PROCESS_NAMEField.Name = "PROCESS_NAME"; PROCESS_NAMEField.Type = typeof(string).ToString(); PROCESS_NAMEField.Index = 3; fields.Add(PROCESS_NAMEField); DataSchemaField LAST_RUN_BEGIN_TIMEField = new DataSchemaField(); LAST_RUN_BEGIN_TIMEField.Name = "LAST_RUN_BEGIN_TIME"; LAST_RUN_BEGIN_TIMEField.Type = typeof(DateTime).ToString(); LAST_RUN_BEGIN_TIMEField.Index = 4; fields.Add(LAST_RUN_BEGIN_TIMEField); DataSchemaField LAST_RUN_END_TIMEField = new DataSchemaField(); LAST_RUN_END_TIMEField.Name = "LAST_RUN_END_TIME"; LAST_RUN_END_TIMEField.Type = typeof(DateTime).ToString(); LAST_RUN_END_TIMEField.Index = 5; fields.Add(LAST_RUN_END_TIMEField); DataSchemaField LAST_RUN_STATUSField = new DataSchemaField(); LAST_RUN_STATUSField.Name = "LAST_RUN_STATUS"; LAST_RUN_STATUSField.Type = typeof(int).ToString(); LAST_RUN_STATUSField.Index = 6; fields.Add(LAST_RUN_STATUSField); DataSchemaField RUN_INTERVALField = new DataSchemaField(); RUN_INTERVALField.Name = "RUN_INTERVAL"; RUN_INTERVALField.Type = typeof(int).ToString(); RUN_INTERVALField.Index = 7; fields.Add(RUN_INTERVALField); DataSchemaField CHECK_INTERVALField = new DataSchemaField(); CHECK_INTERVALField.Name = "CHECK_INTERVAL"; CHECK_INTERVALField.Type = typeof(int).ToString(); CHECK_INTERVALField.Index = 8; fields.Add(CHECK_INTERVALField); DataSchemaField SYSTEM_PARAMETER1Field = new DataSchemaField(); SYSTEM_PARAMETER1Field.Name = "SYSTEM_PARAMETER1"; SYSTEM_PARAMETER1Field.Type = typeof(string).ToString(); SYSTEM_PARAMETER1Field.Index = 9; fields.Add(SYSTEM_PARAMETER1Field); DataSchemaField SYSTEM_PARAMETER2Field = new DataSchemaField(); SYSTEM_PARAMETER2Field.Name = "SYSTEM_PARAMETER2"; SYSTEM_PARAMETER2Field.Type = typeof(string).ToString(); SYSTEM_PARAMETER2Field.Index = 10; fields.Add(SYSTEM_PARAMETER2Field); DataSchemaField SYSTEM_PARAMETER3Field = new DataSchemaField(); SYSTEM_PARAMETER3Field.Name = "SYSTEM_PARAMETER3"; SYSTEM_PARAMETER3Field.Type = typeof(string).ToString(); SYSTEM_PARAMETER3Field.Index = 11; fields.Add(SYSTEM_PARAMETER3Field); DataSchemaField SYSTEM_PARAMETER4Field = new DataSchemaField(); SYSTEM_PARAMETER4Field.Name = "SYSTEM_PARAMETER4"; SYSTEM_PARAMETER4Field.Type = typeof(string).ToString(); SYSTEM_PARAMETER4Field.Index = 12; fields.Add(SYSTEM_PARAMETER4Field); DataSchemaField SYSTEM_PARAMETER5Field = new DataSchemaField(); SYSTEM_PARAMETER5Field.Name = "SYSTEM_PARAMETER5"; SYSTEM_PARAMETER5Field.Type = typeof(string).ToString(); SYSTEM_PARAMETER5Field.Index = 13; fields.Add(SYSTEM_PARAMETER5Field); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 14; fields.Add(VALID_FLAGField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 15; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 16; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 17; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 18; fields.Add(MODIFY_USERField); Schema.Fields = fields.ToArray(); }
public WmsVmiPackageInboundInfo() : base("TI_IFM_WMS_VMI_PACKAGE_INBOUND") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField WERKSField = new DataSchemaField(); WERKSField.Name = "WERKS"; WERKSField.Type = typeof(string).ToString(); WERKSField.Index = 3; fields.Add(WERKSField); DataSchemaField ORDERKEYField = new DataSchemaField(); ORDERKEYField.Name = "ORDERKEY"; ORDERKEYField.Type = typeof(string).ToString(); ORDERKEYField.Index = 4; fields.Add(ORDERKEYField); DataSchemaField ORDERLINENUMBERField = new DataSchemaField(); ORDERLINENUMBERField.Name = "ORDERLINENUMBER"; ORDERLINENUMBERField.Type = typeof(string).ToString(); ORDERLINENUMBERField.Index = 5; fields.Add(ORDERLINENUMBERField); DataSchemaField STORERKEYField = new DataSchemaField(); STORERKEYField.Name = "STORERKEY"; STORERKEYField.Type = typeof(string).ToString(); STORERKEYField.Index = 6; fields.Add(STORERKEYField); DataSchemaField SKUField = new DataSchemaField(); SKUField.Name = "SKU"; SKUField.Type = typeof(string).ToString(); SKUField.Index = 7; fields.Add(SKUField); DataSchemaField RECQTYField = new DataSchemaField(); RECQTYField.Name = "RECQTY"; RECQTYField.Type = typeof(decimal).ToString(); RECQTYField.Index = 8; fields.Add(RECQTYField); DataSchemaField VMIWAREHOUSECODEField = new DataSchemaField(); VMIWAREHOUSECODEField.Name = "VMIWAREHOUSECODE"; VMIWAREHOUSECODEField.Type = typeof(string).ToString(); VMIWAREHOUSECODEField.Index = 9; fields.Add(VMIWAREHOUSECODEField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 10; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 11; fields.Add(PROCESS_TIMEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 12; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 13; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 14; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 15; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 16; fields.Add(MODIFY_DATEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 17; fields.Add(COMMENTSField); Schema.Fields = fields.ToArray(); }
public PlantInfo() : base("TM_BAS_PLANT") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 0; fields.Add(FIDField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 1; fields.Add(PLANTField); DataSchemaField PLANT_NAMEField = new DataSchemaField(); PLANT_NAMEField.Name = "PLANT_NAME"; PLANT_NAMEField.Type = typeof(string).ToString(); PLANT_NAMEField.Index = 2; fields.Add(PLANT_NAMEField); DataSchemaField SAP_PLANT_CODEField = new DataSchemaField(); SAP_PLANT_CODEField.Name = "SAP_PLANT_CODE"; SAP_PLANT_CODEField.Type = typeof(string).ToString(); SAP_PLANT_CODEField.Index = 3; fields.Add(SAP_PLANT_CODEField); DataSchemaField DESCRIPTIONField = new DataSchemaField(); DESCRIPTIONField.Name = "DESCRIPTION"; DESCRIPTIONField.Type = typeof(string).ToString(); DESCRIPTIONField.Index = 4; fields.Add(DESCRIPTIONField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 5; fields.Add(COMMENTSField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 6; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 7; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 8; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 9; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 10; fields.Add(MODIFY_DATEField); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 11; fields.Add(IDField); Schema.Fields = fields.ToArray(); }
public NotificationHeadInfo() : base("TT_WMM_NOTIFICATION_HEAD") { List <string> keys = new List <string>(); keys.Add("NOTIFICATION_ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField NOTIFICATION_IDField = new DataSchemaField(); NOTIFICATION_IDField.Name = "NOTIFICATION_ID"; NOTIFICATION_IDField.Type = typeof(int).ToString(); NOTIFICATION_IDField.Index = 0; fields.Add(NOTIFICATION_IDField); DataSchemaField NOTIFICATION_NOField = new DataSchemaField(); NOTIFICATION_NOField.Name = "NOTIFICATION_NO"; NOTIFICATION_NOField.Type = typeof(string).ToString(); NOTIFICATION_NOField.Index = 1; fields.Add(NOTIFICATION_NOField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 2; fields.Add(PLANTField); DataSchemaField WM_NOField = new DataSchemaField(); WM_NOField.Name = "WM_NO"; WM_NOField.Type = typeof(string).ToString(); WM_NOField.Index = 3; fields.Add(WM_NOField); DataSchemaField ZONE_NOField = new DataSchemaField(); ZONE_NOField.Name = "ZONE_NO"; ZONE_NOField.Type = typeof(string).ToString(); ZONE_NOField.Index = 4; fields.Add(ZONE_NOField); DataSchemaField COUNT_TYPEField = new DataSchemaField(); COUNT_TYPEField.Name = "COUNT_TYPE"; COUNT_TYPEField.Type = typeof(int).ToString(); COUNT_TYPEField.Index = 5; fields.Add(COUNT_TYPEField); DataSchemaField COUNT_TIMEField = new DataSchemaField(); COUNT_TIMEField.Name = "COUNT_TIME"; COUNT_TIMEField.Type = typeof(DateTime).ToString(); COUNT_TIMEField.Index = 6; fields.Add(COUNT_TIMEField); DataSchemaField APPLY_KEEPERField = new DataSchemaField(); APPLY_KEEPERField.Name = "APPLY_KEEPER"; APPLY_KEEPERField.Type = typeof(string).ToString(); APPLY_KEEPERField.Index = 7; fields.Add(APPLY_KEEPERField); DataSchemaField BOOK_KEEPERField = new DataSchemaField(); BOOK_KEEPERField.Name = "BOOK_KEEPER"; BOOK_KEEPERField.Type = typeof(string).ToString(); BOOK_KEEPERField.Index = 8; fields.Add(BOOK_KEEPERField); DataSchemaField PUBLISH_KEEPERField = new DataSchemaField(); PUBLISH_KEEPERField.Name = "PUBLISH_KEEPER"; PUBLISH_KEEPERField.Type = typeof(string).ToString(); PUBLISH_KEEPERField.Index = 9; fields.Add(PUBLISH_KEEPERField); DataSchemaField PUBLISH_TIMEField = new DataSchemaField(); PUBLISH_TIMEField.Name = "PUBLISH_TIME"; PUBLISH_TIMEField.Type = typeof(DateTime).ToString(); PUBLISH_TIMEField.Index = 10; fields.Add(PUBLISH_TIMEField); DataSchemaField CONFIRM_FLAGField = new DataSchemaField(); CONFIRM_FLAGField.Name = "CONFIRM_FLAG"; CONFIRM_FLAGField.Type = typeof(int).ToString(); CONFIRM_FLAGField.Index = 11; fields.Add(CONFIRM_FLAGField); DataSchemaField COUNT_STATUSField = new DataSchemaField(); COUNT_STATUSField.Name = "COUNT_STATUS"; COUNT_STATUSField.Type = typeof(int).ToString(); COUNT_STATUSField.Index = 12; fields.Add(COUNT_STATUSField); DataSchemaField EMERGENCY_TYPEField = new DataSchemaField(); EMERGENCY_TYPEField.Name = "EMERGENCY_TYPE"; EMERGENCY_TYPEField.Type = typeof(int).ToString(); EMERGENCY_TYPEField.Index = 13; fields.Add(EMERGENCY_TYPEField); DataSchemaField COUNT_REASONField = new DataSchemaField(); COUNT_REASONField.Name = "COUNT_REASON"; COUNT_REASONField.Type = typeof(string).ToString(); COUNT_REASONField.Index = 14; fields.Add(COUNT_REASONField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 15; fields.Add(ASSEMBLY_LINEField); DataSchemaField PLANT_ZONEField = new DataSchemaField(); PLANT_ZONEField.Name = "PLANT_ZONE"; PLANT_ZONEField.Type = typeof(string).ToString(); PLANT_ZONEField.Index = 16; fields.Add(PLANT_ZONEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 17; fields.Add(WORKSHOPField); DataSchemaField FROM_SAPField = new DataSchemaField(); FROM_SAPField.Name = "FROM_SAP"; FROM_SAPField.Type = typeof(int).ToString(); FROM_SAPField.Index = 18; fields.Add(FROM_SAPField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 19; fields.Add(COMMENTSField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 20; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 21; fields.Add(CREATE_DATEField); DataSchemaField UPDATE_USERField = new DataSchemaField(); UPDATE_USERField.Name = "UPDATE_USER"; UPDATE_USERField.Type = typeof(string).ToString(); UPDATE_USERField.Index = 22; fields.Add(UPDATE_USERField); DataSchemaField UPDATE_DATEField = new DataSchemaField(); UPDATE_DATEField.Name = "UPDATE_DATE"; UPDATE_DATEField.Type = typeof(DateTime).ToString(); UPDATE_DATEField.Index = 23; fields.Add(UPDATE_DATEField); DataSchemaField ERP_FLAGField = new DataSchemaField(); ERP_FLAGField.Name = "ERP_FLAG"; ERP_FLAGField.Type = typeof(int).ToString(); ERP_FLAGField.Index = 24; fields.Add(ERP_FLAGField); Schema.Fields = fields.ToArray(); }
public SeqCurrentValueInfo() : base("TS_SYS_SEQ_CURRENT_VALUE") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField SEQ_CODEField = new DataSchemaField(); SEQ_CODEField.Name = "SEQ_CODE"; SEQ_CODEField.Type = typeof(string).ToString(); SEQ_CODEField.Index = 2; fields.Add(SEQ_CODEField); DataSchemaField SEQ_SECTION_FIDField = new DataSchemaField(); SEQ_SECTION_FIDField.Name = "SEQ_SECTION_FID"; SEQ_SECTION_FIDField.Type = typeof(Guid).ToString(); SEQ_SECTION_FIDField.Index = 3; fields.Add(SEQ_SECTION_FIDField); DataSchemaField QUERY_VALUEField = new DataSchemaField(); QUERY_VALUEField.Name = "QUERY_VALUE"; QUERY_VALUEField.Type = typeof(string).ToString(); QUERY_VALUEField.Index = 4; fields.Add(QUERY_VALUEField); DataSchemaField CURRENT_VALUEField = new DataSchemaField(); CURRENT_VALUEField.Name = "CURRENT_VALUE"; CURRENT_VALUEField.Type = typeof(int).ToString(); CURRENT_VALUEField.Index = 5; fields.Add(CURRENT_VALUEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 6; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 7; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 8; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 9; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 10; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public SupplierPartQuotaInfo() : base("TT_SPM_SUPPLIER_PART_QUOTA") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 1; fields.Add(PLANTField); DataSchemaField PLANT_NAMEField = new DataSchemaField(); PLANT_NAMEField.Name = "PLANT_NAME"; PLANT_NAMEField.Type = typeof(string).ToString(); PLANT_NAMEField.Index = 2; fields.Add(PLANT_NAMEField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 3; fields.Add(PART_NOField); DataSchemaField PART_CNAMEField = new DataSchemaField(); PART_CNAMEField.Name = "PART_CNAME"; PART_CNAMEField.Type = typeof(string).ToString(); PART_CNAMEField.Index = 4; fields.Add(PART_CNAMEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 5; fields.Add(WORKSHOPField); DataSchemaField WORKSHOP_NAMEField = new DataSchemaField(); WORKSHOP_NAMEField.Name = "WORKSHOP_NAME"; WORKSHOP_NAMEField.Type = typeof(string).ToString(); WORKSHOP_NAMEField.Index = 6; fields.Add(WORKSHOP_NAMEField); DataSchemaField SUPPLIER_NUMField = new DataSchemaField(); SUPPLIER_NUMField.Name = "SUPPLIER_NUM"; SUPPLIER_NUMField.Type = typeof(string).ToString(); SUPPLIER_NUMField.Index = 7; fields.Add(SUPPLIER_NUMField); DataSchemaField SUPPLIER_NAMEField = new DataSchemaField(); SUPPLIER_NAMEField.Name = "SUPPLIER_NAME"; SUPPLIER_NAMEField.Type = typeof(string).ToString(); SUPPLIER_NAMEField.Index = 8; fields.Add(SUPPLIER_NAMEField); DataSchemaField START_EFFECTIVE_DATEField = new DataSchemaField(); START_EFFECTIVE_DATEField.Name = "START_EFFECTIVE_DATE"; START_EFFECTIVE_DATEField.Type = typeof(DateTime).ToString(); START_EFFECTIVE_DATEField.Index = 9; fields.Add(START_EFFECTIVE_DATEField); DataSchemaField END_EFFECTIVE_DATEField = new DataSchemaField(); END_EFFECTIVE_DATEField.Name = "END_EFFECTIVE_DATE"; END_EFFECTIVE_DATEField.Type = typeof(DateTime).ToString(); END_EFFECTIVE_DATEField.Index = 10; fields.Add(END_EFFECTIVE_DATEField); DataSchemaField QUOTEField = new DataSchemaField(); QUOTEField.Name = "QUOTE"; QUOTEField.Type = typeof(decimal).ToString(); QUOTEField.Index = 11; fields.Add(QUOTEField); DataSchemaField PROJECTField = new DataSchemaField(); PROJECTField.Name = "PROJECT"; PROJECTField.Type = typeof(string).ToString(); PROJECTField.Index = 12; fields.Add(PROJECTField); DataSchemaField AGREEMENT_NOField = new DataSchemaField(); AGREEMENT_NOField.Name = "AGREEMENT_NO"; AGREEMENT_NOField.Type = typeof(string).ToString(); AGREEMENT_NOField.Index = 13; fields.Add(AGREEMENT_NOField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 14; fields.Add(COMMENTSField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 15; fields.Add(MODIFY_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 16; fields.Add(MODIFY_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 17; fields.Add(CREATE_DATEField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 18; fields.Add(CREATE_USERField); DataSchemaField LOEKZField = new DataSchemaField(); LOEKZField.Name = "LOEKZ"; LOEKZField.Type = typeof(string).ToString(); LOEKZField.Index = 19; fields.Add(LOEKZField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 20; fields.Add(PROCESS_FLAGField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 21; fields.Add(FIDField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 22; fields.Add(VALID_FLAGField); Schema.Fields = fields.ToArray(); }
public WmsVmiJisPullOrderReturnInfo() : base("TI_IFM_WMS_VMI_JIS_PULL_ORDER_RETURN") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 0; fields.Add(IDField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 1; fields.Add(FIDField); DataSchemaField LOG_FIDField = new DataSchemaField(); LOG_FIDField.Name = "LOG_FID"; LOG_FIDField.Type = typeof(Guid).ToString(); LOG_FIDField.Index = 2; fields.Add(LOG_FIDField); DataSchemaField ORDERCODEField = new DataSchemaField(); ORDERCODEField.Name = "ORDERCODE"; ORDERCODEField.Type = typeof(string).ToString(); ORDERCODEField.Index = 3; fields.Add(ORDERCODEField); DataSchemaField PARTNOField = new DataSchemaField(); PARTNOField.Name = "PARTNO"; PARTNOField.Type = typeof(string).ToString(); PARTNOField.Index = 4; fields.Add(PARTNOField); DataSchemaField CARSORTSEQField = new DataSchemaField(); CARSORTSEQField.Name = "CARSORTSEQ"; CARSORTSEQField.Type = typeof(string).ToString(); CARSORTSEQField.Index = 5; fields.Add(CARSORTSEQField); DataSchemaField WMSSOURCEKEYField = new DataSchemaField(); WMSSOURCEKEYField.Name = "WMSSOURCEKEY"; WMSSOURCEKEYField.Type = typeof(string).ToString(); WMSSOURCEKEYField.Index = 6; fields.Add(WMSSOURCEKEYField); DataSchemaField WMSLINENUMBERField = new DataSchemaField(); WMSLINENUMBERField.Name = "WMSLINENUMBER"; WMSLINENUMBERField.Type = typeof(string).ToString(); WMSLINENUMBERField.Index = 7; fields.Add(WMSLINENUMBERField); DataSchemaField PROCESS_FLAGField = new DataSchemaField(); PROCESS_FLAGField.Name = "PROCESS_FLAG"; PROCESS_FLAGField.Type = typeof(int).ToString(); PROCESS_FLAGField.Index = 8; fields.Add(PROCESS_FLAGField); DataSchemaField PROCESS_TIMEField = new DataSchemaField(); PROCESS_TIMEField.Name = "PROCESS_TIME"; PROCESS_TIMEField.Type = typeof(DateTime).ToString(); PROCESS_TIMEField.Index = 9; fields.Add(PROCESS_TIMEField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 10; fields.Add(VALID_FLAGField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 11; fields.Add(CREATE_USERField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 12; fields.Add(CREATE_DATEField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 13; fields.Add(MODIFY_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 14; fields.Add(MODIFY_DATEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 15; fields.Add(COMMENTSField); Schema.Fields = fields.ToArray(); }
public OnboardTaskGroupInfo() : base("TM_BAS_ONBOARD_TASK_GROUP") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField GROUP_CODEField = new DataSchemaField(); GROUP_CODEField.Name = "GROUP_CODE"; GROUP_CODEField.Type = typeof(string).ToString(); GROUP_CODEField.Index = 0; fields.Add(GROUP_CODEField); DataSchemaField GROUP_NAMEField = new DataSchemaField(); GROUP_NAMEField.Name = "GROUP_NAME"; GROUP_NAMEField.Type = typeof(string).ToString(); GROUP_NAMEField.Index = 1; fields.Add(GROUP_NAMEField); DataSchemaField TASK_TYPEField = new DataSchemaField(); TASK_TYPEField.Name = "TASK_TYPE"; TASK_TYPEField.Type = typeof(int).ToString(); TASK_TYPEField.Index = 2; fields.Add(TASK_TYPEField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 3; fields.Add(PLANTField); DataSchemaField WM_NOField = new DataSchemaField(); WM_NOField.Name = "WM_NO"; WM_NOField.Type = typeof(string).ToString(); WM_NOField.Index = 4; fields.Add(WM_NOField); DataSchemaField ZONE_NOField = new DataSchemaField(); ZONE_NOField.Name = "ZONE_NO"; ZONE_NOField.Type = typeof(string).ToString(); ZONE_NOField.Index = 5; fields.Add(ZONE_NOField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 6; fields.Add(COMMENTSField); DataSchemaField STATUSField = new DataSchemaField(); STATUSField.Name = "STATUS"; STATUSField.Type = typeof(int).ToString(); STATUSField.Index = 7; fields.Add(STATUSField); DataSchemaField IS_GIVEUPField = new DataSchemaField(); IS_GIVEUPField.Name = "IS_GIVEUP"; IS_GIVEUPField.Type = typeof(int).ToString(); IS_GIVEUPField.Index = 8; fields.Add(IS_GIVEUPField); DataSchemaField ROUTEField = new DataSchemaField(); ROUTEField.Name = "ROUTE"; ROUTEField.Type = typeof(string).ToString(); ROUTEField.Index = 9; fields.Add(ROUTEField); DataSchemaField DELAY_TIMEField = new DataSchemaField(); DELAY_TIMEField.Name = "DELAY_TIME"; DELAY_TIMEField.Type = typeof(int).ToString(); DELAY_TIMEField.Index = 10; fields.Add(DELAY_TIMEField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 11; fields.Add(CREATE_DATEField); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 12; fields.Add(IDField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 13; fields.Add(VALID_FLAGField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 14; fields.Add(MODIFY_USERField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 15; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 16; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }
public VechileConsumeLogInfo() : base("TL_PCS_VECHILE_CONSUME_LOG") { List <string> keys = new List <string>(); keys.Add("CONSUME_LOG_IDENTITY"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField CONSUME_LOG_IDENTITYField = new DataSchemaField(); CONSUME_LOG_IDENTITYField.Name = "CONSUME_LOG_IDENTITY"; CONSUME_LOG_IDENTITYField.Type = typeof(int).ToString(); CONSUME_LOG_IDENTITYField.Index = 0; fields.Add(CONSUME_LOG_IDENTITYField); DataSchemaField KNRField = new DataSchemaField(); KNRField.Name = "KNR"; KNRField.Type = typeof(string).ToString(); KNRField.Index = 1; fields.Add(KNRField); DataSchemaField REGION_NOField = new DataSchemaField(); REGION_NOField.Name = "REGION_NO"; REGION_NOField.Type = typeof(string).ToString(); REGION_NOField.Index = 2; fields.Add(REGION_NOField); DataSchemaField FOOTPRINTField = new DataSchemaField(); FOOTPRINTField.Name = "FOOTPRINT"; FOOTPRINTField.Type = typeof(int).ToString(); FOOTPRINTField.Index = 3; fields.Add(FOOTPRINTField); DataSchemaField LOCATIONField = new DataSchemaField(); LOCATIONField.Name = "LOCATION"; LOCATIONField.Type = typeof(string).ToString(); LOCATIONField.Index = 4; fields.Add(LOCATIONField); DataSchemaField PART_NOField = new DataSchemaField(); PART_NOField.Name = "PART_NO"; PART_NOField.Type = typeof(string).ToString(); PART_NOField.Index = 5; fields.Add(PART_NOField); DataSchemaField CURRENT_PART_COUNTField = new DataSchemaField(); CURRENT_PART_COUNTField.Name = "CURRENT_PART_COUNT"; CURRENT_PART_COUNTField.Type = typeof(decimal).ToString(); CURRENT_PART_COUNTField.Index = 6; fields.Add(CURRENT_PART_COUNTField); DataSchemaField DOSAGEField = new DataSchemaField(); DOSAGEField.Name = "DOSAGE"; DOSAGEField.Type = typeof(decimal).ToString(); DOSAGEField.Index = 7; fields.Add(DOSAGEField); DataSchemaField MISSING_TIME_STAMPField = new DataSchemaField(); MISSING_TIME_STAMPField.Name = "MISSING_TIME_STAMP"; MISSING_TIME_STAMPField.Type = typeof(DateTime).ToString(); MISSING_TIME_STAMPField.Index = 8; fields.Add(MISSING_TIME_STAMPField); DataSchemaField CONSUMED_TIME_STAMPField = new DataSchemaField(); CONSUMED_TIME_STAMPField.Name = "CONSUMED_TIME_STAMP"; CONSUMED_TIME_STAMPField.Type = typeof(DateTime).ToString(); CONSUMED_TIME_STAMPField.Index = 9; fields.Add(CONSUMED_TIME_STAMPField); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 10; fields.Add(PLANTField); DataSchemaField ASSEMBLY_LINEField = new DataSchemaField(); ASSEMBLY_LINEField.Name = "ASSEMBLY_LINE"; ASSEMBLY_LINEField.Type = typeof(string).ToString(); ASSEMBLY_LINEField.Index = 11; fields.Add(ASSEMBLY_LINEField); DataSchemaField PLANT_ZONEField = new DataSchemaField(); PLANT_ZONEField.Name = "PLANT_ZONE"; PLANT_ZONEField.Type = typeof(string).ToString(); PLANT_ZONEField.Index = 12; fields.Add(PLANT_ZONEField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 13; fields.Add(WORKSHOPField); DataSchemaField REPLACE_PARTField = new DataSchemaField(); REPLACE_PARTField.Name = "REPLACE_PART"; REPLACE_PARTField.Type = typeof(string).ToString(); REPLACE_PARTField.Index = 14; fields.Add(REPLACE_PARTField); Schema.Fields = fields.ToArray(); }
public WorkshopInfo() : base("TM_BAS_WORKSHOP") { List <string> keys = new List <string>(); keys.Add("ID"); _Keys = keys.ToArray(); Schema = new DataSchema(); List <DataSchemaField> fields = new List <DataSchemaField>(); DataSchemaField PLANTField = new DataSchemaField(); PLANTField.Name = "PLANT"; PLANTField.Type = typeof(string).ToString(); PLANTField.Index = 0; fields.Add(PLANTField); DataSchemaField WORKSHOPField = new DataSchemaField(); WORKSHOPField.Name = "WORKSHOP"; WORKSHOPField.Type = typeof(string).ToString(); WORKSHOPField.Index = 1; fields.Add(WORKSHOPField); DataSchemaField WORKSHOP_NAMEField = new DataSchemaField(); WORKSHOP_NAMEField.Name = "WORKSHOP_NAME"; WORKSHOP_NAMEField.Type = typeof(string).ToString(); WORKSHOP_NAMEField.Index = 2; fields.Add(WORKSHOP_NAMEField); DataSchemaField COMMENTSField = new DataSchemaField(); COMMENTSField.Name = "COMMENTS"; COMMENTSField.Type = typeof(string).ToString(); COMMENTSField.Index = 3; fields.Add(COMMENTSField); DataSchemaField TIME_REFERENCE_TYPEField = new DataSchemaField(); TIME_REFERENCE_TYPEField.Name = "TIME_REFERENCE_TYPE"; TIME_REFERENCE_TYPEField.Type = typeof(int).ToString(); TIME_REFERENCE_TYPEField.Index = 4; fields.Add(TIME_REFERENCE_TYPEField); DataSchemaField WORK_SCHEDULE_TYPEField = new DataSchemaField(); WORK_SCHEDULE_TYPEField.Name = "WORK_SCHEDULE_TYPE"; WORK_SCHEDULE_TYPEField.Type = typeof(int).ToString(); WORK_SCHEDULE_TYPEField.Index = 5; fields.Add(WORK_SCHEDULE_TYPEField); DataSchemaField WORKSHOP_TYPEField = new DataSchemaField(); WORKSHOP_TYPEField.Name = "WORKSHOP_TYPE"; WORKSHOP_TYPEField.Type = typeof(int).ToString(); WORKSHOP_TYPEField.Index = 6; fields.Add(WORKSHOP_TYPEField); DataSchemaField CREATE_DATEField = new DataSchemaField(); CREATE_DATEField.Name = "CREATE_DATE"; CREATE_DATEField.Type = typeof(DateTime).ToString(); CREATE_DATEField.Index = 7; fields.Add(CREATE_DATEField); DataSchemaField IDField = new DataSchemaField(); IDField.Name = "ID"; IDField.Type = typeof(long).ToString(); IDField.Index = 8; fields.Add(IDField); DataSchemaField VALID_FLAGField = new DataSchemaField(); VALID_FLAGField.Name = "VALID_FLAG"; VALID_FLAGField.Type = typeof(bool).ToString(); VALID_FLAGField.Index = 9; fields.Add(VALID_FLAGField); DataSchemaField MODIFY_USERField = new DataSchemaField(); MODIFY_USERField.Name = "MODIFY_USER"; MODIFY_USERField.Type = typeof(string).ToString(); MODIFY_USERField.Index = 10; fields.Add(MODIFY_USERField); DataSchemaField FIDField = new DataSchemaField(); FIDField.Name = "FID"; FIDField.Type = typeof(Guid).ToString(); FIDField.Index = 11; fields.Add(FIDField); DataSchemaField CREATE_USERField = new DataSchemaField(); CREATE_USERField.Name = "CREATE_USER"; CREATE_USERField.Type = typeof(string).ToString(); CREATE_USERField.Index = 12; fields.Add(CREATE_USERField); DataSchemaField MODIFY_DATEField = new DataSchemaField(); MODIFY_DATEField.Name = "MODIFY_DATE"; MODIFY_DATEField.Type = typeof(DateTime).ToString(); MODIFY_DATEField.Index = 13; fields.Add(MODIFY_DATEField); Schema.Fields = fields.ToArray(); }