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 = ""; }
private void SetTermList() { Biz_Bsc_Term_Detail objTrm = new Biz_Bsc_Term_Detail(); DataSet rDs = objTrm.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm)); ugrdTerm.Clear(); ugrdTerm.DataSource = rDs; ugrdTerm.DataBind(); }
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(); }