public static List <BCDoanhThuDTO> DoanhThuTheoLoaiPhongTheoThang(BCDoanhThuDTO infor) { DateTime ntm_min = Convert.ToDateTime("1990-01-01"); DateTime ntm_max = Convert.ToDateTime("1990-01-31"); string n1 = "-01"; string n2 = "-31"; string t = (infor.Thang).ToString(); string nam = (infor.Nam).ToString(); if (infor.Thang == 2) { if ((infor.Nam % 4 != 0) || ((infor.Nam % 100 == 0) && (infor.Nam % 400 != 0))) { n2 = "-28"; } else { n2 = "-29"; } } else if (infor.Thang == 4 || infor.Thang == 6 || infor.Thang == 9 || infor.Thang == 11) { n2 = "-30"; } string ntmold = nam + "-" + t + n1; string ntmnew = nam + "-" + t + n2; ntm_min = Convert.ToDateTime(ntmold); ntm_max = Convert.ToDateTime(ntmnew); return(BaoCaoDAO.DoanhThuTheoLoaiPhongTheoThang(ntm_min, ntm_max)); }
public ActionResult CT_BaoCao() { string ngayden = Request.Form["ngayden"]; string ngaydi = Request.Form["ngaydi"]; string[] arrngayden = ngayden.Split('-'); string[] arrngaydi = ngaydi.Split('-'); BaoCaoDAO baocao_dao = new BaoCaoDAO(); List <BaoCao> bc = new List <BaoCao>(); bc = baocao_dao.GetAllBaoCao(arrngayden[0], arrngayden[1], arrngaydi[1], arrngayden[2], arrngaydi[2]); ViewBag.baocao = bc; ViewBag.ngayden = ngayden; ViewBag.ngaydi = ngaydi; return(View("BaoCao")); }
public List <BaoCaoDTDTO> getBaoCaoDT(string thang, string nam) { BaoCaoDAO dao = new BaoCaoDAO(); return(dao.getBaoCaoDT(thang, nam)); }
public static List <BCDoanhThuDTO> TinhTongDoanhThuTheoLoaiPhong() { return(BaoCaoDAO.TinhTongDoanhThuTheoLoaiPhong()); }