public void SetPropertyDescriptor(DataSchema dataSchema, PropertyDescriptor propertyDescriptor)
 {
     DataSchema = dataSchema;
     PropertyDescriptor = propertyDescriptor;
     PopulateCombo(comboOperation1, FilterOperations.OP_HAS_ANY_VALUE.DisplayName, dataSchema, propertyDescriptor.PropertyType);
     PopulateCombo(comboOperation2, Resources.QuickFilterForm_SetPropertyDescriptor_No_other_filter, dataSchema, propertyDescriptor.PropertyType);
     Text = string.Format(Resources.QuickFilterForm_SetPropertyDescriptor_Show_rows_where__0____, propertyDescriptor.DisplayName);
 }
 public void SetFilter(DataSchema dataSchema, PropertyDescriptor propertyDescriptor, RowFilter rowFilter)
 {
     RowFilter = rowFilter;
     SetPropertyDescriptor(dataSchema, propertyDescriptor);
     var columnFilters = rowFilter.GetColumnFilters(propertyDescriptor).ToArray();
     if (columnFilters.Length >= 1)
     {
         SetFilterOperation(comboOperation1, tbxOperand1, columnFilters[0]);
         tbxOperand1.Text = columnFilters[0].Operand;
     }
     if (columnFilters.Length >= 2)
     {
         SetFilterOperation(comboOperation2, tbxOperand2, columnFilters[1]);
     }
 }
 private void PopulateCombo(ComboBox comboBox, String hasAnyValueCaption, DataSchema dataSchema,
     Type propertyType)
 {
     comboBox.Items.Clear();
     foreach (var filterOperation in FilterOperations.ListOperations())
     {
         if (!filterOperation.IsValidFor(dataSchema, propertyType))
         {
             continue;
         }
         string displayName;
         if (filterOperation == FilterOperations.OP_HAS_ANY_VALUE)
         {
             displayName = hasAnyValueCaption;
         }
         else
         {
             displayName = filterOperation.DisplayName;
         }
         comboBox.Items.Add(new FilterItem(displayName, filterOperation));
     }
 }
        public WmsVmiPackageInfo() : base("TI_IFM_WMS_VMI_PACKAGE")
        {
            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 SKUField = new DataSchemaField();

            SKUField.Name  = "SKU";
            SKUField.Type  = typeof(string).ToString();
            SKUField.Index = 3;
            fields.Add(SKUField);

            DataSchemaField SKUDESCRField = new DataSchemaField();

            SKUDESCRField.Name  = "SKUDESCR";
            SKUDESCRField.Type  = typeof(string).ToString();
            SKUDESCRField.Index = 4;
            fields.Add(SKUDESCRField);

            DataSchemaField SKUCLSField = new DataSchemaField();

            SKUCLSField.Name  = "SKUCLS";
            SKUCLSField.Type  = typeof(string).ToString();
            SKUCLSField.Index = 5;
            fields.Add(SKUCLSField);

            DataSchemaField SUPPLYCODEField = new DataSchemaField();

            SUPPLYCODEField.Name  = "SUPPLYCODE";
            SUPPLYCODEField.Type  = typeof(string).ToString();
            SUPPLYCODEField.Index = 6;
            fields.Add(SUPPLYCODEField);

            DataSchemaField PROCESS_FLAGField = new DataSchemaField();

            PROCESS_FLAGField.Name  = "PROCESS_FLAG";
            PROCESS_FLAGField.Type  = typeof(int).ToString();
            PROCESS_FLAGField.Index = 7;
            fields.Add(PROCESS_FLAGField);

            DataSchemaField PROCESS_TIMEField = new DataSchemaField();

            PROCESS_TIMEField.Name  = "PROCESS_TIME";
            PROCESS_TIMEField.Type  = typeof(DateTime).ToString();
            PROCESS_TIMEField.Index = 8;
            fields.Add(PROCESS_TIMEField);

            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_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 MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 12;
            fields.Add(MODIFY_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);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 14;
            fields.Add(COMMENTSField);

            Schema.Fields = fields.ToArray();
        }
 public override SqlDataSet <TBusiness, TEntity> SqlDataSetFactory <TBusiness, TEntity>(DataSchema dataSchema, IQueryProvider queryProvider)
 {
     return(new AspNetCoreSqlDataSet <TBusiness, TEntity>(
                dataSchema.Sql.SqlEntities.OfType <SqlDataModel <TEntity> >().First(),
                queryProvider,
                _objectFactory,
                _bindingProvider
                ));
 }
        public PlanWindowTimeInfo() : base("TT_MPM_PLAN_WINDOW_TIME")
        {
            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_BOX_FIDField = new DataSchemaField();

            PART_BOX_FIDField.Name  = "PART_BOX_FID";
            PART_BOX_FIDField.Type  = typeof(Guid).ToString();
            PART_BOX_FIDField.Index = 2;
            fields.Add(PART_BOX_FIDField);

            DataSchemaField PART_BOX_CODEField = new DataSchemaField();

            PART_BOX_CODEField.Name  = "PART_BOX_CODE";
            PART_BOX_CODEField.Type  = typeof(string).ToString();
            PART_BOX_CODEField.Index = 3;
            fields.Add(PART_BOX_CODEField);

            DataSchemaField PART_BOX_NAMEField = new DataSchemaField();

            PART_BOX_NAMEField.Name  = "PART_BOX_NAME";
            PART_BOX_NAMEField.Type  = typeof(string).ToString();
            PART_BOX_NAMEField.Index = 4;
            fields.Add(PART_BOX_NAMEField);

            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 SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 8;
            fields.Add(SUPPLIER_NUMField);

            DataSchemaField WORK_DAYField = new DataSchemaField();

            WORK_DAYField.Name  = "WORK_DAY";
            WORK_DAYField.Type  = typeof(DateTime).ToString();
            WORK_DAYField.Index = 9;
            fields.Add(WORK_DAYField);

            DataSchemaField SEND_TIMEField = new DataSchemaField();

            SEND_TIMEField.Name  = "SEND_TIME";
            SEND_TIMEField.Type  = typeof(DateTime).ToString();
            SEND_TIMEField.Index = 10;
            fields.Add(SEND_TIMEField);

            DataSchemaField WINDOW_TIMEField = new DataSchemaField();

            WINDOW_TIMEField.Name  = "WINDOW_TIME";
            WINDOW_TIMEField.Type  = typeof(DateTime).ToString();
            WINDOW_TIMEField.Index = 11;
            fields.Add(WINDOW_TIMEField);

            DataSchemaField SEND_TIME_STATUSField = new DataSchemaField();

            SEND_TIME_STATUSField.Name  = "SEND_TIME_STATUS";
            SEND_TIME_STATUSField.Type  = typeof(int).ToString();
            SEND_TIME_STATUSField.Index = 12;
            fields.Add(SEND_TIME_STATUSField);

            DataSchemaField TIME_ZONEField = new DataSchemaField();

            TIME_ZONEField.Name  = "TIME_ZONE";
            TIME_ZONEField.Type  = typeof(string).ToString();
            TIME_ZONEField.Index = 13;
            fields.Add(TIME_ZONEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 14;
            fields.Add(COMMENTSField);

            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_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 16;
            fields.Add(CREATE_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 MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 18;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 19;
            fields.Add(MODIFY_DATEField);

            Schema.Fields = fields.ToArray();
        }
Exemple #7
0
        /// <summary>
        /// 生成实体
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Build_Model(object sender, RoutedEventArgs e)
        {
            var list = new List <EntityInfo>();

            //生成list
            foreach (var item in Dtable.Items)
            {
                var box = Common.GetTemplateColumn <System.Windows.Controls.CheckBox>(Dtable, 0, "tabBox", item);

                if (box != null && box.IsChecked == true)
                {
                    var entiy = new EntityInfo();
                    entiy.table       = item as BaseTable;
                    entiy.language    = language.SelectionBoxItem.ToString();
                    entiy.columns     = DataSchema.ColumnList(AppCache.GetBuildLink(), entiy.table.tabName) ?? new List <BaseColumn>();
                    entiy.columns     = entiy.disColType(entiy.columns, entiy.language);
                    entiy.isSerialize = (bool)isSerialize.IsChecked;
                    entiy.isCheck     = (bool)isCheck.IsChecked;
                    entiy.isMap       = (bool)isMap.IsChecked;
                    entiy.isModel     = (bool)isModel.IsChecked;
                    entiy.isOldModel  = (bool)isOldModel.IsChecked;

                    if (DataDbType.Oracle == AppCache.GetBuildLink().dbType)
                    {
                        entiy.param = ":";
                    }

                    if (DataDbType.MySql == AppCache.GetBuildLink().dbType)
                    {
                        entiy.param = "?";
                    }

                    if (DataDbType.SqlServer == AppCache.GetBuildLink().dbType)
                    {
                        entiy.param = "@";
                    }

                    if (!entiy.isCheck && !entiy.isSerialize && !entiy.isMap && !entiy.isModel && !entiy.isOldModel)
                    {
                        CodeBox.Show("请选择模板", this);
                        return;
                    }

                    list.Add(entiy);
                }
            }

            if (list.Count == 0)
            {
                CodeBox.Show("请选择要生成表", this);
                return;
            }

            //执行生成实体
            list.ForEach(a => {
                //命名空间
                a.nameSpace = txtNameSpace.Text.Trim();

                //生成路径
                if (txtFile != "")
                {
                    a.modelFile = txtFile;
                }

                //语言
                a.language = language.SelectionBoxItem.ToString();

                if (a.isMap)
                {
                    Common.BuildCodeModel(a, "xml");
                }

                else
                {
                    Common.BuildCodeModel(a);
                }
            });

            CodeBox.Show(string.Format("生成完成"), this);
        }
Exemple #8
0
        public SmsOutboundLogInfo() : base("TI_IFM_SMS_OUTBOUND_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 KEY_VALUEField = new DataSchemaField();

            KEY_VALUEField.Name  = "KEY_VALUE";
            KEY_VALUEField.Type  = typeof(string).ToString();
            KEY_VALUEField.Index = 6;
            fields.Add(KEY_VALUEField);

            DataSchemaField EXECUTE_START_TIMEField = new DataSchemaField();

            EXECUTE_START_TIMEField.Name  = "EXECUTE_START_TIME";
            EXECUTE_START_TIMEField.Type  = typeof(DateTime).ToString();
            EXECUTE_START_TIMEField.Index = 7;
            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 = 8;
            fields.Add(EXECUTE_END_TIMEField);

            DataSchemaField EXECUTE_RESULTField = new DataSchemaField();

            EXECUTE_RESULTField.Name  = "EXECUTE_RESULT";
            EXECUTE_RESULTField.Type  = typeof(int).ToString();
            EXECUTE_RESULTField.Index = 9;
            fields.Add(EXECUTE_RESULTField);

            DataSchemaField EXECUTE_TIMESField = new DataSchemaField();

            EXECUTE_TIMESField.Name  = "EXECUTE_TIMES";
            EXECUTE_TIMESField.Type  = typeof(int).ToString();
            EXECUTE_TIMESField.Index = 10;
            fields.Add(EXECUTE_TIMESField);

            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();
        }
Exemple #9
0
        public DataSchema CompileSchema(IVerificationContext context)
        {
            if (context == null)
            {
                throw new ArgumentNullException("context");
            }

            DataSchema dataSchema = new DataSchema();
            dataSchema.Name = Name;

            foreach (var filePath in InputFiles)
            {
                var inputFilePath = Path.GetFullPath(filePath);

                if (!File.Exists(inputFilePath))
                {

                    context.Add(new VerificationMessage(Severity.Error, string.Format(CultureInfo.CurrentCulture, Properties.Resources.InputFileNotFound, inputFilePath)));
                    return null;
                }

                using (StreamReader reader = new StreamReader(inputFilePath))
                {
                    dataSchema.LoadDataSchemaFile(reader, context);
                }
            }

            if (!string.IsNullOrEmpty(Options.PrimaryKeyFormatString))
            {
                dataSchema.NameFormats.PrimaryKeyFormatString = Options.PrimaryKeyFormatString;
            }
            if (!string.IsNullOrEmpty(Options.ForeignKeyFormatString))
            {
                dataSchema.NameFormats.ForeignKeyFormatString = Options.ForeignKeyFormatString;
            }
            if (!string.IsNullOrEmpty(Options.UniqueIndexFormatString))
            {
                dataSchema.NameFormats.UniqueIndexFormatString = Options.UniqueIndexFormatString;
            }
            if (!string.IsNullOrEmpty(Options.IndexFormatString))
            {
                dataSchema.NameFormats.IndexFormatString = Options.IndexFormatString;
            }

            return dataSchema;
        }
        public SpsPullOrderInfo() : base("TT_MPM_SPS_PULL_ORDER")
        {
            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_CODEField = new DataSchemaField();

            ORDER_CODEField.Name  = "ORDER_CODE";
            ORDER_CODEField.Type  = typeof(string).ToString();
            ORDER_CODEField.Index = 2;
            fields.Add(ORDER_CODEField);

            DataSchemaField PART_BOX_CODEField = new DataSchemaField();

            PART_BOX_CODEField.Name  = "PART_BOX_CODE";
            PART_BOX_CODEField.Type  = typeof(string).ToString();
            PART_BOX_CODEField.Index = 3;
            fields.Add(PART_BOX_CODEField);

            DataSchemaField PART_BOX_NAMEField = new DataSchemaField();

            PART_BOX_NAMEField.Name  = "PART_BOX_NAME";
            PART_BOX_NAMEField.Type  = typeof(string).ToString();
            PART_BOX_NAMEField.Index = 4;
            fields.Add(PART_BOX_NAMEField);

            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 SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 8;
            fields.Add(SUPPLIER_NUMField);

            DataSchemaField S_ZONE_NOField = new DataSchemaField();

            S_ZONE_NOField.Name  = "S_ZONE_NO";
            S_ZONE_NOField.Type  = typeof(string).ToString();
            S_ZONE_NOField.Index = 9;
            fields.Add(S_ZONE_NOField);

            DataSchemaField S_WM_NOField = new DataSchemaField();

            S_WM_NOField.Name  = "S_WM_NO";
            S_WM_NOField.Type  = typeof(string).ToString();
            S_WM_NOField.Index = 10;
            fields.Add(S_WM_NOField);

            DataSchemaField T_ZONE_NOField = new DataSchemaField();

            T_ZONE_NOField.Name  = "T_ZONE_NO";
            T_ZONE_NOField.Type  = typeof(string).ToString();
            T_ZONE_NOField.Index = 11;
            fields.Add(T_ZONE_NOField);

            DataSchemaField T_WM_NOField = new DataSchemaField();

            T_WM_NOField.Name  = "T_WM_NO";
            T_WM_NOField.Type  = typeof(string).ToString();
            T_WM_NOField.Index = 12;
            fields.Add(T_WM_NOField);

            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 ORDER_TYPEField = new DataSchemaField();

            ORDER_TYPEField.Name  = "ORDER_TYPE";
            ORDER_TYPEField.Type  = typeof(int).ToString();
            ORDER_TYPEField.Index = 14;
            fields.Add(ORDER_TYPEField);

            DataSchemaField DOCKField = new DataSchemaField();

            DOCKField.Name  = "DOCK";
            DOCKField.Type  = typeof(string).ToString();
            DOCKField.Index = 15;
            fields.Add(DOCKField);

            DataSchemaField PLAN_SHIPPING_TIMEField = new DataSchemaField();

            PLAN_SHIPPING_TIMEField.Name  = "PLAN_SHIPPING_TIME";
            PLAN_SHIPPING_TIMEField.Type  = typeof(DateTime).ToString();
            PLAN_SHIPPING_TIMEField.Index = 16;
            fields.Add(PLAN_SHIPPING_TIMEField);

            DataSchemaField PLAN_DELIVERY_TIMEField = new DataSchemaField();

            PLAN_DELIVERY_TIMEField.Name  = "PLAN_DELIVERY_TIME";
            PLAN_DELIVERY_TIMEField.Type  = typeof(DateTime).ToString();
            PLAN_DELIVERY_TIMEField.Index = 17;
            fields.Add(PLAN_DELIVERY_TIMEField);

            DataSchemaField ACTUAL_ARRIVAL_TIMEField = new DataSchemaField();

            ACTUAL_ARRIVAL_TIMEField.Name  = "ACTUAL_ARRIVAL_TIME";
            ACTUAL_ARRIVAL_TIMEField.Type  = typeof(DateTime).ToString();
            ACTUAL_ARRIVAL_TIMEField.Index = 18;
            fields.Add(ACTUAL_ARRIVAL_TIMEField);

            DataSchemaField ACTUAL_UNLOADING_TIMEField = new DataSchemaField();

            ACTUAL_UNLOADING_TIMEField.Name  = "ACTUAL_UNLOADING_TIME";
            ACTUAL_UNLOADING_TIMEField.Type  = typeof(DateTime).ToString();
            ACTUAL_UNLOADING_TIMEField.Index = 19;
            fields.Add(ACTUAL_UNLOADING_TIMEField);

            DataSchemaField ORDER_STATUSField = new DataSchemaField();

            ORDER_STATUSField.Name  = "ORDER_STATUS";
            ORDER_STATUSField.Type  = typeof(int).ToString();
            ORDER_STATUSField.Index = 20;
            fields.Add(ORDER_STATUSField);

            DataSchemaField PRINT_TIMESField = new DataSchemaField();

            PRINT_TIMESField.Name  = "PRINT_TIMES";
            PRINT_TIMESField.Type  = typeof(int).ToString();
            PRINT_TIMESField.Index = 21;
            fields.Add(PRINT_TIMESField);

            DataSchemaField LAST_PRINT_DATEField = new DataSchemaField();

            LAST_PRINT_DATEField.Name  = "LAST_PRINT_DATE";
            LAST_PRINT_DATEField.Type  = typeof(DateTime).ToString();
            LAST_PRINT_DATEField.Index = 22;
            fields.Add(LAST_PRINT_DATEField);

            DataSchemaField LAST_PRINT_USERField = new DataSchemaField();

            LAST_PRINT_USERField.Name  = "LAST_PRINT_USER";
            LAST_PRINT_USERField.Type  = typeof(string).ToString();
            LAST_PRINT_USERField.Index = 23;
            fields.Add(LAST_PRINT_USERField);

            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 = 24;
            fields.Add(DAY_VEHICHE_SEQ_NOField);

            DataSchemaField KEEPERField = new DataSchemaField();

            KEEPERField.Name  = "KEEPER";
            KEEPERField.Type  = typeof(string).ToString();
            KEEPERField.Index = 25;
            fields.Add(KEEPERField);

            DataSchemaField VEHICHE_MODEL_NOField = new DataSchemaField();

            VEHICHE_MODEL_NOField.Name  = "VEHICHE_MODEL_NO";
            VEHICHE_MODEL_NOField.Type  = typeof(string).ToString();
            VEHICHE_MODEL_NOField.Index = 26;
            fields.Add(VEHICHE_MODEL_NOField);

            DataSchemaField PRODUCTION_NOField = new DataSchemaField();

            PRODUCTION_NOField.Name  = "PRODUCTION_NO";
            PRODUCTION_NOField.Type  = typeof(string).ToString();
            PRODUCTION_NOField.Index = 27;
            fields.Add(PRODUCTION_NOField);

            DataSchemaField PACKAGE_MODELField = new DataSchemaField();

            PACKAGE_MODELField.Name  = "PACKAGE_MODEL";
            PACKAGE_MODELField.Type  = typeof(string).ToString();
            PACKAGE_MODELField.Index = 28;
            fields.Add(PACKAGE_MODELField);

            DataSchemaField PACKAGEField = new DataSchemaField();

            PACKAGEField.Name  = "PACKAGE";
            PACKAGEField.Type  = typeof(decimal).ToString();
            PACKAGEField.Index = 29;
            fields.Add(PACKAGEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 30;
            fields.Add(COMMENTSField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 31;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 32;
            fields.Add(CREATE_DATEField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 33;
            fields.Add(CREATE_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 34;
            fields.Add(MODIFY_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 35;
            fields.Add(MODIFY_USERField);

            Schema.Fields = fields.ToArray();
        }
Exemple #11
0
        private void ReadVisio(DataSchema dataSchema)
        {
            // Search for the right model among the ones available in
            // the visioModelingEngine
            IEnumIVMEModels modelsEnumerator = visioModelingEngine.Models;
            IVMEModel model = modelsEnumerator.Next();
            while (model.Filename != ModelFilePath)
            {
                model = modelsEnumerator.Next();
            }

            if (backgroundWorker.CancellationPending)
                return;

            ReadTables(dataSchema, model.Elements);
            ReadRelations(dataSchema, model.Elements);
        }
Exemple #12
0
        private void ReadTables(DataSchema dataSchema, IEnumIVMEModelElements elementEnumerator)
        {
            //  Iterate over all the entities in the model, searching
            //  for tables.
            //  Each entity is a table, we gather column and index information from here
            for (IVMEModelElement element = elementEnumerator.Next(); element != null; element = elementEnumerator.Next())
            {
                if (backgroundWorker.CancellationPending)
                    return;

                if (element.Type == VMEModelElementKind.eVMEKindEREntity)
                {
                    IVMEEntity entity = element as IVMEEntity;

                    Table newTable = new Table();
                    newTable.Name = entity.PhysicalName;
                    dataSchema.Tables.Add(newTable);

                    //
                    //  Here we search for the columns of the table
                    //
                    IEnumIVMEAttributes columnEnumerator = entity.Attributes;
                    for (IVMEAttribute columnDefinition = columnEnumerator.Next(); columnDefinition != null; columnDefinition = columnEnumerator.Next())
                    {
                        if (backgroundWorker.CancellationPending)
                            return;
                        Column newColumn = new Column();
                        newColumn.Name = columnDefinition.PhysicalName;
                        string columnTypeName = GetColumnTypeName(columnDefinition.DataType);
                        newColumn.ColumnType = FindColumnType(dataSchema, columnTypeName);
                        if (newColumn.ColumnType == null)
                        {
                            throw CreateException("Column type " + columnTypeName + " used in table " + newTable.Name + " was not found in the type definition document");
                        }

                        newColumn.CanBeNull = columnDefinition.AllowNulls;
                        newTable.Columns.Add(newColumn);
                    }

                    //
                    //  Now we search for indexes in the structure
                    //
                    IEnumIVMEEntityAnnotations indexesEnumerator = entity.EntityAnnotations;
                    for (IVMEEntityAnnotation indexDefinition = indexesEnumerator.Next(); indexDefinition != null; indexDefinition = indexesEnumerator.Next())
                    {
                        if (backgroundWorker.CancellationPending)
                            return;
                        bool isPrimaryKey = indexDefinition.kind == VMEEREntityAnnotationKind.eVMEEREntityAnnotationPrimary;
                        if (!isPrimaryKey)
                        {
                            // Primary keys in the Knightrunner DataSchema are not index objects
                            Index newIndex = new Index(newTable);
                            newIndex.Name = indexDefinition.PhysicalName;
                            newIndex.IsUnique = indexDefinition.kind == VMEEREntityAnnotationKind.eVMEEREntityAnnotationAlternate;

                            IEnumIVMEAttributes indexColumnEnumerator = indexDefinition.Attributes;
                            for (IVMEAttribute indexColumn = indexColumnEnumerator.Next(); indexColumn != null; indexColumn = indexColumnEnumerator.Next())
                            {
                                newIndex.Columns.Add(newTable.Columns[indexColumn.PhysicalName]);
                            }

                            newTable.Indices.Add(newIndex);
                        }
                        else
                        {
                            IEnumIVMEAttributes indexColumnEnumerator = indexDefinition.Attributes;
                            for (IVMEAttribute indexColumn = indexColumnEnumerator.Next(); indexColumn != null; indexColumn = indexColumnEnumerator.Next())
                            {
                                newTable.Columns[indexColumn.PhysicalName].InPrimaryKey = true;
                            }
                        }
                    }

                }
            }
        }
Exemple #13
0
        private void ReadRelations(DataSchema dataSchema, IEnumIVMEModelElements elementEnumerator)
        {
            //
            //  Iterates over all the entities in the model, searching
            //  for relationships.
            //
            //  for each relationship, we need to find the related tables
            //  and all the interesting properties of the relationship
            //
            for (IVMEModelElement element = elementEnumerator.Next(); element != null; element = elementEnumerator.Next())
            {
                if (element.Type == VMEModelElementKind.eVMEKindERRelationship)
                {
                    IVMEBinaryRelationship relationship = element as IVMEBinaryRelationship;

                    if (relationship.FirstEntity != null && relationship.SecondEntity != null)
                    {
                        string relationName = relationship.PhysicalName;
                        Table primaryTable = dataSchema.Tables[relationship.FirstEntity.PhysicalName];
                        Table referencedTable = dataSchema.Tables[relationship.SecondEntity.PhysicalName];

                        //
                        //  Now we need to add the columns that are used to mantain the
                        //  relationship. We need two cursors, one for the primary
                        //  table and the other for the referenced one
                        //
                        IEnumIVMEAttributes primaryColumnEnumerator = relationship.FirstAttributes;
                        IVMEAttribute primaryColumn = primaryColumnEnumerator.Next();

                        IEnumIVMEAttributes referencedColumnEnumerator = relationship.SecondAttributes;
                        IVMEAttribute referencedColumn = referencedColumnEnumerator.Next();

                        while (primaryColumn != null)
                        {
                            Column primaryDataColumn = primaryTable.Columns[primaryColumn.PhysicalName];
                            Column referencedDataColumn = referencedTable.Columns[referencedColumn.PhysicalName];

                            ForeignKey foreignKey = new ForeignKey();
                            foreignKey.FromTable = primaryTable;
                            foreignKey.ToTable = referencedTable;
                            foreignKey.Columns.Add(new ForeignKey.ColumnPair { FromColumn = primaryDataColumn, ToColumn = referencedDataColumn });

                            primaryColumn = primaryColumnEnumerator.Next();
                            referencedColumn = referencedColumnEnumerator.Next();
                        }
                    }
                }
            }
        }
Exemple #14
0
        private DataSchema InitializeSchema()
        {
            var verificationContext = new VerificationContext();
            DataSchema dataSchema = new DataSchema();
            dataSchema.Name = Path.GetFileNameWithoutExtension(DataTypesFilePath);
            using (StreamReader reader = new StreamReader(DataTypesFilePath))
            {
                dataSchema.LoadDataSchemaFile(reader, verificationContext);
            }
            dataSchema.Verify(verificationContext);

            if (!backgroundWorker.CancellationPending && verificationContext.HasErrors)
            {
                ReportErrors(verificationContext);
                return null;
            }

            return dataSchema;
        }
Exemple #15
0
 private void GenerateScript(DataSchema dataSchema)
 {
     TargetSystem targetSystem = dataSchema.TargetSystems[TargetSystemNameForScript];
     SqlServerScriptGenerator gen = new SqlServerScriptGenerator();
     gen.TargetSystem = targetSystem;
     gen.DataSchema = dataSchema;
     using (FileStream stream = new FileStream(SqlScriptFilePath, FileMode.Create))
     {
         gen.Generate(stream);
     }
 }
        public Shgx002Info() : base("V_WMM_SHGX_002")
        {
            List <string> keys = new List <string>();

            _Keys = keys.ToArray();

            Schema = new DataSchema();
            List <DataSchemaField> fields = new List <DataSchemaField>();


            DataSchemaField SumVolumeField = new DataSchemaField();

            SumVolumeField.Name  = "SumVolume";
            SumVolumeField.Type  = typeof(decimal).ToString();
            SumVolumeField.Index = 0;
            fields.Add(SumVolumeField);

            DataSchemaField CustTrustNoField = new DataSchemaField();

            CustTrustNoField.Name  = "CustTrustNo";
            CustTrustNoField.Type  = typeof(string).ToString();
            CustTrustNoField.Index = 1;
            fields.Add(CustTrustNoField);

            DataSchemaField CustNameField = new DataSchemaField();

            CustNameField.Name  = "CustName";
            CustNameField.Type  = typeof(string).ToString();
            CustNameField.Index = 2;
            fields.Add(CustNameField);

            DataSchemaField YsfField = new DataSchemaField();

            YsfField.Name  = "Ysf";
            YsfField.Type  = typeof(decimal).ToString();
            YsfField.Index = 3;
            fields.Add(YsfField);

            DataSchemaField QtfyField = new DataSchemaField();

            QtfyField.Name  = "Qtfy";
            QtfyField.Type  = typeof(decimal).ToString();
            QtfyField.Index = 4;
            fields.Add(QtfyField);

            DataSchemaField BxfField = new DataSchemaField();

            BxfField.Name  = "Bxf";
            BxfField.Type  = typeof(decimal).ToString();
            BxfField.Index = 5;
            fields.Add(BxfField);

            DataSchemaField SumPackageQtyField = new DataSchemaField();

            SumPackageQtyField.Name  = "SumPackageQty";
            SumPackageQtyField.Type  = typeof(int).ToString();
            SumPackageQtyField.Index = 6;
            fields.Add(SumPackageQtyField);

            DataSchemaField IDField = new DataSchemaField();

            IDField.Name  = "ID";
            IDField.Type  = typeof(long).ToString();
            IDField.Index = 7;
            fields.Add(IDField);

            DataSchemaField RouteNameField = new DataSchemaField();

            RouteNameField.Name  = "RouteName";
            RouteNameField.Type  = typeof(string).ToString();
            RouteNameField.Index = 8;
            fields.Add(RouteNameField);

            DataSchemaField SourceZoneField = new DataSchemaField();

            SourceZoneField.Name  = "SourceZone";
            SourceZoneField.Type  = typeof(string).ToString();
            SourceZoneField.Index = 9;
            fields.Add(SourceZoneField);

            DataSchemaField BgfField = new DataSchemaField();

            BgfField.Name  = "Bgf";
            BgfField.Type  = typeof(decimal).ToString();
            BgfField.Index = 10;
            fields.Add(BgfField);

            DataSchemaField TrustTimeField = new DataSchemaField();

            TrustTimeField.Name  = "TrustTime";
            TrustTimeField.Type  = typeof(DateTime).ToString();
            TrustTimeField.Index = 11;
            fields.Add(TrustTimeField);

            DataSchemaField KdfField = new DataSchemaField();

            KdfField.Name  = "Kdf";
            KdfField.Type  = typeof(decimal).ToString();
            KdfField.Index = 12;
            fields.Add(KdfField);

            DataSchemaField SumAmountField = new DataSchemaField();

            SumAmountField.Name  = "SumAmount";
            SumAmountField.Type  = typeof(decimal).ToString();
            SumAmountField.Index = 13;
            fields.Add(SumAmountField);

            DataSchemaField OrganizationNameField = new DataSchemaField();

            OrganizationNameField.Name  = "OrganizationName";
            OrganizationNameField.Type  = typeof(string).ToString();
            OrganizationNameField.Index = 14;
            fields.Add(OrganizationNameField);

            DataSchemaField OrderTypeField = new DataSchemaField();

            OrderTypeField.Name  = "OrderType";
            OrderTypeField.Type  = typeof(string).ToString();
            OrderTypeField.Index = 15;
            fields.Add(OrderTypeField);

            DataSchemaField SumWeightField = new DataSchemaField();

            SumWeightField.Name  = "SumWeight";
            SumWeightField.Type  = typeof(decimal).ToString();
            SumWeightField.Index = 16;
            fields.Add(SumWeightField);

            DataSchemaField OrderNoField = new DataSchemaField();

            OrderNoField.Name  = "OrderNo";
            OrderNoField.Type  = typeof(string).ToString();
            OrderNoField.Index = 17;
            fields.Add(OrderNoField);

            DataSchemaField XkzField = new DataSchemaField();

            XkzField.Name  = "Xkz";
            XkzField.Type  = typeof(decimal).ToString();
            XkzField.Index = 18;
            fields.Add(XkzField);

            DataSchemaField TargetZoneField = new DataSchemaField();

            TargetZoneField.Name  = "TargetZone";
            TargetZoneField.Type  = typeof(string).ToString();
            TargetZoneField.Index = 19;
            fields.Add(TargetZoneField);

            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 InspectionModeField = new DataSchemaField();

            InspectionModeField.Name  = "InspectionMode";
            InspectionModeField.Type  = typeof(string).ToString();
            InspectionModeField.Index = 21;
            fields.Add(InspectionModeField);

            DataSchemaField JcfField = new DataSchemaField();

            JcfField.Name  = "Jcf";
            JcfField.Type  = typeof(decimal).ToString();
            JcfField.Index = 22;
            fields.Add(JcfField);

            Schema.Fields = fields.ToArray();
        }
Exemple #17
0
        public UserLoginInfo() : base("TL_SYS_USER_LOGIN")
        {
            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(int).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 LOGIN_NAMEField = new DataSchemaField();

            LOGIN_NAMEField.Name  = "LOGIN_NAME";
            LOGIN_NAMEField.Type  = typeof(string).ToString();
            LOGIN_NAMEField.Index = 2;
            fields.Add(LOGIN_NAMEField);

            DataSchemaField IP_ADDRESSField = new DataSchemaField();

            IP_ADDRESSField.Name  = "IP_ADDRESS";
            IP_ADDRESSField.Type  = typeof(string).ToString();
            IP_ADDRESSField.Index = 3;
            fields.Add(IP_ADDRESSField);

            DataSchemaField LOGIN_TYPEField = new DataSchemaField();

            LOGIN_TYPEField.Name  = "LOGIN_TYPE";
            LOGIN_TYPEField.Type  = typeof(string).ToString();
            LOGIN_TYPEField.Index = 4;
            fields.Add(LOGIN_TYPEField);

            DataSchemaField SOURCE_TYPEField = new DataSchemaField();

            SOURCE_TYPEField.Name  = "SOURCE_TYPE";
            SOURCE_TYPEField.Type  = typeof(string).ToString();
            SOURCE_TYPEField.Index = 5;
            fields.Add(SOURCE_TYPEField);

            DataSchemaField EXECUTE_TIMEField = new DataSchemaField();

            EXECUTE_TIMEField.Name  = "EXECUTE_TIME";
            EXECUTE_TIMEField.Type  = typeof(DateTime).ToString();
            EXECUTE_TIMEField.Index = 6;
            fields.Add(EXECUTE_TIMEField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 7;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 8;
            fields.Add(CREATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 9;
            fields.Add(CREATE_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 10;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 11;
            fields.Add(MODIFY_DATEField);

            Schema.Fields = fields.ToArray();
        }
        public SupplierInfo() : base("TM_BAS_SUPPLIER")
        {
            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 SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 1;
            fields.Add(SUPPLIER_NUMField);

            DataSchemaField DUNSField = new DataSchemaField();

            DUNSField.Name  = "DUNS";
            DUNSField.Type  = typeof(string).ToString();
            DUNSField.Index = 2;
            fields.Add(DUNSField);

            DataSchemaField SUPPLIER_NAMEField = new DataSchemaField();

            SUPPLIER_NAMEField.Name  = "SUPPLIER_NAME";
            SUPPLIER_NAMEField.Type  = typeof(string).ToString();
            SUPPLIER_NAMEField.Index = 3;
            fields.Add(SUPPLIER_NAMEField);

            DataSchemaField SUPPLIER_SNAMEField = new DataSchemaField();

            SUPPLIER_SNAMEField.Name  = "SUPPLIER_SNAME";
            SUPPLIER_SNAMEField.Type  = typeof(string).ToString();
            SUPPLIER_SNAMEField.Index = 4;
            fields.Add(SUPPLIER_SNAMEField);

            DataSchemaField SUPPLIER_ADDRESSField = new DataSchemaField();

            SUPPLIER_ADDRESSField.Name  = "SUPPLIER_ADDRESS";
            SUPPLIER_ADDRESSField.Type  = typeof(string).ToString();
            SUPPLIER_ADDRESSField.Index = 5;
            fields.Add(SUPPLIER_ADDRESSField);

            DataSchemaField SUPPLIER_TYPEField = new DataSchemaField();

            SUPPLIER_TYPEField.Name  = "SUPPLIER_TYPE";
            SUPPLIER_TYPEField.Type  = typeof(int).ToString();
            SUPPLIER_TYPEField.Index = 6;
            fields.Add(SUPPLIER_TYPEField);

            DataSchemaField CONTACT_NAMEField = new DataSchemaField();

            CONTACT_NAMEField.Name  = "CONTACT_NAME";
            CONTACT_NAMEField.Type  = typeof(string).ToString();
            CONTACT_NAMEField.Index = 7;
            fields.Add(CONTACT_NAMEField);

            DataSchemaField CONTACT_TELField = new DataSchemaField();

            CONTACT_TELField.Name  = "CONTACT_TEL";
            CONTACT_TELField.Type  = typeof(string).ToString();
            CONTACT_TELField.Index = 8;
            fields.Add(CONTACT_TELField);

            DataSchemaField CONTACT_FAXField = new DataSchemaField();

            CONTACT_FAXField.Name  = "CONTACT_FAX";
            CONTACT_FAXField.Type  = typeof(string).ToString();
            CONTACT_FAXField.Index = 9;
            fields.Add(CONTACT_FAXField);

            DataSchemaField CONTACT_MOBILEField = new DataSchemaField();

            CONTACT_MOBILEField.Name  = "CONTACT_MOBILE";
            CONTACT_MOBILEField.Type  = typeof(string).ToString();
            CONTACT_MOBILEField.Index = 10;
            fields.Add(CONTACT_MOBILEField);

            DataSchemaField CONTACT_EMAILField = new DataSchemaField();

            CONTACT_EMAILField.Name  = "CONTACT_EMAIL";
            CONTACT_EMAILField.Type  = typeof(string).ToString();
            CONTACT_EMAILField.Index = 11;
            fields.Add(CONTACT_EMAILField);

            DataSchemaField NIGHTCONTACT_NAMEField = new DataSchemaField();

            NIGHTCONTACT_NAMEField.Name  = "NIGHTCONTACT_NAME";
            NIGHTCONTACT_NAMEField.Type  = typeof(string).ToString();
            NIGHTCONTACT_NAMEField.Index = 12;
            fields.Add(NIGHTCONTACT_NAMEField);

            DataSchemaField NIGHTCONTACT_TELField = new DataSchemaField();

            NIGHTCONTACT_TELField.Name  = "NIGHTCONTACT_TEL";
            NIGHTCONTACT_TELField.Type  = typeof(string).ToString();
            NIGHTCONTACT_TELField.Index = 13;
            fields.Add(NIGHTCONTACT_TELField);

            DataSchemaField NIGHTCONTACT_FAXField = new DataSchemaField();

            NIGHTCONTACT_FAXField.Name  = "NIGHTCONTACT_FAX";
            NIGHTCONTACT_FAXField.Type  = typeof(string).ToString();
            NIGHTCONTACT_FAXField.Index = 14;
            fields.Add(NIGHTCONTACT_FAXField);

            DataSchemaField NIGHTCONTACT_MOBILEField = new DataSchemaField();

            NIGHTCONTACT_MOBILEField.Name  = "NIGHTCONTACT_MOBILE";
            NIGHTCONTACT_MOBILEField.Type  = typeof(string).ToString();
            NIGHTCONTACT_MOBILEField.Index = 15;
            fields.Add(NIGHTCONTACT_MOBILEField);

            DataSchemaField NIGHTCONTACT_EMAILField = new DataSchemaField();

            NIGHTCONTACT_EMAILField.Name  = "NIGHTCONTACT_EMAIL";
            NIGHTCONTACT_EMAILField.Type  = typeof(string).ToString();
            NIGHTCONTACT_EMAILField.Index = 16;
            fields.Add(NIGHTCONTACT_EMAILField);

            DataSchemaField DAYCONTACT_NAMEField = new DataSchemaField();

            DAYCONTACT_NAMEField.Name  = "DAYCONTACT_NAME";
            DAYCONTACT_NAMEField.Type  = typeof(string).ToString();
            DAYCONTACT_NAMEField.Index = 17;
            fields.Add(DAYCONTACT_NAMEField);

            DataSchemaField DAYCONTACT_TELField = new DataSchemaField();

            DAYCONTACT_TELField.Name  = "DAYCONTACT_TEL";
            DAYCONTACT_TELField.Type  = typeof(string).ToString();
            DAYCONTACT_TELField.Index = 18;
            fields.Add(DAYCONTACT_TELField);

            DataSchemaField DAYCONTACT_FAXField = new DataSchemaField();

            DAYCONTACT_FAXField.Name  = "DAYCONTACT_FAX";
            DAYCONTACT_FAXField.Type  = typeof(string).ToString();
            DAYCONTACT_FAXField.Index = 19;
            fields.Add(DAYCONTACT_FAXField);

            DataSchemaField DAYCONTACT_MOBILEField = new DataSchemaField();

            DAYCONTACT_MOBILEField.Name  = "DAYCONTACT_MOBILE";
            DAYCONTACT_MOBILEField.Type  = typeof(string).ToString();
            DAYCONTACT_MOBILEField.Index = 20;
            fields.Add(DAYCONTACT_MOBILEField);

            DataSchemaField DAYCONTACT_EMAILField = new DataSchemaField();

            DAYCONTACT_EMAILField.Name  = "DAYCONTACT_EMAIL";
            DAYCONTACT_EMAILField.Type  = typeof(string).ToString();
            DAYCONTACT_EMAILField.Index = 21;
            fields.Add(DAYCONTACT_EMAILField);

            DataSchemaField PROVINCEField = new DataSchemaField();

            PROVINCEField.Name  = "PROVINCE";
            PROVINCEField.Type  = typeof(string).ToString();
            PROVINCEField.Index = 22;
            fields.Add(PROVINCEField);

            DataSchemaField CITYField = new DataSchemaField();

            CITYField.Name  = "CITY";
            CITYField.Type  = typeof(string).ToString();
            CITYField.Index = 23;
            fields.Add(CITYField);

            DataSchemaField SUPPLIER_GROUPField = new DataSchemaField();

            SUPPLIER_GROUPField.Name  = "SUPPLIER_GROUP";
            SUPPLIER_GROUPField.Type  = typeof(string).ToString();
            SUPPLIER_GROUPField.Index = 24;
            fields.Add(SUPPLIER_GROUPField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 25;
            fields.Add(COMMENTSField);

            DataSchemaField ASN_FLAGField = new DataSchemaField();

            ASN_FLAGField.Name  = "ASN_FLAG";
            ASN_FLAGField.Type  = typeof(bool).ToString();
            ASN_FLAGField.Index = 26;
            fields.Add(ASN_FLAGField);

            DataSchemaField BATCH_FLAGField = new DataSchemaField();

            BATCH_FLAGField.Name  = "BATCH_FLAG";
            BATCH_FLAGField.Type  = typeof(bool).ToString();
            BATCH_FLAGField.Index = 27;
            fields.Add(BATCH_FLAGField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 28;
            fields.Add(CREATE_DATEField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 29;
            fields.Add(VALID_FLAGField);

            DataSchemaField IDField = new DataSchemaField();

            IDField.Name  = "ID";
            IDField.Type  = typeof(long).ToString();
            IDField.Index = 30;
            fields.Add(IDField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 31;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 32;
            fields.Add(MODIFY_DATEField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 33;
            fields.Add(CREATE_USERField);

            DataSchemaField ASN_VMI_FLAGField = new DataSchemaField();

            ASN_VMI_FLAGField.Name  = "ASN_VMI_FLAG";
            ASN_VMI_FLAGField.Type  = typeof(bool).ToString();
            ASN_VMI_FLAGField.Index = 34;
            fields.Add(ASN_VMI_FLAGField);

            Schema.Fields = fields.ToArray();
        }
        public PlanPartBoxInfo() : base("TM_MPM_PLAN_PART_BOX")
        {
            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_BOX_CODEField = new DataSchemaField();

            PART_BOX_CODEField.Name  = "PART_BOX_CODE";
            PART_BOX_CODEField.Type  = typeof(string).ToString();
            PART_BOX_CODEField.Index = 2;
            fields.Add(PART_BOX_CODEField);

            DataSchemaField PART_BOX_NAMEField = new DataSchemaField();

            PART_BOX_NAMEField.Name  = "PART_BOX_NAME";
            PART_BOX_NAMEField.Type  = typeof(string).ToString();
            PART_BOX_NAMEField.Index = 3;
            fields.Add(PART_BOX_NAMEField);

            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 PLANTField = new DataSchemaField();

            PLANTField.Name  = "PLANT";
            PLANTField.Type  = typeof(string).ToString();
            PLANTField.Index = 6;
            fields.Add(PLANTField);

            DataSchemaField WORKSHOPField = new DataSchemaField();

            WORKSHOPField.Name  = "WORKSHOP";
            WORKSHOPField.Type  = typeof(string).ToString();
            WORKSHOPField.Index = 7;
            fields.Add(WORKSHOPField);

            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 SOURCE_ZONE_NOField = new DataSchemaField();

            SOURCE_ZONE_NOField.Name  = "SOURCE_ZONE_NO";
            SOURCE_ZONE_NOField.Type  = typeof(string).ToString();
            SOURCE_ZONE_NOField.Index = 9;
            fields.Add(SOURCE_ZONE_NOField);

            DataSchemaField SOURCE_WM_NOField = new DataSchemaField();

            SOURCE_WM_NOField.Name  = "SOURCE_WM_NO";
            SOURCE_WM_NOField.Type  = typeof(string).ToString();
            SOURCE_WM_NOField.Index = 10;
            fields.Add(SOURCE_WM_NOField);

            DataSchemaField TARGET_ZONE_NOField = new DataSchemaField();

            TARGET_ZONE_NOField.Name  = "TARGET_ZONE_NO";
            TARGET_ZONE_NOField.Type  = typeof(string).ToString();
            TARGET_ZONE_NOField.Index = 11;
            fields.Add(TARGET_ZONE_NOField);

            DataSchemaField TARGET_WM_NOField = new DataSchemaField();

            TARGET_WM_NOField.Name  = "TARGET_WM_NO";
            TARGET_WM_NOField.Type  = typeof(string).ToString();
            TARGET_WM_NOField.Index = 12;
            fields.Add(TARGET_WM_NOField);

            DataSchemaField PICK_UP_TIMEField = new DataSchemaField();

            PICK_UP_TIMEField.Name  = "PICK_UP_TIME";
            PICK_UP_TIMEField.Type  = typeof(int).ToString();
            PICK_UP_TIMEField.Index = 13;
            fields.Add(PICK_UP_TIMEField);

            DataSchemaField DELIVERY_TIMEField = new DataSchemaField();

            DELIVERY_TIMEField.Name  = "DELIVERY_TIME";
            DELIVERY_TIMEField.Type  = typeof(int).ToString();
            DELIVERY_TIMEField.Index = 14;
            fields.Add(DELIVERY_TIMEField);

            DataSchemaField DELAY_TIMEField = new DataSchemaField();

            DELAY_TIMEField.Name  = "DELAY_TIME";
            DELAY_TIMEField.Type  = typeof(int).ToString();
            DELAY_TIMEField.Index = 15;
            fields.Add(DELAY_TIMEField);

            DataSchemaField DOCKField = new DataSchemaField();

            DOCKField.Name  = "DOCK";
            DOCKField.Type  = typeof(string).ToString();
            DOCKField.Index = 16;
            fields.Add(DOCKField);

            DataSchemaField STATUSField = new DataSchemaField();

            STATUSField.Name  = "STATUS";
            STATUSField.Type  = typeof(int).ToString();
            STATUSField.Index = 17;
            fields.Add(STATUSField);

            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_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 MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 22;
            fields.Add(MODIFY_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);

            Schema.Fields = fields.ToArray();
        }
Exemple #20
0
        public UserRoleConditionInfo() : base("TS_SYS_USER_ROLE_CONDITION")
        {
            List <string> keys = new List <string>();

            keys.Add("ID");     _Keys = keys.ToArray();

            Schema = new DataSchema();
            List <DataSchemaField> fields = new List <DataSchemaField>();


            DataSchemaField CONDITION_NAMEField = new DataSchemaField();

            CONDITION_NAMEField.Name  = "CONDITION_NAME";
            CONDITION_NAMEField.Type  = typeof(string).ToString();
            CONDITION_NAMEField.Index = 0;
            fields.Add(CONDITION_NAMEField);

            DataSchemaField TABLE_NAMEField = new DataSchemaField();

            TABLE_NAMEField.Name  = "TABLE_NAME";
            TABLE_NAMEField.Type  = typeof(string).ToString();
            TABLE_NAMEField.Index = 1;
            fields.Add(TABLE_NAMEField);

            DataSchemaField FIELD_NAMEField = new DataSchemaField();

            FIELD_NAMEField.Name  = "FIELD_NAME";
            FIELD_NAMEField.Type  = typeof(string).ToString();
            FIELD_NAMEField.Index = 2;
            fields.Add(FIELD_NAMEField);

            DataSchemaField ATTRIBUTE_NAMEField = new DataSchemaField();

            ATTRIBUTE_NAMEField.Name  = "ATTRIBUTE_NAME";
            ATTRIBUTE_NAMEField.Type  = typeof(string).ToString();
            ATTRIBUTE_NAMEField.Index = 3;
            fields.Add(ATTRIBUTE_NAMEField);

            DataSchemaField DATA_TYPEField = new DataSchemaField();

            DATA_TYPEField.Name  = "DATA_TYPE";
            DATA_TYPEField.Type  = typeof(int).ToString();
            DATA_TYPEField.Index = 4;
            fields.Add(DATA_TYPEField);

            DataSchemaField CONTROL_TYPEField = new DataSchemaField();

            CONTROL_TYPEField.Name  = "CONTROL_TYPE";
            CONTROL_TYPEField.Type  = typeof(int).ToString();
            CONTROL_TYPEField.Index = 5;
            fields.Add(CONTROL_TYPEField);

            DataSchemaField EXTEND_ATTRIBUTEField = new DataSchemaField();

            EXTEND_ATTRIBUTEField.Name  = "EXTEND_ATTRIBUTE";
            EXTEND_ATTRIBUTEField.Type  = typeof(string).ToString();
            EXTEND_ATTRIBUTEField.Index = 6;
            fields.Add(EXTEND_ATTRIBUTEField);

            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();
        }
Exemple #21
0
        private void GenerateLinqToSql(DataSchema dataSchema)
        {
            TargetSystem targetSystemLinq = dataSchema.TargetSystems[TargetSystemNameForLinq];
            TargetSystem targetSystemScript = dataSchema.TargetSystems[TargetSystemNameForScript];

            LinqDbmlGenerator linqGen = new LinqDbmlGenerator();
            linqGen.DataSchema = dataSchema;
            linqGen.TargetSystem = targetSystemLinq;
            linqGen.DatabaseTargetSystem = targetSystemScript;
            linqGen.TableSchemaName = "dbo";
            linqGen.DatabaseColumnTypeMapper = new SqlServerColumnTypeMapper();
            using (FileStream stream = new FileStream(LinqToSqlFilePath, FileMode.Create))
            {
                linqGen.Generate(stream);
            }
        }
 /// <summary>
 /// 加载数据源
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void LoadData_Click(object sender, RoutedEventArgs e)
 {
     DataSchema.InitTable(AppCache.GetLink, true);
     CodeBox.Show("加载数据源成功!", this);
 }
Exemple #23
0
 /// <summary>
 /// 更新视图结构
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void ReLoad_View(object sender, RoutedEventArgs e)
 {
     AppCache.SetViewList(DataSchema.ViewList(AppCache.GetBuildLink(), true) ?? new List <BaseTable>(), AppCache.GetBuildLink());
     Dtable.DataContext = AppCache.GetViewList(AppCache.GetBuildLink());
 }
 /// <summary>
 /// 更新数据源
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void UpdateData_Click(object sender, RoutedEventArgs e)
 {
     DataSchema.InitTable(AppCache.GetLink, false);
     CodeBox.Show("更新数据源成功!", this);
 }
Exemple #25
0
        /// <summary>
        /// 生成建表语句
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Bulid_Table(object sender, RoutedEventArgs e)
        {
            var bat  = new StringBuilder();
            var path = string.Format("{0}sql", AppDomain.CurrentDomain.BaseDirectory);

            if (txtFile != "")
            {
                path = txtFile + "\\sql";
            }

            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }

            foreach (var item in Dtable.Items)
            {
                var box = Common.GetTemplateColumn <System.Windows.Controls.CheckBox>(Dtable, 0, "tabBox", item);

                if (box != null && box.IsChecked == true)
                {
                    var sql = new StringBuilder();
                    sql.AppendFormat("create table {0}(\r\n", (item as BaseTable).tabName);
                    var field = DataSchema.ColumnList(AppCache.GetBuildLink(), (item as BaseTable).tabName) ?? new List <BaseColumn>();
                    var i     = 0;
                    field.ForEach(a => {
                        if (AppCache.GetBuildLink().dbType == DataDbType.MySql)
                        {
                            if (a.isNull == "是")
                            {
                                sql.AppendFormat("\t{0} {1}{2} comment {3}\r\n", a.colName, a.showType, i == field.Count - 1 ? "" : ",", a.colComments.Replace("'", ""));
                            }
                            else
                            {
                                sql.AppendFormat("\t{0} {1} not null{2} comment {3}\r\n", a.colName, a.showType, i == field.Count - 1 ? "" : ",", a.colComments.Replace("'", ""));
                            }
                        }
                        else
                        {
                            if (a.isNull == "是")
                            {
                                sql.AppendFormat("\t{0} {1}{2}\r\n", a.colName, a.showType, i == field.Count - 1 ? "" : ",");
                            }
                            else
                            {
                                sql.AppendFormat("\t{0} {1} not null{2}\r\n", a.colName, a.showType, i == field.Count - 1 ? "" : ",");
                            }
                        }
                        i++;
                    });

                    if (AppCache.GetBuildLink().dbType == DataDbType.MySql)
                    {
                        sql.AppendFormat(")comment={0} ", (item as BaseTable).tabComments.Replace("'", ""));
                        bat.AppendFormat("mysql -h {0} -u {1} -p {2} < @{3}.sql\r\n", AppCache.GetBuildLink().hostName, AppCache.GetBuildLink().userName, AppCache.GetBuildLink().userPwd, (item as BaseTable).tabName);
                    }
                    else
                    {
                        sql.Append(") ");
                    }

                    if (AppCache.GetBuildLink().dbType == DataDbType.SqlServer)
                    {
                        field.ForEach(a => {
                            if (a.colComments != "")
                            {
                                sql.AppendFormat("execute sp_addextendedproperty 'MS_Description','{0}','user','dbo','table','{1}','column','{2}';\r\n", a.colComments.Replace("'", ""), (item as BaseTable).tabName, a.colName);
                            }
                        });
                        sql.AppendFormat("execute sp_addextendedproperty 'MS_Description','{0}','user','dbo','table','{1}',null,null;\r\n", (item as BaseTable).tabComments.Replace("'", ""), (item as BaseTable).tabName);

                        bat.AppendFormat("sqlcmd -U {0} -P {1} -i @{2}.sql\r\n", AppCache.GetBuildLink().userName, AppCache.GetBuildLink().userPwd, (item as BaseTable).tabName);
                    }

                    if (AppCache.GetBuildLink().dbType == DataDbType.Oracle)
                    {
                        sql.Append("\r\n tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage(initial 64K minextents 1 maxextents unlimited);\r\n");

                        field.ForEach(a => {
                            if (a.colComments != "")
                            {
                                sql.AppendFormat("comment on column {0}.{1} is '{2}'; \r\n", (item as BaseTable).tabName, a.colName, a.colComments.Replace("'", ""));
                            }
                        });
                        sql.AppendFormat("comment on table {0} is '{1}';\r\n", (item as BaseTable).tabName, (item as BaseTable).tabComments.Replace("'", ""));

                        bat.AppendFormat("sqlplus {0}/{1}@{2} @{3}.sql> CreateTable.log\r\n", AppCache.GetBuildLink().userName, AppCache.GetBuildLink().userPwd, AppCache.GetBuildLink().serverValue, (item as BaseTable).tabName);
                    }

                    File.WriteAllText(string.Format("{0}/{1}.sql", path, (item as BaseTable).tabName), sql.ToString(), Encoding.UTF8);
                }
            }

            bat.Append("exit;");

            if (AppCache.GetBuildLink().dbType == DataDbType.Oracle)
            {
                File.WriteAllText(string.Format("{0}/Oracle.bat", path), bat.ToString(), Encoding.UTF8);
            }

            if (AppCache.GetBuildLink().dbType == DataDbType.MySql)
            {
                File.WriteAllText(string.Format("{0}/MySql.bat", path), bat.ToString(), Encoding.UTF8);
            }

            if (AppCache.GetBuildLink().dbType == DataDbType.SqlServer)
            {
                File.WriteAllText(string.Format("{0}/SqlServer.bat", path), bat.ToString(), Encoding.UTF8);
            }

            CodeBox.Show("生成成功", this);
        }
Exemple #26
0
        public TaskInfo() : base("TT_EPS_TASK")
        {
            List <string> keys = new List <string>();

            keys.Add("TASK_SN");                                                     _Keys = keys.ToArray();

            Schema = new DataSchema();
            List <DataSchemaField> fields = new List <DataSchemaField>();


            DataSchemaField TASK_SNField = new DataSchemaField();

            TASK_SNField.Name  = "TASK_SN";
            TASK_SNField.Type  = typeof(int).ToString();
            TASK_SNField.Index = 0;
            fields.Add(TASK_SNField);

            DataSchemaField TASK_TIMEField = new DataSchemaField();

            TASK_TIMEField.Name  = "TASK_TIME";
            TASK_TIMEField.Type  = typeof(DateTime).ToString();
            TASK_TIMEField.Index = 1;
            fields.Add(TASK_TIMEField);

            DataSchemaField TASK_STATUSField = new DataSchemaField();

            TASK_STATUSField.Name  = "TASK_STATUS";
            TASK_STATUSField.Type  = typeof(int).ToString();
            TASK_STATUSField.Index = 2;
            fields.Add(TASK_STATUSField);

            DataSchemaField TASK_PRIORITYField = new DataSchemaField();

            TASK_PRIORITYField.Name  = "TASK_PRIORITY";
            TASK_PRIORITYField.Type  = typeof(int).ToString();
            TASK_PRIORITYField.Index = 3;
            fields.Add(TASK_PRIORITYField);

            DataSchemaField PLANTField = new DataSchemaField();

            PLANTField.Name  = "PLANT";
            PLANTField.Type  = typeof(string).ToString();
            PLANTField.Index = 4;
            fields.Add(PLANTField);

            DataSchemaField ASSEMBLY_LINEField = new DataSchemaField();

            ASSEMBLY_LINEField.Name  = "ASSEMBLY_LINE";
            ASSEMBLY_LINEField.Type  = typeof(string).ToString();
            ASSEMBLY_LINEField.Index = 5;
            fields.Add(ASSEMBLY_LINEField);

            DataSchemaField LOCATIONField = new DataSchemaField();

            LOCATIONField.Name  = "LOCATION";
            LOCATIONField.Type  = typeof(string).ToString();
            LOCATIONField.Index = 6;
            fields.Add(LOCATIONField);

            DataSchemaField PACKAGEField = new DataSchemaField();

            PACKAGEField.Name  = "PACKAGE";
            PACKAGEField.Type  = typeof(int).ToString();
            PACKAGEField.Index = 7;
            fields.Add(PACKAGEField);

            DataSchemaField USAGEField = new DataSchemaField();

            USAGEField.Name  = "USAGE";
            USAGEField.Type  = typeof(int).ToString();
            USAGEField.Index = 8;
            fields.Add(USAGEField);

            DataSchemaField E_LOCATIONField = new DataSchemaField();

            E_LOCATIONField.Name  = "E_LOCATION";
            E_LOCATIONField.Type  = typeof(string).ToString();
            E_LOCATIONField.Index = 9;
            fields.Add(E_LOCATIONField);

            DataSchemaField E_ASSEMBLY_LINEField = new DataSchemaField();

            E_ASSEMBLY_LINEField.Name  = "E_ASSEMBLY_LINE";
            E_ASSEMBLY_LINEField.Type  = typeof(string).ToString();
            E_ASSEMBLY_LINEField.Index = 10;
            fields.Add(E_ASSEMBLY_LINEField);

            DataSchemaField E_PLANTField = new DataSchemaField();

            E_PLANTField.Name  = "E_PLANT";
            E_PLANTField.Type  = typeof(string).ToString();
            E_PLANTField.Index = 11;
            fields.Add(E_PLANTField);

            DataSchemaField D_LOCATIONField = new DataSchemaField();

            D_LOCATIONField.Name  = "D_LOCATION";
            D_LOCATIONField.Type  = typeof(string).ToString();
            D_LOCATIONField.Index = 12;
            fields.Add(D_LOCATIONField);

            DataSchemaField D_ASSEMBLY_LINEField = new DataSchemaField();

            D_ASSEMBLY_LINEField.Name  = "D_ASSEMBLY_LINE";
            D_ASSEMBLY_LINEField.Type  = typeof(string).ToString();
            D_ASSEMBLY_LINEField.Index = 13;
            fields.Add(D_ASSEMBLY_LINEField);

            DataSchemaField D_PLANTField = new DataSchemaField();

            D_PLANTField.Name  = "D_PLANT";
            D_PLANTField.Type  = typeof(string).ToString();
            D_PLANTField.Index = 14;
            fields.Add(D_PLANTField);

            DataSchemaField PART_NOField = new DataSchemaField();

            PART_NOField.Name  = "PART_NO";
            PART_NOField.Type  = typeof(string).ToString();
            PART_NOField.Index = 15;
            fields.Add(PART_NOField);

            DataSchemaField REQUEST_TIMEField = new DataSchemaField();

            REQUEST_TIMEField.Name  = "REQUEST_TIME";
            REQUEST_TIMEField.Type  = typeof(DateTime).ToString();
            REQUEST_TIMEField.Index = 16;
            fields.Add(REQUEST_TIMEField);

            DataSchemaField DELIVER_TIMEField = new DataSchemaField();

            DELIVER_TIMEField.Name  = "DELIVER_TIME";
            DELIVER_TIMEField.Type  = typeof(DateTime).ToString();
            DELIVER_TIMEField.Index = 17;
            fields.Add(DELIVER_TIMEField);

            DataSchemaField ALARM_TIMEField = new DataSchemaField();

            ALARM_TIMEField.Name  = "ALARM_TIME";
            ALARM_TIMEField.Type  = typeof(DateTime).ToString();
            ALARM_TIMEField.Index = 18;
            fields.Add(ALARM_TIMEField);

            DataSchemaField ACTUAL_QUANTITYField = new DataSchemaField();

            ACTUAL_QUANTITYField.Name  = "ACTUAL_QUANTITY";
            ACTUAL_QUANTITYField.Type  = typeof(int).ToString();
            ACTUAL_QUANTITYField.Index = 19;
            fields.Add(ACTUAL_QUANTITYField);

            DataSchemaField ROUTEField = new DataSchemaField();

            ROUTEField.Name  = "ROUTE";
            ROUTEField.Type  = typeof(string).ToString();
            ROUTEField.Index = 20;
            fields.Add(ROUTEField);

            DataSchemaField ROUTE_COMBINATION_LIMITField = new DataSchemaField();

            ROUTE_COMBINATION_LIMITField.Name  = "ROUTE_COMBINATION_LIMIT";
            ROUTE_COMBINATION_LIMITField.Type  = typeof(int).ToString();
            ROUTE_COMBINATION_LIMITField.Index = 21;
            fields.Add(ROUTE_COMBINATION_LIMITField);

            DataSchemaField ZONEField = new DataSchemaField();

            ZONEField.Name  = "ZONE";
            ZONEField.Type  = typeof(string).ToString();
            ZONEField.Index = 22;
            fields.Add(ZONEField);

            DataSchemaField ZONE_SCHEDULE_TYPEField = new DataSchemaField();

            ZONE_SCHEDULE_TYPEField.Name  = "ZONE_SCHEDULE_TYPE";
            ZONE_SCHEDULE_TYPEField.Type  = typeof(int).ToString();
            ZONE_SCHEDULE_TYPEField.Index = 23;
            fields.Add(ZONE_SCHEDULE_TYPEField);

            DataSchemaField TRIGGER_STATUSField = new DataSchemaField();

            TRIGGER_STATUSField.Name  = "TRIGGER_STATUS";
            TRIGGER_STATUSField.Type  = typeof(int).ToString();
            TRIGGER_STATUSField.Index = 24;
            fields.Add(TRIGGER_STATUSField);

            DataSchemaField COMBINATION_TYPEField = new DataSchemaField();

            COMBINATION_TYPEField.Name  = "COMBINATION_TYPE";
            COMBINATION_TYPEField.Type  = typeof(int).ToString();
            COMBINATION_TYPEField.Index = 25;
            fields.Add(COMBINATION_TYPEField);

            DataSchemaField PULL_TYPEField = new DataSchemaField();

            PULL_TYPEField.Name  = "PULL_TYPE";
            PULL_TYPEField.Type  = typeof(int).ToString();
            PULL_TYPEField.Index = 26;
            fields.Add(PULL_TYPEField);

            DataSchemaField COMPULSORY_FLAGField = new DataSchemaField();

            COMPULSORY_FLAGField.Name  = "COMPULSORY_FLAG";
            COMPULSORY_FLAGField.Type  = typeof(int).ToString();
            COMPULSORY_FLAGField.Index = 27;
            fields.Add(COMPULSORY_FLAGField);

            DataSchemaField MIN_STORAGEField = new DataSchemaField();

            MIN_STORAGEField.Name  = "MIN_STORAGE";
            MIN_STORAGEField.Type  = typeof(int).ToString();
            MIN_STORAGEField.Index = 28;
            fields.Add(MIN_STORAGEField);

            DataSchemaField MAX_STORAGEField = new DataSchemaField();

            MAX_STORAGEField.Name  = "MAX_STORAGE";
            MAX_STORAGEField.Type  = typeof(int).ToString();
            MAX_STORAGEField.Index = 29;
            fields.Add(MAX_STORAGEField);

            DataSchemaField CURRENT_STORAGEField = new DataSchemaField();

            CURRENT_STORAGEField.Name  = "CURRENT_STORAGE";
            CURRENT_STORAGEField.Type  = typeof(int).ToString();
            CURRENT_STORAGEField.Index = 30;
            fields.Add(CURRENT_STORAGEField);

            DataSchemaField BUTTON_IDField = new DataSchemaField();

            BUTTON_IDField.Name  = "BUTTON_ID";
            BUTTON_IDField.Type  = typeof(string).ToString();
            BUTTON_IDField.Index = 31;
            fields.Add(BUTTON_IDField);

            DataSchemaField TAG_REQUEST_SNField = new DataSchemaField();

            TAG_REQUEST_SNField.Name  = "TAG_REQUEST_SN";
            TAG_REQUEST_SNField.Type  = typeof(int).ToString();
            TAG_REQUEST_SNField.Index = 32;
            fields.Add(TAG_REQUEST_SNField);

            DataSchemaField SESSION_SNField = new DataSchemaField();

            SESSION_SNField.Name  = "SESSION_SN";
            SESSION_SNField.Type  = typeof(int).ToString();
            SESSION_SNField.Index = 33;
            fields.Add(SESSION_SNField);

            DataSchemaField SCREEN_LOCATIONField = new DataSchemaField();

            SCREEN_LOCATIONField.Name  = "SCREEN_LOCATION";
            SCREEN_LOCATIONField.Type  = typeof(string).ToString();
            SCREEN_LOCATIONField.Index = 34;
            fields.Add(SCREEN_LOCATIONField);

            DataSchemaField BAHNHOF_NOField = new DataSchemaField();

            BAHNHOF_NOField.Name  = "BAHNHOF_NO";
            BAHNHOF_NOField.Type  = typeof(string).ToString();
            BAHNHOF_NOField.Index = 35;
            fields.Add(BAHNHOF_NOField);

            DataSchemaField DOLLYField = new DataSchemaField();

            DOLLYField.Name  = "DOLLY";
            DOLLYField.Type  = typeof(string).ToString();
            DOLLYField.Index = 36;
            fields.Add(DOLLYField);

            DataSchemaField WMS_SEND_TIMEField = new DataSchemaField();

            WMS_SEND_TIMEField.Name  = "WMS_SEND_TIME";
            WMS_SEND_TIMEField.Type  = typeof(DateTime).ToString();
            WMS_SEND_TIMEField.Index = 37;
            fields.Add(WMS_SEND_TIMEField);

            DataSchemaField WMS_SEND_STATUSField = new DataSchemaField();

            WMS_SEND_STATUSField.Name  = "WMS_SEND_STATUS";
            WMS_SEND_STATUSField.Type  = typeof(int).ToString();
            WMS_SEND_STATUSField.Index = 38;
            fields.Add(WMS_SEND_STATUSField);

            DataSchemaField SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 39;
            fields.Add(SUPPLIER_NUMField);

            DataSchemaField TRANS_SUPPLIER_NUMField = new DataSchemaField();

            TRANS_SUPPLIER_NUMField.Name  = "TRANS_SUPPLIER_NUM";
            TRANS_SUPPLIER_NUMField.Type  = typeof(string).ToString();
            TRANS_SUPPLIER_NUMField.Index = 40;
            fields.Add(TRANS_SUPPLIER_NUMField);

            DataSchemaField INHOUSE_PACKAGE_MODELField = new DataSchemaField();

            INHOUSE_PACKAGE_MODELField.Name  = "INHOUSE_PACKAGE_MODEL";
            INHOUSE_PACKAGE_MODELField.Type  = typeof(string).ToString();
            INHOUSE_PACKAGE_MODELField.Index = 41;
            fields.Add(INHOUSE_PACKAGE_MODELField);

            DataSchemaField INHOUSE_PACKAGEField = new DataSchemaField();

            INHOUSE_PACKAGEField.Name  = "INHOUSE_PACKAGE";
            INHOUSE_PACKAGEField.Type  = typeof(int).ToString();
            INHOUSE_PACKAGEField.Index = 42;
            fields.Add(INHOUSE_PACKAGEField);

            DataSchemaField PICKUP_TIMEField = new DataSchemaField();

            PICKUP_TIMEField.Name  = "PICKUP_TIME";
            PICKUP_TIMEField.Type  = typeof(DateTime).ToString();
            PICKUP_TIMEField.Index = 43;
            fields.Add(PICKUP_TIMEField);

            DataSchemaField ARRIVE_TIMEField = new DataSchemaField();

            ARRIVE_TIMEField.Name  = "ARRIVE_TIME";
            ARRIVE_TIMEField.Type  = typeof(DateTime).ToString();
            ARRIVE_TIMEField.Index = 44;
            fields.Add(ARRIVE_TIMEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 45;
            fields.Add(COMMENTSField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 46;
            fields.Add(CREATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 47;
            fields.Add(CREATE_DATEField);

            DataSchemaField UPDATE_USERField = new DataSchemaField();

            UPDATE_USERField.Name  = "UPDATE_USER";
            UPDATE_USERField.Type  = typeof(string).ToString();
            UPDATE_USERField.Index = 48;
            fields.Add(UPDATE_USERField);

            DataSchemaField UPDATE_DATEField = new DataSchemaField();

            UPDATE_DATEField.Name  = "UPDATE_DATE";
            UPDATE_DATEField.Type  = typeof(DateTime).ToString();
            UPDATE_DATEField.Index = 49;
            fields.Add(UPDATE_DATEField);

            DataSchemaField RUNSHEET_NOField = new DataSchemaField();

            RUNSHEET_NOField.Name  = "RUNSHEET_NO";
            RUNSHEET_NOField.Type  = typeof(string).ToString();
            RUNSHEET_NOField.Index = 50;
            fields.Add(RUNSHEET_NOField);

            DataSchemaField PRINT_STATEField = new DataSchemaField();

            PRINT_STATEField.Name  = "PRINT_STATE";
            PRINT_STATEField.Type  = typeof(int).ToString();
            PRINT_STATEField.Index = 51;
            fields.Add(PRINT_STATEField);

            DataSchemaField PRINT_TIMESField = new DataSchemaField();

            PRINT_TIMESField.Name  = "PRINT_TIMES";
            PRINT_TIMESField.Type  = typeof(int).ToString();
            PRINT_TIMESField.Index = 52;
            fields.Add(PRINT_TIMESField);

            DataSchemaField PLANT_ZONEField = new DataSchemaField();

            PLANT_ZONEField.Name  = "PLANT_ZONE";
            PLANT_ZONEField.Type  = typeof(string).ToString();
            PLANT_ZONEField.Index = 53;
            fields.Add(PLANT_ZONEField);

            Schema.Fields = fields.ToArray();
        }
Exemple #27
0
        public OutputInfo() : base("TT_WMM_OUTPUT")
        {
            List <string> keys = new List <string>();

            keys.Add("OUTPUT_ID");                                  _Keys = keys.ToArray();

            Schema = new DataSchema();
            List <DataSchemaField> fields = new List <DataSchemaField>();


            DataSchemaField OUTPUT_IDField = new DataSchemaField();

            OUTPUT_IDField.Name  = "OUTPUT_ID";
            OUTPUT_IDField.Type  = typeof(long).ToString();
            OUTPUT_IDField.Index = 0;
            fields.Add(OUTPUT_IDField);

            DataSchemaField OUTPUT_NOField = new DataSchemaField();

            OUTPUT_NOField.Name  = "OUTPUT_NO";
            OUTPUT_NOField.Type  = typeof(string).ToString();
            OUTPUT_NOField.Index = 1;
            fields.Add(OUTPUT_NOField);

            DataSchemaField PLANTField = new DataSchemaField();

            PLANTField.Name  = "PLANT";
            PLANTField.Type  = typeof(string).ToString();
            PLANTField.Index = 2;
            fields.Add(PLANTField);

            DataSchemaField SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 3;
            fields.Add(SUPPLIER_NUMField);

            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 SEND_TIMEField = new DataSchemaField();

            SEND_TIMEField.Name  = "SEND_TIME";
            SEND_TIMEField.Type  = typeof(DateTime).ToString();
            SEND_TIMEField.Index = 6;
            fields.Add(SEND_TIMEField);

            DataSchemaField OUTPUT_TYPEField = new DataSchemaField();

            OUTPUT_TYPEField.Name  = "OUTPUT_TYPE";
            OUTPUT_TYPEField.Type  = typeof(int).ToString();
            OUTPUT_TYPEField.Index = 7;
            fields.Add(OUTPUT_TYPEField);

            DataSchemaField TRAN_TIMEField = new DataSchemaField();

            TRAN_TIMEField.Name  = "TRAN_TIME";
            TRAN_TIMEField.Type  = typeof(DateTime).ToString();
            TRAN_TIMEField.Index = 8;
            fields.Add(TRAN_TIMEField);

            DataSchemaField OUTPUT_REASONField = new DataSchemaField();

            OUTPUT_REASONField.Name  = "OUTPUT_REASON";
            OUTPUT_REASONField.Type  = typeof(string).ToString();
            OUTPUT_REASONField.Index = 9;
            fields.Add(OUTPUT_REASONField);

            DataSchemaField BOOK_KEEPERField = new DataSchemaField();

            BOOK_KEEPERField.Name  = "BOOK_KEEPER";
            BOOK_KEEPERField.Type  = typeof(string).ToString();
            BOOK_KEEPERField.Index = 10;
            fields.Add(BOOK_KEEPERField);

            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 PLAN_NOField = new DataSchemaField();

            PLAN_NOField.Name  = "PLAN_NO";
            PLAN_NOField.Type  = typeof(string).ToString();
            PLAN_NOField.Index = 12;
            fields.Add(PLAN_NOField);

            DataSchemaField ASN_NOField = new DataSchemaField();

            ASN_NOField.Name  = "ASN_NO";
            ASN_NOField.Type  = typeof(string).ToString();
            ASN_NOField.Index = 13;
            fields.Add(ASN_NOField);

            DataSchemaField RUNSHEET_NOField = new DataSchemaField();

            RUNSHEET_NOField.Name  = "RUNSHEET_NO";
            RUNSHEET_NOField.Type  = typeof(string).ToString();
            RUNSHEET_NOField.Index = 14;
            fields.Add(RUNSHEET_NOField);

            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 TRANS_SUPPLIER_NUMField = new DataSchemaField();

            TRANS_SUPPLIER_NUMField.Name  = "TRANS_SUPPLIER_NUM";
            TRANS_SUPPLIER_NUMField.Type  = typeof(string).ToString();
            TRANS_SUPPLIER_NUMField.Index = 18;
            fields.Add(TRANS_SUPPLIER_NUMField);

            DataSchemaField PART_TYPEField = new DataSchemaField();

            PART_TYPEField.Name  = "PART_TYPE";
            PART_TYPEField.Type  = typeof(int).ToString();
            PART_TYPEField.Index = 19;
            fields.Add(PART_TYPEField);

            DataSchemaField SUPPLIER_TYPEField = new DataSchemaField();

            SUPPLIER_TYPEField.Name  = "SUPPLIER_TYPE";
            SUPPLIER_TYPEField.Type  = typeof(int).ToString();
            SUPPLIER_TYPEField.Index = 20;
            fields.Add(SUPPLIER_TYPEField);

            DataSchemaField RUNSHEET_CODEField = new DataSchemaField();

            RUNSHEET_CODEField.Name  = "RUNSHEET_CODE";
            RUNSHEET_CODEField.Type  = typeof(string).ToString();
            RUNSHEET_CODEField.Index = 21;
            fields.Add(RUNSHEET_CODEField);

            DataSchemaField ERP_FLAGField = new DataSchemaField();

            ERP_FLAGField.Name  = "ERP_FLAG";
            ERP_FLAGField.Type  = typeof(int).ToString();
            ERP_FLAGField.Index = 22;
            fields.Add(ERP_FLAGField);

            DataSchemaField LOGICAL_PKField = new DataSchemaField();

            LOGICAL_PKField.Name  = "LOGICAL_PK";
            LOGICAL_PKField.Type  = typeof(string).ToString();
            LOGICAL_PKField.Index = 23;
            fields.Add(LOGICAL_PKField);

            DataSchemaField BUSINESS_PKField = new DataSchemaField();

            BUSINESS_PKField.Name  = "BUSINESS_PK";
            BUSINESS_PKField.Type  = typeof(string).ToString();
            BUSINESS_PKField.Index = 24;
            fields.Add(BUSINESS_PKField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 25;
            fields.Add(COMMENTSField);

            DataSchemaField UPDATE_DATEField = new DataSchemaField();

            UPDATE_DATEField.Name  = "UPDATE_DATE";
            UPDATE_DATEField.Type  = typeof(DateTime).ToString();
            UPDATE_DATEField.Index = 26;
            fields.Add(UPDATE_DATEField);

            DataSchemaField UPDATE_USERField = new DataSchemaField();

            UPDATE_USERField.Name  = "UPDATE_USER";
            UPDATE_USERField.Type  = typeof(string).ToString();
            UPDATE_USERField.Index = 27;
            fields.Add(UPDATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 28;
            fields.Add(CREATE_DATEField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 29;
            fields.Add(CREATE_USERField);

            DataSchemaField ROUTEField = new DataSchemaField();

            ROUTEField.Name  = "ROUTE";
            ROUTEField.Type  = typeof(string).ToString();
            ROUTEField.Index = 30;
            fields.Add(ROUTEField);

            DataSchemaField REQUEST_TIMEField = new DataSchemaField();

            REQUEST_TIMEField.Name  = "REQUEST_TIME";
            REQUEST_TIMEField.Type  = typeof(DateTime).ToString();
            REQUEST_TIMEField.Index = 31;
            fields.Add(REQUEST_TIMEField);

            DataSchemaField PTL_FLAGField = new DataSchemaField();

            PTL_FLAGField.Name  = "PTL_FLAG";
            PTL_FLAGField.Type  = typeof(int).ToString();
            PTL_FLAGField.Index = 32;
            fields.Add(PTL_FLAGField);

            DataSchemaField PTL_TIMEField = new DataSchemaField();

            PTL_TIMEField.Name  = "PTL_TIME";
            PTL_TIMEField.Type  = typeof(DateTime).ToString();
            PTL_TIMEField.Index = 33;
            fields.Add(PTL_TIMEField);

            DataSchemaField FIDField = new DataSchemaField();

            FIDField.Name  = "FID";
            FIDField.Type  = typeof(Guid).ToString();
            FIDField.Index = 34;
            fields.Add(FIDField);

            Schema.Fields = fields.ToArray();
        }
        public ContractInfo() : base("TT_SRM_CONTRACT")
        {
            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 CONTRACT_NOField = new DataSchemaField();

            CONTRACT_NOField.Name  = "CONTRACT_NO";
            CONTRACT_NOField.Type  = typeof(string).ToString();
            CONTRACT_NOField.Index = 2;
            fields.Add(CONTRACT_NOField);

            DataSchemaField CONTRACT_NAMEField = new DataSchemaField();

            CONTRACT_NAMEField.Name  = "CONTRACT_NAME";
            CONTRACT_NAMEField.Type  = typeof(string).ToString();
            CONTRACT_NAMEField.Index = 3;
            fields.Add(CONTRACT_NAMEField);

            DataSchemaField EFFECTIVE_DATEField = new DataSchemaField();

            EFFECTIVE_DATEField.Name  = "EFFECTIVE_DATE";
            EFFECTIVE_DATEField.Type  = typeof(DateTime).ToString();
            EFFECTIVE_DATEField.Index = 4;
            fields.Add(EFFECTIVE_DATEField);

            DataSchemaField INVALID_DATEField = new DataSchemaField();

            INVALID_DATEField.Name  = "INVALID_DATE";
            INVALID_DATEField.Type  = typeof(DateTime).ToString();
            INVALID_DATEField.Index = 5;
            fields.Add(INVALID_DATEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 6;
            fields.Add(COMMENTSField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 7;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 8;
            fields.Add(CREATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 9;
            fields.Add(CREATE_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 10;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 11;
            fields.Add(MODIFY_DATEField);

            Schema.Fields = fields.ToArray();
        }
        public WmsVmiJisPullOrderInfo() : base("TI_IFM_WMS_VMI_JIS_PULL_ORDER")
        {
            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 ORDER_CODEField = new DataSchemaField();

            ORDER_CODEField.Name  = "ORDER_CODE";
            ORDER_CODEField.Type  = typeof(string).ToString();
            ORDER_CODEField.Index = 4;
            fields.Add(ORDER_CODEField);

            DataSchemaField DOCKField = new DataSchemaField();

            DOCKField.Name  = "DOCK";
            DOCKField.Type  = typeof(string).ToString();
            DOCKField.Index = 5;
            fields.Add(DOCKField);

            DataSchemaField SEQUENCENUMBEField = new DataSchemaField();

            SEQUENCENUMBEField.Name  = "SEQUENCENUMBE";
            SEQUENCENUMBEField.Type  = typeof(string).ToString();
            SEQUENCENUMBEField.Index = 6;
            fields.Add(SEQUENCENUMBEField);

            DataSchemaField PUBLISH_TIMEField = new DataSchemaField();

            PUBLISH_TIMEField.Name  = "PUBLISH_TIME";
            PUBLISH_TIMEField.Type  = typeof(DateTime).ToString();
            PUBLISH_TIMEField.Index = 7;
            fields.Add(PUBLISH_TIMEField);

            DataSchemaField PART_BOX_CODEField = new DataSchemaField();

            PART_BOX_CODEField.Name  = "PART_BOX_CODE";
            PART_BOX_CODEField.Type  = typeof(string).ToString();
            PART_BOX_CODEField.Index = 8;
            fields.Add(PART_BOX_CODEField);

            DataSchemaField PART_BOX_NAMEField = new DataSchemaField();

            PART_BOX_NAMEField.Name  = "PART_BOX_NAME";
            PART_BOX_NAMEField.Type  = typeof(string).ToString();
            PART_BOX_NAMEField.Index = 9;
            fields.Add(PART_BOX_NAMEField);

            DataSchemaField SUPPLIER_NUMField = new DataSchemaField();

            SUPPLIER_NUMField.Name  = "SUPPLIER_NUM";
            SUPPLIER_NUMField.Type  = typeof(string).ToString();
            SUPPLIER_NUMField.Index = 10;
            fields.Add(SUPPLIER_NUMField);

            DataSchemaField SUPPLIER_NAMEField = new DataSchemaField();

            SUPPLIER_NAMEField.Name  = "SUPPLIER_NAME";
            SUPPLIER_NAMEField.Type  = typeof(string).ToString();
            SUPPLIER_NAMEField.Index = 11;
            fields.Add(SUPPLIER_NAMEField);

            DataSchemaField SOURCE_ZONE_NOField = new DataSchemaField();

            SOURCE_ZONE_NOField.Name  = "SOURCE_ZONE_NO";
            SOURCE_ZONE_NOField.Type  = typeof(string).ToString();
            SOURCE_ZONE_NOField.Index = 12;
            fields.Add(SOURCE_ZONE_NOField);

            DataSchemaField TARGET_ZONE_NOField = new DataSchemaField();

            TARGET_ZONE_NOField.Name  = "TARGET_ZONE_NO";
            TARGET_ZONE_NOField.Type  = typeof(string).ToString();
            TARGET_ZONE_NOField.Index = 13;
            fields.Add(TARGET_ZONE_NOField);

            DataSchemaField START_INFOPOIN_TTIMEField = new DataSchemaField();

            START_INFOPOIN_TTIMEField.Name  = "START_INFOPOIN_TTIME";
            START_INFOPOIN_TTIMEField.Type  = typeof(DateTime).ToString();
            START_INFOPOIN_TTIMEField.Index = 14;
            fields.Add(START_INFOPOIN_TTIMEField);

            DataSchemaField PLAN_DELIVERY_TIMEField = new DataSchemaField();

            PLAN_DELIVERY_TIMEField.Name  = "PLAN_DELIVERY_TIME";
            PLAN_DELIVERY_TIMEField.Type  = typeof(DateTime).ToString();
            PLAN_DELIVERY_TIMEField.Index = 15;
            fields.Add(PLAN_DELIVERY_TIMEField);

            DataSchemaField START_VEHICLE_SEQ_NOField = new DataSchemaField();

            START_VEHICLE_SEQ_NOField.Name  = "START_VEHICLE_SEQ_NO";
            START_VEHICLE_SEQ_NOField.Type  = typeof(int).ToString();
            START_VEHICLE_SEQ_NOField.Index = 16;
            fields.Add(START_VEHICLE_SEQ_NOField);

            DataSchemaField END_VEHICLESEQ_NOField = new DataSchemaField();

            END_VEHICLESEQ_NOField.Name  = "END_VEHICLESEQ_NO";
            END_VEHICLESEQ_NOField.Type  = typeof(int).ToString();
            END_VEHICLESEQ_NOField.Index = 17;
            fields.Add(END_VEHICLESEQ_NOField);

            DataSchemaField LOCATIONField = new DataSchemaField();

            LOCATIONField.Name  = "LOCATION";
            LOCATIONField.Type  = typeof(string).ToString();
            LOCATIONField.Index = 18;
            fields.Add(LOCATIONField);

            DataSchemaField KEEPERField = new DataSchemaField();

            KEEPERField.Name  = "KEEPER";
            KEEPERField.Type  = typeof(string).ToString();
            KEEPERField.Index = 19;
            fields.Add(KEEPERField);

            DataSchemaField REMARKField = new DataSchemaField();

            REMARKField.Name  = "REMARK";
            REMARKField.Type  = typeof(string).ToString();
            REMARKField.Index = 20;
            fields.Add(REMARKField);

            DataSchemaField DELETEFLAGField = new DataSchemaField();

            DELETEFLAGField.Name  = "DELETEFLAG";
            DELETEFLAGField.Type  = typeof(bool).ToString();
            DELETEFLAGField.Index = 21;
            fields.Add(DELETEFLAGField);

            DataSchemaField PROCESS_FLAGField = new DataSchemaField();

            PROCESS_FLAGField.Name  = "PROCESS_FLAG";
            PROCESS_FLAGField.Type  = typeof(int).ToString();
            PROCESS_FLAGField.Index = 22;
            fields.Add(PROCESS_FLAGField);

            DataSchemaField PROCESS_TIMEField = new DataSchemaField();

            PROCESS_TIMEField.Name  = "PROCESS_TIME";
            PROCESS_TIMEField.Type  = typeof(DateTime).ToString();
            PROCESS_TIMEField.Index = 23;
            fields.Add(PROCESS_TIMEField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 24;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 25;
            fields.Add(CREATE_DATEField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 26;
            fields.Add(CREATE_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 27;
            fields.Add(MODIFY_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 28;
            fields.Add(MODIFY_USERField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 29;
            fields.Add(COMMENTSField);

            Schema.Fields = fields.ToArray();
        }
Exemple #30
0
        public PackageBarcodeDetailInfo() : base("TT_PCM_PACKAGE_BARCODE_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 PACKAGE_BARCODE_FIDField = new DataSchemaField();

            PACKAGE_BARCODE_FIDField.Name  = "PACKAGE_BARCODE_FID";
            PACKAGE_BARCODE_FIDField.Type  = typeof(Guid).ToString();
            PACKAGE_BARCODE_FIDField.Index = 2;
            fields.Add(PACKAGE_BARCODE_FIDField);

            DataSchemaField PACKAGE_MODELField = new DataSchemaField();

            PACKAGE_MODELField.Name  = "PACKAGE_MODEL";
            PACKAGE_MODELField.Type  = typeof(string).ToString();
            PACKAGE_MODELField.Index = 3;
            fields.Add(PACKAGE_MODELField);

            DataSchemaField PACKAGE_QTYField = new DataSchemaField();

            PACKAGE_QTYField.Name  = "PACKAGE_QTY";
            PACKAGE_QTYField.Type  = typeof(int).ToString();
            PACKAGE_QTYField.Index = 4;
            fields.Add(PACKAGE_QTYField);

            DataSchemaField PACKAGE_CNAMEField = new DataSchemaField();

            PACKAGE_CNAMEField.Name  = "PACKAGE_CNAME";
            PACKAGE_CNAMEField.Type  = typeof(string).ToString();
            PACKAGE_CNAMEField.Index = 5;
            fields.Add(PACKAGE_CNAMEField);

            DataSchemaField PACKAGE_TYPEField = new DataSchemaField();

            PACKAGE_TYPEField.Name  = "PACKAGE_TYPE";
            PACKAGE_TYPEField.Type  = typeof(int).ToString();
            PACKAGE_TYPEField.Index = 6;
            fields.Add(PACKAGE_TYPEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 7;
            fields.Add(COMMENTSField);

            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_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 9;
            fields.Add(CREATE_DATEField);

            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 MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 11;
            fields.Add(MODIFY_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 12;
            fields.Add(MODIFY_USERField);

            Schema.Fields = fields.ToArray();
        }
		public KanbanPullOrderDetailInfo():base("TT_MPM_KANBAN_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 ORDER_STATUSField = new DataSchemaField();
			ORDER_STATUSField.Name = "ORDER_STATUS";
			ORDER_STATUSField.Type = typeof(int).ToString();
			ORDER_STATUSField.Index = 4;
			fields.Add(ORDER_STATUSField);
			 
			DataSchemaField CARD_NOField = new DataSchemaField();
			CARD_NOField.Name = "CARD_NO";
			CARD_NOField.Type = typeof(string).ToString();
			CARD_NOField.Index = 5;
			fields.Add(CARD_NOField);
			 
			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_NAMEField = new DataSchemaField();
			PART_NAMEField.Name = "PART_NAME";
			PART_NAMEField.Type = typeof(string).ToString();
			PART_NAMEField.Index = 7;
			fields.Add(PART_NAMEField);
			 
			DataSchemaField SUPPLIER_CODEField = new DataSchemaField();
			SUPPLIER_CODEField.Name = "SUPPLIER_CODE";
			SUPPLIER_CODEField.Type = typeof(string).ToString();
			SUPPLIER_CODEField.Index = 8;
			fields.Add(SUPPLIER_CODEField);
			 
			DataSchemaField SUPPLIER_NAMEField = new DataSchemaField();
			SUPPLIER_NAMEField.Name = "SUPPLIER_NAME";
			SUPPLIER_NAMEField.Type = typeof(string).ToString();
			SUPPLIER_NAMEField.Index = 9;
			fields.Add(SUPPLIER_NAMEField);
			 
			DataSchemaField PART_QTYField = new DataSchemaField();
			PART_QTYField.Name = "PART_QTY";
			PART_QTYField.Type = typeof(decimal).ToString();
			PART_QTYField.Index = 10;
			fields.Add(PART_QTYField);
			 
			DataSchemaField PACKAGE_CODEField = new DataSchemaField();
			PACKAGE_CODEField.Name = "PACKAGE_CODE";
			PACKAGE_CODEField.Type = typeof(string).ToString();
			PACKAGE_CODEField.Index = 11;
			fields.Add(PACKAGE_CODEField);
			 
			DataSchemaField PACKAGE_QTYField = new DataSchemaField();
			PACKAGE_QTYField.Name = "PACKAGE_QTY";
			PACKAGE_QTYField.Type = typeof(decimal).ToString();
			PACKAGE_QTYField.Index = 12;
			fields.Add(PACKAGE_QTYField);
			 
			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 CREATE_DATEField = new DataSchemaField();
			CREATE_DATEField.Name = "CREATE_DATE";
			CREATE_DATEField.Type = typeof(DateTime).ToString();
			CREATE_DATEField.Index = 14;
			fields.Add(CREATE_DATEField);
			 
			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);
			 
			DataSchemaField MODIFY_USERField = new DataSchemaField();
			MODIFY_USERField.Name = "MODIFY_USER";
			MODIFY_USERField.Type = typeof(string).ToString();
			MODIFY_USERField.Index = 17;
			fields.Add(MODIFY_USERField);
						
			Schema.Fields = fields.ToArray();
		}
        public ImageSourceInfo() : base("TS_SYS_IMAGE_SOURCE")
        {
            List <string> keys = new List <string>();

            keys.Add("ID");    _Keys = keys.ToArray();

            Schema = new DataSchema();
            List <DataSchemaField> fields = new List <DataSchemaField>();


            DataSchemaField IMAGE_NAMEField = new DataSchemaField();

            IMAGE_NAMEField.Name  = "IMAGE_NAME";
            IMAGE_NAMEField.Type  = typeof(string).ToString();
            IMAGE_NAMEField.Index = 0;
            fields.Add(IMAGE_NAMEField);

            DataSchemaField IMAGE_NAME_CNField = new DataSchemaField();

            IMAGE_NAME_CNField.Name  = "IMAGE_NAME_CN";
            IMAGE_NAME_CNField.Type  = typeof(string).ToString();
            IMAGE_NAME_CNField.Index = 1;
            fields.Add(IMAGE_NAME_CNField);

            DataSchemaField IMAGE_URLField = new DataSchemaField();

            IMAGE_URLField.Name  = "IMAGE_URL";
            IMAGE_URLField.Type  = typeof(string).ToString();
            IMAGE_URLField.Index = 2;
            fields.Add(IMAGE_URLField);

            DataSchemaField RESOURCEField = new DataSchemaField();

            RESOURCEField.Name  = "RESOURCE";
            RESOURCEField.Type  = typeof(byte[]).ToString();
            RESOURCEField.Index = 3;
            fields.Add(RESOURCEField);

            DataSchemaField IMAGE_TYPEField = new DataSchemaField();

            IMAGE_TYPEField.Name  = "IMAGE_TYPE";
            IMAGE_TYPEField.Type  = typeof(int).ToString();
            IMAGE_TYPEField.Index = 4;
            fields.Add(IMAGE_TYPEField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 5;
            fields.Add(CREATE_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 IDField = new DataSchemaField();

            IDField.Name  = "ID";
            IDField.Type  = typeof(long).ToString();
            IDField.Index = 7;
            fields.Add(IDField);

            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 FIDField = new DataSchemaField();

            FIDField.Name  = "FID";
            FIDField.Type  = typeof(Guid).ToString();
            FIDField.Index = 9;
            fields.Add(FIDField);

            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 VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 11;
            fields.Add(VALID_FLAGField);

            Schema.Fields = fields.ToArray();
        }
        public SmsSupplyPlanInfo() : base("TI_IFM_SMS_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 LOG_FIDField = new DataSchemaField();

            LOG_FIDField.Name  = "LOG_FID";
            LOG_FIDField.Type  = typeof(Guid).ToString();
            LOG_FIDField.Index = 2;
            fields.Add(LOG_FIDField);

            DataSchemaField SUPPLIER_CODEField = new DataSchemaField();

            SUPPLIER_CODEField.Name  = "SUPPLIER_CODE";
            SUPPLIER_CODEField.Type  = typeof(string).ToString();
            SUPPLIER_CODEField.Index = 3;
            fields.Add(SUPPLIER_CODEField);

            DataSchemaField PART_NOField = new DataSchemaField();

            PART_NOField.Name  = "PART_NO";
            PART_NOField.Type  = typeof(string).ToString();
            PART_NOField.Index = 4;
            fields.Add(PART_NOField);

            DataSchemaField REQUIRE_DATEField = new DataSchemaField();

            REQUIRE_DATEField.Name  = "REQUIRE_DATE";
            REQUIRE_DATEField.Type  = typeof(DateTime).ToString();
            REQUIRE_DATEField.Index = 5;
            fields.Add(REQUIRE_DATEField);

            DataSchemaField PART_QTYField = new DataSchemaField();

            PART_QTYField.Name  = "PART_QTY";
            PART_QTYField.Type  = typeof(decimal).ToString();
            PART_QTYField.Index = 6;
            fields.Add(PART_QTYField);

            DataSchemaField PROCESS_FLAGField = new DataSchemaField();

            PROCESS_FLAGField.Name  = "PROCESS_FLAG";
            PROCESS_FLAGField.Type  = typeof(int).ToString();
            PROCESS_FLAGField.Index = 7;
            fields.Add(PROCESS_FLAGField);

            DataSchemaField PROCESS_TIMEField = new DataSchemaField();

            PROCESS_TIMEField.Name  = "PROCESS_TIME";
            PROCESS_TIMEField.Type  = typeof(DateTime).ToString();
            PROCESS_TIMEField.Index = 8;
            fields.Add(PROCESS_TIMEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 9;
            fields.Add(COMMENTSField);

            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);

            Schema.Fields = fields.ToArray();
        }
        public WmsVmiTransitInventoryInfo() : base("TI_IFM_WMS_VMI_TRANSIT_INVENTORY")
        {
            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 TRANSFERKEYField = new DataSchemaField();

            TRANSFERKEYField.Name  = "TRANSFERKEY";
            TRANSFERKEYField.Type  = typeof(string).ToString();
            TRANSFERKEYField.Index = 3;
            fields.Add(TRANSFERKEYField);

            DataSchemaField TRANSFERLINENUMBERField = new DataSchemaField();

            TRANSFERLINENUMBERField.Name  = "TRANSFERLINENUMBER";
            TRANSFERLINENUMBERField.Type  = typeof(string).ToString();
            TRANSFERLINENUMBERField.Index = 4;
            fields.Add(TRANSFERLINENUMBERField);

            DataSchemaField VMICODEField = new DataSchemaField();

            VMICODEField.Name  = "VMICODE";
            VMICODEField.Type  = typeof(string).ToString();
            VMICODEField.Index = 5;
            fields.Add(VMICODEField);

            DataSchemaField FROMSTORERKEYField = new DataSchemaField();

            FROMSTORERKEYField.Name  = "FROMSTORERKEY";
            FROMSTORERKEYField.Type  = typeof(string).ToString();
            FROMSTORERKEYField.Index = 6;
            fields.Add(FROMSTORERKEYField);

            DataSchemaField FROMSKUField = new DataSchemaField();

            FROMSKUField.Name  = "FROMSKU";
            FROMSKUField.Type  = typeof(string).ToString();
            FROMSKUField.Index = 7;
            fields.Add(FROMSKUField);

            DataSchemaField TOQTYField = new DataSchemaField();

            TOQTYField.Name  = "TOQTY";
            TOQTYField.Type  = typeof(decimal).ToString();
            TOQTYField.Index = 8;
            fields.Add(TOQTYField);

            DataSchemaField FROMLOT07Field = new DataSchemaField();

            FROMLOT07Field.Name  = "FROMLOT07";
            FROMLOT07Field.Type  = typeof(string).ToString();
            FROMLOT07Field.Index = 9;
            fields.Add(FROMLOT07Field);

            DataSchemaField TOLOT07Field = new DataSchemaField();

            TOLOT07Field.Name  = "TOLOT07";
            TOLOT07Field.Type  = typeof(string).ToString();
            TOLOT07Field.Index = 10;
            fields.Add(TOLOT07Field);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 11;
            fields.Add(VALID_FLAGField);

            DataSchemaField PROCESS_FLAGField = new DataSchemaField();

            PROCESS_FLAGField.Name  = "PROCESS_FLAG";
            PROCESS_FLAGField.Type  = typeof(int).ToString();
            PROCESS_FLAGField.Index = 12;
            fields.Add(PROCESS_FLAGField);

            DataSchemaField PROCESS_TIMEField = new DataSchemaField();

            PROCESS_TIMEField.Name  = "PROCESS_TIME";
            PROCESS_TIMEField.Type  = typeof(DateTime).ToString();
            PROCESS_TIMEField.Index = 13;
            fields.Add(PROCESS_TIMEField);

            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 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);

            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 COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 18;
            fields.Add(COMMENTSField);

            Schema.Fields = fields.ToArray();
        }
		public SapPlantStructureInfo():base("TI_IFM_SAP_PLANT_STRUCTURE")
		{
			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 NAME1Field = new DataSchemaField();
			NAME1Field.Name = "NAME1";
			NAME1Field.Type = typeof(string).ToString();
			NAME1Field.Index = 4;
			fields.Add(NAME1Field);
			 
			DataSchemaField ZBMField = new DataSchemaField();
			ZBMField.Name = "ZBM";
			ZBMField.Type = typeof(string).ToString();
			ZBMField.Index = 5;
			fields.Add(ZBMField);
			 
			DataSchemaField ZBMMSField = new DataSchemaField();
			ZBMMSField.Name = "ZBMMS";
			ZBMMSField.Type = typeof(string).ToString();
			ZBMMSField.Index = 6;
			fields.Add(ZBMMSField);
			 
			DataSchemaField ZCJField = new DataSchemaField();
			ZCJField.Name = "ZCJ";
			ZCJField.Type = typeof(string).ToString();
			ZCJField.Index = 7;
			fields.Add(ZCJField);
			 
			DataSchemaField ZCJMSField = new DataSchemaField();
			ZCJMSField.Name = "ZCJMS";
			ZCJMSField.Type = typeof(string).ToString();
			ZCJMSField.Index = 8;
			fields.Add(ZCJMSField);
			 
			DataSchemaField LINE_NOField = new DataSchemaField();
			LINE_NOField.Name = "LINE_NO";
			LINE_NOField.Type = typeof(string).ToString();
			LINE_NOField.Index = 9;
			fields.Add(LINE_NOField);
			 
			DataSchemaField LINE_NOMSField = new DataSchemaField();
			LINE_NOMSField.Name = "LINE_NOMS";
			LINE_NOMSField.Type = typeof(string).ToString();
			LINE_NOMSField.Index = 10;
			fields.Add(LINE_NOMSField);
			 
			DataSchemaField VLSCHField = new DataSchemaField();
			VLSCHField.Name = "VLSCH";
			VLSCHField.Type = typeof(string).ToString();
			VLSCHField.Index = 11;
			fields.Add(VLSCHField);
			 
			DataSchemaField TXTField = new DataSchemaField();
			TXTField.Name = "TXT";
			TXTField.Type = typeof(string).ToString();
			TXTField.Index = 12;
			fields.Add(TXTField);
			 
			DataSchemaField ZSXField = new DataSchemaField();
			ZSXField.Name = "ZSX";
			ZSXField.Type = typeof(string).ToString();
			ZSXField.Index = 13;
			fields.Add(ZSXField);
			 
			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 PROCESS_FLAGField = new DataSchemaField();
			PROCESS_FLAGField.Name = "PROCESS_FLAG";
			PROCESS_FLAGField.Type = typeof(int).ToString();
			PROCESS_FLAGField.Index = 15;
			fields.Add(PROCESS_FLAGField);
			 
			DataSchemaField PROCESS_TIMEField = new DataSchemaField();
			PROCESS_TIMEField.Name = "PROCESS_TIME";
			PROCESS_TIMEField.Type = typeof(DateTime).ToString();
			PROCESS_TIMEField.Index = 16;
			fields.Add(PROCESS_TIMEField);
			 
			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 CREATE_DATEField = new DataSchemaField();
			CREATE_DATEField.Name = "CREATE_DATE";
			CREATE_DATEField.Type = typeof(DateTime).ToString();
			CREATE_DATEField.Index = 18;
			fields.Add(CREATE_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 MODIFY_DATEField = new DataSchemaField();
			MODIFY_DATEField.Name = "MODIFY_DATE";
			MODIFY_DATEField.Type = typeof(DateTime).ToString();
			MODIFY_DATEField.Index = 20;
			fields.Add(MODIFY_DATEField);
			 
			DataSchemaField COMMENTSField = new DataSchemaField();
			COMMENTSField.Name = "COMMENTS";
			COMMENTSField.Type = typeof(string).ToString();
			COMMENTSField.Index = 21;
			fields.Add(COMMENTSField);
						
			Schema.Fields = fields.ToArray();
		}
Exemple #36
0
        protected override async Task ExecuteAsync(CancellationToken stoppingToken)
        {
            try
            {
                while (!stoppingToken.IsCancellationRequested)
                {
                    lock (thisLock)
                    {
                        using (var db = new DataContext(AppEtl.Db))
                        {
                            var tableLink = DataSchema.TableLink(db);
                            BaseLog.SaveLog("开始抽取", "FastEtlService");

                            var list = IFast.Query <Data_Business>(a => a.Id != null).ToList <Data_Business>(db);

                            foreach (var item in list)
                            {
                                var isExec = item.UpdateTime == DateTime.Now.Hour;
                                if (item.UpdateTime == 99)
                                {
                                    isExec = true;
                                }

                                if (DataSchema.IsExistsTable(db, item.TableName) && isExec)
                                {
                                    Parallel.Invoke(() =>
                                    {
                                        var leaf = IFast.Query <Data_Business_Details>(a => a.Id == item.Id).ToList <Data_Business_Details>(db) ?? new List <Data_Business_Details>();

                                        if (leaf.Count > 0 && leaf.Exists(a => a.Key.ToStr() != ""))
                                        {
                                            var isAdd = true;
                                            var dt    = DataSchema.GetTable(tableLink, item.TableName);

                                            var columnName = dt.Columns[2].ColumnName.ToLower();

                                            if (leaf.Exists(a => a.FieldName.ToLower() == columnName))
                                            {
                                                DataSchema.ExpireData(db, item);

                                                //第一列
                                                var link     = DataSchema.InitColLink(leaf, db, IFast);
                                                var tempLeaf = leaf.Find(a => a.FieldName.ToLower() == columnName);
                                                var pageInfo = DataSchema.GetTableCount(tempLeaf, item);

                                                for (var i = 1; i <= pageInfo.pageCount; i++)
                                                {
                                                    var log           = new Data_Log();
                                                    log.Id            = Guid.NewGuid().ToStr();
                                                    log.TableName     = string.Format("{0}_page_{1}", item.TableName, i);
                                                    log.BeginDateTime = DateTime.Now;

                                                    pageInfo.pageId = i;
                                                    var tempLink    = link.Find(a => a.GetValue("id").ToStr() == tempLeaf.DataSourceId);
                                                    var pageData    = DataSchema.GetFirstColumnData(tempLink, tempLeaf, item, pageInfo);

                                                    //遍历填充table
                                                    for (var row = 0; row < pageData.list.Count; row++)
                                                    {
                                                        var dtRow           = dt.NewRow();
                                                        dtRow["EtlAddTime"] = DateTime.Now;
                                                        dtRow["EtlKey"]     = pageData.list[row].GetValue("key");
                                                        dtRow[columnName]   = pageData.list[row].GetValue("data");

                                                        //字典对照
                                                        if (!string.IsNullOrEmpty(tempLeaf.Dic))
                                                        {
                                                            dtRow[columnName] = IFast.Query <Data_Dic_Details>(a => a.Value.ToLower() == dtRow[columnName].ToStr().ToLower() && a.DicId == tempLeaf.Dic, a => new { a.ContrastValue }).ToDic(db).GetValue("ContrastValue");
                                                        }

                                                        //数据策略
                                                        isAdd = DataSchema.DataPolicy(db, item, dtRow["EtlKey"], columnName, dtRow[columnName]);

                                                        for (var col = 2; col < dt.Columns.Count; col++)
                                                        {
                                                            columnName = dt.Columns[col].ColumnName.ToLower();
                                                            if (leaf.Exists(a => a.FieldName.ToLower() == columnName))
                                                            {
                                                                tempLeaf          = leaf.Find(a => a.FieldName.ToLower() == columnName);
                                                                tempLink          = link.Find(a => a.GetValue("id").ToStr() == tempLeaf.DataSourceId);
                                                                dtRow[columnName] = DataSchema.GetColumnData(tempLink, tempLeaf, dtRow["EtlKey"]);

                                                                //字典对照
                                                                if (!string.IsNullOrEmpty(tempLeaf.Dic))
                                                                {
                                                                    dtRow[columnName] = IFast.Query <Data_Dic_Details>(a => a.Value.ToLower() == dtRow[columnName].ToStr().ToLower() && a.DicId == tempLeaf.Dic, a => new { a.ContrastValue }).ToDic(db).GetValue("ContrastValue");
                                                                }

                                                                //数据策略
                                                                if (item.Policy == "2")
                                                                {
                                                                    isAdd = DataSchema.DataPolicy(db, item, dtRow["EtlKey"], columnName, dtRow[columnName]);
                                                                }
                                                            }
                                                        }

                                                        if (isAdd)
                                                        {
                                                            dt.Rows.Add(dtRow);
                                                        }
                                                    }

                                                    if (dt.Rows.Count > 0)
                                                    {
                                                        DataSchema.AddList(db, dt, ref log);
                                                    }
                                                    db.Add(log);
                                                    dt.Clear();
                                                }

                                                DataSchema.CloseLink(link);
                                                item.LastUpdateTime = DateTime.Now;
                                                IFast.Update <Data_Business>(item, a => a.Id == item.Id, a => new { a.LastUpdateTime }, db);
                                            }
                                        }
                                    });
                                }
                            }

                            BaseLog.SaveLog("结束抽取", "FastEtlService");
                            DataSchema.CloseTableLink(tableLink);
                        }
                    }
                    await Task.Delay(1000 * 60 * 30, stoppingToken);
                }
            }
            catch (Exception ex)
            {
                BaseLog.SaveLog(ex.ToString(), "FastEtlServiceError");
            }
        }
        public CljckInfo() : base("TT_WMS_CLJCK")
        {
            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 JCDHField = new DataSchemaField();

            JCDHField.Name  = "JCDH";
            JCDHField.Type  = typeof(string).ToString();
            JCDHField.Index = 1;
            fields.Add(JCDHField);

            DataSchemaField DMField = new DataSchemaField();

            DMField.Name  = "DM";
            DMField.Type  = typeof(string).ToString();
            DMField.Index = 2;
            fields.Add(DMField);

            DataSchemaField MCField = new DataSchemaField();

            MCField.Name  = "MC";
            MCField.Type  = typeof(string).ToString();
            MCField.Index = 3;
            fields.Add(MCField);

            DataSchemaField TMField = new DataSchemaField();

            TMField.Name  = "TM";
            TMField.Type  = typeof(string).ToString();
            TMField.Index = 4;
            fields.Add(TMField);

            DataSchemaField JCSLField = new DataSchemaField();

            JCSLField.Name  = "JCSL";
            JCSLField.Type  = typeof(decimal).ToString();
            JCSLField.Index = 5;
            fields.Add(JCSLField);

            DataSchemaField CCSLField = new DataSchemaField();

            CCSLField.Name  = "CCSL";
            CCSLField.Type  = typeof(decimal).ToString();
            CCSLField.Index = 6;
            fields.Add(CCSLField);

            DataSchemaField KCSLField = new DataSchemaField();

            KCSLField.Name  = "KCSL";
            KCSLField.Type  = typeof(decimal).ToString();
            KCSLField.Index = 7;
            fields.Add(KCSLField);

            DataSchemaField HWCWField = new DataSchemaField();

            HWCWField.Name  = "HWCW";
            HWCWField.Type  = typeof(string).ToString();
            HWCWField.Index = 8;
            fields.Add(HWCWField);

            DataSchemaField JSMZField = new DataSchemaField();

            JSMZField.Name  = "JSMZ";
            JSMZField.Type  = typeof(decimal).ToString();
            JSMZField.Index = 9;
            fields.Add(JSMZField);

            DataSchemaField HWCField = new DataSchemaField();

            HWCField.Name  = "HWC";
            HWCField.Type  = typeof(decimal).ToString();
            HWCField.Index = 10;
            fields.Add(HWCField);

            DataSchemaField HWKField = new DataSchemaField();

            HWKField.Name  = "HWK";
            HWKField.Type  = typeof(decimal).ToString();
            HWKField.Index = 11;
            fields.Add(HWKField);

            DataSchemaField HWGField = new DataSchemaField();

            HWGField.Name  = "HWG";
            HWGField.Type  = typeof(decimal).ToString();
            HWGField.Index = 12;
            fields.Add(HWGField);

            DataSchemaField JSTJField = new DataSchemaField();

            JSTJField.Name  = "JSTJ";
            JSTJField.Type  = typeof(decimal).ToString();
            JSTJField.Index = 13;
            fields.Add(JSTJField);

            DataSchemaField DWMZField = new DataSchemaField();

            DWMZField.Name  = "DWMZ";
            DWMZField.Type  = typeof(decimal).ToString();
            DWMZField.Index = 14;
            fields.Add(DWMZField);

            DataSchemaField DWTJField = new DataSchemaField();

            DWTJField.Name  = "DWTJ";
            DWTJField.Type  = typeof(decimal).ToString();
            DWTJField.Index = 15;
            fields.Add(DWTJField);

            DataSchemaField SCRQField = new DataSchemaField();

            SCRQField.Name  = "SCRQ";
            SCRQField.Type  = typeof(DateTime).ToString();
            SCRQField.Index = 16;
            fields.Add(SCRQField);

            DataSchemaField YXRQField = new DataSchemaField();

            YXRQField.Name  = "YXRQ";
            YXRQField.Type  = typeof(DateTime).ToString();
            YXRQField.Index = 17;
            fields.Add(YXRQField);

            DataSchemaField JSDWField = new DataSchemaField();

            JSDWField.Name  = "JSDW";
            JSDWField.Type  = typeof(string).ToString();
            JSDWField.Index = 18;
            fields.Add(JSDWField);

            DataSchemaField BZDWField = new DataSchemaField();

            BZDWField.Name  = "BZDW";
            BZDWField.Type  = typeof(string).ToString();
            BZDWField.Index = 19;
            fields.Add(BZDWField);

            DataSchemaField BZSLField = new DataSchemaField();

            BZSLField.Name  = "BZSL";
            BZSLField.Type  = typeof(decimal).ToString();
            BZSLField.Index = 20;
            fields.Add(BZSLField);

            DataSchemaField BZField = new DataSchemaField();

            BZField.Name  = "BZ";
            BZField.Type  = typeof(string).ToString();
            BZField.Index = 21;
            fields.Add(BZField);

            DataSchemaField XJSField = new DataSchemaField();

            XJSField.Name  = "XJS";
            XJSField.Type  = typeof(decimal).ToString();
            XJSField.Index = 22;
            fields.Add(XJSField);

            DataSchemaField DJField = new DataSchemaField();

            DJField.Name  = "DJ";
            DJField.Type  = typeof(decimal).ToString();
            DJField.Index = 23;
            fields.Add(DJField);

            DataSchemaField ZJField = new DataSchemaField();

            ZJField.Name  = "ZJ";
            ZJField.Type  = typeof(decimal).ToString();
            ZJField.Index = 24;
            fields.Add(ZJField);

            DataSchemaField MSField = new DataSchemaField();

            MSField.Name  = "MS";
            MSField.Type  = typeof(string).ToString();
            MSField.Index = 25;
            fields.Add(MSField);

            DataSchemaField XHField = new DataSchemaField();

            XHField.Name  = "XH";
            XHField.Type  = typeof(string).ToString();
            XHField.Index = 26;
            fields.Add(XHField);

            DataSchemaField CDDMField = new DataSchemaField();

            CDDMField.Name  = "CDDM";
            CDDMField.Type  = typeof(string).ToString();
            CDDMField.Index = 27;
            fields.Add(CDDMField);

            DataSchemaField CDField = new DataSchemaField();

            CDField.Name  = "CD";
            CDField.Type  = typeof(string).ToString();
            CDField.Index = 28;
            fields.Add(CDField);

            DataSchemaField SXHField = new DataSchemaField();

            SXHField.Name  = "SXH";
            SXHField.Type  = typeof(int).ToString();
            SXHField.Index = 29;
            fields.Add(SXHField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 30;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 31;
            fields.Add(CREATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 32;
            fields.Add(CREATE_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 33;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 34;
            fields.Add(MODIFY_DATEField);

            Schema.Fields = fields.ToArray();
        }
Exemple #38
0
        public MaintainInhouseLogisticStandardInfo() : base("TM_BAS_MAINTAIN_INHOUSE_LOGISTIC_STANDARD")
        {
            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 ASSEMBLY_LINEField = new DataSchemaField();

            ASSEMBLY_LINEField.Name  = "ASSEMBLY_LINE";
            ASSEMBLY_LINEField.Type  = typeof(string).ToString();
            ASSEMBLY_LINEField.Index = 1;
            fields.Add(ASSEMBLY_LINEField);

            DataSchemaField PLANT_ZONEField = new DataSchemaField();

            PLANT_ZONEField.Name  = "PLANT_ZONE";
            PLANT_ZONEField.Type  = typeof(string).ToString();
            PLANT_ZONEField.Index = 2;
            fields.Add(PLANT_ZONEField);

            DataSchemaField WORKSHOPField = new DataSchemaField();

            WORKSHOPField.Name  = "WORKSHOP";
            WORKSHOPField.Type  = typeof(string).ToString();
            WORKSHOPField.Index = 3;
            fields.Add(WORKSHOPField);

            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 TRANS_SUPPLIER_NUMField = new DataSchemaField();

            TRANS_SUPPLIER_NUMField.Name  = "TRANS_SUPPLIER_NUM";
            TRANS_SUPPLIER_NUMField.Type  = typeof(string).ToString();
            TRANS_SUPPLIER_NUMField.Index = 5;
            fields.Add(TRANS_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_CNAMEField = new DataSchemaField();

            PART_CNAMEField.Name  = "PART_CNAME";
            PART_CNAMEField.Type  = typeof(string).ToString();
            PART_CNAMEField.Index = 7;
            fields.Add(PART_CNAMEField);

            DataSchemaField PART_ENAMEField = new DataSchemaField();

            PART_ENAMEField.Name  = "PART_ENAME";
            PART_ENAMEField.Type  = typeof(string).ToString();
            PART_ENAMEField.Index = 8;
            fields.Add(PART_ENAMEField);

            DataSchemaField PART_NICKNAMEField = new DataSchemaField();

            PART_NICKNAMEField.Name  = "PART_NICKNAME";
            PART_NICKNAMEField.Type  = typeof(string).ToString();
            PART_NICKNAMEField.Index = 9;
            fields.Add(PART_NICKNAMEField);

            DataSchemaField WORKSHOP_SECTIONField = new DataSchemaField();

            WORKSHOP_SECTIONField.Name  = "WORKSHOP_SECTION";
            WORKSHOP_SECTIONField.Type  = typeof(string).ToString();
            WORKSHOP_SECTIONField.Index = 10;
            fields.Add(WORKSHOP_SECTIONField);

            DataSchemaField LOCATIONField = new DataSchemaField();

            LOCATIONField.Name  = "LOCATION";
            LOCATIONField.Type  = typeof(string).ToString();
            LOCATIONField.Index = 11;
            fields.Add(LOCATIONField);

            DataSchemaField IN_PLANT_LOGISTIC_MODEField = new DataSchemaField();

            IN_PLANT_LOGISTIC_MODEField.Name  = "IN_PLANT_LOGISTIC_MODE";
            IN_PLANT_LOGISTIC_MODEField.Type  = typeof(string).ToString();
            IN_PLANT_LOGISTIC_MODEField.Index = 12;
            fields.Add(IN_PLANT_LOGISTIC_MODEField);

            DataSchemaField IN_PLANT_SYSTEM_MODEField = new DataSchemaField();

            IN_PLANT_SYSTEM_MODEField.Name  = "IN_PLANT_SYSTEM_MODE";
            IN_PLANT_SYSTEM_MODEField.Type  = typeof(string).ToString();
            IN_PLANT_SYSTEM_MODEField.Index = 13;
            fields.Add(IN_PLANT_SYSTEM_MODEField);

            DataSchemaField IN_PLANT_LOGISTIC_PART_CLASSField = new DataSchemaField();

            IN_PLANT_LOGISTIC_PART_CLASSField.Name  = "IN_PLANT_LOGISTIC_PART_CLASS";
            IN_PLANT_LOGISTIC_PART_CLASSField.Type  = typeof(string).ToString();
            IN_PLANT_LOGISTIC_PART_CLASSField.Index = 14;
            fields.Add(IN_PLANT_LOGISTIC_PART_CLASSField);

            DataSchemaField INHOUSE_MODEField = new DataSchemaField();

            INHOUSE_MODEField.Name  = "INHOUSE_MODE";
            INHOUSE_MODEField.Type  = typeof(string).ToString();
            INHOUSE_MODEField.Index = 15;
            fields.Add(INHOUSE_MODEField);

            DataSchemaField INHOUSE_SYSTEM_MODEField = new DataSchemaField();

            INHOUSE_SYSTEM_MODEField.Name  = "INHOUSE_SYSTEM_MODE";
            INHOUSE_SYSTEM_MODEField.Type  = typeof(string).ToString();
            INHOUSE_SYSTEM_MODEField.Index = 16;
            fields.Add(INHOUSE_SYSTEM_MODEField);

            DataSchemaField INHOUSE_PART_CLASSField = new DataSchemaField();

            INHOUSE_PART_CLASSField.Name  = "INHOUSE_PART_CLASS";
            INHOUSE_PART_CLASSField.Type  = typeof(string).ToString();
            INHOUSE_PART_CLASSField.Index = 17;
            fields.Add(INHOUSE_PART_CLASSField);

            DataSchemaField LOGICAL_PKField = new DataSchemaField();

            LOGICAL_PKField.Name  = "LOGICAL_PK";
            LOGICAL_PKField.Type  = typeof(string).ToString();
            LOGICAL_PKField.Index = 18;
            fields.Add(LOGICAL_PKField);

            DataSchemaField STORAGE_LOCATIONField = new DataSchemaField();

            STORAGE_LOCATIONField.Name  = "STORAGE_LOCATION";
            STORAGE_LOCATIONField.Type  = typeof(string).ToString();
            STORAGE_LOCATIONField.Index = 19;
            fields.Add(STORAGE_LOCATIONField);

            DataSchemaField SEQUENCE_NOField = new DataSchemaField();

            SEQUENCE_NOField.Name  = "SEQUENCE_NO";
            SEQUENCE_NOField.Type  = typeof(string).ToString();
            SEQUENCE_NOField.Index = 20;
            fields.Add(SEQUENCE_NOField);

            DataSchemaField IS_ACTIVEField = new DataSchemaField();

            IS_ACTIVEField.Name  = "IS_ACTIVE";
            IS_ACTIVEField.Type  = typeof(int).ToString();
            IS_ACTIVEField.Index = 21;
            fields.Add(IS_ACTIVEField);

            DataSchemaField IS_REPACKField = new DataSchemaField();

            IS_REPACKField.Name  = "IS_REPACK";
            IS_REPACKField.Type  = typeof(int).ToString();
            IS_REPACKField.Index = 22;
            fields.Add(IS_REPACKField);

            DataSchemaField REPACK_ROUTEField = new DataSchemaField();

            REPACK_ROUTEField.Name  = "REPACK_ROUTE";
            REPACK_ROUTEField.Type  = typeof(string).ToString();
            REPACK_ROUTEField.Index = 23;
            fields.Add(REPACK_ROUTEField);

            DataSchemaField IS_TRIGGER_PULLField = new DataSchemaField();

            IS_TRIGGER_PULLField.Name  = "IS_TRIGGER_PULL";
            IS_TRIGGER_PULLField.Type  = typeof(bool).ToString();
            IS_TRIGGER_PULLField.Index = 24;
            fields.Add(IS_TRIGGER_PULLField);

            DataSchemaField WM_NOField = new DataSchemaField();

            WM_NOField.Name  = "WM_NO";
            WM_NOField.Type  = typeof(string).ToString();
            WM_NOField.Index = 25;
            fields.Add(WM_NOField);

            DataSchemaField ZONE_NOField = new DataSchemaField();

            ZONE_NOField.Name  = "ZONE_NO";
            ZONE_NOField.Type  = typeof(string).ToString();
            ZONE_NOField.Index = 26;
            fields.Add(ZONE_NOField);

            DataSchemaField DLOCField = new DataSchemaField();

            DLOCField.Name  = "DLOC";
            DLOCField.Type  = typeof(string).ToString();
            DLOCField.Index = 27;
            fields.Add(DLOCField);

            DataSchemaField INBOUND_PACKAGE_MODELField = new DataSchemaField();

            INBOUND_PACKAGE_MODELField.Name  = "INBOUND_PACKAGE_MODEL";
            INBOUND_PACKAGE_MODELField.Type  = typeof(string).ToString();
            INBOUND_PACKAGE_MODELField.Index = 28;
            fields.Add(INBOUND_PACKAGE_MODELField);

            DataSchemaField INBOUND_PACKAGEField = new DataSchemaField();

            INBOUND_PACKAGEField.Name  = "INBOUND_PACKAGE";
            INBOUND_PACKAGEField.Type  = typeof(int).ToString();
            INBOUND_PACKAGEField.Index = 29;
            fields.Add(INBOUND_PACKAGEField);

            DataSchemaField ROUTEField = new DataSchemaField();

            ROUTEField.Name  = "ROUTE";
            ROUTEField.Type  = typeof(string).ToString();
            ROUTEField.Index = 30;
            fields.Add(ROUTEField);

            DataSchemaField TRAN_TYPEField = new DataSchemaField();

            TRAN_TYPEField.Name  = "TRAN_TYPE";
            TRAN_TYPEField.Type  = typeof(string).ToString();
            TRAN_TYPEField.Index = 31;
            fields.Add(TRAN_TYPEField);

            DataSchemaField TRAN_STYLEField = new DataSchemaField();

            TRAN_STYLEField.Name  = "TRAN_STYLE";
            TRAN_STYLEField.Type  = typeof(string).ToString();
            TRAN_STYLEField.Index = 32;
            fields.Add(TRAN_STYLEField);

            DataSchemaField TRAN_SIZESField = new DataSchemaField();

            TRAN_SIZESField.Name  = "TRAN_SIZES";
            TRAN_SIZESField.Type  = typeof(string).ToString();
            TRAN_SIZESField.Index = 33;
            fields.Add(TRAN_SIZESField);

            DataSchemaField CARD_NOField = new DataSchemaField();

            CARD_NOField.Name  = "CARD_NO";
            CARD_NOField.Type  = typeof(string).ToString();
            CARD_NOField.Index = 34;
            fields.Add(CARD_NOField);

            DataSchemaField EMG_TIMEField = new DataSchemaField();

            EMG_TIMEField.Name  = "EMG_TIME";
            EMG_TIMEField.Type  = typeof(int).ToString();
            EMG_TIMEField.Index = 35;
            fields.Add(EMG_TIMEField);

            DataSchemaField ELOCField = new DataSchemaField();

            ELOCField.Name  = "ELOC";
            ELOCField.Type  = typeof(string).ToString();
            ELOCField.Index = 36;
            fields.Add(ELOCField);

            DataSchemaField BUSINESS_PKField = new DataSchemaField();

            BUSINESS_PKField.Name  = "BUSINESS_PK";
            BUSINESS_PKField.Type  = typeof(string).ToString();
            BUSINESS_PKField.Index = 37;
            fields.Add(BUSINESS_PKField);

            DataSchemaField COUNT_TYPEField = new DataSchemaField();

            COUNT_TYPEField.Name  = "COUNT_TYPE";
            COUNT_TYPEField.Type  = typeof(string).ToString();
            COUNT_TYPEField.Index = 38;
            fields.Add(COUNT_TYPEField);

            DataSchemaField DOCKField = new DataSchemaField();

            DOCKField.Name  = "DOCK";
            DOCKField.Type  = typeof(string).ToString();
            DOCKField.Index = 39;
            fields.Add(DOCKField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 40;
            fields.Add(COMMENTSField);

            DataSchemaField MINField = new DataSchemaField();

            MINField.Name  = "MIN";
            MINField.Type  = typeof(int).ToString();
            MINField.Index = 41;
            fields.Add(MINField);

            DataSchemaField MAXField = new DataSchemaField();

            MAXField.Name  = "MAX";
            MAXField.Type  = typeof(int).ToString();
            MAXField.Index = 42;
            fields.Add(MAXField);

            DataSchemaField T_WM_NOField = new DataSchemaField();

            T_WM_NOField.Name  = "T_WM_NO";
            T_WM_NOField.Type  = typeof(string).ToString();
            T_WM_NOField.Index = 43;
            fields.Add(T_WM_NOField);

            DataSchemaField S_WM_NOField = new DataSchemaField();

            S_WM_NOField.Name  = "S_WM_NO";
            S_WM_NOField.Type  = typeof(string).ToString();
            S_WM_NOField.Index = 44;
            fields.Add(S_WM_NOField);

            DataSchemaField T_ZONE_NOField = new DataSchemaField();

            T_ZONE_NOField.Name  = "T_ZONE_NO";
            T_ZONE_NOField.Type  = typeof(string).ToString();
            T_ZONE_NOField.Index = 45;
            fields.Add(T_ZONE_NOField);

            DataSchemaField S_ZONE_NOField = new DataSchemaField();

            S_ZONE_NOField.Name  = "S_ZONE_NO";
            S_ZONE_NOField.Type  = typeof(string).ToString();
            S_ZONE_NOField.Index = 46;
            fields.Add(S_ZONE_NOField);

            DataSchemaField MIN_PULL_BOXField = new DataSchemaField();

            MIN_PULL_BOXField.Name  = "MIN_PULL_BOX";
            MIN_PULL_BOXField.Type  = typeof(int).ToString();
            MIN_PULL_BOXField.Index = 47;
            fields.Add(MIN_PULL_BOXField);

            DataSchemaField BATCH_PULL_BOXField = new DataSchemaField();

            BATCH_PULL_BOXField.Name  = "BATCH_PULL_BOX";
            BATCH_PULL_BOXField.Type  = typeof(int).ToString();
            BATCH_PULL_BOXField.Index = 48;
            fields.Add(BATCH_PULL_BOXField);

            DataSchemaField STATUSField = new DataSchemaField();

            STATUSField.Name  = "STATUS";
            STATUSField.Type  = typeof(int).ToString();
            STATUSField.Index = 49;
            fields.Add(STATUSField);

            DataSchemaField KANBAN_CIRCLE_CNTField = new DataSchemaField();

            KANBAN_CIRCLE_CNTField.Name  = "KANBAN_CIRCLE_CNT";
            KANBAN_CIRCLE_CNTField.Type  = typeof(int).ToString();
            KANBAN_CIRCLE_CNTField.Index = 50;
            fields.Add(KANBAN_CIRCLE_CNTField);

            DataSchemaField SETTLEMENTFLAGField = new DataSchemaField();

            SETTLEMENTFLAGField.Name  = "SETTLEMENTFLAG";
            SETTLEMENTFLAGField.Type  = typeof(int).ToString();
            SETTLEMENTFLAGField.Index = 51;
            fields.Add(SETTLEMENTFLAGField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 52;
            fields.Add(MODIFY_USERField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 53;
            fields.Add(CREATE_USERField);

            DataSchemaField IDField = new DataSchemaField();

            IDField.Name  = "ID";
            IDField.Type  = typeof(long).ToString();
            IDField.Index = 54;
            fields.Add(IDField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 55;
            fields.Add(MODIFY_DATEField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(int).ToString();
            VALID_FLAGField.Index = 56;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 57;
            fields.Add(CREATE_DATEField);

            DataSchemaField FIDField = new DataSchemaField();

            FIDField.Name  = "FID";
            FIDField.Type  = typeof(Guid).ToString();
            FIDField.Index = 58;
            fields.Add(FIDField);

            Schema.Fields = fields.ToArray();
        }
Exemple #39
0
 public void Transform(DataSchema dataSchema, string name, TargetSystem targetSystem, System.Xml.Linq.XElement transformationElement, IScriptDocumentGeneratorFactory docGenFactory)
 {
     throw new NotImplementedException();
 }
        public VmiOutputInfo() : base("TT_WMM_VMI_OUTPUT")
        {
            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 OUTPUT_NOField = new DataSchemaField();

            OUTPUT_NOField.Name  = "OUTPUT_NO";
            OUTPUT_NOField.Type  = typeof(string).ToString();
            OUTPUT_NOField.Index = 2;
            fields.Add(OUTPUT_NOField);

            DataSchemaField PLANTField = new DataSchemaField();

            PLANTField.Name  = "PLANT";
            PLANTField.Type  = typeof(string).ToString();
            PLANTField.Index = 3;
            fields.Add(PLANTField);

            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 WM_NOField = new DataSchemaField();

            WM_NOField.Name  = "WM_NO";
            WM_NOField.Type  = typeof(string).ToString();
            WM_NOField.Index = 5;
            fields.Add(WM_NOField);

            DataSchemaField ZONE_NOField = new DataSchemaField();

            ZONE_NOField.Name  = "ZONE_NO";
            ZONE_NOField.Type  = typeof(string).ToString();
            ZONE_NOField.Index = 6;
            fields.Add(ZONE_NOField);

            DataSchemaField T_WM_NOField = new DataSchemaField();

            T_WM_NOField.Name  = "T_WM_NO";
            T_WM_NOField.Type  = typeof(string).ToString();
            T_WM_NOField.Index = 7;
            fields.Add(T_WM_NOField);

            DataSchemaField T_ZONE_NOField = new DataSchemaField();

            T_ZONE_NOField.Name  = "T_ZONE_NO";
            T_ZONE_NOField.Type  = typeof(string).ToString();
            T_ZONE_NOField.Index = 8;
            fields.Add(T_ZONE_NOField);

            DataSchemaField T_DOCKField = new DataSchemaField();

            T_DOCKField.Name  = "T_DOCK";
            T_DOCKField.Type  = typeof(string).ToString();
            T_DOCKField.Index = 9;
            fields.Add(T_DOCKField);

            DataSchemaField PART_BOX_CODEField = new DataSchemaField();

            PART_BOX_CODEField.Name  = "PART_BOX_CODE";
            PART_BOX_CODEField.Type  = typeof(string).ToString();
            PART_BOX_CODEField.Index = 10;
            fields.Add(PART_BOX_CODEField);

            DataSchemaField SEND_TIMEField = new DataSchemaField();

            SEND_TIMEField.Name  = "SEND_TIME";
            SEND_TIMEField.Type  = typeof(DateTime).ToString();
            SEND_TIMEField.Index = 11;
            fields.Add(SEND_TIMEField);

            DataSchemaField OUTPUT_TYPEField = new DataSchemaField();

            OUTPUT_TYPEField.Name  = "OUTPUT_TYPE";
            OUTPUT_TYPEField.Type  = typeof(int).ToString();
            OUTPUT_TYPEField.Index = 12;
            fields.Add(OUTPUT_TYPEField);

            DataSchemaField TRAN_TIMEField = new DataSchemaField();

            TRAN_TIMEField.Name  = "TRAN_TIME";
            TRAN_TIMEField.Type  = typeof(DateTime).ToString();
            TRAN_TIMEField.Index = 13;
            fields.Add(TRAN_TIMEField);

            DataSchemaField OUTPUT_REASONField = new DataSchemaField();

            OUTPUT_REASONField.Name  = "OUTPUT_REASON";
            OUTPUT_REASONField.Type  = typeof(string).ToString();
            OUTPUT_REASONField.Index = 14;
            fields.Add(OUTPUT_REASONField);

            DataSchemaField BOOK_KEEPERField = new DataSchemaField();

            BOOK_KEEPERField.Name  = "BOOK_KEEPER";
            BOOK_KEEPERField.Type  = typeof(string).ToString();
            BOOK_KEEPERField.Index = 15;
            fields.Add(BOOK_KEEPERField);

            DataSchemaField CONFIRM_FLAGField = new DataSchemaField();

            CONFIRM_FLAGField.Name  = "CONFIRM_FLAG";
            CONFIRM_FLAGField.Type  = typeof(int).ToString();
            CONFIRM_FLAGField.Index = 16;
            fields.Add(CONFIRM_FLAGField);

            DataSchemaField PLAN_NOField = new DataSchemaField();

            PLAN_NOField.Name  = "PLAN_NO";
            PLAN_NOField.Type  = typeof(string).ToString();
            PLAN_NOField.Index = 17;
            fields.Add(PLAN_NOField);

            DataSchemaField ASN_NOField = new DataSchemaField();

            ASN_NOField.Name  = "ASN_NO";
            ASN_NOField.Type  = typeof(string).ToString();
            ASN_NOField.Index = 18;
            fields.Add(ASN_NOField);

            DataSchemaField RUNSHEET_NOField = new DataSchemaField();

            RUNSHEET_NOField.Name  = "RUNSHEET_NO";
            RUNSHEET_NOField.Type  = typeof(string).ToString();
            RUNSHEET_NOField.Index = 19;
            fields.Add(RUNSHEET_NOField);

            DataSchemaField ASSEMBLY_LINEField = new DataSchemaField();

            ASSEMBLY_LINEField.Name  = "ASSEMBLY_LINE";
            ASSEMBLY_LINEField.Type  = typeof(string).ToString();
            ASSEMBLY_LINEField.Index = 20;
            fields.Add(ASSEMBLY_LINEField);

            DataSchemaField PLANT_ZONEField = new DataSchemaField();

            PLANT_ZONEField.Name  = "PLANT_ZONE";
            PLANT_ZONEField.Type  = typeof(string).ToString();
            PLANT_ZONEField.Index = 21;
            fields.Add(PLANT_ZONEField);

            DataSchemaField WORKSHOPField = new DataSchemaField();

            WORKSHOPField.Name  = "WORKSHOP";
            WORKSHOPField.Type  = typeof(string).ToString();
            WORKSHOPField.Index = 22;
            fields.Add(WORKSHOPField);

            DataSchemaField TRANS_SUPPLIER_NUMField = new DataSchemaField();

            TRANS_SUPPLIER_NUMField.Name  = "TRANS_SUPPLIER_NUM";
            TRANS_SUPPLIER_NUMField.Type  = typeof(string).ToString();
            TRANS_SUPPLIER_NUMField.Index = 23;
            fields.Add(TRANS_SUPPLIER_NUMField);

            DataSchemaField PART_TYPEField = new DataSchemaField();

            PART_TYPEField.Name  = "PART_TYPE";
            PART_TYPEField.Type  = typeof(int).ToString();
            PART_TYPEField.Index = 24;
            fields.Add(PART_TYPEField);

            DataSchemaField SUPPLIER_TYPEField = new DataSchemaField();

            SUPPLIER_TYPEField.Name  = "SUPPLIER_TYPE";
            SUPPLIER_TYPEField.Type  = typeof(int).ToString();
            SUPPLIER_TYPEField.Index = 25;
            fields.Add(SUPPLIER_TYPEField);

            DataSchemaField RUNSHEET_CODEField = new DataSchemaField();

            RUNSHEET_CODEField.Name  = "RUNSHEET_CODE";
            RUNSHEET_CODEField.Type  = typeof(string).ToString();
            RUNSHEET_CODEField.Index = 26;
            fields.Add(RUNSHEET_CODEField);

            DataSchemaField ERP_FLAGField = new DataSchemaField();

            ERP_FLAGField.Name  = "ERP_FLAG";
            ERP_FLAGField.Type  = typeof(int).ToString();
            ERP_FLAGField.Index = 27;
            fields.Add(ERP_FLAGField);

            DataSchemaField LOGICAL_PKField = new DataSchemaField();

            LOGICAL_PKField.Name  = "LOGICAL_PK";
            LOGICAL_PKField.Type  = typeof(string).ToString();
            LOGICAL_PKField.Index = 28;
            fields.Add(LOGICAL_PKField);

            DataSchemaField BUSINESS_PKField = new DataSchemaField();

            BUSINESS_PKField.Name  = "BUSINESS_PK";
            BUSINESS_PKField.Type  = typeof(string).ToString();
            BUSINESS_PKField.Index = 29;
            fields.Add(BUSINESS_PKField);

            DataSchemaField ROUTEField = new DataSchemaField();

            ROUTEField.Name  = "ROUTE";
            ROUTEField.Type  = typeof(string).ToString();
            ROUTEField.Index = 30;
            fields.Add(ROUTEField);

            DataSchemaField REQUEST_TIMEField = new DataSchemaField();

            REQUEST_TIMEField.Name  = "REQUEST_TIME";
            REQUEST_TIMEField.Type  = typeof(DateTime).ToString();
            REQUEST_TIMEField.Index = 31;
            fields.Add(REQUEST_TIMEField);

            DataSchemaField CUST_CODEField = new DataSchemaField();

            CUST_CODEField.Name  = "CUST_CODE";
            CUST_CODEField.Type  = typeof(string).ToString();
            CUST_CODEField.Index = 32;
            fields.Add(CUST_CODEField);

            DataSchemaField CUST_NAMEField = new DataSchemaField();

            CUST_NAMEField.Name  = "CUST_NAME";
            CUST_NAMEField.Type  = typeof(string).ToString();
            CUST_NAMEField.Index = 33;
            fields.Add(CUST_NAMEField);

            DataSchemaField COST_CENTERField = new DataSchemaField();

            COST_CENTERField.Name  = "COST_CENTER";
            COST_CENTERField.Type  = typeof(string).ToString();
            COST_CENTERField.Index = 34;
            fields.Add(COST_CENTERField);

            DataSchemaField ORGANIZATION_FIDField = new DataSchemaField();

            ORGANIZATION_FIDField.Name  = "ORGANIZATION_FID";
            ORGANIZATION_FIDField.Type  = typeof(Guid).ToString();
            ORGANIZATION_FIDField.Index = 35;
            fields.Add(ORGANIZATION_FIDField);

            DataSchemaField CONFIRM_USERField = new DataSchemaField();

            CONFIRM_USERField.Name  = "CONFIRM_USER";
            CONFIRM_USERField.Type  = typeof(string).ToString();
            CONFIRM_USERField.Index = 36;
            fields.Add(CONFIRM_USERField);

            DataSchemaField CONFIRM_DATEField = new DataSchemaField();

            CONFIRM_DATEField.Name  = "CONFIRM_DATE";
            CONFIRM_DATEField.Type  = typeof(DateTime).ToString();
            CONFIRM_DATEField.Index = 37;
            fields.Add(CONFIRM_DATEField);

            DataSchemaField LIABLE_USERField = new DataSchemaField();

            LIABLE_USERField.Name  = "LIABLE_USER";
            LIABLE_USERField.Type  = typeof(string).ToString();
            LIABLE_USERField.Index = 38;
            fields.Add(LIABLE_USERField);

            DataSchemaField LIABLE_DATEField = new DataSchemaField();

            LIABLE_DATEField.Name  = "LIABLE_DATE";
            LIABLE_DATEField.Type  = typeof(DateTime).ToString();
            LIABLE_DATEField.Index = 39;
            fields.Add(LIABLE_DATEField);

            DataSchemaField FINANCE_USERField = new DataSchemaField();

            FINANCE_USERField.Name  = "FINANCE_USER";
            FINANCE_USERField.Type  = typeof(string).ToString();
            FINANCE_USERField.Index = 40;
            fields.Add(FINANCE_USERField);

            DataSchemaField FINANCE_DATEField = new DataSchemaField();

            FINANCE_DATEField.Name  = "FINANCE_DATE";
            FINANCE_DATEField.Type  = typeof(DateTime).ToString();
            FINANCE_DATEField.Index = 41;
            fields.Add(FINANCE_DATEField);

            DataSchemaField SUM_PART_QTYField = new DataSchemaField();

            SUM_PART_QTYField.Name  = "SUM_PART_QTY";
            SUM_PART_QTYField.Type  = typeof(decimal).ToString();
            SUM_PART_QTYField.Index = 42;
            fields.Add(SUM_PART_QTYField);

            DataSchemaField SUM_OF_PRICEField = new DataSchemaField();

            SUM_OF_PRICEField.Name  = "SUM_OF_PRICE";
            SUM_OF_PRICEField.Type  = typeof(decimal).ToString();
            SUM_OF_PRICEField.Index = 43;
            fields.Add(SUM_OF_PRICEField);

            DataSchemaField STATUSField = new DataSchemaField();

            STATUSField.Name  = "STATUS";
            STATUSField.Type  = typeof(int).ToString();
            STATUSField.Index = 44;
            fields.Add(STATUSField);

            DataSchemaField CONVEYANCEField = new DataSchemaField();

            CONVEYANCEField.Name  = "CONVEYANCE";
            CONVEYANCEField.Type  = typeof(string).ToString();
            CONVEYANCEField.Index = 45;
            fields.Add(CONVEYANCEField);

            DataSchemaField CARRIER_TELField = new DataSchemaField();

            CARRIER_TELField.Name  = "CARRIER_TEL";
            CARRIER_TELField.Type  = typeof(string).ToString();
            CARRIER_TELField.Index = 46;
            fields.Add(CARRIER_TELField);

            DataSchemaField SUM_WEIGHTField = new DataSchemaField();

            SUM_WEIGHTField.Name  = "SUM_WEIGHT";
            SUM_WEIGHTField.Type  = typeof(decimal).ToString();
            SUM_WEIGHTField.Index = 47;
            fields.Add(SUM_WEIGHTField);

            DataSchemaField SUM_VOLUMEField = new DataSchemaField();

            SUM_VOLUMEField.Name  = "SUM_VOLUME";
            SUM_VOLUMEField.Type  = typeof(decimal).ToString();
            SUM_VOLUMEField.Index = 48;
            fields.Add(SUM_VOLUMEField);

            DataSchemaField PLAN_SHIPPING_TIMEField = new DataSchemaField();

            PLAN_SHIPPING_TIMEField.Name  = "PLAN_SHIPPING_TIME";
            PLAN_SHIPPING_TIMEField.Type  = typeof(DateTime).ToString();
            PLAN_SHIPPING_TIMEField.Index = 49;
            fields.Add(PLAN_SHIPPING_TIMEField);

            DataSchemaField PLAN_DELIVERY_TIMEField = new DataSchemaField();

            PLAN_DELIVERY_TIMEField.Name  = "PLAN_DELIVERY_TIME";
            PLAN_DELIVERY_TIMEField.Type  = typeof(DateTime).ToString();
            PLAN_DELIVERY_TIMEField.Index = 50;
            fields.Add(PLAN_DELIVERY_TIMEField);

            DataSchemaField PRINT_COUNTField = new DataSchemaField();

            PRINT_COUNTField.Name  = "PRINT_COUNT";
            PRINT_COUNTField.Type  = typeof(int).ToString();
            PRINT_COUNTField.Index = 51;
            fields.Add(PRINT_COUNTField);

            DataSchemaField PRINT_TIMEField = new DataSchemaField();

            PRINT_TIMEField.Name  = "PRINT_TIME";
            PRINT_TIMEField.Type  = typeof(DateTime).ToString();
            PRINT_TIMEField.Index = 52;
            fields.Add(PRINT_TIMEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 53;
            fields.Add(COMMENTSField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 54;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 55;
            fields.Add(CREATE_USERField);

            DataSchemaField CREATE_DATEField = new DataSchemaField();

            CREATE_DATEField.Name  = "CREATE_DATE";
            CREATE_DATEField.Type  = typeof(DateTime).ToString();
            CREATE_DATEField.Index = 56;
            fields.Add(CREATE_DATEField);

            DataSchemaField MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 57;
            fields.Add(MODIFY_USERField);

            DataSchemaField MODIFY_DATEField = new DataSchemaField();

            MODIFY_DATEField.Name  = "MODIFY_DATE";
            MODIFY_DATEField.Type  = typeof(DateTime).ToString();
            MODIFY_DATEField.Index = 58;
            fields.Add(MODIFY_DATEField);

            DataSchemaField LAST_PRINT_USERField = new DataSchemaField();

            LAST_PRINT_USERField.Name  = "LAST_PRINT_USER";
            LAST_PRINT_USERField.Type  = typeof(string).ToString();
            LAST_PRINT_USERField.Index = 59;
            fields.Add(LAST_PRINT_USERField);

            DataSchemaField SUM_PACKAGE_QTYField = new DataSchemaField();

            SUM_PACKAGE_QTYField.Name  = "SUM_PACKAGE_QTY";
            SUM_PACKAGE_QTYField.Type  = typeof(int).ToString();
            SUM_PACKAGE_QTYField.Index = 60;
            fields.Add(SUM_PACKAGE_QTYField);

            DataSchemaField PULL_MODEField = new DataSchemaField();

            PULL_MODEField.Name  = "PULL_MODE";
            PULL_MODEField.Type  = typeof(int).ToString();
            PULL_MODEField.Index = 61;
            fields.Add(PULL_MODEField);

            Schema.Fields = fields.ToArray();
        }
        public SapSupplierQuotaInfo() : base("TI_IFM_SAP_SUPPLIER_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 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 PART_NOField = new DataSchemaField();

            PART_NOField.Name  = "PART_NO";
            PART_NOField.Type  = typeof(string).ToString();
            PART_NOField.Index = 3;
            fields.Add(PART_NOField);

            DataSchemaField WERKSField = new DataSchemaField();

            WERKSField.Name  = "WERKS";
            WERKSField.Type  = typeof(string).ToString();
            WERKSField.Index = 4;
            fields.Add(WERKSField);

            DataSchemaField QTYPEField = new DataSchemaField();

            QTYPEField.Name  = "QTYPE";
            QTYPEField.Type  = typeof(string).ToString();
            QTYPEField.Index = 5;
            fields.Add(QTYPEField);

            DataSchemaField I_DATEField = new DataSchemaField();

            I_DATEField.Name  = "I_DATE";
            I_DATEField.Type  = typeof(DateTime).ToString();
            I_DATEField.Index = 6;
            fields.Add(I_DATEField);

            DataSchemaField E_DATEField = new DataSchemaField();

            E_DATEField.Name  = "E_DATE";
            E_DATEField.Type  = typeof(DateTime).ToString();
            E_DATEField.Index = 7;
            fields.Add(E_DATEField);

            DataSchemaField ZNRMMField = new DataSchemaField();

            ZNRMMField.Name  = "ZNRMM";
            ZNRMMField.Type  = typeof(string).ToString();
            ZNRMMField.Index = 8;
            fields.Add(ZNRMMField);

            DataSchemaField QUPOSField = new DataSchemaField();

            QUPOSField.Name  = "QUPOS";
            QUPOSField.Type  = typeof(int).ToString();
            QUPOSField.Index = 9;
            fields.Add(QUPOSField);

            DataSchemaField LIFNRField = new DataSchemaField();

            LIFNRField.Name  = "LIFNR";
            LIFNRField.Type  = typeof(string).ToString();
            LIFNRField.Index = 10;
            fields.Add(LIFNRField);

            DataSchemaField SUPPLIER_NAMEField = new DataSchemaField();

            SUPPLIER_NAMEField.Name  = "SUPPLIER_NAME";
            SUPPLIER_NAMEField.Type  = typeof(string).ToString();
            SUPPLIER_NAMEField.Index = 11;
            fields.Add(SUPPLIER_NAMEField);

            DataSchemaField QUOTEField = new DataSchemaField();

            QUOTEField.Name  = "QUOTE";
            QUOTEField.Type  = typeof(int).ToString();
            QUOTEField.Index = 12;
            fields.Add(QUOTEField);

            DataSchemaField ZSTOPField = new DataSchemaField();

            ZSTOPField.Name  = "ZSTOP";
            ZSTOPField.Type  = typeof(string).ToString();
            ZSTOPField.Index = 13;
            fields.Add(ZSTOPField);

            DataSchemaField FLAGField = new DataSchemaField();

            FLAGField.Name  = "FLAG";
            FLAGField.Type  = typeof(string).ToString();
            FLAGField.Index = 14;
            fields.Add(FLAGField);

            DataSchemaField PROCESS_FLAGField = new DataSchemaField();

            PROCESS_FLAGField.Name  = "PROCESS_FLAG";
            PROCESS_FLAGField.Type  = typeof(int).ToString();
            PROCESS_FLAGField.Index = 15;
            fields.Add(PROCESS_FLAGField);

            DataSchemaField PROCESS_TIMEField = new DataSchemaField();

            PROCESS_TIMEField.Name  = "PROCESS_TIME";
            PROCESS_TIMEField.Type  = typeof(DateTime).ToString();
            PROCESS_TIMEField.Index = 16;
            fields.Add(PROCESS_TIMEField);

            DataSchemaField COMMENTSField = new DataSchemaField();

            COMMENTSField.Name  = "COMMENTS";
            COMMENTSField.Type  = typeof(string).ToString();
            COMMENTSField.Index = 17;
            fields.Add(COMMENTSField);

            DataSchemaField VALID_FLAGField = new DataSchemaField();

            VALID_FLAGField.Name  = "VALID_FLAG";
            VALID_FLAGField.Type  = typeof(bool).ToString();
            VALID_FLAGField.Index = 18;
            fields.Add(VALID_FLAGField);

            DataSchemaField CREATE_USERField = new DataSchemaField();

            CREATE_USERField.Name  = "CREATE_USER";
            CREATE_USERField.Type  = typeof(string).ToString();
            CREATE_USERField.Index = 19;
            fields.Add(CREATE_USERField);

            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 MODIFY_USERField = new DataSchemaField();

            MODIFY_USERField.Name  = "MODIFY_USER";
            MODIFY_USERField.Type  = typeof(string).ToString();
            MODIFY_USERField.Index = 21;
            fields.Add(MODIFY_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);

            Schema.Fields = fields.ToArray();
        }
Exemple #42
0
 private ColumnType FindColumnType(DataSchema dataSchema, string columnTypeName)
 {
     return dataSchema.ColumnTypes[columnTypeName];
 }