bool validateGrid(int preRow)
{
int error = 0;
LinhKien_View lk = gridView1.GetFocusedRow() as LinhKien_View;
if (lk != null)
{
if (lk.TenLinhKien == null || lk.TenLinhKien.Trim().Equals("") || lk.MaThuongHieu == null || lk.MaNhaCungCap == null)
{
gridView1.FocusedRowHandle = preRow;
MessageBox.Show("Chưa nhập đầy đủ thông tin!");
error++;
}
if (lk.TenLinhKien == null)
{
gridView1.SetColumnError(gridView1.Columns["TenLinhKien"], "Tên Linh Kiện không được rỗng!");
}
if (lk.MaThuongHieu == null)
{
gridView1.SetColumnError(gridView1.Columns["MaThuongHieu"], "Thương hiệu không được rỗng!");
}
if (error > 0)
{
return(false);
}
}
gridView1.ClearColumnErrors();
return(true);
}
private void change_GiaBan()
{
//Kho_View kho;
foreach (var cthd in ls_cthd)
{
//kho = list_LK_inKho.Where(key => key.MaLinhKien == cthd.MaLinhKien).FirstOrDefault();
LinhKien_View lk_view = LinhKien_DAL.get_LinhKien_ByMaLK(cthd.MaLinhKien);
switch (loaiKH)
{
case "L001":
cthd.GiaBan = lk_view.GiaBanLe;
phanTramChietKhau = 0;
break;
case "L002":
cthd.GiaBan = lk_view.GiaBanSi;
phanTramChietKhau = 0;
break;
case "L003":
cthd.GiaBan = lk_view.GiaBanLe;
phanTramChietKhau = phanTramChietKhau_DB;
break;
}
cthd.ThanhTien = (cthd.GiaBan * cthd.SoLuong) + (cthd.GiaBan * cthd.SoLuong) * (Decimal)(cthd.Thue / 100);
}
count_TongTien();
gridControl1.RefreshDataSource();
}
private void add_Row()
{
if (validateGrid(gridView1.FocusedRowHandle))
{
LinhKien_View lk = gridThaoTac.addRow(count_row) as LinhKien_View;
lk.MaDonViTinh = "DVT001";
gridThaoTac.refreshData();
count_row++;
}
}
bool validateGrid(GridColumn col)
{
int error = 0;
LinhKien_View lk = gridView1.GetFocusedRow() as LinhKien_View;
if (lk != null)
{
switch (col.FieldName)
{
case "TenLinhKien":
if (lk.TenLinhKien == null || lk.TenLinhKien.Trim().Equals(""))
{
gridView1.SetColumnError(col, "Tên Linh Kiện không được rỗng!");
error++;
}
else
{
gridView1.SetColumnError(col, "", DevExpress.XtraEditors.DXErrorProvider.ErrorType.None);
}
break;
case "MaThuongHieu":
if (lk.MaThuongHieu == null)
{
gridView1.SetColumnError(col, "Thương hiệu không được rỗng!");
error++;
}
else
{
gridView1.SetColumnError(col, "", DevExpress.XtraEditors.DXErrorProvider.ErrorType.None);
}
break;
case "MaNhaCungCap":
if (lk.MaNhaCungCap == null)
{
gridView1.SetColumnError(col, "Nhà cung cấp không được rỗng!");
error++;
}
else
{
gridView1.SetColumnError(col, "", DevExpress.XtraEditors.DXErrorProvider.ErrorType.None);
}
break;
}
if (error > 0)
{
return(false);
}
}
// gridView1.ClearColumnErrors();
return(true);
}
public static bool Add_LinhKien(LinhKien_View item)
{
using (var transaction = Context.getInstance().db.Database.BeginTransaction())
{
try
{
Context.getInstance().db.LINHKIENs.Add(item.toLinhKien());
Context.getInstance().db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
Context.getInstance().db.LINHKIENs.Local.Clear();
transaction.Rollback();
return(false);
}
}
return(true);
}
private void addRowGrid_CT_HoaDon()
{
LinhKien_View lk = gridViewLoc.GetFocusedRow() as LinhKien_View;
bool flat = false;
if (ls_cthd.Count > 0)
{
int sl = 0;
foreach (CT_HoaDonNhap_View item in ls_cthd)
{
if (item.MaLinhKien.Equals(lk.MaLinhKien))
{
sl = item.SoLuong + 1;
item.SoLuong = sl;
item.ThanhTien = item.SoLuong * item.GiaNhap;
flat = true;
break;
}
}
}
if (!flat)
{
CT_HoaDonNhap_View ct_hd = new CT_HoaDonNhap_View();
ct_hd.MaHoaDon = txtMaPhieu.Text.Trim();
ct_hd.MaLinhKien = lk.MaLinhKien;
ct_hd.TenLinhKien = lk.TenLinhKien;
ct_hd.DonViTinh = lk.TenDonViTinh;
ct_hd.SoLuong = 1;
ct_hd.GiaNhap = lk.GiaNhap;
ct_hd.ThanhTien = ct_hd.GiaNhap * ct_hd.SoLuong;
ct_hd.TinhTrang = 1;
ls_cthd.Add(ct_hd);
gridControl1.DataSource = ls_cthd;
}
gridControl1.RefreshDataSource();
count_TongTien();
}
private void btnThem_Click(object sender, EventArgs e)
{
LinhKien_View item = new LinhKien_View();
//item.MaLinhKien = txtMaLinhKien.Text;
//item.TenLinhKien = txtTenLinhKien.Text;
//item.MaThuongHieu = listThuongHieu[cbThuongHieu.SelectedIndex].MaThuongHieu;
//item.MaDonViTinh = listDonViTinh[cbDonViTinh.SelectedIndex].MaDonViTinh;
//item.GiaBanLe = Decimal.Parse(txtGiaBanLe.Text);
//item.GiaBanSi = Decimal.Parse(txtGiaBanSi.Text);
//item.MaNhaCungCap = listNhaCungCap[cbNhaCungCap.SelectedIndex].MaNhaCungCap;
//item.TinhTrang = 1;
//item.ThoiGianBaoHanh = int.Parse(txtThoiGianBH.Text);
//if(LinhKien_DAL.Add_LinhKien(item))
//{
// MessageBox.Show("Đã thêm thanh công");
// SetDataLoad();
//}
//else
//{
// MessageBox.Show("Đã có lỗi xảy ra, vui lòng kiểm tra lại");
//}
}
private void addRowGrid_CT_HoaDon()
{
Kho_View kho = gridViewLoc.GetFocusedRow() as Kho_View;
bool flat = false;
if (ls_cthd.Count > 0)
{
if (kho.SoLuong <= 0)
{
MessageBox.Show("Trong kho đã hết mặt hàng này, vui lòng nhập thêm sản phẩm!");
return;
}
else
{
foreach (CT_HoaDon_View item in ls_cthd)
{
if (item.MaLinhKien.Equals(kho.MaLinhKien))
{
kho.SoLuong -= 1;
item.SoLuong += 1;
item.ThanhTien = (item.SoLuong * item.GiaBan) + (item.SoLuong * item.GiaBan) * (Decimal)(item.Thue / 100);
item.SoSeri.Add(kho.SoSeri[0]);
kho.SoSeri.RemoveAt(0);
flat = true;
break;
}
}
}
}
if (!flat)
{
LinhKien_View lk_view = LinhKien_DAL.get_LinhKien_ByMaLK(kho.MaLinhKien);
CT_HoaDon_View ct_hd = new CT_HoaDon_View();
ct_hd.MaHoaDon = txtMaPhieu.Text.Trim();
ct_hd.MaLinhKien = lk_view.MaLinhKien;
ct_hd.TenLinhKien = lk_view.TenLinhKien;
ct_hd.DonViTinh = lk_view.MaDonViTinh;
ct_hd.ThoiGianBaoHanh = lk_view.ThoiGianBaoHanh;
switch (loaiKH)
{
case "L001":
ct_hd.GiaBan = lk_view.GiaBanLe;
phanTramChietKhau = 0;
break;
case "L002":
ct_hd.GiaBan = lk_view.GiaBanSi;
phanTramChietKhau = 0;
break;
case "L003":
ct_hd.GiaBan = lk_view.GiaBanLe;
phanTramChietKhau = phanTramChietKhau_DB;
break;
}
ct_hd.SoLuong = 1;
kho.SoLuong -= 1;
ct_hd.ThanhTien = (ct_hd.SoLuong * ct_hd.GiaBan) + (ct_hd.SoLuong * ct_hd.GiaBan) * (Decimal)(ct_hd.Thue / 100);
ct_hd.SoSeri = new List <string>();
ct_hd.SoSeri.Add(kho.SoSeri[0]);
kho.SoSeri.RemoveAt(0);
ls_cthd.Add(ct_hd);
}
gridCtrlLoc.RefreshDataSource();
gridControl1.RefreshDataSource();
count_TongTien();
}