private void btnDB2Connection_Click(object sender, EventArgs e)
{
string message = string.Empty;
try
{
IBM.Data.DB2.DB2Connection conn = ConnectDb();
message = "DB2 Connection Successful !";
conn.Close();
}
catch (Exception ex)
{
message = ex.Message;
}
MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnPublishData_Click(object sender, EventArgs e)
{
string sQuery1 = string.Empty;
string sQuery2 = string.Empty;
string sQuery3 = string.Empty;
string message = string.Empty;
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
try
{
conn = ConnectDb();
switch (cmbTransactionType.SelectedIndex)
{
case 0:
sQuery1 = "SELECT * FROM DEPOSIT FETCH FIRST 5 ROWS ONLY";
break;
case 1:
sQuery1 = "SELECT * FROM LOAN FETCH FIRST 5 ROWS ONLY";
break;
}
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(sQuery1, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
if (dt.Rows.Count <= 0)
{
message = "No Record Exist !!!";
}
else
{
SaveData(dt);
message = "Successfully Imported '" + cmbTransactionType.Text + "' Data !!!";
}
}
catch (Exception ex)
{
message = ex.Message;
}
MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void Close()
{
if (_DB2Conn == null)
{
return;
}
try
{
_DB2Conn.Close();
_DB2Conn.Dispose();
_DB2Conn = null;
}
catch (System.Exception ex)
{
_DB2Conn = null;
throw ex;
}
}
/*
* Método que trae las posiciones que dispone cada part number.
*/
private static DataTable bringResultsForPositions(string toolIdToSearch, string _ProductPartNumberId)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForPositions =
@" SELECT CGSLSC.TOOL_SETUP.*, TOOL_KEY AS EXPR1, PRODUCT_PN_KEY AS EXPR2
FROM CGSLSC.TOOL_SETUP
WHERE (TOOL_KEY = " + toolIdToSearch + ") AND (PRODUCT_PN_KEY = " + _ProductPartNumberId + ")";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPositions, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
/*
* Método que devuelve el nombre del part number ID
*/
private static DataTable bringResultsForProductPN(string _ProductPartNumberId)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForPN =
@" SELECT PART_NUMBER_KEY AS EXPR1, CGS.PART_NUMBER.*
FROM CGS.PART_NUMBER
WHERE (PART_NUMBER_KEY = " + _ProductPartNumberId + ")";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPN, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
/*
* Método que trae todos los datos de la tabla TOOL_SETUP_INFO por toolId
*/
private static DataTable bringResultsForToolId(string toolIdToSearch)
{
IBM.Data.DB2.DB2Connection conn = null;
DataTable dt = new DataTable("Table1");
conn = ConnectDb();
string queryDbGetRequestedDataForToolKey =
@"SELECT TS_INFO_KEY, PRODUCT_PN_KEY, TOOL_KEY, ROUTE_STEP_KEY, LAST_CHANGE_TMST, RECIPE_READY, RECIPE_ID, PROGRAM_ID, CARRIER_PN_KEY, DUAL_SIDED, DUAL_LANE, PFC_MODE, LAST_SETUP_TOOL_KEY, LAST_SETUP_TOOL_STAGE
FROM CGSLSC.TOOL_SETUP_INFO
WHERE (TOOL_KEY = " + toolIdToSearch + ") ORDER BY LAST_CHANGE_TMST DESC";
using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForToolKey, conn))
{
IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader();
dt.Load(dr);
}
conn.Close();
return(dt);
}
