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();
}
/// <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);
}
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();
}
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();
}
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);
}
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;
}
}
}
}
}
}
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();
}
}
}
}
}
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;
}
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();
}
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();
}
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();
}
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);
}
/// <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);
}
/// <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);
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
private ColumnType FindColumnType(DataSchema dataSchema, string columnTypeName)
{
return dataSchema.ColumnTypes[columnTypeName];
}
