/* Add các ví lên flowLayoutPanel */ void addItem() { flowLayoutPanelNganSach.Controls.Clear(); listItem = new UserControlNganSach[listNganSachs.Count]; for (int i = 0; i < listItem.Length; i++) { DateTime DateTime = DateTime.Now; DateTime DateTimeKetThuc = DateTime.Parse(Commom.getDate(listNganSachs[i].NgayKetThuc)); TimeSpan interval = DateTimeKetThuc.Subtract(DateTime); if (interval.Days >= 0) { listItem[i] = new UserControlNganSach(this); listItem[i].ID = listNganSachs[i].MaLoaiGD; listItem[i].Vi = listNganSachs[i].MaVi; listItem[i].NgayBatDau = Commom.getDate(listNganSachs[i].NgayBatDau); listItem[i].NgayKetThuc = Commom.getDate(listNganSachs[i].NgayKetThuc); listItem[i].SoTien = listNganSachs[i].SoTien; listItem[i].SoTienConLai = getSoTienConLai(listNganSachs[i].MaVi, listNganSachs[i].MaLoaiGD, listNganSachs[i].SoTien).ToString(); listItem[i].NgayConLai = "Còn lại: " + interval.Days.ToString() + " ngày"; listItem[i].Img = listNganSachs[i].getImage(); } if (flowLayoutPanelNganSach.Controls.Count < 0) { flowLayoutPanelNganSach.Controls.Clear(); } else { flowLayoutPanelNganSach.Controls.Add(listItem[i]); } } }
public void GetData() { string query = @"SELECT so_tien, ngay_bat_dau, ngay_ket_thuc FROM NganSach WHERE ma_vi = " + iD_Vi + " AND ma_loai_gd = " + iD_Loai_Gd + ""; DB.conn.Open(); SqlCommand cmd = new SqlCommand(query, DB.conn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { llbSoTien.Text = Commom.getMoneyStr(rd[0].ToString()); llbNgayBD.Text = Commom.getDate(rd[1].ToString()); llbNgayKT.Text = Commom.getDate(rd[2].ToString()); } DB.conn.Close(); getLoaiGD(iD_Loai_Gd); getVi(iD_Vi); lbSoTienDaChi.Text = so_tien_da_chi; }
void getDataChartThuNhap() { // thu string query = @"SELECT SUM(GiaoDichTaiChinh.so_tien) AS 'so_tien', GiaoDichTaiChinh.thoi_gian FROM GiaoDichTaiChinh, LoaiGiaoDich,NhomGiaoDich,VI WHERE GiaoDichTaiChinh.ma_loai_gd = LoaiGiaoDich.ma_loai_gd AND LoaiGiaoDich.ma_nhom_gd = NhomGiaoDich.ma_nhom_gd AND GiaoDichTaiChinh.ma_vi = VI.ma_vi AND VI.taikhoan = '" + IdUser + "' AND NhomGiaoDich.ten_nhom_gd = N'Khoản thu'"; if (timeEnd == string.Empty && timeStart != string.Empty) { query += " AND GiaoDichTaiChinh.thoi_gian = '" + timeStart + "'"; } else if (timeEnd != string.Empty && timeStart != string.Empty) { query += " AND GiaoDichTaiChinh.thoi_gian >= '" + timeStart + "' AND GiaoDichTaiChinh.thoi_gian <= '" + timeEnd + "'"; } if (IDWallets != string.Empty) { query += " AND VI.ma_vi = '" + IDWallets + "'"; } query += " GROUP BY GiaoDichTaiChinh.thoi_gian"; DB.conn.Open(); SqlCommand cmd = new SqlCommand(query, DB.conn); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { chartThuNhap.Series["Thu"].Points.AddXY(Commom.getDate(rd[1].ToString()), double.Parse(rd[0].ToString())); } DB.conn.Close(); // chi query = @"SELECT SUM(GiaoDichTaiChinh.so_tien) AS 'so_tien', GiaoDichTaiChinh.thoi_gian FROM GiaoDichTaiChinh, LoaiGiaoDich,NhomGiaoDich,VI WHERE GiaoDichTaiChinh.ma_loai_gd = LoaiGiaoDich.ma_loai_gd AND LoaiGiaoDich.ma_nhom_gd = NhomGiaoDich.ma_nhom_gd AND GiaoDichTaiChinh.ma_vi = VI.ma_vi AND VI.taikhoan = '" + IdUser + "' AND NhomGiaoDich.ten_nhom_gd = N'Khoản chi'"; if (timeEnd == string.Empty && timeStart != string.Empty) { query += " AND GiaoDichTaiChinh.thoi_gian = '" + timeStart + "'"; } else if (timeEnd != string.Empty && timeStart != string.Empty) { query += " AND GiaoDichTaiChinh.thoi_gian >= '" + timeStart + "' AND GiaoDichTaiChinh.thoi_gian <= '" + timeEnd + "'"; } if (IDWallets != string.Empty) { query += " AND VI.ma_vi = '" + IDWallets + "'"; } query += " GROUP BY GiaoDichTaiChinh.thoi_gian"; DB.conn.Open(); cmd = new SqlCommand(query, DB.conn); rd = cmd.ExecuteReader(); while (rd.Read()) { chartThuNhap.Series["Chi"].Points.AddXY(Commom.getDate(rd[1].ToString()), double.Parse(rd[0].ToString())); } DB.conn.Close(); }