public string BankName(string Code) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; MaintainBankMain BCO = new MaintainBankMain(ConnectionDBStr); if (Code != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Code); //Bank_ID DataTable Dt = BCO.QueryForSLP(ParameterList); if (Dt.Rows.Count > 0) { Name = Dt.Rows[0]["BANK_NAME"].ToString().Trim(); } else { Name = "查無資料"; } } return Name; }
//codename 用callback回來的code 做查詢 private void dataget() { ParameterList.Clear(); CAAModel.MaintainBankMain BCO = new CAAModel.MaintainBankMain(ConntionDB); //ParameterList.Add(_Category); //keyword查詢時 要改成keyword的值 ParameterList.Add(_Code); //Bank_ID DataTable Dt = BCO.QueryForSLP(ParameterList); //DataTable Dt = BCO.QuerySwitch(CAAModel.MaintainBankMain.QueryType.ID, // ParameterList // ); if (Dt.Rows.Count > 0) { _Name = Dt.Rows[0]["BANK_NAME"].ToString().Trim(); } else { _Name = "查無資料"; } HiddenField1.Value = _Name; TextBoxName.Text = _Name; }//dataget
public Bank() { co_main = new BCO.MaintainBankMain(ConntionDB); }
}//Initiziatoin_Component private DataTable Linedata() { ParameterList.Clear(); CAAModel.MaintainBankMain BCO = new CAAModel.MaintainBankMain(ConntionDB); //ParameterList.Add(_Category); DataTable Dt = BCO.QuerySwitch(CAAModel.MaintainBankMain.QueryType.ALL, ParameterList ); return Dt; }