private void LoadDataToGridView() { this.dgvVoucherStt.Rows.Clear(); VoucherBLL manageVoucherBLL = new VoucherBLL(); List <VoucherBLL> manageVoucherArr = new List <VoucherBLL>(); manageVoucherArr = VoucherDAL.getManageVoucherList(); //MessageBox.Show("ok"); foreach (VoucherBLL row in manageVoucherArr) { this.dgvVoucherStt.Rows.Add(row.Phieutra, row.Phieumuon, row.Ngaytra, row.Docgia, row.Doituong); } this.GetSelectedValue(); this.dgvVoucherStt.SelectionChanged += new EventHandler(dgvCertificateStt_SelectionChanged); }
private void btnSearch_Click(object sender, EventArgs e) { string key = this.txtSearch.Text; if (key == "".Trim()) { MessageBox.Show("Please enter keyword!", "Notice"); return; } string catalog = ""; //MessageBox.Show(this.cboSearch.SelectedItem.ToString()); if (this.cboSearch.SelectedItem.ToString() == "Voucher") { catalog += "phieutra.maphieutra"; //MessageBox.Show(catalog); } else if (this.cboSearch.SelectedItem.ToString() == "Certificate") { catalog += "sachmuon.maphieumuon"; //MessageBox.Show(catalog); } VoucherBLL bookStatusBLL = new VoucherBLL(); List <VoucherBLL> voucherStatusArr = new List <VoucherBLL>(); voucherStatusArr = VoucherDAL.search(key, catalog); this.dgvVoucherStt.Rows.Clear(); if (voucherStatusArr != null) { //MessageBox.Show("ok"); foreach (VoucherBLL row in voucherStatusArr) { this.dgvVoucherStt.Rows.Add(row.Phieutra, row.Phieumuon, row.Ngaytra, row.Docgia, row.Doituong); } } else { MessageBox.Show("Sorry! Can't find this voucher/certificate"); return; } this.GetSelectedValue(); this.dgvVoucherStt.SelectionChanged += new EventHandler(dgvCertificateStt_SelectionChanged); }
public static List <VoucherBLL> search(string value, string catalog) { string sql = "SELECT * FROM [phieutra] INNER JOIN [sachmuon] ON sachmuon.maphieutra = phieutra.maphieutra INNER JOIN [docgia] ON phieutra.madocgia = docgia.madocgia where " + catalog + "=" + value + ""; DataTable dt = VoucherDAL._condb.getDataTable(sql); List <VoucherBLL> voucherStatusBLLList = new List <VoucherBLL>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { VoucherBLL voucherStatusBLL = new VoucherBLL(Int32.Parse(row["maphieutra"].ToString()), Int32.Parse(row["maphieumuon"].ToString()), row["tendocgia"].ToString(), Boolean.Parse(row["lacbcnv"].ToString()), DateTime.Parse(row["ngaytra"].ToString())); voucherStatusBLLList.Add(voucherStatusBLL); } return(voucherStatusBLLList); } else { return(null); } }
public static List <VoucherBLL> getManageVoucherList() { String sql = "SELECT DISTINCT phieutra.maphieutra, sachmuon.maphieumuon, tendocgia, lacbcnv, ngaytra FROM [phieutra] INNER JOIN [sachmuon] ON sachmuon.maphieutra = phieutra.maphieutra INNER JOIN [docgia] ON phieutra.madocgia = docgia.madocgia"; DataTable dt = VoucherDAL._condb.getDataTable(sql); List <VoucherBLL> manageVoucherBLLList = new List <VoucherBLL>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { VoucherBLL manageVoucherBLL = new VoucherBLL(Int32.Parse(row["maphieutra"].ToString()), Int32.Parse(row["maphieumuon"].ToString()), row["tendocgia"].ToString(), Boolean.Parse(row["lacbcnv"].ToString()), DateTime.Parse(row["ngaytra"].ToString())); manageVoucherBLLList.Add(manageVoucherBLL); } return(manageVoucherBLLList); } else { return(null); } }