public string CGDVENDORName(string Code) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; CGD32_BCO bco = new CGD32_BCO(ConnectionDBStr); if (Code != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Add(DBNull.Value); ParameterList.Add(Code); ParameterList.Add(DBNull.Value); ParameterList.Add(DBNull.Value); DataTable dt = bco.DoQuerySLP(ParameterList); if (dt.Rows.Count > 0) { Name = dt.Rows[0]["VENDOR_NAME"].ToString().Trim(); } else { Name = "查無資料"; } } return Name; }