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();
        }
Пример #2
0
 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();
        }
Пример #4
0
        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();
        }
Пример #6
0
        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();
        }
Пример #9
0
        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();
        }
Пример #10
0
        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();
        }
Пример #11
0
        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();
        }
Пример #14
0
        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();
        }
Пример #19
0
        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();
        }
Пример #22
0
        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();
        }
Пример #23
0
        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();
        }
Пример #29
0
        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();
        }
Пример #30
0
        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();
        }