Esempio n. 1
0
        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();
        }
Esempio n. 2
0
 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();
     }
 }