public void btnLuu_Click(object sender, EventArgs e)
{
KhoHangSua.TenKho = Convert.ToString(txtTenKhoHang.Text);
KhoHangSua.NVQuanLy = Convert.ToInt32(lkpNguoiQuanLy.EditValue);
KhoHangSua.NguoiLienHe = Convert.ToString(txtNguoiLienHe.Text);
KhoHangSua.DiaChi = Convert.ToString(txtDiaChi.Text);
KhoHangSua.DienThoai = Convert.ToString(txtDienThoai.Text);
KhoHangSua.Fax = Convert.ToString(txtFax.Text);
KhoHangSua.Email = Convert.ToString(txtEmail.Text);
KhoHangSua.DienGiai = Convert.ToString(txtDienGiai.Text);
if (chkConQuanLy.Checked == true)
{
KhoHangSua.ConQuanLy = true;
}
else
{
KhoHangSua.ConQuanLy = false;
}
int test = KhoHangBUS.SuaKhohang(KhoHangSua);
if (test == -1)
{
MessageBox.Show("Dữ liệu sửa không đúng");
}
else
{
Log_BUS.ThemNhatKy("Kho hàng", "Sửa thông tin kho hàng");
MessageBox.Show("Sửa thành công");
if (eventSuaXongChoEvent != null)
{
eventSuaXongChoEvent();
}
}
}
private void init()
{
grid_ds.Rows.Clear();
ArrayList ds1 = KhoHangBUS.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoThoiDiemThanhToan(GlobalVariables.maNhaHang);
ArrayList ds2 = KhoHangBUS.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoDinhMucNo(GlobalVariables.maNhaHang);
for (int i = 0; i < ds1.Count; i++)
{
NhaCungCapDTO dto1 = (NhaCungCapDTO)ds1[i];
grid_ds.Rows.Add();
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cMaNhaCungCap"].Value = dto1.MaNhaCungCap;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTenNhaCungCap"].Value = dto1;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDienThoai"].Value = dto1.DienThoai;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cSoTaiKhoan"].Value = dto1.SoTaiKhoan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTongNo"].Value = dto1.TongNo;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cThoiDiemThanhToan"].Value = dto1.ThoiDiemThanhToan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDinhMucNo"].Value = "Không có";
}
for (int i = 0; i < ds2.Count; i++)
{
NhaCungCapDTO dto2 = (NhaCungCapDTO)ds2[i];
grid_ds.Rows.Add();
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cMaNhaCungCap"].Value = dto2.MaNhaCungCap;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTenNhaCungCap"].Value = dto2;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDienThoai"].Value = dto2.DienThoai;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cSoTaiKhoan"].Value = dto2.SoTaiKhoan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTongNo"].Value = dto2.TongNo;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cThoiDiemThanhToan"].Value = dto2.ThoiDiemThanhToan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDinhMucNo"].Value = dto2.GiaTriDinhMucNo;
}
}
private void lkpKhoHang_TextChanged(object sender, EventArgs e)
{
// load lại các mặt hàng trong kho đó
int makho = int.Parse(lkpKhoHang.EditValue.ToString());
GridControl1.DataSource = KhoHangBUS.LayHangHoaTheoKho(makho);
}
public void LoadKhoHang()
{
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKHoHang();
cmBoxKhoHang.DataSource = CuaHangBUS.GetAllCuaHang();
cmBoxKhoHang.DisplayMember = "TenCuaHang";
cmBoxKhoHang.ValueMember = "MaCuaHang";
}
private void initGrid_ds()
{
ArrayList ds = new ArrayList();
ds = KhoHangBUS.layDanhSachNguyenLieuDangOKhoangMucToiThieu(GlobalVariables.maNhaHang);
KhoHang_NguyenLieuDTO dto;
if (ds.Count < grid_ds.RowCount)
{
for (int i = 0; i < (grid_ds.RowCount - ds.Count); i++)
{
grid_ds.Rows.RemoveAt(i);
}
}
for (int i = 0; i < grid_ds.RowCount; i++)
{
dto = (KhoHang_NguyenLieuDTO)ds[i];
showThongTinKhoHang_NguyenLieuDTOLenGrid(i, dto);
grid_ds.Rows[i].Cells["cLuongDat"].ReadOnly = false;
}
//grid_ds.Rows.Clear();
for (int i = grid_ds.RowCount; i < ds.Count; i++)
{
dto = (KhoHang_NguyenLieuDTO)ds[i];
grid_ds.Rows.Add();
showThongTinKhoHang_NguyenLieuDTOLenGrid(i, dto);
grid_ds.Rows[i].Cells["cLuongDat"].ReadOnly = false;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (comboBoxCHNhan.SelectedValue.ToString() == comboBoxCHPP.SelectedValue.ToString())
{
MessageBox.Show("Lỗi! Hai Cửa Hàng Trùng Nhau.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (numericUpDownThemBotSL.Value <= Convert.ToInt32(textBoxSLTonCHPP.Text) && numericUpDownThemBotSL.Value > 0)
{
string id1 = comboBoxCHNhan.SelectedValue.ToString();
string id2 = comboBoxCHPP.SelectedValue.ToString();
string id = textBoxMaKieu.Text;
KhoHangBUS.KiemTraKho_CuaHang_MaKieu(id, id1);
KhoHangBUS.KiemTraKho_CuaHang_MaKieu(id, id2);
int sl = Convert.ToInt32(numericUpDownThemBotSL.Value);
try{
ChiTietSPBUS.PhanChiSP(id, id1, id2, sl);
MessageBox.Show("Thành Công! Sản Phẩm Đã Được Phân Phối.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(id);
}
catch
{
MessageBox.Show("Lỗi! Không Thể Thực Hiện Thao Tác.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Lỗi! Số Lượng Phân Phối Không Phù Hợp.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public frmThemHangHoa()
{
InitializeComponent();
txtMaHang.Text = HangHoaBUS.LayMaHH();
txtMaVach.Text = HangHoaBUS.LayMaHH();
gridlookupPhanLoaiHangHoa.Properties.DataSource = PhanLoaiHangHoaBUS.DanhSach();
gridlookupPhanLoaiHangHoa.Properties.DisplayMember = "TenPhanLoai";
gridlookupPhanLoaiHangHoa.Properties.ValueMember = "MaPhanLoai";
gridlookupKho.Properties.DataSource = KhoHangBUS.DanhSach();
gridlookupKho.Properties.DisplayMember = "Ten";
gridlookupKho.Properties.ValueMember = "MaKho";
gridlookupLoaiHangHoa.Properties.DataSource = NhomHangBUS.DanhSach();
gridlookupLoaiHangHoa.Properties.DisplayMember = "Ten";
gridlookupLoaiHangHoa.Properties.ValueMember = "MaNHH";
gridlookupNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
gridlookupNCC.Properties.DisplayMember = "TenNCC";
gridlookupNCC.Properties.ValueMember = "MaNCC";
gridlookupDonVi.Properties.DataSource = DonViBUS.DanhSach();
gridlookupDonVi.Properties.DisplayMember = "Ten";
gridlookupDonVi.Properties.ValueMember = "MaDV";
}
private void LoadKhoMacDinh()
{
lkpKhoMacDinh.Properties.DataSource = KhoHangBUS.LayToanBoKhoHang();
lkpKhoMacDinh.Properties.DisplayMember = "TenKho";
lkpKhoMacDinh.Properties.ValueMember = "MaKho";
if (!ReferenceEquals(((List <KhoHangDTO>)lkpKhoMacDinh.Properties.DataSource)[0], null))
{
lkpKhoMacDinh.EditValue = ((List <KhoHangDTO>)lkpKhoMacDinh.Properties.DataSource)[0].MaKho;
}
}
public frmMuaHang()
{
InitializeComponent();
repositoryItemGridLookUpEdit8.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit8.NullText = "";
repositoryItemGridLookUpEdit8.DisplayMember = "MaHang";
repositoryItemGridLookUpEdit8.ValueMember = "MaHang";
repositoryItemGridLookUpEdit9.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit9.NullText = "";
repositoryItemGridLookUpEdit9.DisplayMember = "TenHang";
repositoryItemGridLookUpEdit9.ValueMember = "MaHang";
repositoryItemGridLookUpEdit10.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit10.NullText = "";
repositoryItemGridLookUpEdit10.DisplayMember = "TenDonVi";
repositoryItemGridLookUpEdit10.ValueMember = "MaDonVi";
gridControl2.DataSource = PhieuTempBUS.DanhSach();
txtNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
txtNCC.Properties.DisplayMember = "TenNCC";
txtNCC.Properties.ValueMember = txtMaNCC.Properties.ValueMember;
txtNCC.Properties.EditValueChanged += Properties_EditValueChanged;
txtNCC.Properties.NullText = "";
txtMaNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
txtMaNCC.Properties.DisplayMember = "MaNCC";
txtMaNCC.Properties.ValueMember = "MaNCC";
txtMaNCC.Properties.EditValueChanged += Properties_EditValueChanged1;
txtMaNCC.Properties.NullText = "";
txtPhieu.Text = PhieuNhapHangBUS.LayMaPhieu();
txtNhanVien.Properties.DataSource = NhanVienBUS.DanhSach();
txtNhanVien.Properties.DisplayMember = "Ten";
txtNhanVien.Properties.ValueMember = "MaNV";
txtDieuKhoanTT.Properties.DataSource = DieuKhoanThanhToanBUS.DanhSach();
txtDieuKhoanTT.Properties.DisplayMember = "TenDKTT";
txtDieuKhoanTT.Properties.ValueMember = "MaDKTT";
txtHinhThucTT.Properties.DataSource = HinhThucThanhToanBUS.DanhSach();
txtHinhThucTT.Properties.DisplayMember = "TenHTTT";
txtHinhThucTT.Properties.ValueMember = "MaHTTT";
txtKho.Properties.DataSource = KhoHangBUS.DanhSach();
txtKho.Properties.DisplayMember = "Ten";
txtKho.Properties.ValueMember = "MaKho";
}
private void lamTuoiDanhSachTraCuuNguyenLieu()
{
for (int i = 0; i < grid_ds.RowCount; i++)
{
KhoHang_NguyenLieuDTO dto = new KhoHang_NguyenLieuDTO();
//dto.NguyenLieu.MaNguyenLieu = ((KhoHang_NguyenLieuDTO)grid_ds.Rows[i].Cells["cTenNguyenLieu"].Value).NguyenLieu.MaNguyenLieu;
dto.NguyenLieu.MaNguyenLieu = Convert.ToInt32(grid_ds.Rows[i].Cells["cMaNguyenLieu"].Value.ToString());
dto = KhoHangBUS.layChiTietKhoHang_NguyenLieu(GlobalVariables.maNhaHang, dto.NguyenLieu);
if (dto != null)
{
//gan lai gia tri moi(neu co thay doi) len dong hien tai
showThongTinKhoHang_NguyenLieuDTOLenGrid(i, dto);
}
}
}
private void timKiemNguyenLieuGanDung(NguyenLieuDTO nl)
{
ArrayList ds = new ArrayList();
ds = KhoHangBUS.layDSKhoHang_NguyenLieu(GlobalVariables.maNhaHang, nl);
//MessageBox.Show(ds.Count.ToString());
for (int i = 0; i < ds.Count; i++)
{
KhoHang_NguyenLieuDTO dto = (KhoHang_NguyenLieuDTO)ds[i];
if (!ingrid_dsOrNot(dto))
{
grid_ds.Rows.Add();
showThongTinKhoHang_NguyenLieuDTOLenGrid(grid_ds.RowCount - 1, dto);
}
}
}
private void btnLuuFullHDNhap_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có đồng ý Lưu hóa đơn này không?\n Khi lưu bạn sẽ không thể thay đổi hóa đơn!", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
ChiTietHoaDonNhapHangBUS.LuuHoaDonNhap(txtBoxMaHDNH.Text);
MessageBox.Show("Lưu Thành Công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
KhoHangBUS.ThemSL_SP_Kho_ByCuaHangBy_MaKieu(txtBoxMaHDNH.Text, comboBoxNoiNhapHang.SelectedValue.ToString());
Luu = true;
this.Close();
}
catch
{
MessageBox.Show("Không Thể Thực Hiện Thao Tác", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int[] l = GridView1.GetSelectedRows();
var index = l[0];
switch (MessageBox.Show("Bạn có chắc chắn muốn xóa kho này không?", "Hỏi Thoát", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
KhoHangDTO khXoa = default(KhoHangDTO);
khXoa = ((List <KhoHangDTO>)gcKhoHang.DataSource)[index];
Log_BUS.ThemNhatKy("Kho hàng", "Xóa kho hàng");
KhoHangBUS.XoaKhoHang(khXoa);
LoadGridKhoHang();
break;
case DialogResult.No:
return;
}
}
private void comboBoxMaKieu_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
textBoxSLTonKieu.Text = "";
pictureBox.BackgroundImage = null;
khoHangBindingSource.DataSource = null;
textBoxMaKieu.Text = "";
string id = comboBoxMaKieu.SelectedValue.ToString();
CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
textBoxMaKieu.Text = CtSp.MaKieu;
textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString();
try
{
pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh);
}
catch { pictureBox.BackgroundImage = null; }
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu);
}
catch { }
}
private void showDanhSachNguyenLieuTheoMonAn(MonAnDTO monAn)
{
ArrayList dsNguyenLieuTheoMon = new ArrayList();
dsNguyenLieuTheoMon = MonAnBUS.layDanhSachNguyenLieuTheoMonAn(monAn);
for (int i = 0; i < dsNguyenLieuTheoMon.Count; i++)
{
ArrayList dsKQ = new ArrayList();
dsKQ = KhoHangBUS.layDSKhoHang_NguyenLieu(GlobalVariables.maNhaHang, ((MonAn_NguyenLieuDTO)dsNguyenLieuTheoMon[i]).NguyenLieu);
for (int j = 0; j < dsKQ.Count; j++)
{
KhoHang_NguyenLieuDTO dto = (KhoHang_NguyenLieuDTO)dsKQ[j];
if (!ingrid_dsOrNot(dto))
{
grid_ds.Rows.Add();
showThongTinKhoHang_NguyenLieuDTOLenGrid(grid_ds.RowCount - 1, dto);
}
}
}
}
public void btnLuu_Click(object sender, EventArgs e)
{
KhoHangDTO kh = new KhoHangDTO();
kh.TenKho = System.Convert.ToString(txtTenKhoHang.Text);
kh.NVQuanLy = System.Convert.ToInt32(lkpNguoiQuanLy.EditValue);
kh.NguoiLienHe = System.Convert.ToString(txtNguoiLienHe.Text);
kh.DiaChi = System.Convert.ToString(txtDiaChi.Text);
kh.DienThoai = System.Convert.ToString(txtDienThoai.Text);
kh.Fax = System.Convert.ToString(txtFax.Text);
kh.Email = System.Convert.ToString(txtEmail.Text);
kh.DienGiai = System.Convert.ToString(txtDienGiai.Text);
if (chkConQuanLy.Checked == true)
{
kh.ConQuanLy = true;
}
else
{
kh.ConQuanLy = false;
}
bool test = KhoHangBUS.ThemKhoHang(kh);
if (test == false)
{
MessageBox.Show("Dữ liệu thêm sai");
}
else
{
Log_BUS.ThemNhatKy("Kho hàng", "Thêm kho hàng");
MessageBox.Show("Thêm thành công");
if (eventThemXongKhoEvent != null)
{
eventThemXongKhoEvent();
}
}
}
public void LoadChiTietSP()
{
//try
//{
LoadSP();
//}
//catch
//{
//}
comboBoxCHNhan.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxCHNhan.DisplayMember = "TenCuaHang";
comboBoxCHNhan.ValueMember = "MaCuaHang";
comboBoxCHPP.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxCHPP.DisplayMember = "TenCuaHang";
comboBoxCHPP.ValueMember = "MaCuaHang";
comboBoxNXS.DataSource = HSXBUS.GetAllHSX();
comboBoxNXS.DisplayMember = "TenHSX";
comboBoxNXS.ValueMember = "MaHSX";
comboBoxNXS.SelectedValue = DSp.MaHSX;
comboBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSPByMaHSX(DSp.MaHSX);
comboBoxDSP.DisplayMember = "TenDong";
comboBoxDSP.ValueMember = "MaDSP";
comboBoxDSP.SelectedValue = DSp.MaDSP;
comboBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(DSp.MaDSP);
comboBoxSP.DisplayMember = "TenSP";
comboBoxSP.ValueMember = "MaSP";
comboBoxSP.SelectedValue = Sp.MaSP;
comboBoxMaKieu.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(Sp.MaSP);
comboBoxMaKieu.DisplayMember = "MaKieu";
comboBoxMaKieu.ValueMember = "MaKieu";
CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu);
comboBoxMaKieu.SelectedValue = CtSp.MaKieu;
textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString();
pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh);
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu);
}
private void bt_timNCCPhuHop_Click(object sender, EventArgs e)
{
string sqlFROM = "";
for (int i = 0; i < grid_nguyenLieuCanDatHang.RowCount; i++)
{
if (Convert.ToBoolean(grid_nguyenLieuCanDatHang.Rows[i].Cells[0].Value) == true)
{
MonAn_NguyenLieuDTO dto = (MonAn_NguyenLieuDTO)grid_nguyenLieuCanDatHang.Rows[i].Cells["grid_nguyenLieuCanDatHang_cNguyenLieu"].Value;
sqlFROM += "(SELECT NHNCC.MaNhaCungCap, NCCNL.DonGia "
+ " FROM NHAHANG_NHACUNGCAP NHNCC JOIN NHACUNGCAP_NGUYENLIEU NCCNL ON NHNCC.MaNhaCungCap=NCCNL.MaNhaCungCap"
+ " WHERE NHNCC.TinhTrang=1 AND NCCNL.MaNguyenLieu=" + dto.NguyenLieu.MaNguyenLieu.ToString() + " AND NHNCC.MaNhaHang=" + GlobalVariables.maNhaHang.ToString() + ")";
int j = i + 1;
sqlFROM += " UNION ALL ";
}
}
sqlFROM = sqlFROM.Substring(0, sqlFROM.Length - 10);
ArrayList dsNCC = KhoHangBUS.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(sqlFROM);
if (dsNCC.Count == 0)
{
return;
}
grid_tabPage_NCC_nhaCungCapPhuHop.Rows.Clear();
for (int i = 0; i < dsNCC.Count; i++)
{
NhaCungCapDTO dto = (NhaCungCapDTO)dsNCC[i];
grid_tabPage_NCC_nhaCungCapPhuHop.Rows.Add();
grid_tabPage_NCC_nhaCungCapPhuHop.Rows[i].Cells["grid_NCCPhuHop_cMaNhaCungCap"].Value = dto.MaNhaCungCap;
grid_tabPage_NCC_nhaCungCapPhuHop.Rows[i].Cells["grid_NCCPhuHop_cTenNhaCungCap"].Value = dto;
grid_tabPage_NCC_nhaCungCapPhuHop.Rows[i].Cells["grid_NCCPhuHop_cSoLuongNguyenLieuThoaYeuCau"].Value = dto.SoLuongNguyenLieuToiDaPhuHopYeuCauDatHang;
}
grid_tabPage_NCC_nhaCungCapPhuHop.Sort(grid_tabPage_NCC_nhaCungCapPhuHop.Columns["grid_NCCPhuHop_cSoLuongNguyenLieuThoaYeuCau"], ListSortDirection.Descending);
grid_tabPage_NCC_nhaCungCapPhuHop.Columns["grid_NCCPhuHop_cSoLuongNguyenLieuThoaYeuCau"].ReadOnly = false;
}
private void cb_tinTrangGiaoDich_SelectedIndexChanged()
{
grid_ds.Rows.Clear();
int curIndex = cb_tinTrangGiaoDich.SelectedIndex;
ArrayList dsNCC = new ArrayList();
if (curIndex == 0)
{
dsNCC = KhoHangBUS.layDanhSachNhaCungCap(GlobalVariables.maNhaHang, txt_ten.Text);
}
else
{
if (curIndex == 1 || curIndex == 2)
{
//dsNCC = KhoHangBUS.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
if (cb_demoXungDot.SelectedIndex == 0)//unrepeat
{
dsNCC = KhoHangBUS.unrepeatableTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
}
else if (cb_demoXungDot.SelectedIndex == 1)//unrepeat solved
{
dsNCC = KhoHangBUS.unrepeatableSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
}
else if (cb_demoXungDot.SelectedIndex == 2)//dirty read
{
dsNCC = KhoHangBUS.dirtyReadTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
}
else if (cb_demoXungDot.SelectedIndex == 3)//dirty read solved
{
dsNCC = KhoHangBUS.dirtyReadSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
}
else
{
dsNCC = KhoHangBUS.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(txt_ten.Text, curIndex, GlobalVariables.maNhaHang);
}
}
if (curIndex == 3)
{
if (cb_demoXungDot.SelectedIndex == 4)//phantom
{
dsNCC = KhoHangBUS.phantomTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichChuaTungGiaoDich(txt_ten.Text, GlobalVariables.maNhaHang);
}
else if (cb_demoXungDot.SelectedIndex == 5)//phantom solved
{
dsNCC = KhoHangBUS.phantomSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichChuaTungGiaoDich(txt_ten.Text, GlobalVariables.maNhaHang);
}
else
{
dsNCC = KhoHangBUS.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichChuaTungGiaoDich(txt_ten.Text, GlobalVariables.maNhaHang);
}
}
}
if (cb_tinTrangGiaoDich.SelectedIndex == 0)
{
for (int i = 0; i < dsNCC.Count; i++)
{
NhaCungCapDTO dto = (NhaCungCapDTO)dsNCC[i];
grid_ds.Rows.Add();
grid_ds.Rows[i].Cells["cMaNhaCungCap"].Value = dto.MaNhaCungCap;
grid_ds.Rows[i].Cells["cTenNhaCungCap"].Value = dto;
grid_ds.Rows[i].Cells["cDienThoai"].Value = dto.DienThoai;
grid_ds.Rows[i].Cells["cSoTaiKhoan"].Value = dto.SoTaiKhoan;
grid_ds.Rows[i].Cells["cTongNo"].Value = dto.TongNo;
if (dto.TinhTrangGiaoDich == 1)
{
grid_ds.Rows[i].Cells["cGiaoDich"].Value = "Có";
}
else if (dto.TinhTrangGiaoDich == 0)
{
grid_ds.Rows[i].Cells["cGiaoDich"].Value = "Ngừng";
}
else
{
grid_ds.Rows[i].Cells["cGiaoDich"].Value = "Chưa từng";
}
}
}
else
{
for (int i = 0; i < dsNCC.Count; i++)
{
NhaCungCapDTO dto = (NhaCungCapDTO)dsNCC[i];
grid_ds.Rows.Add();
grid_ds.Rows[i].Cells["cMaNhaCungCap"].Value = dto.MaNhaCungCap;
grid_ds.Rows[i].Cells["cTenNhaCungCap"].Value = dto;
grid_ds.Rows[i].Cells["cDienThoai"].Value = dto.DienThoai;
grid_ds.Rows[i].Cells["cSoTaiKhoan"].Value = dto.SoTaiKhoan;
grid_ds.Rows[i].Cells["cTongNo"].Value = dto.TongNo;
grid_ds.Rows[i].Cells["cGiaoDich"].Value = cb_tinTrangGiaoDich.Text;
}
}
}
private void dongGoiThongTinThongTinHangNhapDTO(ThongTinHangNhapDTO dto)
{
dto.KhoHang = KhoHangBUS.layThongTinKhoHangTheoNhaHang(GlobalVariables.maNhaHang);
dto.NgayNhap = DateTime.Now;
dongGoiChiTietHangNhapDTO(dto);
}
private void LoadGridKhoHang()
{
gcKhoHang.DataSource = KhoHangBUS.LayToanBoKhoHang();
}
