Esempi in C# (CSharp) per CGD32_BCO.DoQueryEmpSLP

Esempio n. 1

File: SLP_CGDWebService.cs Progetto: ChiangHanLung/PIC_VDS

    public string CGDEMPName(string Vendor, string EMP_ID)
    {
        string Name = "";
        string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
        CGD32_BCO bco = new CGD32_BCO(ConnectionDBStr);

        if (EMP_ID != "")
        {
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(Vendor);
            ParameterList.Add(EMP_ID);            
            ParameterList.Add(DBNull.Value);
            ParameterList.Add(DBNull.Value);
            ParameterList.Add(DBNull.Value);

            DataTable dt = bco.DoQueryEmpSLP(ParameterList);

            if (dt.Rows.Count > 0)
            { Name = dt.Rows[0]["EMP_NAME"].ToString().Trim(); }
            else
            { Name = "查無資料"; }
        }

        return Name;
    }