private void frmHangHoaSearch_Load(object sender, EventArgs e)
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
lbcLoaiHang.ValueMember = "MaLoaiHang";
lbcLoaiHang.DisplayMember = "TenLoaiHang";
lueChungLoai.Properties.ValueMember = "MaChungLoai";
lueChungLoai.Properties.DisplayMember = "TenChungLoai";
lueChungLoai.Properties.Columns.Add(new LookUpColumnInfo("TenChungLoai", "Chủng Loại"));
lueChungLoai.Properties.DataSource = ChungLoaiService.LoadDataTable();
DataTable temp = LoaiHangService.LoadDataTable();
DataRow dr = dtLoaiHang.NewRow();
dr[0] = 0;
dr[1] = "Tất cả";
dtLoaiHang.Rows.Add(dr);
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr1 = dtLoaiHang.NewRow();
dr1[0] = temp.Rows[i].Field <int>("MaLoaiHang");
dr1[1] = temp.Rows[i].Field <string>("TenLoaiHang");
dtLoaiHang.Rows.Add(dr1);
}
lbcLoaiHang.DataSource = dtLoaiHang;
}
private void reload(object sender, FormClosingEventArgs e)
{
frmHangHoa f = (frmHangHoa)sender;
if (f.isDataChanged == true)
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
}
}
public frmChiTietKiemKe_Them()
{
InitializeComponent();
isDataChanged = false;
lueHangHoa.Properties.ValueMember = "MaHangHoa";
lueHangHoa.Properties.DisplayMember = "TenHangHoa";
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaHangHoa", 50, "Mã Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenHangHoa", 100, "Tên Hàng Hóa"));
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
}
private void frmPhieuXuatThemSua_Load(object sender, EventArgs e)
{
tedSoPhieu.Text = PhieuXuatService.AutoGenerateId();
tedNgayLap.Text = DateTime.Now.ToString("dd/MM/yyyy");
lueHangHoa.Properties.ValueMember = "MaHangHoa";
lueHangHoa.Properties.DisplayMember = "TenHangHoa";
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaHangHoa", 50, "Mã Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenHangHoa", 100, "Tên Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SoLuongNhap", 50, "Số Lượng Tồn"));
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
}
private void buttonTimKiem_Click(object sender, EventArgs e)
{
string key = txtTimKiem.Text;
if (key.Trim() != "")
{
grcHanghoaSearch.DataSource = HangHoaService.Search(key);
}
else
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
}
}
private void txtTimKiem_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
string key = txtTimKiem.Text;
if (key.Trim() != "")
{
grcHanghoaSearch.DataSource = HangHoaService.Search(key);
}
else
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
}
}
}
private void frmPhieuKiemKe_Load(object sender, EventArgs e)
{
isSaved = false;
txtNhanVien.ReadOnly = true;
txtMaPhieu.ReadOnly = true;
btnXoa.Enabled = false;
btnLuu.Enabled = false;
txtMaPhieu.Text = PhieuKiemKeService.AutoGenerateId();
deNgayLap.DateTime = DateTime.Now;
lueHangHoa.Properties.ValueMember = "MaHangHoa";
lueHangHoa.Properties.DisplayMember = "TenHangHoa";
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaHangHoa", 50, "Mã Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenHangHoa", 100, "Tên Hàng Hóa"));
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
}
private void frmHoaDon_Load(object sender, EventArgs e)
{
Init();
txtDiemTichLuy.ReadOnly = true;
txtTienGiam.ReadOnly = true;
txtThanhTien.ReadOnly = true;
txtThanhTien.Text = "0";
txtDiemTichLuy.Text = DiemTichLuy.ToString();
lueHangHoa.Properties.ValueMember = "MaHangHoa";
lueHangHoa.Properties.DisplayMember = "TenHangHoa";
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaHangHoa", 50, "Mã Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenHangHoa", 100, "Tên Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("GiaBan", 100, "Giá"));
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
}
private void HangHoaSearch_Load(object sender, EventArgs e)
{
lueChungLoai.Properties.ValueMember = "MaChungLoai";
lueChungLoai.Properties.DisplayMember = "TenChungLoai";
lueChungLoai.Properties.Columns.Add(new LookUpColumnInfo("TenChungLoai", "Tên chủng loại hàng"));
lueChungLoai.Properties.DataSource = ChungLoaiService.LoadDataTable();
lueLoaiHang.Properties.ValueMember = "MaLoaiHang";
lueLoaiHang.Properties.DisplayMember = "TenLoaiHang";
lueLoaiHang.Properties.Columns.Add(new LookUpColumnInfo("TenLoaiHang", "Tên Loại Hàng"));
lueLoaiHang.Properties.DataSource = LoaiHangService.LoadDataTable();
grcHangHoa.DataSource = HangHoaService.LoadDataTable();
if (Mode == MODE_NORMAL)
{
btnChon.Visible = false;
}
}
private void lbcLoaiHang_SelectedIndexChanged(object sender, EventArgs e)
{
if (lbcLoaiHang.SelectedValue != null)
{
if (lbcLoaiHang.SelectedValue.ToString() == "0")
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
}
else
{
int maLoaiHang = int.Parse(lbcLoaiHang.SelectedValue.ToString());
grcHanghoaSearch.DataSource = HangHoaService.GetByLoaiHang(maLoaiHang);
}
}
else
{
}
}
private void frmHangHoaSearch_Load(object sender, EventArgs e)
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
_dtLoaiHang = LoaiHangService.LoadDataTable();
_dtDonViTinh = DonViTinhService.LoadDataTable();
LookUpEditLoaiHang.DataSource = _dtLoaiHang;
LookUpEditLoaiHang.ValueMember = "MaLoaiHang";
LookUpEditLoaiHang.DisplayMember = "TenLoaiHang";
LookUpEditLoaiHang.Columns.Add(new LookUpColumnInfo("MaLoaiHang", "Mã Loại Hàng"));
LookUpEditLoaiHang.Columns.Add(new LookUpColumnInfo("TenLoaiHang", "Tên Loại Hàng"));
LookUpEditDonViTinh.DataSource = _dtDonViTinh;
LookUpEditDonViTinh.ValueMember = "MaDVT";
LookUpEditDonViTinh.DisplayMember = "TenDVT";
LookUpEditDonViTinh.Columns.Add(new LookUpColumnInfo("MaDVT", "Mã Đơn Vị Tính"));
LookUpEditDonViTinh.Columns.Add(new LookUpColumnInfo("TenDVT", "Tên Đơn Vị Tính"));
}
private void frmPhieuNhapThemSua_Load(object sender, EventArgs e)
{
tedSoPhieuNhap.Text = PhieuNhapService.AutoGenerateId();
tedNgayLap.Text = DateTime.Now.ToString("dd/MM/yyyy");
tedNhanVienLap.Text = (ProjectUltil.HoTenNhanVien != "") ? ProjectUltil.HoTenNhanVien : "";
tedNgayLap.ReadOnly = true;
tedSoPhieuNhap.ReadOnly = true;
tedNhanVienLap.ReadOnly = true;
tedTongTien.ReadOnly = true;
lueHangHoa.Properties.ValueMember = "MaHangHoa";
lueHangHoa.Properties.DisplayMember = "TenHangHoa";
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaHangHoa", 50, "Mã Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenHangHoa", 100, "Tên Hàng Hóa"));
lueHangHoa.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SoLuongTon", 50, "Số Lượng Tồn"));
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
lueNhaCungCap.Properties.ValueMember = "MaNhaCungCap";
lueNhaCungCap.Properties.DisplayMember = "TenNhaCungCap";
lueNhaCungCap.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenNhaCungCap", 100, "Tên NCC"));
lueNhaCungCap.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("DiaChi", 100, "Địa Chỉ"));
lueNhaCungCap.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("DienThoai", 100, "Điện Thoại"));
lueNhaCungCap.Properties.DataSource = NhaCungCapService.LoadDataTable();
}
private void btnXoa_Click(object sender, EventArgs e)
{
rowSelected = gridView.GetSelectedRows()[0];
if (rowSelected >= 0)
{
if (MessageBox.Show("Xác nhận xóa nhân viên đã chọn?", "Xác nhận", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (HangHoaService.Delete(gridView.GetRowCellValue(rowSelected, "MaHangHoa").ToString()))
{
grcHanghoaSearch.DataSource = HangHoaService.LoadDataTable();
MessageBox.Show("Xóa thành công!");
}
else
{
MessageBox.Show("Không thể xóa vì nhân viên này còn thông tin liên quan!");
}
}
}
else
{
MessageBox.Show("Vui lòng chọn 1 dòng để xóa!");
}
}
private void grcHangHoa_Load(object sender, EventArgs e)
{
var dt = HangHoaService.LoadDataTable();
grcHangHoa.DataSource = dt;
}
private void btnLapBaoCao_Click(object sender, EventArgs e)
{
if (cbbThang.Text == "")
{
MessageBox.Show("Vui lòng chọn tháng!");
return;
}
thang = int.Parse(cbbThang.Text);
if (cbbNam.Text == "")
{
MessageBox.Show("Vui lòng chọn năm!");
return;
}
nam = int.Parse(cbbNam.Text);
DateTime dateStart = new DateTime(nam, thang, 1);
DateTime dateEnd = new DateTime(nam, thang, ProjectUltil.soNgay(nam, thang));
if (dateStart > DateTime.Now.Date)
{
MessageBox.Show("Thời gian phải trước ngày hiện tại!");
return;
}
//if(dateEnd > DateTime.Now.Date)
//{
// dateEnd = DateTime.Now.Date;
//}
dsPhieuNhap = PhieuNhapService.Search(null, dateStart, dateEnd);
dsPhieuXuat = PhieuXuatService.Search(null, dateStart, dateEnd);
dsBaoCaoTonKho = BaoCaoTonKhoService.GetByMonthYear(thang, nam);
dsHangHoa = HangHoaService.LoadDataTable();
if (dsBaoCaoTonKho.Rows.Count > 0)
{
grcBaoCaoTonKho.DataSource = ChiTietBaoCaoTonKhoService.GetById(dsBaoCaoTonKho.Rows[0].Field <int>("MaBaoCaoTonKho"));
btnIn.Enabled = true;
}
else
{
bctk = new BaoCaoTonKho();
bctk.MaNhanVien = (ProjectUltil.MaNhanVien != "") ? ProjectUltil.MaNhanVien : "NV0001";
bctk.Nam = nam;
bctk.Thang = thang;
bctk.NgayLap = DateTime.Now.Date;
if ((bctk.MaBaoCaoTonKho = BaoCaoTonKhoService.Insert(bctk)) != -1)
{
for (int i = 0; i < dsHangHoa.Rows.Count; i++)
{
ctbctk = new ChiTietBaoCaoTonKho();
ctbctk.MaBaoCaoTonKho = bctk.MaBaoCaoTonKho;
ctbctk.MaHangHoa = dsHangHoa.Rows[i].Field <string>("MaHangHoa");
ctbctk.SoLuongDauKy = 0;
for (int j = 0; j < dsPhieuNhap.Rows.Count; j++)
{
dsCTPhieuNhap = ChiTietPhieuNhapService.GetById(dsPhieuNhap.Rows[j].Field <string>("SoPhieuNhap"));
for (int k = 0; k < dsCTPhieuNhap.Rows.Count; k++)
{
if (dsCTPhieuNhap.Rows[k].Field <string>("MaHangHoa") == ctbctk.MaHangHoa)
{
int soluong = dsCTPhieuNhap.Rows[k].Field <int>("SoLuong");
ctbctk.SoLuongNhap += soluong;
}
}
}
for (int j = 0; j < dsPhieuXuat.Rows.Count; j++)
{
dsCTPhieuXuat = ChiTietPhieuXuatService.GetById(dsPhieuXuat.Rows[j].Field <string>("SoPhieuXuat"));
for (int k = 0; k < dsCTPhieuXuat.Rows.Count; k++)
{
if (dsCTPhieuXuat.Rows[k].Field <string>("MaHangHoa") == ctbctk.MaHangHoa)
{
int soluong = dsCTPhieuXuat.Rows[k].Field <int>("SoLuong");
ctbctk.SoLuongXuat += soluong;
}
}
}
ctbctk.SoLuongCuoiKy = ctbctk.SoLuongDauKy + ctbctk.SoLuongNhap - ctbctk.SoLuongXuat;
if (!ChiTietBaoCaoTonKhoService.Insert(ctbctk))
{
ChiTietBaoCaoTonKhoService.Delete(ctbctk.MaBaoCaoTonKho.ToString());
BaoCaoTonKhoService.Delete(ctbctk.MaBaoCaoTonKho.ToString());
MessageBox.Show("Không thể thêm chi tiết báo cáo!");
}
}
}
else
{
MessageBox.Show("Không thể lập báo cáo!");
}
grcBaoCaoTonKho.DataSource = ChiTietBaoCaoTonKhoService.GetById(bctk.MaBaoCaoTonKho);
btnIn.Enabled = true;
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
string key = null;
Nullable <int> loaiHang = null, slTonTu = null, slTonDen = null, slQuayTu = null, slQuayDen = null;
if (cheKey.Checked == true)
{
if (sctKey.Text != "")
{
key = sctKey.Text;
}
}
if (cheLoai.Checked == true)
{
if (lueLoaiHang.Text.Trim() != "")
{
DataRowView row = lueLoaiHang.Properties.GetDataSourceRowByKeyValue(lueLoaiHang.EditValue) as DataRowView;
try
{
loaiHang = int.Parse(row.Row["MaLoaiHang"].ToString());
}
catch (Exception)
{
MessageBox.Show("Không thể lấy mã loại!");
return;
}
}
}
if (cheSLTon.Checked == true)
{
if (cbbSLTonTu.Text != "")
{
try
{
slTonTu = int.Parse(cbbSLTonTu.Text);
}
catch (Exception)
{
}
}
if (cbbSLTonDen.Text != "")
{
try
{
slTonDen = int.Parse(cbbSLTonDen.Text);
}
catch (Exception)
{
}
}
}
if (cheSLQuay.Checked == true)
{
if (cbbSLQuayTu.Text != "")
{
try
{
slQuayTu = int.Parse(cbbSLQuayTu.Text);
}
catch (Exception)
{
}
}
if (cbbSLQuayDen.Text != "")
{
try
{
slQuayDen = int.Parse(cbbSLQuayDen.Text);
}
catch (Exception)
{
}
}
}
if (key == null && loaiHang == null && slTonTu == null && slTonDen == null && slQuayTu == null && slQuayDen == null)
{
grcHangHoa.DataSource = HangHoaService.LoadDataTable();
}
else
{
grcHangHoa.DataSource = HangHoaService.Search1(key, loaiHang, slTonTu, slTonDen, slQuayTu, slQuayDen);
}
}
private void reloadHangHoa(object sender, FormClosingEventArgs e)
{
lueHangHoa.Properties.DataSource = HangHoaService.LoadDataTable();
}