/* 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();
}
