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(); } }