private void setGridClose() { MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail(); DataSet dsClose = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); ugrdClose.Clear(); ugrdClose.DataSource = dsClose; ugrdClose.DataBind(); }
private void SetBscTermDetail() { MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail(); DataSet rDs = objBSC.GetAllList(this.IEstTermRefID); ugrdClose.Clear(); ugrdClose.DataSource = rDs; ugrdClose.DataBind(); }
private void SetScoreGrid() { MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail(); DataSet rDs = objTerm.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); DataSet dsTScore = new DataSet(); dsTScore.Tables.Add("TSCORE"); dsTScore.Tables.Add("TSCORE2"); string strMM = ""; this.IcntCol = rDs.Tables[0].Rows.Count; for (int i = 0; i < this.IcntCol; i++) { strMM = rDs.Tables[0].Rows[i]["YMD"].ToString(); dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_01", typeof(string)); // YMD dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_02", typeof(string)); // EST_DEPT_REF_ID dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_06", typeof(string)); // EST_YN dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_03", typeof(string)); // RANK_ID dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_04", typeof(string)); // DEPT_NAME dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_05", typeof(string)); // SCORE } MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card(); DataSet dsRtn = objSC.GetYearlyTotalScoreTrend(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , PageUtility.GetIntByValueDropDownList(ddlComTypeInfo) , PageUtility.GetByValueDropDownList(ddlSumType) , (hdfDeptID.Value == "") ? 0 : int.Parse(hdfDeptID.Value) , (chkApplyExtScore.Checked) ? "Y" : "N" , gUserInfo.Emp_Ref_ID); int cntRow = dsRtn.Tables[0].Rows.Count; // 조회행수 int cntCol = dsRtn.Tables[0].Columns.Count; // 컬럼수 int intRowIdx = 0; // DataSet Row Index int intColIdx = 0; // DataSet Col Index int intRowNum = 0; // Row Num string strPTmcode = ""; // 이전행 월코드 string strCTmcode = ""; // 현재행 월코드 string strNTmcode = ""; // 다음행 월코드 int iGrpRow = 0; int iTotRow = 0; try { DataRow drRow = dsTScore.Tables[0].NewRow(); DataRow drRow2 = dsTScore.Tables[1].NewRow(); for (int i = 0; i < cntRow; i++) { strPTmcode = (i > 0) ? dsRtn.Tables[0].Rows[i - 1]["YMD"].ToString() : dsRtn.Tables[0].Rows[i]["YMD"].ToString(); strCTmcode = dsRtn.Tables[0].Rows[i]["YMD"].ToString(); strNTmcode = (i >= cntRow - 1) ? dsRtn.Tables[0].Rows[i]["YMD"].ToString() : dsRtn.Tables[0].Rows[i + 1]["YMD"].ToString(); if (strPTmcode != strCTmcode) { iGrpRow = 1; } else { iGrpRow += 1; } for (int j = 0; j < cntCol; j++) { //if (intRowIdx == 0) if (iGrpRow > iTotRow) { if (j == 0 || j == 1 || j == 5) { drRow2[intColIdx + (j == 5 ? 2 : j)] = dsRtn.Tables[0].Rows[i][j]; } else { drRow[intColIdx + j - 2] = dsRtn.Tables[0].Rows[i][j]; } } else { if (j == 0 || j == 1 || j == 5) { dsTScore.Tables[1].Rows[intRowNum][intColIdx + (j == 5 ? 2 : j)] = dsRtn.Tables[0].Rows[i][j]; } else { dsTScore.Tables[0].Rows[intRowNum][intColIdx + j - 2] = dsRtn.Tables[0].Rows[i][j]; } } } //if (intRowIdx == 0) if (iGrpRow > iTotRow) { dsTScore.Tables[0].Rows.Add(drRow); dsTScore.Tables[1].Rows.Add(drRow2); drRow = dsTScore.Tables[0].NewRow(); drRow2 = dsTScore.Tables[1].NewRow(); iTotRow += 1; } if (strCTmcode != strNTmcode) { intRowIdx += 1; intColIdx += 3; intRowNum = 0; } else { intRowNum += 1; } } } catch (Exception e) { ltrScript.Text = JSHelper.GetAlertScript(e.Message, false); } ugrdMScore2.DataSource = dsTScore.Tables[1]; ugrdMScore2.DataBind(); ugrdMScore.DataSource = dsTScore.Tables[0]; ugrdMScore.DataBind(); //if (ugrdMScore.Rows.Count > 0) //{ // ugrdMScore.Visible = true; // imgNoData.Visible = false; //} //else //{ // ugrdMScore.Visible = false; // imgNoData.Visible = true; //} }