private void ThemHangHoa()
{
EHangHoa eHangHoa = new EHangHoa();
eHangHoa.MaHang = txtMaHangHoa.Text.Trim();
eHangHoa.TenHang = txtTenHangHoa.Text.Trim();
eHangHoa.MaDVT = Convert.ToInt32(cbbDVT.SelectedValue.ToString());
//eHangHoa.MaNhomHangHoa = Convert.ToInt32(cbbNhomHang.SelectedValue.ToString());
//eHangHoa.MaKho = Convert.ToInt32(cbbKhoQuay.SelectedValue.ToString());
eHangHoa.MaKho = 1;
eHangHoa.MaNhomHangHoa = 1;
eHangHoa.GiaNhap = Convert.ToDouble(txtGiaNhapHang.Text.Trim());
eHangHoa.GiaBan = Convert.ToDouble(txtGiaBanHang.Text.Trim());
eHangHoa.MaVach = txtMaVachNSX.Text.Trim();
eHangHoa.CreateDate = UnixTime.GetUnixTime(DateTime.Now);// dùng unix time
eHangHoa.CreateID = Session.MaNhanVien;
eHangHoa.MaNCC = 1;
eHangHoa.EditDate = UnixTime.GetUnixTime(DateTime.Now);
eHangHoa.EditID = Session.MaNhanVien;
try
{
BHangHoa.Insert(eHangHoa);
MessageBox.Show("Thêm thành công");
}
catch (Exception ex)
{
MessageBox.Show("Lỗi:" + ex.ToString());
}
}
private void LoadReport(string MaHang)
{
data = BHangHoa.GetToPrintBarcode(MaHang);
rpInMaVach rp = new rpInMaVach();
rp.SetDataSource(data);
crystalReportViewer1.ReportSource = rp;
crystalReportViewer1.Refresh();
crystalReportViewer1.Zoom(100);
}
private void LoadData()
{
try
{
dtAllHangHoa = BHangHoa.GetHangHoa();
dtgvDanhSachHangHoa.DataSource = dtAllHangHoa;
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.ToString());
}
}
private void LoadData()
{
try
{
dtgvDSPhieuNhapHang.AutoGenerateColumns = false;
dtDataActived = BHangHoa.GetAll();
dtgvDSPhieuNhapHang.DataSource = dtDataActived;
}
catch (Exception ex)
{
MessageBox.Show("Lối:" + ex);
}
}
private void txtMaVach_TextChanged(object sender, EventArgs e)
{
try
{
string text = txtMaVach.Text.Trim();
//txtMaVach.AutoCompleteMode = AutoCompleteMode.Suggest;
//txtMaVach.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection col = new AutoCompleteStringCollection();
DataTable dt = BHangHoa.GetByTenHang(text);
foreach (DataRow item in dt.Rows)
{
col.Add(item["TenHang"].ToString());
}
txtMaVach.AutoCompleteCustomSource = col;
}
catch
{
}
}
private void CapNhatHangHoa()
{
EHangHoa eHangHoa = new EHangHoa();
eHangHoa.MaHang = txtMaHangHoa.Text.Trim();
eHangHoa.TenHang = txtTenHangHoa.Text.Trim();
eHangHoa.MaDVT = Convert.ToInt32(cbbDVT.SelectedValue.ToString());
//eHangHoa.MaNhomHangHoa = Convert.ToInt32(cbbNhomHang.SelectedValue.ToString());
//eHangHoa.MaKho = Convert.ToInt32(cbbKhoQuay.SelectedValue.ToString());
eHangHoa.MaNhomHangHoa = 1;
eHangHoa.MaKho = 1;
eHangHoa.GiaBan = Convert.ToDouble(txtGiaNhap.Text.Trim());
eHangHoa.MaVach = txtMaVach.Text.Trim();
try
{
BHangHoa.Update(eHangHoa);
MessageBox.Show("Cập nhật thành công");
}
catch (Exception ex)
{
MessageBox.Show("Lỗi:" + ex.ToString());
}
}
private void LoadCombobox()
{
cbbSanPham.DataSource = BHangHoa.GetAll();
cbbSanPham.ValueMember = "MaHang";
cbbSanPham.DisplayMember = "TenHang";
}
private void txtMaVach_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
int maHang = 0;
string hangHoa = txtMaVach.Text.Trim();
if (int.TryParse(hangHoa, out maHang) == false)
{
data = BHangHoa.GetByTenHang(hangHoa);
if (data.Rows.Count == 0)
{
MessageBox.Show("Không có hàng có mã này!");
}
}
else
{
//string maHang = txtMaVach.Text.Trim();
txtMaVach.SelectAll();
data = BHangHoa.GetByMaHang(hangHoa);
if (data.Rows.Count == 0)
{
MessageBox.Show("Không có hàng có mã này!");
}
}
if (data.Rows.Count > 1)
{
foreach (DataRow item in data.Rows)
{
DataRow row = dtHH.NewRow();
row["DonViTinh"] = item[2].ToString();
row["MaDVT"] = item[4].ToString();
row["DonGia"] = Convert.ToDouble(item[3].ToString());
dtHH.Rows.Add(row);
}
cbbDVT.DataSource = dtHH;
cbbDVT.DisplayMember = "DonViTinh";
cbbDVT.ValueMember = "MaDVT";
cbbDVT.Focus();
}
if (data.Rows.Count != 0)
{
DataRow row = data.Rows[0];
string TenHang = row[1].ToString();
string MaHang = row[0].ToString();
string DonViTinh = row[2].ToString();
double DonGia = Convert.ToDouble(row[3].ToString());
string MaDVT = row[4].ToString();
double GiaNhap = Convert.ToDouble(row[5].ToString());
int SoLuong = 1;
double ChietKhau = 0;
double HDTrucTiep = 0;
double HDVAT = 0;
double.TryParse(txtChietKhauHang.Text, out ChietKhau);
double.TryParse(txtHDVAT.Text, out HDVAT);
double.TryParse(txtHĐTrucTiep.Text, out HDTrucTiep);
int testExist = KiemTraTonTai(MaHang, MaDVT);
// kiểm tra số lượng
if (txtSoLuong.Text != "")
{
if (testExist != -1)
{
SoLuong = int.Parse(txtSoLuong.Text) + int.Parse(dtView.Rows[testExist]["SoLuong"].ToString());
dtView.Rows[testExist]["SoLuong"] = SoLuong;
dtView.Rows[testExist]["ThanhTien"] = DonGia * (SoLuong) - ChietKhau + HDTrucTiep + HDVAT;
dtView.Rows[testExist]["GiaNhap"] = GiaNhap * (SoLuong);
dtView.Rows[testExist]["ChietKhau"] = ChietKhau;
dtView.Rows[testExist]["HDTrucTiep"] = HDTrucTiep;
dtView.Rows[testExist]["HDVAT"] = HDVAT;
}
else
{
SoLuong = int.Parse(txtSoLuong.Text);
DataRow dtrow = dtView.NewRow();
dtrow["MaHang"] = MaHang;
dtrow["TenHang"] = TenHang;
dtrow["DonViTinh"] = DonViTinh;
dtrow["DonGia"] = DonGia;
dtrow["SoLuong"] = SoLuong;
dtrow["ThanhTien"] = DonGia * SoLuong - ChietKhau + HDTrucTiep + HDVAT;
dtrow["GiaNhap"] = GiaNhap * SoLuong;
dtrow["MaDVT"] = MaDVT;
dtrow["ChietKhau"] = ChietKhau;
dtrow["HDTrucTiep"] = HDTrucTiep;
dtrow["HDVAT"] = HDVAT;
dtView.Rows.Add(dtrow);
}
}
else
{
if (testExist == -1)
{
DataRow dtrow = dtView.NewRow();
dtrow["MaHang"] = MaHang;
dtrow["TenHang"] = TenHang;
dtrow["DonViTinh"] = DonViTinh;
dtrow["DonGia"] = DonGia;
dtrow["SoLuong"] = SoLuong;
dtrow["ThanhTien"] = DonGia * SoLuong - ChietKhau + HDTrucTiep + HDVAT;
dtrow["GiaNhap"] = GiaNhap * SoLuong;
dtrow["MaDVT"] = MaDVT;
dtrow["ChietKhau"] = ChietKhau;
dtrow["HDTrucTiep"] = HDTrucTiep;
dtrow["HDVAT"] = HDVAT;
dtView.Rows.Add(dtrow);
}
else
{
int soLuongNew = int.Parse(dtView.Rows[testExist]["SoLuong"].ToString());
dtView.Rows[testExist]["SoLuong"] = soLuongNew + 1;
dtView.Rows[testExist]["ThanhTien"] = DonGia * (soLuongNew + 1) - ChietKhau + HDTrucTiep + HDVAT;
dtView.Rows[testExist]["GiaNhap"] = GiaNhap * (soLuongNew + 1);
dtView.Rows[testExist]["ChietKhau"] = ChietKhau;
dtView.Rows[testExist]["HDTrucTiep"] = HDTrucTiep;
dtView.Rows[testExist]["HDVAT"] = HDVAT;
}
}
// them vao dtView
dtgvBanHang.DataSource = dtView;
ResetHang();
}
TinhTongHoaDon();
}
}
