private string TaoCauTruyVan()
{
string strTruyVan = string.Empty;
strTruyVan += string.Format("NgayLap >= #{0}# and NgayLap <= #{1}#", TienIch.LayNgayThangQuocTe(dtpNgayDau.Value), TienIch.LayNgayThangQuocTe(dtpNgayCuoi.Value));
return(strTruyVan);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (dgvChiTietBH.Rows.Count == 0 || txtTenKH.Text == "")
{
FormMessage.Show("Vui lòng nhập đầy đủ thông tin!", "Nhắc nhở", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (bThemKH)
{
clsKhachHang_DTO khachHang = new clsKhachHang_DTO();
khachHang.TenKhachHang = txtTenKH.Text;
khachHang.SoDT = txtSoDT.Text;
khachHang.DiaChi = txtDiaChi.Text;
strMaKH = _KhachHangBUS.ThemKhachHang(khachHang);
}
clsBaoHanh_DTO baoHanh = new clsBaoHanh_DTO();
baoHanh.MaKhachHang = strMaKH;
baoHanh.MaNhanVien = Program.MA_NV;
baoHanh.NgayBaoHanh = TienIch.LayNgayThangHienTaiQuocTe();
string strMaBH = _BaoHanhBUS.ThemBaoHanh(baoHanh);
List <clsChiTietBaoHanh_DTO> dsChiTiet = new List <clsChiTietBaoHanh_DTO>();
foreach (DataGridViewRow dgvRow in dgvChiTietBH.Rows)
{
clsChiTietBaoHanh_DTO chiTiet = new clsChiTietBaoHanh_DTO();
chiTiet.MaBaoHanh = strMaBH;
chiTiet.MaSerial = _SerialBUS.LayMaSerial(dgvRow.Cells[1].Value.ToString());
chiTiet.NgayHenTra = TienIch.LayNgayThangQuocTe(Convert.ToDateTime(dgvRow.Cells[3].Value.ToString()));
int iTinhTrang = dgvRow.Cells[5].Value.ToString() == "Chưa trả hàng" ? 0 : dgvRow.Cells[5].Value.ToString() == "Đổi hàng" ? 2 : 3;
chiTiet.TinhTrang = Convert.ToInt16(dgvRow.Cells[5].Value);
chiTiet.MotaLoi = dgvRow.Cells[2].Value.ToString();
chiTiet.GhiChu = dgvRow.Cells[4].Value.ToString();
dsChiTiet.Add(chiTiet);
}
_ChiTietBaoHanhBUS.ThemChiTietBaoHanh(dsChiTiet, strMaBH);
FormMessage.Show("Lưu thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LamSach();
}
private string TaoCauTruyVan()
{
string strTruyVan = string.Empty;
if (chkNgayGui.Checked)
{
strTruyVan += string.Format("NgayBaoHanh >= #{0}# and NgayBaoHanh <= #{1}#", TienIch.LayNgayThangQuocTe(dtpNgayDau.Value), TienIch.LayNgayThangQuocTe(dtpNgayCuoi.Value));
}
if (chkLoai.Checked)
{
if (strTruyVan != "")
{
strTruyVan += " and ";
}
if (cboLoai.SelectedIndex == 0)
{
strTruyVan += "TRUE";
}
else if (cboLoai.SelectedIndex == 1)
{
strTruyVan += "TinhTrang=0";
}
else if (cboLoai.SelectedIndex == 2)
{
strTruyVan += "TinhTrang=2";
}
else if (cboLoai.SelectedIndex == 3)
{
strTruyVan += "TinhTrang=3";
}
}
if (chkMaNCC.Checked)
{
if (strTruyVan != "")
{
strTruyVan += " and ";
}
strTruyVan += string.Format("MaNhaCungCap='{0}'", txtMaNCC.Text);
}
return(strTruyVan);
}
private string TaoCauTruyVan()
{
string strTruyVan = string.Empty;
if (chkNgay.Checked)
{
strTruyVan += string.Format("NgayBaoHanh >= #{0}# and NgayBaoHanh <= #{1}#", TienIch.LayNgayThangQuocTe(dtpNgayDau.Value), TienIch.LayNgayThangQuocTe(dtpNgayCuoi.Value));
}
if (chkNV.Checked)
{
if (strTruyVan != "")
{
strTruyVan += " and ";
}
strTruyVan += string.Format("MaNhanVien = '{0}'", cboNV.SelectedValue);
}
if (chkMaKH.Checked)
{
if (strTruyVan != "")
{
strTruyVan += " and ";
}
strTruyVan += string.Format("MaKhachHang = '{0}'", txtMaKH.Text);
}
return(strTruyVan);
}