C# (CSharp) OUT02.QueryVendorBaseByFind_1 Beispiele

Beispiel #1

Datei: SLP_OUTVDMWebService.cs Projekt: ChiangHanLung/PIC_VDS

    public string VendorBaseName(string Code)
    {
            string Name = "";
        string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
        OUT02 co_main = new OUT02(ConnectionDBStr);

        if (Code != "")
        {
            ArrayList ParameterList = new ArrayList();
            SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.VENDOR", Code, "=", "and");//TextBoxCode.Text

            DataTable dt = co_main.QueryVendorBaseByFind_1(ParameterList); //查詢寫在DBO
            if (dt.Rows.Count > 0)
            { Name = dt.Rows[0]["VENDOR_NAME"].ToString().Trim(); }
            else
            { Name = "查無資料"; }
        }

        return Name;
    }