Esempio n. 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DoInitControl();
            DoBindingMaster();
            DoBindingTree();

            Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
            DataSet             dsTerm  = bizTerm.GetAllList(IESTTERM_REF_ID);
            if (dsTerm.Tables[0].Rows.Count > 0)
            {
                ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString();
            }
            if (ITERM_MONTH == "")
            {
                Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info();
                DataSet          dsMap2  = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID);
                if (dsMap2.Tables[0].Rows.Count > 0)
                {
                    ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString();
                }
            }
        }
        ltrScript.Text = "";
    }
Esempio n. 2
0
    private void DoBinding()
    {
        ltEstDeptName.Text = lblSTGMapName.Text = lblChampName.Text = "";

        this.IESTTERM_REF_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);

        Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
        DataSet          dsMap  = bizMap.GetWorkMapTotalListHeader_DB(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID);

        IMAP_VERSION_ID = 1;
        if (dsMap.Tables[0].Rows.Count > 0)
        {
            ltEstDeptName.Text = dsMap.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString();
            lblSTGMapName.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString();
            lblChampName.Text  = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
            IMAP_VERSION_ID    = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]);
        }

        Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
        DataSet             dsTerm  = bizTerm.GetAllList(IESTTERM_REF_ID);

        if (dsTerm.Tables[0].Rows.Count > 0)
        {
            ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString();
        }
        if (ITERM_MONTH == "")
        {
            Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info();
            DataSet          dsMap2  = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID);
            if (dsMap2.Tables[0].Rows.Count > 0)
            {
                ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString();
            }
        }

        DataSet dsList = bizMap.GetWorkMapTotalList_DB();

        ugrdStgList.Clear();
        ugrdStgList.DataSource = dsList.Tables[0];
        ugrdStgList.DataBind();
    }