コード例 #1
0
        private void bttnBarrowed_Click(object sender, System.EventArgs e)
        {
            FORMBarrowedBooks_Barrowers.sBookNumber = txtBookNO.Text;
            FORMBarrowedBooks_Barrowers sForm = new FORMBarrowedBooks_Barrowers();

            sForm.ShowDialog();
        }
コード例 #2
0
        private void FORMBarrowedBooks_Barrowers_Load(object sender, System.EventArgs e)
        {
            //Set the Icon on Listview.
            lvBooks.SmallImageList = MDIFORM.i16x16;

            //Set the Data Adapter
            daHistory = new OleDbDataAdapter("", clsConnections.CN);

            //Set the Combo Box
            sFunctions.FillCombo(cbYear, "SELECT tblSchoolYear.IndexSY, [YearStart] & ' - ' & [YearEnd] AS SY FROM tblSchoolYear ORDER BY [YearStart] & ' - ' & [YearEnd] ASC", "tblSchoolYear", 1);
            sFunctions.FillCombo(cbLevel, "SELECT * FROM tblLevel ORDER BY LevelName ASC", "tblLevel", 1);

            //Set to Load Books History
            loadBooks("SELECT tblBarrowed.BookNo, tblBarrowers.BarrowerID, [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS Fullname, tblCourse.CourseName, tblBarrowed.DateBarrowed, tblBarrowed.DateRetured, [YearStart] & ' - ' & [YearEnd] AS SY, tblLevel.LevelName FROM tblSchoolYear RIGHT JOIN (tblLevel RIGHT JOIN (tblCourse RIGHT JOIN (tblBarrowers RIGHT JOIN tblBarrowed ON tblBarrowers.BarrowerID = tblBarrowed.BarrowerID) ON tblCourse.IndexCourse = tblBarrowers.Course) ON tblLevel.IndexLevel = tblBarrowers.LevelIndex) ON tblSchoolYear.IndexSY = tblBarrowers.SchoolYear WHERE [YearStart] & ' - ' & [YearEnd] LIKE '" + cbYear.Text + "' AND tblLevel.LevelName LIKE '" + cbLevel.Text + "' AND tblBarrowed.BookNo LIKE '" + sBookNumber + "' ORDER BY tblBarrowers.BarrowerID ASC");

            publicHistory = this;
        }