Example #1
0
 private void ScBankCD_CodeKeyDownEvent(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter)
     {
         if (!string.IsNullOrWhiteSpace(ScBankCD.TxtCode.Text))
         {
             if (ScBankCD.SelectData())
             {
                 ScBranchCD.Value1 = ScBankCD.TxtCode.Text;
                 ScBranchCD.Value2 = ScBankCD.LabelText;
                 mb = GetDate();
                 mb = mtbstbl.M_Bank_ChangeDate_Select(mb);
                 if (mb != null)
                 {
                     date = mb.ChangeDate;
                 }
             }
             else
             {
                 mtbstbl.ShowMessage("E101");
                 ScBankCD.SetFocus(1);
             }
         }
     }
 }
 private void F11()
 {
     if (ErrorCheck())
     {
         mbe = GetSearchInfo();
         DataTable dtBank = sgbl.M_Bank_Search(mbe);
         GdvGinkou.DataSource = dtBank;
     }
 }
Example #3
0
 private M_Bank_Entity GetDate()
 {
     mb = new M_Bank_Entity
     {
         BankCD     = ScBankCD.TxtCode.Text,
         ChangeDate = string.IsNullOrWhiteSpace(ScBranchCD.ChangeDate) ? bbl.GetDate() : ScBranchCD.ChangeDate
     };
     return(mb);
 }
Example #4
0
        public M_Bank_Entity M_Bank_ChangeDate_Select(M_Bank_Entity mb)
        {
            DataTable dt = mbdl.M_Bank_ChangeDate_Select(mb);

            if (dt.Rows.Count > 0)
            {
                mb.ChangeDate = dt.Rows[0]["ChangeDate"].ToString();
                return(mb);
            }
            return(null);
        }
Example #5
0
        public M_Bank_Entity M_Bank_Select(M_Bank_Entity mbe)
        {
            DataTable dtBank = mbdl.M_Bank_Select(mbe);

            if (dtBank.Rows.Count > 0)
            {
                mbe.BankName = dtBank.Rows[0]["BankName"].ToString();
                mbe.BankKana = dtBank.Rows[0]["BankKana"].ToString();

                return(mbe);
            }
            return(null);
        }
        public DataTable M_Bank_ChangeDate_Select(M_Bank_Entity mbe)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@BankCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.BankCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mbe.ChangeDate
                  } }
            };

            return(SelectData(dic, "M_Bank_ChangeDate_Select"));
        }
        private M_Bank_Entity GetSearchInfo()
        {
            mbe = new M_Bank_Entity
            {
                BankCDFrom = txtBankCDFrom.Text,
                BankCDTo   = txtBankCDTo.Text,
                ChangeDate = lblChangeDate.Text,
                BankName   = txtBankName.Text,
                BankKana   = txtBankKana.Text,
                searchType = RdoKijunBi.Checked ? "0" : "1",
                DeleteFlg  = "0",
            };

            return(mbe);
        }
        public DataTable M_Bank_Search(M_Bank_Entity mbe)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@Fields", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.FieldsName
                  } },
                { "@BankCDFrom", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.BankCDFrom
                  } },
                { "@BankCDTo", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.BankCDTo
                  } },
                { "@BankName", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.BankName
                  } },
                { "@BankKana", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.BankKana
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mbe.ChangeDate
                  } },
                { "@SearchType", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.searchType
                  } },
                { "@DeleteFlg", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.DeleteFlg
                  } },
                { "@OrderBy", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.OrderBy
                  } },
            };

            UseTransaction = true;
            return(SelectData(dic, "M_Bank_Search"));
        }
Example #9
0
 public DataTable Bank_Select(M_Bank_Entity mbe)
 {
     return(mbdl.M_Vendor_Bank_Select(mbe));
 }
 public DataTable M_Bank_Search(M_Bank_Entity mbe)
 {
     return(mbankdl.M_Bank_Search(mbe));
 }