public List <ThongKe> listThongKe(int maDeThi) { List <ThongKe> lst = new List <ThongKe>(); var d = from p in db.De_Hs where p.Ma_Chu_De == maDeThi group p by p.Nguoi_Lam; foreach (var item in d) { ThongKe obj = new ThongKe(); obj.userName = item.First().Nguoi_Lam; obj.lop = item.First().TaiKoan_H.lop; obj.SUM_TIME = int.Parse(item.First().DeThi.Thoi_Gian_Lam_Bai.ToString()); obj.THOI_GIAN_LAM = DateTime.Parse(item.First().Thoi_Gian.ToString()); int s = int.Parse(item.First().DeThi.SL_De.ToString()) + int.Parse(item.First().DeThi.SL_TrungBinh.ToString()) + int.Parse(item.First().DeThi.SL_Kho.ToString()); obj.SUM_CAUHOI = s; var d1 = db.De_Hs.Where(p => p.Ma_Chu_De == maDeThi && p.Nguoi_Lam == item.First().Nguoi_Lam).ToList(); int i = 0; foreach (var item1 in d1) { if (item1.Dap_An_HS.Equals(item1.Dap_An_Dung)) { i++; } } obj.SUM_DUNG = i; lst.Add(obj); } return(lst); }
// GET: Admin/ThongKeTinNhan public ActionResult Index() { ThongKe thongKe = new ThongKe(); List <CTTinNhan> cTTinNhans = thongKe.ChiTietTinNhan(Convert.ToInt32(Session["admin"])); return(View(cTTinNhans)); }
private void button6_Click(object sender, EventArgs e) { ThongKe thongKe = new ThongKe(); this.Hide(); thongKe.Show(); }
public ActionResult DonHang() { List <DONHANG> lstDonHangs = db.LayDSDonHangTheoLoai("DL"); ThongKe thongKe = new ThongKe(lstDonHangs); return(View(thongKe)); }
public IActionResult Index() { ThongKeBanHang(); ViewData["DoanhThu"] = new ThongKe() { tanggiam = MonthSaleSort(sumsale, sumlastsale), phantram = decimal.Parse(MonthSale(sumsale, sumlastsale).ToString("0.00")), solieu = sumsale, name = "Doanh thu", donvi = "đ", }; ViewData["DatHang"] = new ThongKe() { tanggiam = MonthSaleSort(countorder, countlastorder), phantram = decimal.Parse(MonthSale(countorder, countlastorder).ToString("0.00")), solieu = countorder, name = "Đặt hàng", donvi = "lượt", }; ViewData["Tài khoản hiện có"] = new ThongKe() { solieu = countkhachhang, name = "Tài khoản hiện có", donvi = "tài khoản", }; return(View()); }
public IHttpActionResult PutThongKe(int id, ThongKe thongKe) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != thongKe.id) { return(BadRequest()); } db.Entry(thongKe).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ThongKeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult ThongKeKH(string KH_ID, DateTime dau, DateTime cuoi) { ViewBag.KH = db.KHACHHANGs.ToList(); laygiatritrongthang(); ViewBag.dauthang = dau; ViewBag.cuoithang = cuoi; List <ThongKe> list = new List <ThongKe>(); if (string.IsNullOrEmpty(KH_ID)) { var TKKH = from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID select dn; foreach (var i in TKKH) { if (list.FirstOrDefault(sp => sp.KH_ID == i.KH_ID) == null) { var count = (from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID join ctdn in db.CHITIETDONHANGs on dn.DN_ID equals ctdn.DN_ID where dn.DN_NGALAPDON >= dau && dn.DN_NGALAPDON <= cuoi && kh.KH_ID == i.KH_ID select ctdn); ThongKe tk = new ThongKe() { KH_ID = i.KH_ID, KH_TEN = i.KHACHHANG.KH_TEN, TongTien = Convert.ToInt32(count.Sum(a => a.CHITIETSANPHAM.SANPHAM.GIASP.GIA_GIA)) }; list.Add(tk); } } } else { var TKKH = from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID where kh.KH_ID == KH_ID select dn; foreach (var i in TKKH) { if (list.FirstOrDefault(sp => sp.KH_ID == i.KH_ID) == null) { var count = (from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID join ctdn in db.CHITIETDONHANGs on dn.DN_ID equals ctdn.DN_ID where dn.DN_NGALAPDON >= dau && dn.DN_NGALAPDON <= cuoi && dn.KH_ID == KH_ID select ctdn); ThongKe tk = new ThongKe() { KH_ID = i.KH_ID, KH_TEN = i.KHACHHANG.KH_TEN, TongTien = Convert.ToInt32(count.Sum(a => a.CHITIETSANPHAM.SANPHAM.GIASP.GIA_GIA)) }; list.Add(tk); } } } return(View(list.OrderByDescending(sp => sp.TongTien).ToList())); }
public ActionResult DeleteConfirmed(int id) { ThongKe thongKe = db.ThongKe.Find(id); db.ThongKe.Remove(thongKe); db.SaveChanges(); return(RedirectToAction("Index")); }
private void btnThongKe_Click(object sender, EventArgs e) { panelContainer.Controls.Clear(); ThongKe uc = new ThongKe(); uc.Dock = DockStyle.Fill; panelContainer.Controls.Add(uc); }
private void dgPhieuThongKe_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dgPhieuThongKe.SelectedItem != null) { thongKeSelect = new ThongKe(); thongKeSelect = CThongKe.find(dgPhieuThongKe.SelectedValue.ToString()); } }
private void btnTrangChu_Click(object sender, EventArgs e) { this.pnlChucNang.Controls.Clear(); ThongKe FormThongKe = new ThongKe(); FormThongKe.TopLevel = false; this.pnlChucNang.Controls.Add(FormThongKe); FormThongKe.Show(); }
public static bool kiemTraThongTin(ThongKe thongKe) { if (thongKe.ngayLap.Value.ToString("dd/MM/yyyy") != DateTime.Now.ToString("dd/MM/yyyy")) { MessageBox.Show("Ngày lập phiếu thống kê phải là ngày hiện tại"); return(false); } return(true); }
public ActionResult Edit([Bind(Include = "id,ten,diaChi,SDT,email,soLanMuaHang")] ThongKe thongKe) { if (ModelState.IsValid) { db.Entry(thongKe).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(thongKe)); }
public frmQuanLyChiTietThongKe(ThongKe thongKe = null) { InitializeComponent(); thongKeSelect = thongKe; if (thongKeSelect != null) { hienThiThongKe(thongKeSelect); } }
private void barThongKe_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { ucTK = new ThongKe(); if (!pnmain.Controls.Contains(ucTK)) { pnmain.Controls.Add(ucTK); } ucTK.Dock = DockStyle.Fill; ucTK.BringToFront(); }
public IHttpActionResult GetThongKe(string value) { ThongKe thongKe = db.ThongKe.Where(p => p.SDT == value).FirstOrDefault(); if (thongKe == null) { return(NotFound()); } return(Ok(thongKe)); }
private void LoadChart() { DataTable dt = ThongKe.LoadDuLieu(); chart1.DataSource = dt; chart1.ChartAreas["ChartArea1"].AxisX.Title = "Tên Trang"; chart1.ChartAreas["ChartArea1"].AxisY.Title = "Số bài"; chart1.Series["Trang"].XValueMember = "NameRoot"; chart1.Series["Trang"].YValueMembers = "soluong"; }
public IHttpActionResult GetThongKe(int id) { ThongKe thongKe = db.ThongKe.Find(id); if (thongKe == null) { return(NotFound()); } return(Ok(thongKe)); }
public ActionResult Create([Bind(Include = "id,ten,diaChi,SDT,email,soLanMuaHang")] ThongKe thongKe) { if (ModelState.IsValid) { db.ThongKe.Add(thongKe); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(thongKe)); }
// GET: Admin/Home public ActionResult Index() { ThongKe thongKe = new ThongKe(); XLThongKe xLThongKe = thongKe.XuLyThongKe(Convert.ToInt32(Session["admin"])); Session["doanhsothang"] = xLThongKe.doanhsothang; Session["doanhsonam"] = xLThongKe.doanhsonam; Session["kyvong"] = xLThongKe.kyvong; Session["tongtinnhan"] = xLThongKe.tinnhan; return(View()); }
public bool UpdateTongSldTonKho(ThongKe tk) { bool isCheck = false; var result = thongKeDAL.sp_UPDATE_TONKHO(tk.Sld, tk.MaSp); if (result > 0) { isCheck = true; } return(isCheck); }
public DataTable TongSoLuongTonTheoMaSp(ThongKe tk) { var result = thongKeDAL.sp_HienThiTongSltTheoMaSp(tk.MaSp); DataTable table = new DataTable(); table.Columns.Add("TONGSLT", typeof(Int32)); foreach (sp_HienThiTongSltTheoMaSpResult sp in result) { table.Rows.Add(sp.TONGSLT); } return(table); }
public DataTable TonSldhTheoMaSp(ThongKe tk) { var result = thongKeDAL.sp_ThongKeTongSoDoDhTheoMaSp(tk.MaSp); DataTable table = new DataTable(); table.Columns.Add("SLDH", typeof(Int32)); foreach (sp_ThongKeTongSoDoDhTheoMaSpResult tong in result) { table.Rows.Add(tong.SLDH); } return(table); }
public DataTable TongSldhTheoNgayDh(ThongKe tk) { var result = thongKeDAL.sp_TinhTongSlDonDhTheoNgayDatHang(tk.DateOne, tk.DateTwo); DataTable table = new DataTable(); table.Columns.Add("SLDH", typeof(Int32)); foreach (sp_TinhTongSlDonDhTheoNgayDatHangResult dh in result) { table.Rows.Add(dh.SLDH); } return(table); }
public DataTable TongSldhTheoNhaSx(ThongKe tk) { var result = thongKeDAL.sp_TinhTongSlDonDhTheoNhaSx(tk.TenSx); DataTable table = new DataTable(); table.Columns.Add("SLDH", typeof(Int32)); foreach (sp_TinhTongSlDonDhTheoNhaSxResult dh in result) { table.Rows.Add(dh.SLDH); } return(table); }
public IHttpActionResult PostThongKe(ThongKe thongKe) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ThongKe.Add(thongKe); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = thongKe.id }, thongKe)); }
public List <ThongKe> ThongKeTonKhoTheoNgayThang(ThongKe tk) { var result = thongKeDAL.sp_ThongKeTonKhoTheoNgayThang(tk.DateOne, tk.DateTwo); List <ThongKe> list = new List <ThongKe>(); foreach (sp_ThongKeTonKhoTheoNgayThangResult ds in result) { list.Add(new ThongKe { MaSp = ds.MASP, TenSp = ds.TENSP, Sld = ds.TONGSLD, Sln = ds.TONGSLN, Slx = ds.TONGSLX, Slcl = ds.TONGSLT }); } return(list); }
public List <ThongKe> ThongKePHieuXuatTHeoNhaSx(ThongKe tk) { var result = thongKeDAL.sp_ThongKePhieuXuatTtheoNhaSx(tk.TenSx); List <ThongKe> list = new List <ThongKe>(); foreach (sp_ThongKePhieuXuatTtheoNhaSxResult tks in result) { list.Add(new ThongKe { MaSp = tks.MASP, TenSp = tks.TENSP, TenLoai = tks.TENLOAI, TenSx = tks.TENSX, TenKh = tks.TENKH, Slx = tks.SLX, TongTien = tks.TongTien, PhanTram = tks.PHANTRAM, ThanhTien = tks.THANHTIEN }); } return(list); }
public List <ThongKe> TinhTongThanhTienTheoNgayXuat(ThongKe tk) { var result = thongKeDAL.sp_TinhTongThanhTienPhieuXuatTheoNgayXuat(tk.DateOne, tk.DateTwo); List <ThongKe> list = new List <ThongKe>(); foreach (sp_TinhTongThanhTienPhieuXuatTheoNgayXuatResult pn in result) { list.Add(new ThongKe { ThanhTien = pn.Column1 }); } return(list); }
public List <ThongKe> TinhTongThanhTienTheoNhaSanXuat(ThongKe tk) { var result = thongKeDAL.sp_TinhhTongThanhTienPHieuXuatTheoNhaSx(tk.TenSx); List <ThongKe> list = new List <ThongKe>(); foreach (sp_TinhhTongThanhTienPHieuXuatTheoNhaSxResult pn in result) { list.Add(new ThongKe { ThanhTien = pn.Column1 }); } return(list); }