private void btnThongKe_Click(object sender, EventArgs e)
{
if (rbtnNhanVienSapNghiHuu.Checked == true)
dgrThongKeSinhNhat.DataSource = ThongKeDAO.ThongKeNghiHuu(DateTime.Now);
else
dgrThongKeSinhNhat.DataSource = ThongKeDAO.ThongKeNVMoi(DateTime.Now);
}
private void LayDuLieuVaoGridView()
{
ThongKeDAO thongKeDAO = new ThongKeDAO();
GridView1.DataSource = thongKeDAO.ThongKeTrongNgay(DateTime.Now.ToShortDateString());
GridView1.DataBind();
}
public void tongdoanhthutrongngay()
{
ThongKeDAO thongKeDAO = new ThongKeDAO();
int tongtien = thongKeDAO.GetTongTienTrongNgay(DateTime.Now.ToShortDateString());
lblTongSoTien.Text = "Tổng số doanh thu là: " + tongtien.ToString() + " đồng";
}
private void simpleButton5_Click(object sender, EventArgs e)
{
int idnv = (int)cboNhanVien.SelectedValue;
int thang = cboThang.SelectedIndex + 1;
list.DataSource = ThongKeDAO.LoadChamCong(idnv, thang);
}
public static string DemNhanKhauTamTru(string column, string gioiHan = "", string giaTri = "", bool coCuTru = true)
{
gioiHan = string.IsNullOrEmpty(gioiHan) ? "" : " AND TIMESTAMPDIFF(MONTH, nhankhautamtru.tungay, CURDATE())<=" + gioiHan;
//" AND MONTH(DATEDIFF(CURDATE(), nhankhautamtru.tungay))<=" + gioiHan;
//" AND MONTH(nhankhautamtru.tungay)=MONTH(DATE_SUB(CURDATE(), INTERVAL -" + gioiHan + " MONTH)) AND YEAR(nhankhautamtru.tungay)=YEAR(DATE_SUB(CURDATE(), INTERVAL -" + gioiHan + " MONTH))";
return(ThongKeDAO.demNhanKhauTamTru(column, gioiHan, giaTri, coCuTru));
}
public JsonResult ThongKe()
{
//int today = DateTime.Today.Day;
//int month = DateTime.Today.Month;
//int year = DateTime.Today.Year;
string tenthongke = "Tháng " + DateTime.Now.Month.ToString();
string thoigian = DateTime.Now.ToString("MM/dd/yyyy");
var dao = new HoaDonDAO();
double tongthu = 0;
tongthu = dao.GetHoaDon_TongGia_TrangThaiChua();
var daothongke = new ThongKeDAO();
int result = daothongke.CreateThongKe(tenthongke, thoigian, tongthu);
if (result != 0)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
private void LayDuLieuVaoGridView2()
{
string ngaybatdau = txtSelectDateFirst.Text;
string ngayketthuc = txtSelectDateLast.Text;
ThongKeDAO thongKeDAO = new ThongKeDAO();
GridView1.DataSource = thongKeDAO.ThongKeTuyChon(ngaybatdau, ngayketthuc);
GridView1.DataBind();
}
public void tongdoanhthutuychon()
{
string ngaybatdau = txtSelectDateFirst.Text;
string ngayketthuc = txtSelectDateLast.Text;
ThongKeDAO thongKeDAO = new ThongKeDAO();
int tongtien = thongKeDAO.GetTongTienTuyChon(ngaybatdau, ngayketthuc);
lblTongSoTien.Text = "Tổng số doanh thu là: " + tongtien.ToString() + " đồng";
}
public ucThongKeLuotThueTheoGio()
{
InitializeComponent();
chartThongKe.DataSource = ThongKeDAO.ThongKeLuotThueTheoGio(GlobalVar.dateFrom, GlobalVar.dateTo);
chartThongKe.ChartAreas["ChartArea1"].AxisX.Title = "Giờ";
chartThongKe.ChartAreas["ChartArea1"].AxisY.Title = "Lượt thuê";
chartThongKe.Series["Lượt thuê"].XValueMember = "hour";
chartThongKe.Series["Lượt thuê"].YValueMembers = "LuotThue";
//chartThongKe.ChartAreas[0].AxisY.Maximum = 20;
chartThongKe.ChartAreas[0].AxisY.Minimum = 0;
}
private void btnThongKeChucVu_Click(object sender, EventArgs e)
{
try
{
int idcv = (int)cboChucVu.SelectedValue;
dgrThongKeSinhNhat.DataSource = ThongKeDAO.ThongKeNVTheoChucVu(idcv);
}
catch
{
return;
}
}
private void btnThongKePhongBan_Click(object sender, EventArgs e)
{
try
{
int idpb = (int)cboPhongBan.SelectedValue;
dgrThongKeSinhNhat.DataSource = ThongKeDAO.ThongKeNVTheoPhongBan(idpb);
}
catch
{
return;
}
}
private void cboThongKe_Click(object sender, EventArgs e)
{
try
{
int thang = (int)cboThang.SelectedIndex + 1;
dgrThongKeSinhNhat.DataSource = ThongKeDAO.ThongKeSinhNhat(thang);
}
catch
{
return;
}
}
public ucTKDT_TheoLoaiPhong()
{
InitializeComponent();
chartThongKe.DataSource = ThongKeDAO.ThongKeDoanhThuTheoLoaiPhong(GlobalVar.dateFrom, GlobalVar.dateTo);
//chartThongKe.ChartAreas["ChartArea1"].AxisX.Title = "Loại phòng";
//chartThongKe.ChartAreas["ChartArea1"].AxisY.Title = "VND";
//chartThongKe.Series["Doanh Thu (VND)"]["PixelPointWidth"] = "30";
//chartThongKe.Series["Doanh Thu (VND)"].IsValueShownAsLabel = true;
chartThongKe.Series["Doanh Thu (VND)"].XValueMember = "TenLoai";
chartThongKe.Series["Doanh Thu (VND)"].YValueMembers = "DoanhThu";
chartThongKe.Series[0].Label = "#VALX: #VALY (#PERCENT{P0})";
//chartThongKe.Series[0].Label = "#VALX";
}
private void cboNhanVien_SelectedValueChanged(object sender, EventArgs e)
{
try
{
int idnv = (int)cboNhanVien.SelectedValue;
int thang = cboThang.SelectedIndex + 1;
list.DataSource = ThongKeDAO.LoadChamCong(idnv, thang);
}
catch
{
return;
}
}
public void ThongKe_SanPhamBanChay(ThongKeDate tkDate)
{
List <SanPhamBanChay> results = new ThongKeDAO().getSanPhamBanChay(tkDate);
cbx_spbc_fromYear.Text = tkDate.fromYear.ToString();
cbx_spbc_fromMonth.Text = tkDate.fromMonth.ToString();
cbx_spbc_toYear.Text = tkDate.toYear.ToString();
cbx_spbc_toMonth.Text = tkDate.toMonth.ToString();
dgv_spbc.DataSource = results;
//GridView gv_spbc = dgv_spbc.MainView as GridView;
//for (int i = 0; i < results.Count(); i++)
//{
// gv_spbc.SetRowCellValue(i, "STT", (i+1).ToString());
//}
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
int idcc = Convert.ToInt32(grvChamCong.GetFocusedDataRow()["CHAMCONGID"].ToString());
int idnv = (int)cboNhanVien.SelectedValue;
if (ThongKeDAO.DeleteChamCong(idcc) == 1)
{
MessageBox.Show("thành công");
}
else
{
MessageBox.Show("thất bại");
}
list.DataSource = ThongKeDAO.LoadChamCong(idnv, cboThang.SelectedIndex + 1);
}
catch
{
return;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
int idnv = (int)cboNhanVien.SelectedValue;
DateTime ngay = dtpNgay.DateTime;
int loai = cboLoai.SelectedIndex;
if (ThongKeDAO.InsertChamCong(idnv, ngay, loai) == 1)
{
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
list.DataSource = ThongKeDAO.LoadChamCong(idnv, cboThang.SelectedIndex + 1);
}
catch
{
return;
}
}
public void ThongKe_TheoNam(ThongKeDate tkDate)
{
List <THONGKE> tkList = new ThongKeDAO().getThongKe(tkDate);
for (int i = 1; i <= 12; i++)
{
DateTime from = new DateTime(tkDate.toYear, i, 1);
DateTime to;
if (i < 12)
{
to = new DateTime(tkDate.toYear, i + 1, 1);
}
else
{
to = new DateTime(tkDate.toYear + 1, 1, 1);
}
int doanhthu = tkList.Where(p => p.NGAY >= from && p.NGAY < to).Select(p => p.DOANHTHU).ToList().Sum();
int loinhuan = tkList.Where(p => p.NGAY >= from && p.NGAY < to).Select(p => p.LOINHUAN).ToList().Sum();
//this.Controls["txt_dt" + i].Text = doanhthu.ToString();
//this.Controls["txt_ln" + i].Text = loinhuan.ToString();
this.Controls.Find("txt_dt" + i, true).FirstOrDefault().Text = string.Format("{0:0,0} VNĐ", doanhthu);
this.Controls.Find("txt_ln" + i, true).FirstOrDefault().Text = string.Format("{0:0,0} VNĐ", loinhuan);
}
}
public static double SumSL_theongay(PhieuNhapDTO pn1, PhieuNhapDTO pn2)
{
return(ThongKeDAO.SumSL_theongay(pn1, pn2));
}
private void btnPhanTich_Click(object sender, EventArgs e)
{
if (cboNam.Text == "" || cboXuatNhap.Text == "")
{
MessageBox.Show("Mời bạn nhập đủ thông tin");
return;
}
chartThongKe.Series.Clear();
var series = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Thang",
Color = Color.Green,
IsVisibleInLegend = true,
IsXValueIndexed = true,
ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column
};
chartThongKe.Series.Add(series);
DataTable dt;
string[] hang;
if (cboXuatNhap.Text == "Xuất kho")
{
dt = ThongKeDAO.TongTienXuatTungThang(int.Parse(cboNam.Text));
hang = ThongKeDAO.HangHoaXuatNhieuItNhatNam(int.Parse(cboNam.Text)).Split('|');
}
else
{
dt = ThongKeDAO.TongTienNhapTungThang(int.Parse(cboNam.Text));
hang = ThongKeDAO.HangHoaNhapNhieuItNhatNam(int.Parse(cboNam.Text)).Split('|');
}
lblMatHangUaChuongNhat.Text = "Mặt hàng ưa chuộng nhất : " + hang[1];
lblMatHangItQuanTam.Text = "Mặt hàng ít được quan tâm nhất : " + hang[0];
int[] thang = new int[13];
int sum = 0;
int min = int.MaxValue;
int max = int.MinValue;
int imin = 0;
int imax = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
int t = int.Parse(dt.Rows[i][1].ToString());
int index = int.Parse(dt.Rows[i][0].ToString());
thang[index] = t;
sum += t;
if (min > t)
{
min = t;
imin = index;
}
if (max < t)
{
max = t;
imax = index;
}
}
for (int i = 0; i <= 12; i++)
{
series.Points.AddXY(i, thang[i]);
}
chartThongKe.Invalidate();
lblTongTienNam.Text += sum;
lblThangNhieuNhat.Text += imax;
lblThangThapNhat.Text += imin;
}
public static DataTable Load_TheoNgayLapHD(HoaDonDTO hd1, HoaDonDTO hd2)
{
return(ThongKeDAO.Load_TheoNgayLapHD(hd1, hd2));
}
public static double SumGTHD()
{
return(ThongKeDAO.SumGTHD());
}
public static double SumGTHD_theongay(HoaDonDTO hd1, HoaDonDTO hd2)
{
return(ThongKeDAO.SumGTHD_theongay(hd1, hd2));
}
public static string Dem1bang(string column, string aTable, string aGioiHan)
{
return(ThongKeDAO.dem1Bang(column, aTable, aGioiHan));
}
public void BieuDo(ThongKeDate tkDate)
{
cbx_chart_fromMonth.Text = tkDate.fromMonth.ToString();
cbx_chart_fromYear.Text = tkDate.fromYear.ToString();
cbx_chart_toMonth.Text = tkDate.toMonth.ToString();
cbx_chart_toYear.Text = tkDate.toYear.ToString();
List <THONGKE> tkList = new ThongKeDAO().getThongKe(tkDate);
splitContainerControl2.Panel2.Controls.Clear();
// Create a new chart.
ChartControl lineChart = new ChartControl();
// Create a line series.
Series doanhthu_series = new Series("Doanh Thu", ViewType.Line);
Series loinhuan_series = new Series("Lợi Nhuận", ViewType.Line);
// Add points to it.
for (int year = tkDate.fromYear; year <= tkDate.toYear; year++)
{
for (int month = 1; month <= 12; month++)
{
DateTime from = new DateTime(tkDate.toYear, month, 1);
DateTime to;
if (month < 12)
{
to = new DateTime(tkDate.toYear, month + 1, 1);
}
else
{
to = new DateTime(tkDate.toYear + 1, 1, 1);
}
int doanhthu = tkList.Where(p => p.NGAY >= from && p.NGAY < to).Select(p => p.DOANHTHU).ToList().Sum();
int loinhuan = tkList.Where(p => p.NGAY >= from && p.NGAY < to).Select(p => p.LOINHUAN).ToList().Sum();
//this.Controls["txt_dt" + month].Text = doanhthu.ToString();
//this.Controls["txt_ln" + month].Text = loinhuan.ToString();
doanhthu_series.Points.Add(new SeriesPoint(new DateTime(year, month, 1), doanhthu));
loinhuan_series.Points.Add(new SeriesPoint(new DateTime(year, month, 1), loinhuan));
}
}
// Add the series to the chart.
lineChart.Series.Add(doanhthu_series);
lineChart.Series.Add(loinhuan_series);
// Set the numerical argument scale types for the series,
// as it is qualitative, by default.
doanhthu_series.ArgumentScaleType = ScaleType.DateTime;
loinhuan_series.ArgumentScaleType = ScaleType.DateTime;
// Access the view-type-specific options of the series.
((LineSeriesView)doanhthu_series.View).MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
((LineSeriesView)doanhthu_series.View).LineMarkerOptions.Kind = MarkerKind.Circle;
((LineSeriesView)doanhthu_series.View).LineStyle.DashStyle = DashStyle.Solid;
((LineSeriesView)loinhuan_series.View).MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
((LineSeriesView)loinhuan_series.View).LineMarkerOptions.Kind = MarkerKind.Circle;
((LineSeriesView)loinhuan_series.View).LineStyle.DashStyle = DashStyle.Solid;
// Access the type-specific options of the diagram.
((XYDiagram)lineChart.Diagram).EnableAxisXZooming = true;
((XYDiagram)lineChart.Diagram).EnableAxisXScrolling = true;
// Set maximum and minimum range of AxisX
((XYDiagram)lineChart.Diagram).AxisX.WholeRange.MinValue = new DateTime(tkDate.fromYear, tkDate.fromMonth, 1);
if (tkDate.toMonth < 12)
{
((XYDiagram)lineChart.Diagram).AxisX.WholeRange.MaxValue = new DateTime(tkDate.toYear, tkDate.toMonth + 1, 1);
}
else
{
((XYDiagram)lineChart.Diagram).AxisX.WholeRange.MaxValue = new DateTime(tkDate.toYear + 1, 1, 1);
}
// Set format of show value
lineChart.SeriesTemplate.CrosshairLabelPattern = "{S}: {V:F2}";
((XYDiagram)lineChart.Diagram).AxisY.Label.TextPattern = "{0:0,0} VNĐ";
// Show the legend (if necessary).
lineChart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
// Add a title to the chart (if necessary).
lineChart.Titles.Add(new ChartTitle());
lineChart.Titles[0].Text = "Biểu đồ thống kê";
// Add the chart to the form.
lineChart.Dock = DockStyle.Fill;
splitContainerControl2.Panel2.Controls.Add(lineChart);
}
public static double SumCTPN_theoma(PhieuNhapDTO pn1)
{
return(ThongKeDAO.SumCTPN_TheoMa(pn1));
}
public static string DemNhanKhauThuongTru(string column, string gioiHan = "", string giaTri = "", bool coCuTru = true)
{
gioiHan = string.IsNullOrEmpty(gioiHan) ? "" : " AND TIMESTAMPDIFF(MONTH, sohokhau.ngaycap, CURDATE())<=" + gioiHan;
return(ThongKeDAO.demNhanKhauThuongTru(column, gioiHan, giaTri, coCuTru));
}
public static double SumHD_theoma(HoaDonDTO hd)
{
return(ThongKeDAO.Sum_MaHD(hd));
}
public static string DemSoTamTru(string column, string gioiHan = "", bool coCuTru = true)
{
gioiHan = string.IsNullOrEmpty(gioiHan) ? "" : " AND TIMESTAMPDIFF(MONTH, sotamtru.ngaycap, CURDATE())<=" + gioiHan;
return(ThongKeDAO.demSoTamTru(column, gioiHan, coCuTru));
}
public static double SumPDH_theoma(PhieuDatHangDTO pdh)
{
return(ThongKeDAO.SumPDH_TheoMa(pdh));
}
