private void but_search_Click(object sender, EventArgs e) { string search; if (IsNullsearch()) { LoadPhieuNhap(); } else { while (true) { if (comboBox_loc.Text == "") { if (funcShare.isNumber(textbox_search.Text)) { string or = " OR "; string searchID = "phieu_nhap.id= " + textbox_search.Text; string ngay = "DAY(ngay_nhap) = " + textbox_search.Text; string thang = "MONTH(ngay_nhap) = " + textbox_search.Text; search = query + " and (" + searchID + or + ngay + or + thang + ")"; } else { if (funcShare.isDate(textbox_search.Text) == true) { string[] arr = textbox_search.Text.Split('/', '-'); search = query + " and ngay_nhap =" + funcShare.date(arr[0], arr[1], arr[2]); } else { string tenNCC = "nha_cung_cap.ten LIKE N'%" + textbox_search.Text + "%'"; string tenNV = "nhan_vien.ten LIKE N'%" + textbox_search.Text + "%'"; search = query + " and (" + tenNCC + " or " + tenNV + ")"; } } database.pushGridview(search, gridView); break; } if (comboBox_loc.Text == "Mã phiếu nhập hàng" && funcShare.isNumber(textbox_search.Text)) { search = query + " and phieu_nhap.id=" + textbox_search.Text; database.pushGridview(search, gridView); break; } //v if (comboBox_loc.Text == "Nhà cung cấp") { if (funcShare.isNumber(textbox_search.Text)) { search = query + " and ncc_id=" + textbox_search.Text; } else { string like = "nha_cung_cap.ten LIKE N'%" + textbox_search.Text + "%'"; search = query + " and " + like; } database.pushGridview(search, gridView); break; } //v if (comboBox_loc.Text == "Ngày nhập") { if (funcShare.isNumber(textbox_search.Text)) { if (textbox_search.Text.Length <= 2) { search = query + " and (DAY(ngay_nhap)=" + textbox_search.Text + " or MONTH(ngay_nhap)=" + textbox_search.Text + ")"; } else { search = query + " and YEAR(ngay_nhap)=" + textbox_search.Text; } database.pushGridview(search, gridView); } else { if (funcShare.isDate(textbox_search.Text) == true) { string[] arr = textbox_search.Text.Split('/', '-'); search = query + " and ngay_nhap =" + funcShare.date(arr[0], arr[1], arr[2]); database.pushGridview(search, gridView); } } break; } //v if (comboBox_loc.Text == "Nhân viên") { if (funcShare.isNumber(textbox_search.Text)) { search = query + " and nhan_vien_id=" + textbox_search.Text; } else { string like = "nhan_vien.ten LIKE N'%" + textbox_search.Text + "%'"; search = query + " and " + like; } database.pushGridview(search, gridView); break; } //v if (comboBox_loc.Text == "Mặt hàng") { if (funcShare.isNumber(textbox_search.Text)) { search = "SELECT distinct phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten FROM " + "phieu_nhap,nha_cung_cap,nhan_vien,chi_tiet_phieu_nhap " + "where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id " + "and phieu_nhap.id = phieu_nhap_id and mat_hang_id =" + textbox_search.Text; } else { search = "SELECT distinct phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten FROM " + "phieu_nhap,nha_cung_cap,nhan_vien,chi_tiet_phieu_nhap,mat_hang " + "where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id " + "and phieu_nhap.id = phieu_nhap_id and mat_hang_id = mat_hang.id and mat_hang.ten LIKE N'%" + textbox_search.Text + "%';"; } database.pushGridview(search, gridView); break; } //v break; } } }
private void but_search_Click(object sender, EventArgs e) { string search; if (funcShare.isNumber(textbox_search.Text)) { if (comboBox_loc.Text == "") { string or = " OR "; string searchID = "id= " + textbox_search.Text; string searchncc = "ncc_id= " + textbox_search.Text; string searchnv = "nhan_vien_id= " + textbox_search.Text; search = query + " where " + searchID + or + searchncc + or + searchnv; database.pushGridview(search, gridView); } if (comboBox_loc.Text == "Mã đơn hàng") { search = query + " WHERE id=" + textbox_search.Text; database.pushGridview(search, gridView); } if (comboBox_loc.Text == "Mã nhà cung cấp") { search = query + " WHERE ncc_id=" + textbox_search.Text; database.pushGridview(search, gridView); } if (comboBox_loc.Text == "Mã nhân viên") { search = query + " WHERE nhan_vien_id=" + textbox_search.Text; database.pushGridview(search, gridView); } if (comboBox_loc.Text == "Mã mặt hàng") { search = "SELECT distinct phieu_nhap.id,phieu_nhap.ncc_id,ngay_nhap,nhan_vien_id FROM phieu_nhap " + "inner join chi_tiet_phieu_nhap on phieu_nhap.id = phieu_nhap_id WHERE mat_hang_id =" + textbox_search.Text; database.pushGridview(search, gridView); } } else { if (comboBox_loc.Text == "" && funcShare.isDate(textbox_search.Text) == true) { string date = "ngay_nhap = '" + textbox_search.Text + "'"; search = query + " where " + date; database.pushGridview(search, gridView); } if (textbox_search.Text == "Tìm kiếm") { funcShare.loadGridView("phieu_nhap,nha_cung_cap,nhan_vien where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id" , "phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten", gridView); } if (comboBox_loc.Text == "Tên mặt hàng") { search = " SELECT distinct phieu_nhap.id,phieu_nhap.ncc_id,ngay_nhap,nhan_vien_id " + "FROM phieu_nhap,chi_tiet_phieu_nhap,mat_hang" + " where phieu_nhap.id = phieu_nhap_id and mat_hang_id = mat_hang.id " + "and mat_hang.ten LIKE N'%" + textbox_search.Text + "%';"; database.pushGridview(search, gridView); } if (comboBox_loc.Text == "Ngày nhập") { if (funcShare.isDate(textbox_search.Text) == true) { search = query + " WHERE ngay_nhap ='" + textbox_search.Text + "'"; database.pushGridview(search, gridView); } } } }