private void BtnXoa_ItemClick(object sender, ItemClickEventArgs e)
{
if (XtraMessageBox.Show("Bạn có chắc chắn muốn xóa ?", "CẢNH BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
== DialogResult.No)
{
return;
}
int rowIndex = gvMain.FocusedRowHandle;
string colID = "Stock_ID";
string value = gvMain.GetRowCellValue(rowIndex, colID).ToString();
if (BUS_KhoXuat.KiemTraKho(value) == true)
{
BUS_KhoXuat.XoaKho(value);
Action.Module = "Kho Hàng";
Action.ActionName = "Xóa";
Action.Reference = value;
Action.LuuThongTin();
LoadData();
}
else
{
return;
}
}
private void xlThem()
{
CKho kho = new CKho
(txtMa.Text,
txtTen.Text,
txtLienHe.Text,
txtDiaChi.Text,
txtEmail.Text,
txtDienThoai.Text,
txtFax.Text,
"",
leNguoiQL.EditValue.ToString(),
txtDienGiai.Text,
checkConQL.Checked);
BUS_KhoXuat.ThemKho(kho);
sendKho?.Invoke();
Action.Module = "Kho Hàng";
Action.ActionName = "Thêm";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
this.Close();
}
private void BtnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (XtraMessageBox.Show("Bạn có chắc muốn xóa không ?", "CẢNH BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
== DialogResult.Yes)
{
if (sale == true)
{
string ma = gvMain.GetFocusedRowCellValue("Outward_ID").ToString();
BUS_KhoXuat.XoaBH(ma);
Action.Module = "Bán Hàng";
Action.ActionName = "Xóa";
Action.Reference = ma;
Action.LuuThongTin();
}
else
{
string ma = gvMain.GetFocusedRowCellValue("Inward_ID").ToString();
BUS_KhoXuat.XoaMH(ma);
Action.Module = "Mua Hàng";
Action.ActionName = "Xóa";
Action.Reference = ma;
Action.LuuThongTin();
}
Refresh();
}
}
private void Refresh()
{
if (sale == true)
{
gvcMain.DataSource = BUS_KhoXuat.LayChungTuBH();
}
else
{
gvcMain.DataSource = BUS_KhoXuat.LayChungTuMH();
}
}
private void KhoiTaoChungTuBH()
{
gvcMain.DataSource = BUS_KhoXuat.LayChungTuBH();
gvMain.Columns[0].FieldName = "Outward_ID";
gvMain.Columns[1].FieldName = "RefDate";
gvMain.Columns[2].FieldName = "Description";
gvMain.Columns[3].FieldName = "Product_ID";
gvMain.Columns[4].FieldName = "ProductName";
gvMain.Columns[5].FieldName = "Stock_ID";
gvMain.Columns[6].FieldName = "Unit";
gvMain.Columns[7].FieldName = "Quantity";
gvMain.Columns[8].FieldName = "UnitPrice";
gvMain.Columns[9].FieldName = "Charge";
gvMain.Columns[10].FieldName = "DiscountRate";
gvMain.Columns[11].FieldName = "Discount";
gvMain.Columns[12].FieldName = "Amount";
}
private void KhoiTaoChungTuMH()
{
gvcMain.DataSource = BUS_KhoXuat.LayChungTuMH();
gvMain.Columns[0].FieldName = "Inward_ID";
gvMain.Columns[1].FieldName = "RefDate";
gvMain.Columns[2].FieldName = "CustomerName";
gvMain.Columns[3].FieldName = "Product_ID";
gvMain.Columns[4].FieldName = "ProductName";
gvMain.Columns[5].FieldName = "Stock_ID";
gvMain.Columns[6].FieldName = "Unit";
gvMain.Columns[7].FieldName = "Quantity";
gvMain.Columns[8].FieldName = "UnitPrice";
gvMain.Columns[9].FieldName = "Amount";
gvMain.Columns[2].Caption = "Nhà Cung Cấp";
gvMain.Columns[10].Visible = false;
gvMain.Columns[11].Visible = false;
gvMain.Columns[12].Visible = false;
}
private void xlSua()
{
editKho.MaKho = txtMa.Text;
editKho.TenKho = txtTen.Text;
editKho.LienHe = txtLienHe.Text;
editKho.DiaChi = txtDiaChi.Text;
editKho.Email = txtEmail.Text;
editKho.DienThoai = txtDienThoai.Text;
editKho.Fax = txtFax.Text;
editKho.NguoiQuanLy = leNguoiQL.EditValue.ToString();
editKho.DienGiai = txtDienGiai.Text;
editKho.ConQL = checkConQL.Checked;
BUS_KhoXuat.SuaKho(editKho);
sendKho();
Action.Module = "Kho Hàng";
Action.ActionName = "Sửa";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
this.Close();
}
public fThemKho(bool isAdd = true, CKho kho = null, fKhoHang.sendMessage send = null)
{
InitializeComponent();
if (isAdd == false && kho == null)
{
XtraMessageBox.Show("ERROR : Dữ liệu không được cung cấp để thực hiện hành động !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
Close();
}
if (isAdd == true)
{
table = BUS_KhoXuat.LayKho();
Text = "Thêm nhà cung cấp";
}
else
{
editKho = kho;
Text = "Sửa thông tin nhà cung cấp";
}
add = isAdd;
sendKho = send;
Init();
}
private void Init()
{
gcMain.DataSource = BUS_KhoXuat.GetTonKhoLookup();
gvMain.BestFitColumns();
gvMain.Columns[0].FieldName = "RefDate";
gvMain.Columns[1].FieldName = "RefNo";
gvMain.Columns[2].FieldName = "RefType";
gvMain.Columns[3].FieldName = "Stock_ID";
gvMain.Columns[4].FieldName = "Product_ID";
gvMain.Columns[5].FieldName = "Product_Name";
gvMain.Columns[6].FieldName = "Unit";
gvMain.Columns[7].FieldName = "Quantity";
gvMain.Columns[8].FieldName = "Price";
gvMain.Columns[9].FieldName = "Price";
gvMain.Columns[10].FieldName = "UnitPrice";
gvMain.Columns[11].FieldName = "Amount";
gvMain.Columns[12].FieldName = "E_Qty";
gvMain.Columns[13].FieldName = "E_Amt";
gvMain.Columns[14].FieldName = "Description";
gvMain.IndicatorWidth = 45;
gvMain.CustomDrawRowIndicator += GvMain_CustomDrawRowIndicator;
}
private void LoadData()
{
gcMain.DataSource = BUS_KhoXuat.LayKho();
}
private void Init()
{
List <object> list = new List <object>
{
new { ID = 0, Name = "Hàng hóa" },
new { ID = 1, Name = "Dịch vụ" }
};
cbLoaiHH.Properties.DataSource = list;
cbLoaiHH.Properties.DisplayMember = "Name";
cbLoaiHH.Properties.ValueMember = "ID";
LookUpColumnInfo col_t = new LookUpColumnInfo("Name", "");
cbLoaiHH.Properties.Columns.Add(col_t);
cbLoaiHH.EditValue = 0;
leKhoMacDinh.Properties.DataSource = BUS_KhoXuat.LayKhoDonGian();
leKhoMacDinh.Properties.DisplayMember = "STOCK_Name";
leKhoMacDinh.Properties.ValueMember = "STOCK_ID";
LookUpColumnInfo col = new LookUpColumnInfo("STOCK_ID", "Mã");
LookUpColumnInfo col1 = new LookUpColumnInfo("STOCK_Name", "Tên");
leKhoMacDinh.Properties.Columns.Add(col1);
leKhoMacDinh.Properties.Columns.Add(col);
leKhoMacDinh.EditValue = ((DataTable)leKhoMacDinh.Properties.DataSource).Rows[0]["STOCK_ID"];
leKhoMacDinh.Properties.Buttons[1].Click += btnThemKho_ThemHangHoa_Click;
lePhanLoai.Properties.TextEditStyle = TextEditStyles.Standard;
lePhanLoai.Properties.DataSource = BUS_HangHoa.LayNhomHang();
lePhanLoai.Properties.DisplayMember = "ProductGroup_Name";
lePhanLoai.Properties.ValueMember = "ProductGroup_ID";
col = new LookUpColumnInfo("ProductGroup_ID", "Mã");
col1 = new LookUpColumnInfo("ProductGroup_Name", "Tên");
lePhanLoai.Properties.Columns.Add(col1);
lePhanLoai.Properties.Columns.Add(col);
lePhanLoai.EditValue = ((DataTable)lePhanLoai.Properties.DataSource).Rows[0]["ProductGroup_ID"];
lePhanLoai.Properties.Buttons[1].Click += btnThemNhomhang_ThemHangHoa_Click;
leDonVi.Properties.TextEditStyle = TextEditStyles.Standard;
leDonVi.Properties.DataSource = BUS_DonViTinh.GetDVTDonGian();
leDonVi.Properties.DisplayMember = "UNIT_Name";
leDonVi.Properties.ValueMember = "UNIT_ID";
col = new LookUpColumnInfo("UNIT_ID", "Mã");
col1 = new LookUpColumnInfo("UNIT_Name", "Tên");
leDonVi.Properties.Columns.Add(col1);
leDonVi.Properties.Columns.Add(col);
leDonVi.EditValue = ((DataTable)leDonVi.Properties.DataSource).Rows[0]["UNIT_ID"];
leDonVi.Properties.Buttons[1].Click += btnThemDV_ThemHangHoa_Click;
leNCC.Properties.TextEditStyle = TextEditStyles.Standard;
leNCC.Properties.DataSource = BUS_NhaCungCap.LayNhaCC();
leNCC.Properties.DisplayMember = "CustomerName";
leNCC.Properties.ValueMember = "Customer_ID";
col = new LookUpColumnInfo("Customer_ID", "Mã");
col1 = new LookUpColumnInfo("CustomerName", "Tên");
leNCC.Properties.Columns.Add(col1);
leNCC.Properties.Columns.Add(col);
leNCC.EditValue = ((DataTable)leNCC.Properties.DataSource).Rows[0]["Customer_ID"];
leNCC.Properties.Buttons[1].Click += btnThemNCC_ThemHangHoa_Click;
peHinhAnh.Properties.NullText = "Ảnh";
peHinhAnh.Click += PeHinhAnh_Click;
txtMa.TextChanged += TxtMa_TextChanged;
txtMaVachNSX.TextChanged += TxtMaVachNSX_TextChanged;
if (add == true)
{
phatSinhMa();
}
else
{
LoadDuLieuHH();
}
}
void xl(
DateTime _NgayLap,
string _KhoXuat,
string _MaKH,
string _TenKH,
string _NhanVienBH,
string _DiaChi,
string _GhiChu,
string _DienThoai,
string _SoHoaDonVat,
string _SoPhieuNhapTay,
string _DieuKhoanThanhToan,
string _HinhThucTT,
DateTime _HanTT,
DateTime _NgayGiao
)
{
List <CBanHang> listBH = new List <CBanHang>();
string _DonVi;
float _DonGia;
float _SoLuong;
float _ThanhTien;
float _ChietKhauTiLe;
float _ChietKhau;
float _ThanhToan;
string _MaHH;
string _TenHH;
for (int i = 0; i < dsGcMain.Tables[0].Rows.Count; i++)
{
DataRow dr = dsGcMain.Tables[0].Rows[i];
_DonVi = dr["colDonVi"].ToString();
_DonGia = dr["colDonGia"].ToString() == "" ? 0 : float.Parse(dr["colDonGia"].ToString());
_SoLuong = dr["colSoLuong"].ToString() == "" ? 0 : float.Parse(dr["colSoLuong"].ToString());
_ThanhTien = dr["colThanhTien"].ToString() == "" ? 0 : float.Parse(dr["colThanhTien"].ToString());
_ChietKhauTiLe = dr["colChietKhauTiLe"].ToString() == "" ? 0 : float.Parse(dr["colChietKhauTiLe"].ToString());
_ChietKhau = dr["colChietKhau"].ToString() == "" ? 0 : float.Parse(dr["colChietKhau"].ToString());
_ThanhToan = dr["colThanhToan"].ToString() == "" ? 0 : float.Parse(dr["colThanhToan"].ToString());
_MaHH = dr["colMa"].ToString();
_TenHH = gvMain.GetRowCellDisplayText(i, "colTen").ToString();
CBanHang bh = new CBanHang
(
txtMa.Text,
_NgayLap,
_MaKH,
_TenKH,
_NhanVienBH,
_KhoXuat,
_DiaChi,
_GhiChu,
_DienThoai,
_SoHoaDonVat,
_SoPhieuNhapTay,
_DieuKhoanThanhToan,
_HinhThucTT,
_HanTT,
_NgayGiao,
_MaHH,
_TenHH,
_DonVi,
_SoLuong,
_DonGia,
_ThanhTien,
_ChietKhauTiLe,
_ChietKhau,
_ThanhToan
);
listBH.Add(bh);
}
if (isSale == true)
{
if (add == true)
{
BUS_KhoXuat.ThemBH(listBH);
Action.Module = "Bán Hàng";
Action.ActionName = "Thêm";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
}
else
{
BUS_KhoXuat.SuaBH(listBH);
Action.Module = "Bán Hàng";
Action.ActionName = "Sửa";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
}
}
else
{
if (add == true)
{
BUS_KhoXuat.ThemMH(listBH);
Action.Module = "Mua Hàng";
Action.ActionName = "Thêm";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
}
else
{
BUS_KhoXuat.SuaMH(listBH);
Action.Module = "Mua Hàng";
Action.ActionName = "Sửa";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
}
}
}
private void Init()
{
//Khởi tạo nhân viên bán hàng
leNhanVienBH.Properties.TextEditStyle = TextEditStyles.Standard;
leNhanVienBH.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leNhanVienBH, BUS_NhanVien.LayNhanVienDonGian(), "EMPLOYEE_Name", "EMPLOYEE_ID");
leNhanVienBH.Properties.Columns[0].FieldName = "EMPLOYEE_Name";
leNhanVienBH.Properties.Columns[1].FieldName = "EMPLOYEE_ID";
//leNhanVienBH.EditValue = ((DataTable)leNhanVienBH.Properties.DataSource).Rows[0]["EMPLOYEE_ID"];
//Khởi tạo kho xuất
leKhoXuat.Properties.TextEditStyle = TextEditStyles.Standard;
leKhoXuat.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leKhoXuat, BUS_KhoXuat.LayKhoDonGian(), "STOCK_Name", "STOCK_ID");
leKhoXuat.Properties.Columns[0].FieldName = "STOCK_Name";
leKhoXuat.Properties.Columns[1].FieldName = "STOCK_ID";
//leKhoXuat.EditValue = ((DataTable)leKhoXuat.Properties.DataSource).Rows[0]["STOCK_ID"];
//Khởi tạo các DateEdit
deHanTT.EditValue = DateTime.Today.ToShortDateString();
deNgayGiao.EditValue = DateTime.Today.ToShortDateString();
deNgay.EditValue = DateTime.Today.ToShortDateString();
//Khởi tạo GridviewControl
gvMain.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;
CreateDataSource();
gvcMain.DataSource = dsGcMain.Tables[0];
gvMain.CellValueChanged += GvMain_CellValueChanged;
//gvMain.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
//Khởi tạo đơn vị tính
leDonVi.NullText = "(Chọn)";
leDonVi.TextEditStyle = TextEditStyles.Standard;
leMaHang.TextEditStyle = TextEditStyles.Standard;
leMaHang.BestFitMode = BestFitMode.BestFit;
SetDataSource(leDonVi, BUS_DonViTinh.GetDVTDonGian(), "UNIT_Name", "UNIT_ID");
leDonVi.Columns.Add(new LookUpColumnInfo("UNIT_Name", "ĐVT"));
//Khởi tạo Mã hàng
leMaHang.NullText = "(Chọn)";
SetDataSource(leMaHang, BUS_HangHoa.LayHangHoaLookupEdit(), "Product_ID", "Product_ID");
leMaHang.Columns.Add(new LookUpColumnInfo("Product_ID", "Mã hàng"));
leMaHang.Columns.Add(new LookUpColumnInfo("Product_Name", "Tên hàng"));
leMaHang.Columns.Add(new LookUpColumnInfo("Quantity", "Tồn kho"));
leMaHang.Columns.Add(new LookUpColumnInfo("Stock_Name", "Kho hàng"));
leMaHang.Columns.Add(new LookUpColumnInfo("Unit", "Đơn vị tính"));
leMaHang.PopupFormMinSize = new System.Drawing.Size(600, 350);
//Khởi tạo Tên hàng
leTenHang.NullText = "(Chọn)";
SetDataSource(leTenHang, BUS_HangHoa.LayHangHoaLookupEdit(), "Product_Name", "Product_ID");
leTenHang.Columns.Add(new LookUpColumnInfo("Product_ID", "Mã hàng"));
leTenHang.Columns.Add(new LookUpColumnInfo("Product_Name", "Tên hàng"));
leTenHang.Columns.Add(new LookUpColumnInfo("Quantity", "Tồn kho"));
leTenHang.Columns.Add(new LookUpColumnInfo("Stock_Name", "Kho hàng"));
leTenHang.Columns.Add(new LookUpColumnInfo("Unit", "Đơn vị tính"));
leTenHang.PopupFormMinSize = new System.Drawing.Size(600, 350);
calceSoLuong.NullText = "0";
calceSoLuong.MaxLength = 10;
calceDonGia.NullText = "0";
calceDonGia.MaxLength = 10;
calceChietKhauTiLe.NullText = "0";
calceChietKhauTiLe.MaxLength = 10;
calceChietKhau.NullText = "0";
calceChietKhau.MaxLength = 10;
calceThanhToan.NullText = "0";
calceThanhToan.MaxLength = 10;
List <object> listDKTT = new List <object>
{
new { name = "Công nợ" },
new { name = "Thanh toán ngay" }
};
gleDKTT.Properties.DataSource = listDKTT;
gleDKTT.Properties.ValueMember = "name";
gleDKTT.Properties.DisplayMember = "name";
LookUpColumnInfo col_t = new LookUpColumnInfo("name", "");
gleDKTT.Properties.Columns.Add(col_t);
gleDKTT.EditValue = "Công nợ";
List <object> listHTTT = new List <object>
{
new { ID = 0, name = "Tiền mặt" },
new { ID = 1, name = "Chuyển khoản" }
};
gleHTTT.Properties.DataSource = listHTTT;
gleHTTT.Properties.ValueMember = "name";
gleHTTT.Properties.DisplayMember = "name";
col_t = new LookUpColumnInfo("name", "");
gleHTTT.Properties.Columns.Add(col_t);
gleHTTT.EditValue = "Tiền mặt";
//Xử lý
if (isSale == true)
{
//Khởi tạo KH
leKH.Properties.TextEditStyle = TextEditStyles.Standard;
leKH.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leKH, BUS_KhachHang.LayKhachHangDonGian(), "CustomerName", "Customer_ID");
leKH.Properties.Columns[0].FieldName = "CustomerName";
leKH.Properties.Columns[1].FieldName = "Customer_ID";
leKH.Properties.Buttons[1].Click += btnThemKH_BaseMH_BH_Click;
//Khởi tạo Mã KH
leMaKH.Properties.TextEditStyle = TextEditStyles.Standard;
leMaKH.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leMaKH, BUS_KhachHang.LayKhachHangDonGian(), "Customer_ID", "Customer_ID");
leMaKH.Properties.Columns[1].FieldName = "CustomerName";
leMaKH.Properties.Columns[0].FieldName = "Customer_ID";
//Gán sự kiện cho KH và Mã KH
leKH.EditValueChanged += GeKH_EditValueChanged;
leMaKH.EditValueChanged += GeMaKH_EditValueChanged;
Text = "Phiếu xuất hàng";
}
else
{
lcITen.Text = "Tên NCC";
lcIMa.Text = "Mã NCC";
lcINgayGiao.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
//Khởi tạo NCC
leKH.Properties.NullText = "Chọn tên Nhà cung cấp ...";
leKH.Properties.TextEditStyle = TextEditStyles.Standard;
leKH.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leKH, BUS_NhaCungCap.LayNhaCC(), "CustomerName", "Customer_ID");
leKH.Properties.Columns[0].FieldName = "CustomerName";
leKH.Properties.Columns[1].FieldName = "Customer_ID";
leKH.Properties.Buttons[1].Click += btnThenNCC_BaseMH_BH_Click;
//Khởi tạo Mã NCC
leMaKH.Properties.NullText = "Chọn mã Nhà cung cấp ...";
leMaKH.Properties.TextEditStyle = TextEditStyles.Standard;
leMaKH.Properties.BestFitMode = BestFitMode.BestFit;
SetDataSource(leMaKH, BUS_NhaCungCap.LayNhaCC(), "Customer_ID", "Customer_ID");
leMaKH.Properties.Columns[1].FieldName = "CustomerName";
leMaKH.Properties.Columns[0].FieldName = "Customer_ID";
//Gán sự kiện cho NCC và Mã NCC
leKH.EditValueChanged += GeKH_EditValueChanged;
leMaKH.EditValueChanged += GeMaKH_EditValueChanged;
Text = "Phiếu nhập hàng";
deNgayGiao.Visible = false;
lcIKho.Text = "Kho nhập";
gvMain.Columns["colChietKhauTiLe"].Visible = false;
gvMain.Columns["colChietKhau"].Visible = false;
gvMain.Columns["colThanhToan"].Visible = false;
}
table = BUS_KhoXuat.GetTonKhoLookup();
if (add == true)
{
phatSinhMa();
}
else
{
LoadDuLieu();
}
}
private void SuaChungTuBH()
{
List <CBanHang> lBH = new List <CBanHang>();
int rowIndex = gvMain.FocusedRowHandle;
DataTable fBH;
if (sale == true)
{
fBH = BUS_KhoXuat.TimBH(gvMain.GetRowCellValue(rowIndex, "Outward_ID").ToString());
}
else
{
fBH = BUS_KhoXuat.TimMH(gvMain.GetRowCellValue(rowIndex, "Inward_ID").ToString());
}
foreach (DataRow item in fBH.Rows)
{
if (sale == true)
{
string _MaBH = item.Field <string>("MaBH");
DateTime _NgayLap = item.Field <DateTime>("NgayLap");
string _MaKH = item.Field <string>("MaKH");
string _TenKH = item.Field <string>("TenKH");
string _NhanVienBH = item.Field <string>("NhanVienBH");
string _KhoXuat = item.Field <string>("KhoXuat");
string _DiaChi = item.Field <string>("DiaChi");
string _GhiChu = item.Field <string>("GhiChu");
string _DienThoai = item.Field <string>("DienThoai");
string _SoHoaDonVat = item.Field <string>("SoHoaDonVat");
string _SoPhieuNhapTay = item.Field <string>("SoPhieuNhapTay");
string _DieuKhoanThanhToan = item.Field <string>("DieuKhoanThanhToan");
string _HinhThucTT = item.Field <string>("HinhThucTT");
DateTime _HanTT = item.Field <DateTime>("HanTT");
DateTime _NgayGiao = item.Field <DateTime>("NgayGiao");
string _MaHH = item.Field <string>("MaHH");
string _TenHH = item.Field <string>("TenHH");
string _DonVi = item.Field <string>("DonVi");
decimal _SoLuong = item.Field <decimal>("SoLuong");
decimal _DonGia = item.Field <decimal>("DonGia");
decimal _ThanhTien = item.Field <decimal>("ThanhTien");
decimal _ChietKhauTiLe = item.Field <decimal>("ChietKhauTiLe");
decimal _ChietKhau = item.Field <decimal>("ChietKhau");
decimal _ThanhToan = item.Field <decimal>("ThanhToan");
CBanHang bh = new CBanHang
(
_MaBH,
_NgayLap,
_MaKH,
_TenKH,
_NhanVienBH,
_KhoXuat,
_DiaChi,
_GhiChu,
_DienThoai,
_SoHoaDonVat,
_SoPhieuNhapTay,
_DieuKhoanThanhToan,
_HinhThucTT,
_HanTT,
_NgayGiao,
_MaHH,
_TenHH,
_DonVi,
float.Parse(_SoLuong.ToString()),
float.Parse(_DonGia.ToString()),
float.Parse(_ThanhTien.ToString()),
float.Parse(_ChietKhauTiLe.ToString()),
float.Parse(_ChietKhau.ToString()),
float.Parse(_ThanhToan.ToString())
);
lBH.Add(bh);
}
else
{
string _MaBH = item.Field <string>("MaBH");
DateTime _NgayLap = item.Field <DateTime>("NgayLap");
string _MaKH = item.Field <string>("MaKH");
string _TenKH = item.Field <string>("TenKH");
string _NhanVienBH = item.Field <string>("NhanVienBH");
string _KhoXuat = item.Field <string>("KhoXuat");
string _DiaChi = item.Field <string>("DiaChi");
string _GhiChu = item.Field <string>("GhiChu");
string _DienThoai = item.Field <string>("DienThoai");
string _SoHoaDonVat = item.Field <string>("SoHoaDonVat");
string _SoPhieuNhapTay = item.Field <string>("SoPhieuNhapTay");
string _DieuKhoanThanhToan = item.Field <string>("DieuKhoanThanhToan");
string _HinhThucTT = item.Field <string>("HinhThucTT");
DateTime _HanTT = item.Field <DateTime>("HanTT");
DateTime _NgayGiao = DateTime.Now;
string _MaHH = item.Field <string>("MaHH");
string _TenHH = item.Field <string>("TenHH");
string _DonVi = item.Field <string>("DonVi");
decimal _SoLuong = item.Field <decimal>("SoLuong");
decimal _DonGia = item.Field <decimal>("DonGia");
decimal _ThanhTien = item.Field <decimal>("ThanhToan");
decimal _ChietKhauTiLe = 0;
decimal _ChietKhau = 0;
decimal _ThanhToan = 0;
CBanHang bh = new CBanHang
(
_MaBH,
_NgayLap,
_MaKH,
_TenKH,
_NhanVienBH,
_KhoXuat,
_DiaChi,
_GhiChu,
_DienThoai,
_SoHoaDonVat,
_SoPhieuNhapTay,
_DieuKhoanThanhToan,
_HinhThucTT,
_HanTT,
_NgayGiao,
_MaHH,
_TenHH,
_DonVi,
float.Parse(_SoLuong.ToString()),
float.Parse(_DonGia.ToString()),
float.Parse(_ThanhTien.ToString()),
float.Parse(_ChietKhauTiLe.ToString()),
float.Parse(_ChietKhau.ToString()),
float.Parse(_ThanhToan.ToString())
);
lBH.Add(bh);
}
}
_sua?.Invoke(lBH);
}
