private void SetCtrlSetting(int estterm_ref_id, int est_dept_ref_id) { Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map(); //DataSet dsMap = bizMap.GetWorkMapTotalList(estterm_ref_id, est_dept_ref_id); DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(estterm_ref_id, est_dept_ref_id); if (dsMap.Tables[0].Rows.Count > 0) { ltrStgMapVision.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString(); ltrStgMapChamp.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString(); this.IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]); } Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail(); string strYMD = bizTerm.GetReleasedMonth(); this.IYMD = (strYMD == "000000" ? DataTypeUtility.GetToInt32(DateTime.Now.ToString("yyyyMM")) : DataTypeUtility.GetToInt32(strYMD)); SetViewScoreGrid(estterm_ref_id, est_dept_ref_id, this.IYMD); string view_kpi_str = (ViewKPI) ? "1" : "0"; string url = "../usr/usr_stg_map.aspx?ESTTERM_REF_ID=" + estterm_ref_id.ToString() + "&EST_DEPT_REF_ID=" + est_dept_ref_id.ToString() + "&MAP_VERSION_ID=" + this.IMAP_VERSION_ID + "&TMCODE=" + this.IYMD + "&LINE_TYPE=0" + "&SHOW_KPI_LIST=" + view_kpi_str + "&WORKINGMAPYN=T"; ifm.Attributes.Add("src", Server.UrlDecode(url)); }
/// <summary> /// 생성쿼리 검증 /// </summary> public void SetQueryValidate() { Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); string sSYmd = objTerm.GetStartEstMonth(); string sCYmd = objTerm.GetReleasedMonth(); decimal dRtnVal = 0; string sRtnMsg = ""; bool bIsSuccess = false; this.IisValidQuery = "Y"; Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(); // 인터페이스 리스트 DataSet rDs = objQry.GetInterfaceData(txtQUERY_AL.Text, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessAl.Text = sRtnMsg; lblSuccessAl.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } // 당월실적 쿼리결과 dRtnVal = objQry.GetInterfaceResultMs(txtQUERY_MS.Text, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessMs.Text = sRtnMsg; lblSuccessMs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } // 누적실적 쿼리결과 dRtnVal = objQry.GetInterfaceResultTs(txtQUERY_TS.Text, sSYmd, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessTs.Text = sRtnMsg; lblSuccessTs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } }
public void SetPreviewGrid() { Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column(); DataSet rDs = objCol.GetAllList(this.IDiCode, gUserInfo.Emp_Ref_ID); int iRow = 0; string sUseYn = "N"; string sColKey = ""; string sColName = ""; int iDPoints = 0; int iGridWith = 0; UltraGridColumn ugCol; if (rDs.Tables.Count > 0) { iRow = rDs.Tables[0].Rows.Count; if (iRow > 0) { ugCol = new UltraGridColumn(); ugCol.Key = "YMD"; ugCol.BaseColumnName = "YMD"; ugCol.Header.Caption = "평가월"; ugCol.Width = Unit.Pixel(50); ugCol.AllowUpdate = AllowUpdate.No; ugCol.DataType = "System.String"; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center; ugrdPreview.Columns.Add(ugCol); ugCol = new UltraGridColumn(); ugCol.Key = "DD"; ugCol.BaseColumnName = "DD"; ugCol.Header.Caption = "발생일자"; ugCol.Width = Unit.Pixel(35); ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.DataType = "System.String"; ugCol.Header.Style.Wrap = true; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center; ugrdPreview.Columns.Add(ugCol); for (int i = 0; i < iRow; i++) { sUseYn = rDs.Tables[0].Rows[i]["USE_YN"].ToString(); sColKey = rDs.Tables[0].Rows[i]["COLUMN_ID"].ToString(); sColName = rDs.Tables[0].Rows[i]["COLUMN_ALIAS"].ToString(); iDPoints = Convert.ToInt32(rDs.Tables[0].Rows[i]["DECIMAL_POINTS"].ToString()); iGridWith = Convert.ToInt32(rDs.Tables[0].Rows[i]["GRID_WIDTH"].ToString()); if (sUseYn == "Y") { if (sColKey.Substring(0, 7) == "SVALUES") { ugCol = new UltraGridColumn(); ugCol.Key = sColKey; ugCol.BaseColumnName = sColKey; ugCol.Header.Caption = sColName; ugCol.Width = Unit.Pixel(iGridWith); ugCol.DataType = "System.String"; ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left; ugrdPreview.Columns.Add(ugCol); } else { ugCol = new UltraGridColumn(); ugCol.Key = sColKey; ugCol.BaseColumnName = sColKey; ugCol.Header.Caption = sColName; ugCol.Width = Unit.Pixel(iGridWith); ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.DataType = "System.Double"; ugCol.Format = "#,###,###,###,###,###,###,##0" + this.GetFormatPoints(iDPoints); ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Right; ugrdPreview.Columns.Add(ugCol); } } } } } Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); string sEstMon = objTerm.GetReleasedMonth(); Random rndObj = new Random(); for (int i = 0; i < 11; i++) { ugrdPreview.Rows.Add(); for (int j = 0; j < ugrdPreview.Columns.Count; j++) { if (ugrdPreview.Columns[j].DataType == "System.String") { if (ugrdPreview.Columns[j].Key == "YMD") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = sEstMon; } else if (ugrdPreview.Columns[j].Key == "DD") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = Convert.ToString(rndObj.Next(1, 31)).PadLeft(2, '0'); } else { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = "String" + i.ToString(); } } else if (ugrdPreview.Columns[j].DataType == "System.Date") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = DateTime.Now; } else if (ugrdPreview.Columns[j].DataType == "System.Double") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = rndObj.NextDouble() * rndObj.Next(1000, 1000000); } } } ugrdPreview.Visible = true; }