public static HssUtility.SQLserver.CmdTemplate Get_cmdTP() { if (DTCPositionModelNumber_Mapping.DBcmd_TP != null) { return(DTCPositionModelNumber_Mapping.DBcmd_TP); } DTCPositionModelNumber_Mapping.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate(); DTCPositionModelNumber_Mapping.DBcmd_TP.tableName = "DTCPositionModelNumber_Mapping"; DTCPositionModelNumber_Mapping.DBcmd_TP.schema = "dbo"; DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("DTCModelMappingID"); DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("Country"); /*Optional 2*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("Issue"); /*Optional 3*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("RecordYear"); /*Optional 4*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("IncomeEvent"); /*Optional 5*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("ModelNumber"); DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("ADRRecordDate"); /*Optional 7*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("ORDPayDate"); /*Optional 8*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("SecurityTypeID"); /*Optional 9*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("ADRRecordDate_End"); /*Optional 10*/ DTCPositionModelNumber_Mapping.DBcmd_TP.AddColumn("AtSourceSumFromDetails"); /*Optional 11*/ return(DTCPositionModelNumber_Mapping.DBcmd_TP); }
public DB_insert(CmdTemplate tp) { this.template = tp; this.DBname = tp.DBname; this.schema = tp.schema; this.tableName = tp.tableName; }
public static CmdTemplate Get_cmdTP() { if (TableSchema.DBcmd_TP != null) { return(TableSchema.DBcmd_TP); } TableSchema.DBcmd_TP = new CmdTemplate(); TableSchema.DBcmd_TP.schema = "INFORMATION_SCHEMA"; TableSchema.DBcmd_TP.tableName = "TABLES"; TableSchema.DBcmd_TP.AddColumn("TABLE_SCHEMA"); TableSchema.DBcmd_TP.AddColumn("TABLE_NAME"); return(TableSchema.DBcmd_TP); }