private void btnLuu_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Xác Nhận Mua Hàng?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
HDBanDTO ob = checkDataHDB();
if (ob != null)
{
if (cthdbList.Count == 0)
{
MessageBox.Show("Phải Có Hàng Hóa", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxMaHang.Focus();
return;
}
else
{
B_HDBan.saveHDB(ob, sys.INSERT);
foreach (CTHDBDTO cthdb in cthdbList)
{
B_CTHDB.saveCTHDB(cthdb, sys.INSERT);
}
MessageBox.Show("Tuyệt Vời", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
cthdbList.Clear();
loadTempTable(cthdbList);
dgvHDB.DataSource = B_HDBan.GetAllHDBan();
clrHang();
clrHD();
clrCbx();
turnOffBtnUnder(false);
}
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
/*param*/
string s = DateTime.Now.ToString("dd/MM/yyyy");
ReportParameter[] parms = new ReportParameter[3];
parms[0] = new ReportParameter("Month", cbxThang.Text);
parms[1] = new ReportParameter("Year", cbxNam.Text);
parms[2] = new ReportParameter("DateNow", s);
/* get debug/report path*/
string exeFolder = Application.StartupPath;
string reportPath = Path.Combine(exeFolder, @"Reports\Report1.rdlc");
rpvChitiet.LocalReport.ReportPath = reportPath;
rpvChitiet.LocalReport.SetParameters(parms);
/* dataSet*/
DataSet ds = B_HDBan.SPBanChayNhatTheoThang(int.Parse(cbxThang.Text), int.Parse(cbxNam.Text));
rpvChitiet.ProcessingMode = ProcessingMode.Local;
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Không Có Kết Quả Để Xuất Báo Cáo", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "sp_SPBanChayNhatTheoThang";
rds.Value = ds.Tables[0];
rpvChitiet.LocalReport.DataSources.Clear();
rpvChitiet.LocalReport.DataSources.Add(rds);
rpvChitiet.RefreshReport();
}
}
private void frmBaocaoSanpham_Load(object sender, EventArgs e)
{
DataTable dt = B_HDBan.GetYearHDB();
Nam = dt.AsEnumerable().Select(r => r.Field <int>("NamHienCo")).ToList();
cbxNam.DataSource = Nam;
}
private void frmBaocaoKhachhangmuait_Load(object sender, EventArgs e)
{
DataTable dt = B_HDBan.GetYearHDB();
Nam = dt.AsEnumerable().Select(r => r.Field <int>("NamHienCo")).ToList();
cbxNam.DataSource = Nam;
for (int i = 1; i <= 4; i++)
{
cbxQuy.Items.Add(i);
}
rpvChitiet.RefreshReport();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (DuplicatedOrNone() == 2)
{
{
MessageBox.Show("Không Có Số Hóa Đó Để Thay Đổi Liên Quan", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSoHDB.Text = "";
return;
}
}
else
{
B_HDBan.DeleteHDBan(txtSoHDB.Text);
MessageBox.Show("Xóa Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt = B_HDBan.GetAllHDBan();
dgvHDB.DataSource = dt;
}
}
private void frmChitietHDB_Load(object sender, EventArgs e)
{
DataTable cthdb = B_HDBan.GetAllHDBan();
dgvHDB.DataSource = cthdb;
dt = cthdb;
DataTable t = B_KhachHang.GetAllKhachHang();
FillCbo(t, cbxMaKH, "MaKhach", "TenKhach");
DataTable ts = B_NhanVien.GetAllNhanVien();
FillCbo(ts, cbxMaNV, "MaNV", "TenNV");
//btnXoa.Enabled = false;
txtTongTien.Enabled = false;
}
private void btnThem_Click(object sender, EventArgs e)
{
HDBanDTO ob = checkDataHDB();
if (ob != null)
{
{
if (DuplicatedOrNone() == 1)
{
{
MessageBox.Show("Số Hóa Đơn Trùng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSoHDB.Focus();
return;
}
}
else
{
B_HDBan.saveHDB(ob, sys.INSERT);
MessageBox.Show("Thêm Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt = B_HDBan.GetAllHDBan();
dgvHDB.DataSource = dt;
}
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (DuplicatedOrNone() == 2)
{
{
MessageBox.Show("Không Có Số Hóa Đơn Đó Để Thay Đổi Liên Quan", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSoHDB.Text = "";
return;
}
}
else
{
HDBanDTO ob = checkDataHDB();
if (ob != null)
{
{
B_HDBan.saveHDB(ob, sys.UPDATE);
MessageBox.Show("Sửa Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt = B_HDBan.GetAllHDBan();
dgvHDB.DataSource = dt;
}
}
}
}
private void btnIn_Click(object sender, EventArgs e)
{
if (txtSoHDB.Text == "")
{
MessageBox.Show("Chưa Có Thông Tin Hóa Đơn", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (B_HDBan.GetBillBan(txtSoHDB.Text).Rows.Count == 0)
{
MessageBox.Show("Chưa Có Thông Tin Hóa Đơn", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
ExcelAutomate.automateHD
(B_HDBan.GetBillBan(txtSoHDB.Text), B_HDBan.XuatMatHangHDB(txtSoHDB.Text)
, "HÓA ĐƠN BÁN", "Khách Hàng");
}
}
private void intoCTHDB(object sender, DataGridViewCellEventArgs e)
{
if (cthdbList.Count != 0)
{
try
{
currentLeastAmount = 0;
var obj = amountHang.FirstOrDefault(cthdn => cthdn.MaHang == cbxMaHang.SelectedValue.ToString());
currentLeastAmount = obj.SoLuong;
DataGridViewRow row = new DataGridViewRow();
row = dgvHDB.Rows[e.RowIndex];
cbxMaHang.Text = row.Cells[0].Value.ToString();
txtTenHang.Text = row.Cells[1].Value.ToString();
txtSoLuong.Text = row.Cells[2].Value.ToString();
currentLeastAmount += int.Parse(txtSoLuong.Text);
txtDonGia.Text = row.Cells[3].Value.ToString();
txtGiamGia.Text = row.Cells[4].Value.ToString();
txtThanhTien.Text = row.Cells[5].Value.ToString();
}
catch
{
}
}
if (e.RowIndex == dgvHDB.Rows.Count - 1)
{
DialogResult kq = MessageBox.Show("Hủy Đơn ?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (kq == DialogResult.Yes)
{
cthdbList.Clear();
currentLeastAmount = 0;
dgvHDB.DataSource = B_HDBan.GetAllHDBan();
cbxMaKH.SelectedIndex = cbxMaNV.SelectedIndex = -1;
dtpNgayBan.Value = DateTime.Now;
turnOffBtnUnder(false);
clrHang();
clrHD();
clrCbx();
}
}
}
private void frmBanhang_Load(object sender, EventArgs e)
{
DataTable cthdb = B_HDBan.GetAllHDBan();
dgvHDB.DataSource = cthdb;
#region Instance To List
DataTable amountHangDt = removeHangWithNonePriceAndAmount(B_HangHoa.GetAllHangHoa());
amountHang = InstanceHandling.ConvertDataTable <HangHoaEntity>(amountHangDt);
#endregion
DataTable t = B_KhachHang.GetAllKhachHang();
FillCbo(t, cbxMaKH, "MaKhach", "TenKhach");
DataTable ts = B_NhanVien.GetAllNhanVien();
FillCbo(ts, cbxMaNV, "MaNV", "TenNV");
DataTable hang = removeHangWithNonePriceAndAmount(B_HangHoa.GetAllHangHoa());
FillCbo(hang, cbxMaHang, "MaHang", "TenHangHoa");
txtTongTien.Text = "0";
txtThanhTien.Enabled = false;
// setup btn
turnOffBtnUnder(false);
//
loadTextBox();
}
private void btnOk_Click(object sender, EventArgs e)
{
string nv = cbxNV.Text;
int sub = cbxNV.Text.LastIndexOf("-");
string tenNV = nv.Substring(sub + 1);
/*param*/
string s = DateTime.Now.ToString("dd/MM/yyyy");
ReportParameter[] parms = new ReportParameter[2];
parms[0] = new ReportParameter("TenNV", tenNV);
parms[1] = new ReportParameter("DateNow", s);
string exeFolder = Application.StartupPath;
string reportPath = Path.Combine(exeFolder, @"Reports\Report3.rdlc");
rpvChitiet.LocalReport.ReportPath = reportPath;
//rpvChitiet.LocalReport.ReportPath = "Report3.rdlc";
rpvChitiet.LocalReport.SetParameters(parms);
/* dataSet*/
DataSet ds = B_HDBan.HDBTheoNV(cbxNV.SelectedValue.ToString());
rpvChitiet.ProcessingMode = ProcessingMode.Local;
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Không Có Kết Quả Để Xuất Báo Cáo", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "sp_HDBTheoNV";
rds.Value = ds.Tables[0];
rpvChitiet.LocalReport.DataSources.Clear();
rpvChitiet.LocalReport.DataSources.Add(rds);
rpvChitiet.RefreshReport();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
/*param*/
int truoc = 0;
int sau = 0;
switch (cbxQuy.Text)
{
case "1":
truoc = 1;
sau = 3;
break;
case "2":
truoc = 4;
sau = 6;
break;
case "3":
truoc = 7;
sau = 9;
break;
case "4":
truoc = 10;
sau = 12;
break;
default:
break;
}
string s = DateTime.Now.ToString("dd/MM/yyyy");
ReportParameter[] parms = new ReportParameter[3];
parms[0] = new ReportParameter("Quy", cbxQuy.Text);
parms[1] = new ReportParameter("Nam", cbxNam.Text);
parms[2] = new ReportParameter("DateNow", s);
string exeFolder = Application.StartupPath;
string reportPath = Path.Combine(exeFolder, @"Reports\Report4.rdlc");
rpvChitiet.LocalReport.ReportPath = reportPath;
//rpvChitiet.LocalReport.ReportPath = "Report4.rdlc";
rpvChitiet.LocalReport.SetParameters(parms);
/* dataSet*/
DataSet ds = B_HDBan.KhachMuaItHangNhat(truoc, sau, int.Parse(cbxNam.Text));
rpvChitiet.ProcessingMode = ProcessingMode.Local;
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Không Có Kết Quả Để Xuất Báo Cáo", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "sp_KhachHangMuaItHangNhat";
rds.Value = ds.Tables[0];
rpvChitiet.LocalReport.DataSources.Clear();
rpvChitiet.LocalReport.DataSources.Add(rds);
rpvChitiet.RefreshReport();
}
}
