protected void Grid_ChuTruongDauTu_OnRebind(object sender, EventArgs e)
{
string sttBCGSDauTupr = "", maGiaiDoanpr_sd = "";
if (Session["sttBCGSDauTupr"] != null)
{
sttBCGSDauTupr = Session["sttBCGSDauTupr"].ToString();
}
if (Session["maGiaiDoanpr_sd"] != null)
{
maGiaiDoanpr_sd = Session["maGiaiDoanpr_sd"].ToString();
}
SqlFunction sqlFun = new SqlFunction(HttpContext.Current.Session.GetConnectionString2());
string sql = @"SELECT
sttDuAnpr_sd,sttBCGSDauTuCTpr
,maDuAn=(SELECT maDuAn FROM dbo.tblDuAn WHERE sttDuAnpr=sttDuAnpr_sd)
,tenDuAn=(SELECT tenDuAn FROM dbo.tblDuAn WHERE sttDuAnpr=sttDuAnpr_sd)
,chuDauTu=(SELECT chuDauTu=(SELECT tenDonVi FROM dbo.tblDMDonVi WHERE maDonVipr=maDonVipr_chudautu) FROM dbo.tblDuAn WHERE sttDuAnpr=sttDuAnpr_sd)
,nhomDuAn = (select tenNhomDA from tblDMNhomDA where maNhomDApr = (select maNhomDApr_sd FROM dbo.tblDuAn WHERE sttDuAnpr=sttDuAnpr_sd))
,ngayPheDuyet= (SELECT ngayQuyetDinh fROM dbo.tblDuAn where sttDuAnpr=sttDuAnpr_sd)
,thoiGian=(SELECT thoiGian=thoiGianKCongDuyet+'-'+ thoiGianHThanhDuyet FROM dbo.tblDuAn where sttDuAnpr=sttDuAnpr_sd)
,nguonVon = (SELECT nguonVon=(SELECT nhomBCPL1_GSDT+';' FROM dbo.tblDMNguonLDTC WHERE maNguonLDTCpr IN
(SELECT (SELECT maNguonLDTCpr_sd FROM dbo.tblDMNguonVon WHERE maNguonVonpr=maNguonVonpr_sd)
FROM dbo.tblNguonVonDA WHERE sttDuAnpr_sd=sttDuAnpr) FOR XML PATH('')) FROM dbo.tblDuAn where sttDuAnpr=sttDuAnpr_sd)
,loaiVanBan=(SELECT (SELECT tenLoaiVBan FROM dbo.tblDMLoaiVanBan WHERE maLoaiVBanpr=maLoaiVBanpr_sd) FROM dbo.tblVanBanDA WHERE sttVBDApr=sttVBDApr_sd)
from tblBCGSDauTuCT where sttBuocThaoTac=N'" + maGiaiDoanpr_sd + "' and sttBCGSDauTupr_sd=N'" + sttBCGSDauTupr + "'";
Grid_ChuTruongDauTu.DataSource = sqlFun.GetData(sql);
Grid_ChuTruongDauTu.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(ProOnline.Class.ntsLibraryFunctions));
AjaxPro.Utility.RegisterTypeForAjax(typeof(ProOnline.module.baocaogiamsatdautu));
if (!IsPostBack)
{
Grid_ChuTruongDauTu.DataSource = null;
Grid_ChuTruongDauTu.DataBind();
Grid1_duAn.DataSource = null;
Grid1_duAn.DataBind();
}
}
