private void GridDataBinding() { string query = @" SELECT ISNULL(CE.EMP_REF_ID,0) as EMP_REF_ID, RTRIM(ISNULL(DE.DEPT_NAME,'')) as DEPT_NAME, ISNULL(CE.EMP_NAME,'') as EMP_NAME, MAX(ISNULL(CE.EMP_EMAIL,'')) as EMP_EMAIL FROM KPI_INFO KI, COM_EMP_INFO CE, COM_DEPT_INFO DE, REL_DEPT_EMP RD, KPI_RESULT KR, (SELECT " + hdnMM.Value + @" as TMCODE, MON_" + hdnMM.Value + @"_FLAG as CHECK_YN, KPI_REF_ID FROM KPI_TERM WHERE KPI_TERM_TYPE = 0) TM WHERE KI.KPI_REF_ID *= KR.KPI_REF_ID AND KI.KPI_REF_ID *= TM.KPI_REF_ID AND KI.CHAMPION_EMP_ID *= CE.EMP_REF_ID AND RD.EMP_REF_ID = CE.EMP_REF_ID AND RD.DEPT_REF_ID = DE.DEPT_REF_ID AND TM.CHECK_YN = 1 AND KR.CHECKSTATUS IN (" + ddlApplyYN.SelectedValue + @") AND KR.TMCODE = " + hdnMM.Value + @" GROUP BY DE.DEPT_REF_ID,DE.DEPT_NAME,CE.EMP_REF_ID, CE.EMP_NAME "; MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString); DataSet ds = gDbAgent.FillDataSet(query, "data"); EmpInfos emp = new EmpInfos(); UltraWebGrid1.DataSource = ds.Tables[0].DefaultView; UltraWebGrid1.DataBind(); }
protected static DataSet GetDataSet(string query) { MicroBSC.Data.DBAgent dbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString); DataSet ds = dbAgent.FillDataSet(query, "Data"); return(ds); }
private void setFormData() { int intKpi_Ref_ID = int.Parse(hdnKpiRefID.Value.ToString()); string strSQL = @" SELECT KI.KPI_NAME, KL.QRY_DATA, KL.QRY_MS, KL.QRY_TS, KI.KPI_REF_ID FROM KPI_INFO KI, KPI_LOW KL WHERE KI.KPI_REF_ID = KL.KPI_REF_ID AND KI.KPI_REF_ID = " + intKpi_Ref_ID + @" "; MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString); DataSet dsClose = gDbAgent.FillDataSet(strSQL, "tblClose"); if (dsClose.Tables[0].Rows.Count > 0) { txtKPIName.Text = dsClose.Tables[0].Rows[0]["KPI_NAME"].ToString(); txtQRY_DATA.Text = dsClose.Tables[0].Rows[0]["QRY_DATA"].ToString(); txtQRY_MS.Text = dsClose.Tables[0].Rows[0]["QRY_MS"].ToString(); txtQRY_TS.Text = dsClose.Tables[0].Rows[0]["QRY_TS"].ToString(); } else { txtKPIName.Text = ""; txtQRY_DATA.Text = ""; txtQRY_MS.Text = ""; txtQRY_TS.Text = ""; } }
private void setGridClose() { string strSQL = @" SELECT KI.KPI_CODE as KPI_CODE, KI.KPI_NAME as KPI_NAME, CD.DEPT_NAME as DEPT_NAME, CE.EMP_NAME as EMP_NAME, KR.RESULT as MS_RESULT, KR.COLRESULT as TS_RESULT, KR.CAL_MS_RESULT as CAL_MS_RESUTL, KR.CAL_TS_RESULT as CAL_TS_RESULT, KR.CAL_MODIFY_REASON as MREASON FROM KPI_INFO KI, KPI_RESULT KR, COM_EMP_INFO CE, COM_DEPT_INFO CD, REL_DEPT_EMP RD WHERE KI.KPI_REF_ID = KR.KPI_REF_ID AND KI.CHAMPION_EMP_ID = CE.EMP_REF_ID AND RD.DEPT_REF_ID = CD.DEPT_REF_ID AND RD.EMP_REF_ID = CE.EMP_REF_ID AND KR.TMCODE = " + ddlMonthInfo.SelectedValue.ToString() + @" AND KR.CAL_APPLY_YN = 0 --RESULT NOT APPLY AND KI.RESULT_INPUT_METHOD = 'SYS' --SYSTEM AND KR.CONFIRMSTATUS = 1 --CONFIRM AND KI.ESTTERM_REF_ID = " + ddlEstTermInfo.SelectedValue.ToString() + @" "; MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString); DataSet dsClose = gDbAgent.FillDataSet(strSQL, "tblClose"); ugrdClose.DataSource = dsClose; ugrdClose.DataBind(); }
private void setGridClose() { string strSQL = @" SELECT KPI_REF_ID, KPI_CODE, KPI_NAME FROM KPI_INFO WHERE KPI_CODE LIKE ('" + txtSKpiCode.Text + @"'+'%') AND KPI_NAME LIKE ('" + txtSKpiName.Text + @"'+'%') AND RESULT_INPUT_METHOD = 'SYS' ORDER BY KPI_NAME "; MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString); DataSet dsClose = gDbAgent.FillDataSet(strSQL, "tblClose"); ugrdClose.DataSource = dsClose; ugrdClose.DataBind(); }