public string AMSDML(string SQL, string sRCPGroup)
{
string sResult = "";
PubUtil.WriteLog("EasyFlowLog", "AMSDML", SQL, sRCPGroup, "Start!!");
try
{
System.Data.DataSet ds = new System.Data.DataSet();
AMSWebReference.AMSWebService ws = new AMSWebReference.AMSWebService();
ds = ws.AMSDBQuery2(SQL, "ecimwebservice");
PubUtil.WriteLog("EasyFlowLog", "AMSDML", "Call AMSDBQuery", SQL, "Complete!!");
if (sRCPGroup.Equals("True"))
{//do Recipe Group
PubUtil.WriteLog("EasyFlowLog", "AMSDML", "Recipe Group = ", sRCPGroup, "Start!!");
PubUtil.WriteLog("EasyFlowLog", "AMSDML", "Recipe Group = ", sRCPGroup, "Complete!!");
}
}
catch (Exception ex)
{
sResult = "";
PubUtil.WriteLog("Exception", "AMSDML", SQL, sRCPGroup, "Exception:" + ex.Message);
}
PubUtil.WriteLog("EasyFlowLog", "AMSDML", SQL, sRCPGroup, "Complete!!" + sResult);
return(sResult);
}
[WebMethod] //20150408 add by Mark for any SQL update/delete statement
public string AMSUpdateDeleteSQLStatement(string SQL)
{
string sResult = "";
try
{
System.Data.DataSet ds = new System.Data.DataSet();
AMSWebReference.AMSWebService ws = new AMSWebReference.AMSWebService();
ds = ws.AMSDBQuery2(SQL, "ecimwebservice");
if (null == ds || ds.Tables.Count != 1 || ds.Tables[0].Rows.Count < 1)
{
sResult = "";
}
else
{
sResult = ds.Tables[0].Rows[0]["srcdevice"].ToString();
}
}
catch (Exception ex)
{
sResult = ex.ToString();
}
return(sResult);
}
[WebMethod] //20140407 add by Mark for T3 DPS PnP Besi source device
public string getDPS_Besi_PnP_SRDevice(string sWaferID)
{
string sResult = "";
try
{
System.Data.DataSet ds = new System.Data.DataSet();
AMSWebReference.AMSWebService ws = new AMSWebReference.AMSWebService();
ds = ws.AMSDBQuery2("select distinct p.srcdevice from waferdetails wd,container c,product p where wd.waferid='" + sWaferID + "' and wd.baseobjectid=c.containerid and c.productid=p.productid and substr(c.containername,1,2)='DP'", "ecimwebservice");
if (null == ds || ds.Tables.Count != 1 || ds.Tables[0].Rows.Count < 1)
{
sResult = "";
}
else
{
sResult = ds.Tables[0].Rows[0]["srcdevice"].ToString();
}
}
catch (Exception ex)
{
sResult = "";
}
return(sResult);
}
[WebMethod] //20140407 add by Mark for T3 update MC status for Production Index system
public string updateMcStatusToProdIndex(string sMachineID, string Status)
{
string sResult = "";
try
{
System.Data.DataSet ds = new System.Data.DataSet();
AMSWebReference.AMSWebService ws = new AMSWebReference.AMSWebService();
ds = ws.AMSDBQuery2("update legacydev.pn_testers set ecim_status='" + Status + "',ecim_last_update=sysdate where tester='" + sMachineID + "'", "ecimwebservice");
//if (null == ds || ds.Tables.Count != 1 || ds.Tables[0].Rows.Count < 1)
// sResult = "";
//else
//{
// sResult = ds.Tables[0].Rows[0]["srcdevice"].ToString();
//}
}
catch (Exception ex)
{
sResult = "";
}
return(sResult);
}
