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