private void btnXoa_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Bạn có muốn xóa doanh thu ngày " + dtpNgay.Text + " không?", "Xóa", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { DoanhThuNgay dtn = new DoanhThuNgay(); dtn.madtngay = txtMa.Text; DoanhThuNgayBUS.Instance.Xoa(dtn); Load(sender, e); } }
private void dgvRevenueDay_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { DoanhThuNgay row = (DoanhThuNgay)dgvRevenueDay.SelectedItems[0]; txtMa.Text = row.madtngay; txtTenVeNgay.Text = row.tenvengay.ToString(); dtpNgay.Text = row.ngay.ToString(); cboPhuXe.Text = row.PhuXe.hoten; txtSoluong1.Text = row.soluongveloai1.ToString(); txtSoluong2.Text = row.soluongveloai2.ToString(); txtSoluong3.Text = row.soluongveloai3.ToString(); txtDoanhThu.Text = row.dtngay.ToString(); } catch (Exception i) { } }
public IEnumerable <DoanhThuNgay> Xem() { List <DoanhThuNgay> Details = new List <DoanhThuNgay>(); var result = db.Get_DoanhThuNgay().ToList(); for (int j = 0; j < result.Count; j++) { DoanhThuNgay dtn = new DoanhThuNgay(); dtn.PhuXe = new PhuXe(); dtn.madtngay = Convert.ToString(result[j].madtngay); dtn.PhuXe.hoten = Convert.ToString(result[j].hoten); dtn.tenvengay = Convert.ToString(result[j].tenvengay); dtn.ngay = Convert.ToDateTime(result[j].ngay); dtn.soluongveloai1 = Convert.ToInt32(result[j].soluongveloai1); dtn.soluongveloai2 = Convert.ToInt32(result[j].soluongveloai2); dtn.soluongveloai3 = Convert.ToInt32(result[j].soluongveloai3); dtn.dtngay = Convert.ToDouble(result[j].dtngay); Details.Add(dtn); } return(Details); }
private void btnLuu_Click(object sender, RoutedEventArgs e) { DoanhThuNgay dtn = new DoanhThuNgay(); dtn.mapx = cboPhuXe.SelectedValue.ToString(); dtn.tenvengay = txtTenVeNgay.Text; dtn.ngay = dtpNgay.SelectedDate.Value; dtn.soluongveloai1 = Convert.ToInt32(txtSoluong1.Text); dtn.soluongveloai2 = Convert.ToInt32(txtSoluong2.Text); dtn.soluongveloai3 = Convert.ToInt32(txtSoluong3.Text); dtn.dtngay = Convert.ToDouble(txtDoanhThu.Text); if (themMoi) { DoanhThuNgayBUS.Instance.Them(dtn); } else { DoanhThuNgayBUS.Instance.CapNhat(dtn, maDTN); } Load(sender, e); }
void ThongKe() { chart1.Series[0].Points.Clear(); if (cbbThongKe.Text.ToString() == "Doanh Thu") { // Hien thi danh sach hoa don DataTable data = DataProvider.Instance.ExecuteQuery("exec USP_ThongKeBill @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") }); dtgThongKe.DataSource = data; // lay doanh thu theo ngay va ve bieu do List <DoanhThuNgay> listDoanhThu = new List <DoanhThuNgay>(); DataTable dataDoanhThu = DataProvider.Instance.ExecuteQuery("exec USP_BieuDoThongKeDoanhThu @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") }); foreach (DataRow row in dataDoanhThu.Rows) { DoanhThuNgay doanhThu = new DoanhThuNgay(row); listDoanhThu.Add(doanhThu); } chart1.Series[0].Name = "Doanh Thu (VNĐ)"; foreach (DoanhThuNgay item in listDoanhThu) { chart1.Series[0].Points.AddXY(item.Date.Value.ToString("yyyy-MM-dd"), (float)item.TotalPrice); } dataExportExcel = data; } else { List <ThongKeSanPham> listSanPham = new List <ThongKeSanPham>(); DataTable dataSanPham = DataProvider.Instance.ExecuteQuery("exec USP_ThongKeSanPham @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") }); dtgThongKe.DataSource = dataSanPham; foreach (DataRow row in dataSanPham.Rows) { ThongKeSanPham tkSanPham = new ThongKeSanPham(row); listSanPham.Add(tkSanPham); } chart1.Series[0].Name = "Số Lượng Đã Bán"; foreach (ThongKeSanPham item in listSanPham) { chart1.Series[0].Points.AddXY(item.TenSP.ToString(), item.DaBan); } dataExportExcel = dataSanPham; } try { string doanhThuNow = DataProvider.Instance.ExecuteScalar("select sum(totalPrice) from Bill where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' group by DateCheckIn").ToString(); lblDoanhThu.Text = doanhThuNow.ToString() + " ₫"; string hoaDonNow = DataProvider.Instance.ExecuteScalar("select count(DateCheckIn) from Bill where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'").ToString(); lblSLHoaDon.Text = hoaDonNow.ToString(); string daBanNow = DataProvider.Instance.ExecuteScalar("select sum(bi.count) from BillInfo as bi, Bill as b where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and bi.idBill = b.id group by b.DateCheckIn").ToString(); lblSLDaBan.Text = daBanNow.ToString(); } catch (Exception ex) { } }
public void Xoa(DoanhThuNgay dtn) { DoanhThuNgayDAO.Instance.Xoa(dtn); }
public void CapNhat(DoanhThuNgay dtn, string maDTN) { DoanhThuNgayDAO.Instance.CapNhat(dtn, maDTN); }
public void Them(DoanhThuNgay dtn) { DoanhThuNgayDAO.Instance.Them(dtn); }
public void Xoa(DoanhThuNgay dtn) { var result = db.Delete_DoanhThuNgay(dtn.madtngay); }
public void CapNhat(DoanhThuNgay dtn, string maDTN) { var result = db.Update_DoanhThuNgay(maDTN, dtn.mapx, dtn.tenvengay, dtn.ngay, dtn.soluongveloai1, dtn.soluongveloai2, dtn.soluongveloai3, dtn.dtngay); }
public void Them(DoanhThuNgay dtn) { var result = db.Insert_DoanhThuNgay(dtn.mapx, dtn.tenvengay, dtn.ngay, dtn.soluongveloai1, dtn.soluongveloai2, dtn.soluongveloai3, dtn.dtngay); }