Esempio n. 1
0
    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;
    }
Esempio n. 2
0
        //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
Esempio n. 3
0
 public Bank()
 {
     co_main = new BCO.MaintainBankMain(ConntionDB);
 }
Esempio n. 4
0
        }//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;
        }