public Form1()
{
InitializeComponent();
cmd = new DBConnect.ODBC_DB2Connect();
execution = Execution.Execution.getBuilder();
host=Execution.EasyClient.getHost();
//eventid = execution..setMoveConstruction("test", DateTime.Now, "N6", "E", 17770, 18000, "1", "1100000000");
}
internal static System.Data.DataTable GetDeviceDT()
{
if (DeviceDT == null)
{
lock (typeof(System.Data.DataTable))
{
if (DeviceDT == null)
{
DBConnect.ODBC_DB2Connect conn = new DBConnect.ODBC_DB2Connect();
string cmd = string.Format("Select DeviceName,Location,Device_Type,Mile_M from {0}.{1};", GlobaSchema, DBConnect.DB2TableName.tblDeviceConfig);
DeviceDT = conn.Select(cmd);
DeviceDT.PrimaryKey = new System.Data.DataColumn[] { DeviceDT.Columns[0] };
}
}
}
return DeviceDT;
}
internal static System.Data.DataTable GetCMSTypeDT()
{
if (CMSTypeDT == null)
{
lock (typeof(System.Data.DataTable))
{
if (CMSTypeDT == null)
{
DBConnect.ODBC_DB2Connect conn = new DBConnect.ODBC_DB2Connect();
string cmd = string.Format("Select DeviceName,show_icon From {0}.{1};", GlobaSchema, DBConnect.DB2TableName.tblDeviceConfig);
CMSTypeDT = conn.Select(cmd);
CMSTypeDT.PrimaryKey = new System.Data.DataColumn[] { CMSTypeDT.Columns[0] };
}
}
}
return CMSTypeDT;
}
internal static System.Data.DataTable GetCloverleafDT()
{
if (CloverleafDT == null)
{
lock (typeof(System.Data.DataTable))
{
if (CloverleafDT == null)
{
DBConnect.ODBC_DB2Connect conn = new DBConnect.ODBC_DB2Connect();
string cmd = string.Format("Select LineID1,mileage1,lineid2,Mileage2,direction2 from {0}.VWCLOVERLEAF "
+ " where direction1 in ('N','E');", GlobaSchema);
CloverleafDT = conn.Select(cmd);
}
}
}
return CloverleafDT;
}
internal static System.Data.DataTable GetLineNameDT()
{
if (LineNameDT == null)
{
lock (typeof(System.Data.DataTable))
{
if (LineNameDT == null)
{
DBConnect.ODBC_DB2Connect conn = new DBConnect.ODBC_DB2Connect();
string cmd = string.Format("Select LineID,LineName,startMileage,endMileage from {0}.{1};", GlobaSchema, DBConnect.DB2TableName.tblGroupLine);
LineNameDT = conn.Select(cmd);
LineNameDT.PrimaryKey = new System.Data.DataColumn[] { LineNameDT.Columns[0] };
}
}
}
return LineNameDT;
}
internal static System.Data.DataTable GetDivisionDT()
{
if (DivisionDT == null)
{
lock (typeof(System.Data.DataTable))
{
if (DivisionDT == null)
{
DBConnect.ODBC_DB2Connect conn = new DBConnect.ODBC_DB2Connect();
string cmd = string.Format("Select DivisionName,DivisionType,mileage,LineID,DivisionID from {0}.{1};", GlobaSchema, DBConnect.DB2TableName.tblGroupDivision);
DivisionDT = conn.Select(cmd);
}
}
}
return DivisionDT;
}
