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;
    }
    protected void ButtonQuery_Click(object sender, EventArgs e)
    {
        try
        {
            //清除目前選擇DATA            
            this.lblVENDOR.Text = "";
            this.lblVENDOR_NAME.Text = "";

            CGD32_BCO bco = new CGD32_BCO(ConntionDB);
            firstpage = 0;
            firstindex = -1;

            databind();
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        finally { }
    }//ButtonQuery_Click
 public SLP_CGDVENDOR()
 {
     bco = new CGD32_BCO(ConntionDB);
 }
 public SLP_CGDEMP()
 {
     bco = new CGD32_BCO(ConntionDB);
 }