private void button8_Click(object sender, EventArgs e)
{
OraDbHelper a = new OraDbHelper(null);
a.ConnectionString = "Data Source=KS_QAS_AY;User Id=FWASSY;Password=FWASSY;Connection Lifetime=120;";
string sSql = "";
sSql = " SELECT 'a' from dual ";
DataTable dtStrip = a.ExecuteDataTable(sSql);
a = new OraDbHelper(null);
return;
}
private void btnClick_Click(object sender, EventArgs e)
{
try
{
txtShow.Text = "";
ConfigurationManager.RefreshSection("appSettings");
txtShow.Text = ConfigurationManager.AppSettings["Test"];
txtShow.Text = Guid.NewGuid().ToString();
//timer1.Interval = 60000;
//timer1.Start();
OraDbHelper _OraHelper = new OraDbHelper(null);
_OraHelper.ConnectionString = "Data Source=KS_QAS_AY;Persist Security Info=True;User ID=FA;Password=FA;Unicode=True";
string sSql = "";
sSql = " SELECT STRIPID FROM FA.MARKOUT WHERE LOT= 'ENEB08N001.031' AND STEPNAME ='STD_CuMold_Step' ORDER BY CDT ";
DataTable SSS = _OraHelper.ExecuteDataTable(sSql);
string a = ConvertDataTableToXML(SSS);
DataTable aaa = ConvertXMLToDataTable(a);
if (aaa.Rows.Count > 0)
{
txtShow.Text = aaa.Rows[0][0].ToString();
}
else
{
MessageBox.Show("没有资料");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}