public void loadSelector() { clearDataSourceSelector(); int limit = Configuration.defaultLimit; authorList.AddRange(SqlObjectLoader.getSqlObjectsFromDataTable(typeof(BookAuthor), getDataTableWithOffsetAndLimit("getTacGia", 0, limit))); nxbList.AddRange(SqlObjectLoader.getSqlObjectsFromDataTable(typeof(BookNXB), getDataTableWithOffsetAndLimit("getNXB", 0, limit))); locationList.AddRange(SqlObjectLoader.getSqlObjectsFromDataTable(typeof(BookLocation), getDataTableWithOffsetAndLimit("getVitri", 0, limit))); typeList.AddRange(SqlObjectLoader.getSqlObjectsFromDataTable(typeof(BookType), getDataTableWithOffsetAndLimit("getLoaiSach", 0, limit))); Program.MainForm.BookForm.clearSearchInput(); }
public override void changeControlData() { base.changeControlData(); this.buttonAdd.Text = getExecuteButtonName(); if (!isAdd) { oldBooks.AddRange(main.phieuMuonManager.getBookPhieuMuon(int.Parse(id))); this.inputID.Text = id; newBooks.AddRange(oldBooks); bookBinding.ResetBindings(true); DataTable dataTable = main.getSqlObject("sp_get_PhieuMuon_raw", "@MaPhieu", int.Parse(id)); DataRow row = dataTable.Rows[0]; inputReader.Text = Convert.ToString(row["MaSV"]); inputNgayMuon.Value = (DateTime)row["NgayMuon"]; DateTime ngayHenTra = (DateTime)row["NgayHenTra"]; int totalDays = (ngayHenTra - inputNgayMuon.Value).Days; inputSoNgay.Value = totalDays; } }