// GET: Admin/QuanLy
public ActionResult Index()
{
BaoCaoModel baocao = new BaoCaoModel();
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
//Lay so sp da ban
int soSPDaBanHomNay = baocao.GetSoSPBanTaiQuanTrongNgay(day, month, year) + baocao.GetSoSPBanOnlineTrongNgay(day, month, year);
ViewBag.SoSPDaBanHomNay = soSPDaBanHomNay;
//Lay doanh thu 1 ngay
ViewBag.TongThuHomNay = baocao.GetTongThu1Ngay(day, month, year);
ViewBag.TongChiHomNay = baocao.GetTongChi1Ngay(day, month, year);
int soDonChuaXacNhan = baocao.GetSoDDHChuaXacNhanTrongNgay(day, month, year);
ViewBag.SoDonChuaXacNhan = soDonChuaXacNhan;
ViewBag.SoTienThuTaiQuan = baocao.GetTongThuTaiQuan1Ngay(day, month, year);
ViewBag.SoTienThuOnline = baocao.GetTongThuOnline1Ngay(day, month, year);
ViewBag.SoTienThuKhac = baocao.GetTongThuKhac1Ngay(day, month, year);
ViewBag.TongThuBuoiTrua = baocao.GetTongThuBuoiTrua1Ngay(day, month, year);
ViewBag.TongThuBuoiToi = baocao.GetTongThuBuoiToi1Ngay(day, month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetChiNhapNguyenLieu1Ngay(day, month, year);
ViewBag.ChiNhapDungCu = baocao.GetChiNhapDungCu1Ngay(day, month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetChiNhapNuocGiaiKhat1Ngay(day, month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetChiTraLuongNhanVien1Ngay(day, month, year);
ViewBag.ChiKhac = baocao.GetChiKhac1Ngay(day, month, year);
return(View());
}
// GET: Admin/BaoCaoThuChi
public ActionResult Index(string thang, string nam)
{
int month;
int year;
try
{
month = Int32.Parse(thang);
year = Int32.Parse(nam);
}
catch { return(null); }
//Viewbag
List <int> dataChiThang = new List <int>();
List <int> dataThuThang = new List <int>();
List <int> dataDoanhThuThang = new List <int>();
//Lay du lieu tung ngay
BaoCaoModel baocao = new BaoCaoModel();
for (int i = 1; i <= DateTime.DaysInMonth(year, month); i++)
{
int chi = -baocao.GetTongChi1Ngay(i, month, year);
int thu = baocao.GetTongThu1Ngay(i, month, year);
dataChiThang.Add(chi);
dataThuThang.Add(thu);
dataDoanhThuThang.Add(thu + chi);
}
ViewBag.BaoCaoChiThang = dataChiThang;
ViewBag.BaoCaoThuThang = dataThuThang;
ViewBag.BaoCaoDoanhThuThang = dataDoanhThuThang;
ViewBag.Thang = thang;
ViewBag.Nam = nam;
//LAY so ngay can hien thi
int soNgayCanHienThi = 1;
if (month == DateTime.Now.Month && year == DateTime.Now.Year)
{
soNgayCanHienThi = DateTime.Now.Day;
}
else
{
soNgayCanHienThi = DateTime.DaysInMonth(year, month);
}
ViewBag.SoNgayCanHienThi = soNgayCanHienThi;
//Lay bao cao tong doanh thu
ViewBag.ThuBanHangTaiQuan = baocao.GetTongThuBanHangTaiQuan1Thang(month, year);
ViewBag.ThuBanHangTrenWeb = baocao.GetTongThuBanHangTrenWeb1Thang(month, year);
ViewBag.ThuKhac = baocao.GetTongThuKhac(month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetTongChiNhapNguyenLieu(month, year);
ViewBag.ChiNhapDungCu = baocao.GetTongChiNhapDungCu(month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetTongChiNhapNuocGiaiKhat(month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetTongChiTraLuongNhanVien(month, year);
ViewBag.ChiKhac = baocao.GetTongChiKhac(month, year);
return(View());
}
// GET: Admin/BaoCaoBanHang
public ActionResult Index(string thang, string nam)
{
int month;
int year;
try
{
month = Int32.Parse(thang);
year = Int32.Parse(nam);
}
catch { return(null); }
List <int> dataSanPhamDaBanOnline = new List <int>(); //Lay du lieu tung ngay
List <int> dataSanPhamDaBanTaiQuan = new List <int>(); //Lay du lieu tung ngay
List <int> dataTongSanPhamDaBan = new List <int>(); //Lay du lieu tung ngay
BaoCaoModel baocao = new BaoCaoModel();
for (int i = 1; i <= DateTime.DaysInMonth(year, month); i++)
{
int soSPBanOnline = baocao.GetSoSPBanOnlineTrongNgay(i, month, year);
int soSPBanTaiQuan = baocao.GetSoSPBanTaiQuanTrongNgay(i, month, year);
dataSanPhamDaBanOnline.Add(soSPBanOnline);
dataSanPhamDaBanTaiQuan.Add(soSPBanTaiQuan);
dataTongSanPhamDaBan.Add(soSPBanOnline + soSPBanTaiQuan);
}
ViewBag.BaoCaoSoSanPhamBanOnlineCuaThang = dataSanPhamDaBanOnline;
ViewBag.BaoCaoSoSanPhamBanTaiQuanCuaThang = dataSanPhamDaBanTaiQuan;
ViewBag.BaoCaoSoSanPhamDaBanCuaThang = dataTongSanPhamDaBan;
ViewBag.Thang = thang;
ViewBag.Nam = nam;
//LAY so ngay can hien thi
int soNgayCanHienThi = 1;
if (month == DateTime.Now.Month && year == DateTime.Now.Year)
{
soNgayCanHienThi = DateTime.Now.Day;
}
else
{
soNgayCanHienThi = DateTime.DaysInMonth(year, month);
}
ViewBag.SoNgayCanHienThi = soNgayCanHienThi;
//Lay BXH MONAN TRONG THANG
//ViewBag.BXHMONAN = baocao.GetBXHMONANTrongThang(month,year);
//ViewBag.BXHNGK = baocao.GetBXHNGKTrongThang(month, year);
//LAY BXH NUOCGIAIKHAT TRONG THANG
return(View());
}
// GET: Admin/BaoCaoHangNgay
public ActionResult Index(string ngay, string thang, string nam)
{
int day;
int month;
int year;
try
{
day = Int32.Parse(ngay);
month = Int32.Parse(thang);
year = Int32.Parse(nam);
}
catch { return(null); }
BaoCaoModel baocao = new BaoCaoModel();
//Lay so sp da ban
int soSPDaBanHomNay = baocao.GetSoSPBanTaiQuanTrongNgay(day, month, year) + baocao.GetSoSPBanOnlineTrongNgay(day, month, year);
ViewBag.SoSPDaBanHomNay = soSPDaBanHomNay;
//Lay doanh thu 1 ngay
ViewBag.TongThuHomNay = baocao.GetTongThu1Ngay(day, month, year);
ViewBag.TongChiHomNay = baocao.GetTongChi1Ngay(day, month, year);
int soDonChuaXacNhan = baocao.GetSoDDHChuaXacNhanTrongNgay(day, month, year);
ViewBag.SoDonChuaXacNhan = soDonChuaXacNhan;
ViewBag.SoTienThuTaiQuan = baocao.GetTongThuTaiQuan1Ngay(day, month, year);
ViewBag.SoTienThuOnline = baocao.GetTongThuOnline1Ngay(day, month, year);
ViewBag.SoTienThuKhac = baocao.GetTongThuKhac1Ngay(day, month, year);
ViewBag.TongThuBuoiTrua = baocao.GetTongThuBuoiTrua1Ngay(day, month, year);
ViewBag.TongThuBuoiToi = baocao.GetTongThuBuoiToi1Ngay(day, month, year);
ViewBag.ChiNhapNguyenLieu = baocao.GetChiNhapNguyenLieu1Ngay(day, month, year);
ViewBag.ChiNhapDungCu = baocao.GetChiNhapDungCu1Ngay(day, month, year);
ViewBag.ChiNhapNuocGiaiKhat = baocao.GetChiNhapNuocGiaiKhat1Ngay(day, month, year);
ViewBag.ChiTraLuongNhanVien = baocao.GetChiTraLuongNhanVien1Ngay(day, month, year);
ViewBag.ChiKhac = baocao.GetChiKhac1Ngay(day, month, year);
ViewBag.Ngay = ngay;
ViewBag.Thang = thang;
ViewBag.Nam = nam;
return(View());
}
public void loadDataQuy(Int32 current)
{
var y = txtNam.Text;
var q = txtQuy.SelectedItem.ToString().ToQuy(y);
currentModel.startTime = q.StartTime;
currentModel.endTime = q.EndTime;
currentModel = controller.GetData(current, currentModel);
//-------------------------------
dataGridView.DataSource = new BindingSource {
DataSource = currentModel.Hoadonnhap
};
dataGridView.Columns["ID"].Display(false);
dataGridView.Columns["NhaCungCapID"].Display(false);
dataGridView.Columns["NhaCungCap"].Display(false);
dataGridView.Columns["NhanVienID"].Display(false);
dataGridView.Columns["NhanVien"].Display(false);
}
public BaoCaoView(IBaoCaoController <BaoCaoModel> value)
{
controller = value;
InitializeComponent();
bntLuaChon.Enabled = false;
bntXoa.Enabled = false;
var a = new List <DropdownList>
{
new DropdownList {
ID = 0, Value = "..Lựa chọn báo cáo..."
},
new DropdownList {
ID = 1, Value = "Sản phẩm tồn kho"
},
new DropdownList {
ID = 2, Value = "Tổng tiền nhập hàng theo quý"
},
new DropdownList {
ID = 3, Value = "Tổng tiền bán hàng của một nhân viên"
},
new DropdownList {
ID = 4, Value = "Tổng tiền 3 khách hàng mua nhiều nhất"
}
};
currentModel = new BaoCaoModel();
var b = new BindingSource();
b.DataSource = a;
cbbBaoCao.DataSource = b;
cbbBaoCao.DisplayMember = "Value";
cbbBaoCao.ValueMember = "ID";
cbbBaoCao.SelectedValueChanged += new System.EventHandler(comboBox1_SelectedValueChanged);
label1.Visible = false;
label2.Visible = false;
label3.Visible = false;
txtNam.Visible = false;
txtQuy.Visible = false;
txtMaNhanVien.Visible = false;
txtNam.Text = "2016";
}
private void button1_Click(object sender, EventArgs e)
{
if (cbbBaoCao.SelectedValue != null)
{
var current = cbbBaoCao.SelectedValue.ToInt32();
dataGridView.Columns.Clear();
if (current == 1)
{
// todo: Sản phẩm tồn kho
currentModel = controller.GetData(current, currentModel);
dataGridView.DataSource = new BindingSource {
DataSource = currentModel.Sanpham
};
dataGridView.Columns["ID"].Display(false);
dataGridView.Columns["TheLoaiID"].Display(false);
dataGridView.Columns["KichCoID"].Display(false);
dataGridView.Columns["ChatLieuID"].Display(false);
dataGridView.Columns["MauID"].Display(false);
dataGridView.Columns["DoiTuongID"].Display(false);
dataGridView.Columns["MuaID"].Display(false);
dataGridView.Columns["NuocSanXuatID"].Display(false);
dataGridView.Columns["TheLoai"].Display(false);
dataGridView.Columns["KichCo"].Display(false);
dataGridView.Columns["ChatLieu"].Display(false);
dataGridView.Columns["Mau"].Display(false);
dataGridView.Columns["DoiTuong"].Display(false);
dataGridView.Columns["Mua"].Display(false);
dataGridView.Columns["NuocSanXuat"].Display(false);
}
else if (current == 2)
{
// todo: Tổng tiền nhập hàng theo quý
loadDataQuy(current);
}
else if (current == 3)
{
// todo: Tổng tiền bán hàng của một nhân viên
currentModel.MaNhanVien = txtMaNhanVien.Text;
currentModel = controller.GetData(current, currentModel);
//------
dataGridView.DataSource = new BindingSource {
DataSource = currentModel.Hoadonban
};
dataGridView.Columns["ID"].Display(false);
dataGridView.Columns["KhachHangID"].Display(false);
dataGridView.Columns["KhachHang"].Display(false);
dataGridView.Columns["NhanVienID"].Display(false);
dataGridView.Columns["NhanVien"].Display(false);
}
else if (current == 4)
{
// todo: Tổng tiền 3 khách hàng mua nhiều nhất
currentModel.TopBuy = 3;
currentModel = controller.GetData(current, currentModel);
//------
dataGridView.DataSource = new BindingSource {
DataSource = currentModel.Hoadonban
};
dataGridView.Columns["ID"].Display(false);
dataGridView.Columns["KhachHangID"].Display(false);
dataGridView.Columns["KhachHang"].Display(false);
dataGridView.Columns["NhanVienID"].Display(false);
dataGridView.Columns["NhanVien"].Display(false);
dataGridView.Columns["MaNV"].Display(false);
dataGridView.Columns["SoHDB"].Display(false);
if (dataGridView.Columns["MaKhach"] != null)
{
dataGridView.Columns["MaKhach"].DisplayIndex = 0;
}
if (dataGridView.Columns["TongTien"] != null)
{
dataGridView.Columns["TongTien"].DisplayIndex = 1;
}
}
else
{
// todo: clear
}
dataGridView.ClearSelection();
dataGridView.CurrentCell = null;
}
}
