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);
}
}
}
}
