Esempio n. 1
0
    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);
    }
Esempio n. 2
0
    [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);
    }
Esempio n. 3
0
    [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);
    }
Esempio n. 4
0
    [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);
    }