private void DanhSach()
{
daSLDenBGGTri dBGGT = new daSLDenBGGTri();
dBGGT.TuNgay = DateTime.Parse(TuNgay);
dBGGT.DenNgay = DateTime.Parse(DenNgay);
dBGGT.MaBuuCuc = MaBuuCuc;
dBGGT.MaDonVi = MaBuuCuc;
Double _gt, _st;
_gt = Convert.ToDouble(GiaTri);
_st = Convert.ToDouble(SoTien);
_st = _st / 2;
stoChiTietNT.DataSource = dBGGT.DanhSachCTiet(_gt - 500000, _gt + 500000);
stoChiTietNT.DataBind();
}
protected void btnXuatExcel_Click(object sender, DirectEventArgs e)
{
daXuatExcel dXuatE = new daXuatExcel();
dXuatE.TenFileExcel = "BuuGuiPhatCODGiaTriLon" + DateTime.Now.ToString("ddMMyyyHHmmss") + ".xls";
dXuatE.DuongDan = Server.MapPath("..");
dXuatE.TenFileMau = dXuatE.DuongDan + "\\Resource\\FileMauExcel\\MauBGGTri.xls";
daSLDenBGGTri dBGGT = new daSLDenBGGTri();
dBGGT.TuNgay = DateTime.Parse(TuNgay);
dBGGT.DenNgay = DateTime.Parse(DenNgay);
dBGGT.MaBuuCuc = MaBuuCuc;
dBGGT.MaDonVi = MaBuuCuc;
Double _gt, _st;
_gt = Convert.ToDouble(GiaTri);
_st = Convert.ToDouble(SoTien);
_st = _st / 2;
DataTable dt = dBGGT.DanhSachCTiet(_gt - 500000, _gt + 500000);
try
{
dt.Columns.Remove("Year");
dt.Columns.Remove("DaPhat");
dt.Columns.Remove("DaChuyenHoan");
dt.Columns.Remove("DaHuy");
dt.Columns.Remove("LyDo");
dt.Columns.Remove("NgayHuy");
}
catch { }
dXuatE.DuLieu = dt;
string _url = UIHelper.daPhien.LayDiaChiURL(dXuatE.XuatFileExcel_TheoMau());
Response.Redirect(_url);
}