/// <summary> /// 기본정보 조회 /// </summary> public void SetFormData() { Biz_Bsc_Kpi_Info objBSC = new Biz_Bsc_Kpi_Info(this.IEstTermRefID, this.IKpiRefID); lblKpiCode.Text = objBSC.Ikpi_code; lblKpiName.Text = objBSC.Ikpi_name; txtCalcFormMs.Text = objBSC.Icalc_form_ms; txtCalcFormTs.Text = objBSC.Icalc_form_ts; Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(this.IKpiRefID, this.IDiCode); this.IDiCode = objQry.IDicode; txtDiCode.Text = objQry.IDicode; this.IVersionNo = 1; //objQry.IVersion_No; -- 차후에 버젼관리 연결 txtField_Ss.Text = objQry.IResult_Field_Al; txtCondition_SS.Text = objQry.IResult_Where_Al; txtField_Ms.Text = objQry.IResult_Field_Ms; txtCondition_Ms.Text = objQry.IResult_Where_Ms; txtField_Ts.Text = objQry.IResult_Field_Ts; txtCondition_Ts.Text = objQry.IResult_Where_Ts; txtQUERY_AL.Text = objQry.IQuery_Al; txtQUERY_MS.Text = objQry.IQuery_Ms; txtQUERY_TS.Text = objQry.IQuery_Ts; this.IisValidQuery = objQry.IIsvalid_Query; if (this.IVersionNo > 0) { Biz_Bsc_Interface_Dicode objCode = new Biz_Bsc_Interface_Dicode(this.IDiCode, gUserInfo.Emp_Ref_ID); txtDiName.Text = objCode.IName; this.IType = "U"; this.SetColumnList(); } else { txtDiCode.Text = ""; txtDiName.Text = ""; this.IDiCode = ""; this.IType = "A"; } //int iTxrUser = gUserInfo.Emp_Ref_ID; //Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(this.IDiCode, iTxrUser); //txtDICODE.Text = objBSC.IDicode; //txtDINAME.Text = objBSC.IName; //txtDEFINITION.Text = objBSC.IDefinition; //lblUseYN.Text = objBSC.IUse_Yn; //txtDICODE.BackColor = Color.WhiteSmoke; //txtDICODE.ReadOnly = true; //this.IType = (objBSC.IUse_Yn=="Y") ? "U" : "R"; //Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column(); //DataTable dtRtn = objCol.GetColumnInfoPerDicode(this.IDiCode, iTxrUser); //ugrdDIColumn.Clear(); //ugrdDIColumn.DataSource = dtRtn.DefaultView; //ugrdDIColumn.DataBind(); this.SetButton(); }
/// <summary> /// 조회 /// </summary> public void SetFormData() { int iTxrUser = gUserInfo.Emp_Ref_ID; Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(this.IDiCode, iTxrUser); lblDICODE.Text = objBSC.IDicode; lblDINAME.Text = objBSC.IName; lblDEFINITION.Text = objBSC.IDefinition; lblUseYN.Text = objBSC.IUse_Yn; }
/// <summary> /// DICode 리스트 조회 /// </summary> public void SetDicodeGrid() { Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(); objBSC.IDicode = txtsCode.Text; objBSC.IName = txtsName.Text; objBSC.ICreate_User = gUserInfo.Emp_Ref_ID; DataSet dsDicdoe = objBSC.GetAllList(objBSC.IDicode, objBSC.IName, objBSC.ICreate_User); ugrdDicode.Clear(); ugrdDicode.DataSource = dsDicdoe; ugrdDicode.DataBind(); }
public void SetInterfaceGrid() { Biz_Bsc_Kpi_Info objKpi = new Biz_Bsc_Kpi_Info(this.IEstTermRefID, this.IKpiRefID); lblKpiCode.Text = objKpi.Ikpi_code; lblKpiName.Text = objKpi.Ikpi_name; txtCalcFormMs.Text = objKpi.Icalc_form_ms; txtCalcFormTs.Text = objKpi.Icalc_form_ts; Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(this.IKpiRefID, ""); this.IDiCode = objQry.IDicode; txtFieldMs.Text = "계산식 : " + objQry.IResult_Field_Ms + "\n" + "조건식 : " + objQry.IResult_Where_Ms; txtFieldTs.Text = "계산식 : " + objQry.IResult_Field_Ts + "\n" + "조건식 : " + objQry.IResult_Where_Ts; if (this.IDiCode == "") { ltrScript.Text = JSHelper.GetAlertScript("정의된 Interface가 없습니다.", true); return; } Biz_Bsc_Interface_Dicode objCode = new Biz_Bsc_Interface_Dicode(this.IDiCode, gUserInfo.Emp_Ref_ID); txtDiCode.Text = objCode.IDicode; txtDiName.Text = objCode.IName; 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 = "RDTERM"; ugCol.BaseColumnName = "RDTERM"; ugCol.Header.Caption = "발생일자"; ugCol.Width = Unit.Pixel(100); ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.DataType = "System.String"; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left; ugrdInterface.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; ugrdInterface.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; ugrdInterface.Columns.Add(ugCol); } } } } } sRtnMsg = ""; bIsSuccess = false; dRtnVal = 0; DataSet rDsQry = objQry.GetInterfaceData(this.IKpiRefID, this.IYMD, out sRtnMsg, out bIsSuccess); ugrdInterface.Clear(); ugrdInterface.DataSource = rDsQry; ugrdInterface.DataBind(); dRtnVal = objQry.GetInterfaceResultMs(this.IKpiRefID, this.IYMD, out sRtnMsg, out bIsSuccess); txtResult_Ms.Text = (bIsSuccess) ? dRtnVal.ToString() : "0"; dRtnVal = objQry.GetInterfaceResultTs(this.IKpiRefID, this.IYMD.Substring(0, 4) + "01", this.IYMD, out sRtnMsg, out bIsSuccess); txtResult_Ts.Text = (bIsSuccess) ? dRtnVal.ToString() : "0"; }