private void KhoiTao(string LyDo)
{
grdvDSThuChi.Columns.Clear();
if (grdvDSThuChi.Rows.Count > 0)
{
grdvDSThuChi.Rows.Clear();
}
DataTable Bang;
if (LyDo == "Tất cả")
{
Bang = CongTyBus.LayBangChiTietThuChi(dtpTuNgay.Value, dtpDenNgay.Value, "TatCa", txtDoiTuong.Text.Trim());
}
else
{
Bang = CongTyBus.LayBangChiTietThuChi(dtpTuNgay.Value, dtpDenNgay.Value, LyDo, txtDoiTuong.Text.Trim());
}
Double TienTonDauKy = CongTyBus.LayTienTonDauKy();
Double TienTonCuoiKy = TienTonDauKy;
for (int i = 0; i < Bang.Rows.Count; i++)
{
Double TienThu = double.Parse(Bang.Rows[i]["Thu"].ToString());
Double TienChi = double.Parse(Bang.Rows[i]["Chi"].ToString());
TienTonCuoiKy = TienTonCuoiKy + TienThu - TienChi;
Bang.Rows[i]["Ton"] = TienTonCuoiKy;
}
txtTonDauDy.Text = clsSupport.CurrencyNumber(TienTonDauKy.ToString());
txtTonCuoiKy.Text = clsSupport.CurrencyNumber(TienTonCuoiKy.ToString());
grdvDSThuChi.DataSource = Bang;
AnCotTrenLuoi();
DinhDangCot();
btnInRa.Enabled = true;
}
private void frmTienQuyDauKy_Load(object sender, EventArgs e)
{
try
{
Double TienTonDauKy = CongTyBus.LayTienTonDauKy();
txtTienQuyDauKy.Text = clsSupport.CurrencyNumber(TienTonDauKy.ToString());
}
catch (Exception ex)
{
MessageBox.Show("Lỗi kết nối cơ sở dữ liệu.", "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
