public FrmKiemKho(PhongTap phong = null) { InitializeComponent(); phongHienTai = phong != null ? phong : Login1.GetPhongHienTai(); dataGridView1.AutoGenerateColumns = false; loc(); }
internal static List<GoiTap> GetByPhong(PhongTap phongTap, int type) { using (var db = DBContext.GetContext()) { return db.GoiTap.Include(p => p.PhongTap). Where(p => p.PhongTap.MaPhongTap == phongTap.MaPhongTap && p.Type == type).ToList(); } }
internal static List<KhachLe> ThongKe(DateTime start, DateTime end, PhongTap phong, Models.NhanVien nhanVienHienTai, int mode) { using (var db = DBContext.GetContext()) { var ks = db.KhachLe.Include(k => k.NhanVien).Include(k=>k.NhanVien.PhongTap).Where(k => k.ThoiGian >= start && k.ThoiGian <= end); if (phong.MaPhongTap != -1) { ks = ks.Where(p => p.NhanVien.PhongTap.MaPhongTap == phong.MaPhongTap); } if (nhanVienHienTai.MaNhanVien != -1) { ks = ks.Where(h => h.NhanVien.MaNhanVien == nhanVienHienTai.MaNhanVien); } switch (mode) { case 1: ks = ks.Where(k => k.IsGYM); break; case 2: ks = ks.Where(k => !k.IsGYM); break; } ks = ks.OrderByDescending(d => d.ThoiGian); return ks.ToList(); } }
public FrmHangBanDuoc(NhanVien nhanVien = null, bool isNhap = false) { InitializeComponent(); nhanVienHienTai = nhanVien; //pnGrid.Dock = DockStyle.Fill; for (int i = 2010; i < 2250; i++) { cbbTheoThangNam.Items.Add(i); } IsNhap = isNhap; cbbTheoThangNam.SelectedIndex = cbbTheoThangThang.SelectedIndex = 0; phongHienTai = Login1.GetPhongHienTai(); DataFiller.fillNhanVienCombo(cbbNhanVien, phongHienTai.MaPhongTap, append: true); DataFiller.fillPhongCombo(cbbPhong, append: true); cbbPhong.SelectedValue = phongHienTai.MaPhongTap; cbbPhong.Enabled = cbbNhanVien.Enabled = nhanVien == null; //loadData(); loc(); if (IsNhap) { lblTitle.Text = "Thống kê nhập hàng"; pnTongTien.Visible = false; } if (nhanVien != null) { cbbNhanVien.Enabled = false; cbbNhanVien.SelectedValue = nhanVien.MaNhanVien; } }
private void simpleButton1_Click(object sender, EventArgs e) { dxErrorProvider1.ClearErrors(); if (txtTenPhong.Text == "") { dxErrorProvider1.SetIconAlignment(txtTenPhong, ErrorIconAlignment.MiddleRight); dxErrorProvider1.SetError(txtTenPhong, "Tên phòng không được trống"); txtTenPhong.Focus(); return; } if (txtDiaChi.Text == "") { dxErrorProvider1.SetIconAlignment(txtDiaChi, ErrorIconAlignment.MiddleRight); dxErrorProvider1.SetError(txtDiaChi, "Địa chỉ không được trống"); txtDiaChi.Focus(); return; } var tenMoi = txtTenPhong.Text.Trim(); var dcMoi = txtDiaChi.Text.Trim(); if (current == null) { current = new PhongTap() { TenPhongTap = tenMoi, DiaChi = dcMoi }; if (PhongTapController.Add(current) == CODE_RESULT_RETURN.ThanhCong) { DialogResult = DialogResult.OK; Close(); } else { MessageBox.Show("Có lỗi khi thêm"); } } else { current.TenPhongTap = tenMoi; current.DiaChi = dcMoi; if (PhongTapController.Update(current) == CODE_RESULT_RETURN.ThanhCong) { DialogResult = DialogResult.OK; } else { MessageBox.Show("Có lỗi khi cập nhật"); Close(); } } }
public FrmPhongTapEdit(PhongTap p = null) { InitializeComponent(); current = p; if (current != null) { btnOK.Text = "Cập nhật"; Text = "Chỉnh sửa phòng tập"; txtDiaChi.Text = current.DiaChi; txtTenPhong.Text = current.TenPhongTap; } }
void loc() { try { phongHienTai = (PhongTap)cbbPhong.SelectedItem; } catch { } var maPhong = phongHienTai != null ? phongHienTai.MaPhongTap : -1; try { DateTime start = new DateTime(), end = new DateTime(); if (rdTheoThang.Checked) { int month = int.Parse(cbbTheoThangThang.Text.ToString()); int year = int.Parse(cbbTheoThangNam.Text.ToString()); start = new DateTime(year, month, 1); end = start.AddMonths(1).AddDays(-1); } else if (rdTheoQuy.Checked) { int year = int.Parse(cbbTheoQuyNam.Text); switch (cbbTheoQuyQuy.SelectedIndex) { case 0: start = new DateTime(year, 1, 1); end = new DateTime(year, 3, 31); break; case 1: start = new DateTime(year, 4, 1); end = new DateTime(year, 6, 30); break; case 2: start = new DateTime(year, 7, 1); end = new DateTime(year, 9, 30); break; case 3: start = new DateTime(year, 10, 1); end = new DateTime(year, 12, 31); break; } } else if (rdTheoKhoangNgay.Checked) { start = dtpFrom.Value; end = dtpTo.Value; } List<ThongKeSoLuongModel> tks = SanPhamController.ThongKeSoLuong(); dataGridView1.DataSource = tks; } catch { } }
public static bool IsKhongRangBuoc(PhongTap g) { using (var db = DBContext.GetContext()) { var goiTap = db.GoiTap.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap); if (goiTap != null) return false; var nhanVien = db.NhanVien.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap); if (nhanVien != null) return false; var hoiVien = db.HoiVien.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap); if (hoiVien != null) return false; var sp = db.SanPham.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap); if (sp != null) return false; return true; } }
internal static CODE_RESULT_RETURN Add(PhongTap nv) { using (var context = DBContext.GetContext()) { try { var n1 = context.PhongTap.FirstOrDefault(n => n.MaPhongTap == nv.MaPhongTap); if (n1 == null) { context.PhongTap.Add(nv); context.SaveChanges(); return CODE_RESULT_RETURN.ThanhCong; } return CODE_RESULT_RETURN.MaTrung; } catch { return CODE_RESULT_RETURN.ThatBai; } } }
public FrmLichSuPhieuThu(NhanVien nhanVienTruyenVao = null) { InitializeComponent(); nhanVienHienTai = nhanVienTruyenVao; dataGridView1.AutoGenerateColumns = false; for (int i = 2010; i < 2250; i++) { cbbTheoThangNam.Items.Add(i); cbbTheoThangNam.SelectedIndex = 0; } cbbTheoThangThang.SelectedIndex = 0; phongHienTai = Login1.GetPhongHienTai(); DataFiller.fillPhongCombo(cbbPhong, append:true); if (nhanVienTruyenVao != null) { cbbNhanVien.SelectedValue = nhanVienTruyenVao.MaNhanVien; cbbNhanVien.Enabled = cbbPhong.Enabled = false; } //loadData(); loc(); // loadEnable(); }
internal static CODE_RESULT_RETURN Update(PhongTap hv) { using (var db = DBContext.GetContext()) { var hvc = db.PhongTap.FirstOrDefault(h => h.MaPhongTap == hv.MaPhongTap); if (hvc != null) { hvc.DiaChi = hv.DiaChi; hvc.TenPhongTap = hv.TenPhongTap; db.SaveChanges(); return CODE_RESULT_RETURN.ThanhCong; } return CODE_RESULT_RETURN.ThatBai; } }
void loc() { //var maPhong =Convert.ToInt32( cbbPhong.SelectedItem); try { phongHienTai = (PhongTap)cbbPhong.SelectedItem; } catch { } allPhieuThu = PhieuThuController.GetList(phongHienTai.MaPhongTap, nhanVienHienTai); try { DateTime start = new DateTime(), end = new DateTime(); if (rdTheoThang.Checked) { int month = int.Parse(cbbTheoThangThang.Text.ToString()); int year = int.Parse(cbbTheoThangNam.Text.ToString()); start = new DateTime(year, month, 1); end = start.AddMonths(1).AddDays(-1); } else if (rdTheoKhoangNgay.Checked) { start =DateTimeUtil.StartOfDay( dtpFrom.Value); end = DateTimeUtil.EndOfDay( dtpTo.Value); } List<PhieuThu> li = new List<PhieuThu>(); li = allPhieuThu.Where(h => h.NgayLap.CompareTo(start) >= 0 && h.NgayLap.CompareTo(end) <= 0).ToList(); dataGridView1.DataSource = li; lblTongTien.Text = li.Sum(c => c.TienSauGiam).ToString().FormatCurrency()+" đ"; } catch { } }
internal static List<HoiVien> GetDangKyNhanhTrongNgay(PhongTap p) { var dauNgay = DateTimeUtil.StartOfDay(DateTime.Now); var cuoiNgay = DateTimeUtil.EndOfDay(DateTime.Now); using (var db = DBContext.GetContext()) { var hs =db.HoiVien.Include(h=>h.PhongTap).Include(h=>h.DanhSachPhieuThu).Where(h=> //h.IsDangKyNhanh //&& h.PhongTap.MaPhongTap == p.MaPhongTap && h.NgayGioDangKy >= dauNgay && h.NgayGioDangKy <=cuoiNgay).OrderByDescending(d=>d.NgayGioDangKy).ToList(); return hs; } }
//internal static List<ThongKeSanPhamModel> ThongKeMuaVaoBanRa(DateTime start, DateTime end, int maPhong = -1, NhanVien nhanVienHienTai = null) { // List<ThongKeSanPhamModel> li = new List<ThongKeSanPhamModel>(); // using (var db = DBContext.GetContext()) // { // var tatCaNhanVien = db.NhanVien; // // foreach (var nv in tatCaNhanVien) { // var kq = from nv in db.NhanVien // group nv by nv.MaNhanVien into groupNV // select new { // groupNV.ToList() // }; // // } // foreach (var t in kq) { // ThongKeSanPhamModel model = new ThongKeSanPhamModel() { // NhanVien = t. // }; // } // } //} internal static List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel> ThongKeSoLuong(PhongTap phong) { List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel> li = new List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel>(); using (var db = DBContext.GetContext()) { var hh = db.SanPham.ToList(); var allChiTiet = db.ChiTietHoaDon.Include(c => c.HoaDon).Select(c => c.SanPham); foreach (var sp in hh) { GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel model = new GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel(); model.SanPham = sp; model.SoBan = db.ChiTietHoaDon.Where(c => !c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong); model.TienBan = db.ChiTietHoaDon.Where(c => !c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong * c.Gia); model.SoNhap = db.ChiTietHoaDon.Where(c => c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong); model.TienNhap = db.ChiTietHoaDon.Where(c => c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong * c.Gia); li.Add(model); } return li; } }
void loc() { //var maPhong =Convert.ToInt32( cbbPhong.SelectedItem); try { phongHienTai = (PhongTap)cbbPhong.SelectedItem; } catch { } var maPhong = phongHienTai != null ? phongHienTai.MaPhongTap : -1; //allHoaDon = HoaDonController.GetList(phongHienTai.MaPhongTap, nhanVienHienTai); try { DateTime start = new DateTime(), end = new DateTime(); if (rdTheoThang.Checked) { int month = int.Parse(cbbTheoThangThang.Text.ToString()); int year = int.Parse(cbbTheoThangNam.Text.ToString()); start = new DateTime(year, month, 1); end = start.AddMonths(1).AddDays(-1); } else if (rdTheoKhoangNgay.Checked) { start = DateTimeUtil.StartOfDay(dtpFrom.Value); end = DateTimeUtil.EndOfDay(dtpTo.Value); } //List<HoaDon> li = new List<HoaDon>(); //li = allPhieuThu.Where(h => h.NgayLap.CompareTo(start) >= 0 && h.NgayLap.CompareTo(end) <= 0).ToList(); allThongKe = SanPhamController.ThongKeMuaVaoBanRa(start, end, maPhong, nhanVienHienTai, IsNhap); lblTongTien.Text = allThongKe.Sum(c => c.TongTien).ToString().FormatCurrency(); pnGrid.Controls.Clear(); if (IsNhap) { var grid = new UcGridHangNhap(); grid.Dock = DockStyle.Fill; pnGrid.Controls.Add(grid); grid.dataGridView1.DataSource = allThongKe; } else { var grid = new UcGridHangBan(); grid.Dock = DockStyle.Fill; pnGrid.Controls.Add(grid); grid.dataGridView1.DataSource = allThongKe; } } catch { } }