private Boolean fnDataFind() { /**************************************************** * Comment : DataBase에 저장된 데이터를 조회한다. * * Created By : bee-jae jung(2016-06-15-수요일) * * Modified By : bee-jae jung(2016-06-16-목요일) ****************************************************/ String sPackage = "", sParameter = ""; try { Cursor.Current = Cursors.WaitCursor; LoadingPopUp.LoadIngPopUpShow(this); if (fnBusinessRule() == false) { return(false); } // 2016-06-16-정비재 : Sheet / Listview를 초기화 한다. CmnInitFunction.ClearList(SS01, true); // 2016-06-16-정비재 : oracle package(procedure)를 이용하여 데이터를 조회한다. sPackage = "PACKAGE_TRN090106.PROC_TRN090106"; sParameter = "P_WORK_MONTH:" + cdvFromToDate.FromYearMonth.Value.ToString("yyyyMM") + "│ P_CUSTOMER:" + (cdvCustomer.Text == "ALL" ? "%" : cdvCustomer.Text) + "%" + "│ P_PACKAGE:" + (cdvPackage.Text == "ALL" ? "%" : cdvPackage.Text) + "%"; DataTable dt = CmnFunction.oComm.fnExecutePackage("DYNAMIC", sPackage, sParameter); if (dt.Rows.Count <= 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return(false); } SS01.DataSource = dt; SS01.RPT_AutoFit(false); return(true); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); MessageBox.Show(ex.Message); return(false); } finally { LoadingPopUp.LoadingPopUpHidden(); Cursor.Current = Cursors.Default; } }
private bool fnDataFind() { /**************************************************** * Comment : DataBase에 저장된 데이터를 조회한다. * * Created By : KIM-MINWOO(2010-10-04-월요일) * * Modified By :KIM-MINWOO(2010-10-04-월요일) ****************************************************/ DataTable dt = null; Miracom.SmartWeb.UI.Controls.udcFarPoint SS = null; string QRY = ""; try { Cursor.Current = Cursors.WaitCursor; LoadingPopUp.LoadIngPopUpShow(this); CmnInitFunction.ClearList(SS01, true); // 검색 날짜의 주차 가져오기 DataTable dt1 = null; dt1 = null; dt1 = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2(cdvBaseDate.Value.ToString("yyyyMMdd"))); string week = dt1.Rows[0][0].ToString(); // 검색 날짜의 주차 가져오기(-1) dt1 = null; dt1 = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2(cdvBaseDate.Value.AddDays(-7).ToString("yyyyMMdd"))); string week_1 = dt1.Rows[0][0].ToString(); // 검색 날짜의 주차 가져오기(-2) dt1 = null; dt1 = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2(cdvBaseDate.Value.AddDays(-14).ToString("yyyyMMdd"))); string week_2 = dt1.Rows[0][0].ToString(); // 검색 날짜의 주차 가져오기(-3) dt1 = null; dt1 = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2(cdvBaseDate.Value.AddDays(-21).ToString("yyyyMMdd"))); string week_3 = dt1.Rows[0][0].ToString(); QRY = "SELECT CUSTOMER \n" + " , NVL(ROUND(DC_OUT_QTY_MM_2/DECODE(DC_IN_QTY_MM_2,0,1,DC_IN_QTY_MM_2) * 100,2),0) AS MM_2 \n" + " , NVL(ROUND(DC_OUT_QTY_MM_1/DECODE(DC_IN_QTY_MM_1,0,1,DC_IN_QTY_MM_1) * 100,2),0) AS MM_1 \n" + " , NVL(ROUND(DC_OUT_QTY_MM/DECODE(DC_IN_QTY_MM,0,1,DC_IN_QTY_MM) * 100,2),0) AS MM \n" + " , ROUND(DC_OUT_QTY_WW_3/DECODE(DC_IN_QTY_WW_3,0,1,DC_IN_QTY_WW_3) * 100,2) AS WW_3 \n" + " , ROUND(DC_OUT_QTY_WW_2/DECODE(DC_IN_QTY_WW_2,0,1,DC_IN_QTY_WW_2) * 100,2) AS WW_2 \n" + " , ROUND(DC_OUT_QTY_WW_1/DECODE(DC_IN_QTY_WW_1,0,1,DC_IN_QTY_WW_1) * 100,2) AS WW_1 \n" + " , ROUND(DC_OUT_QTY_WW/DECODE(DC_IN_QTY_WW,0,1,DC_IN_QTY_WW) * 100,2) AS WW \n" + " , ROUND(DC_OUT_QTY_DD_6/DECODE(DC_IN_QTY_DD_6,0,1,DC_IN_QTY_DD_6) * 100,2) AS DD_6 \n" + " , ROUND(DC_OUT_QTY_DD_5/DECODE(DC_IN_QTY_DD_5,0,1,DC_IN_QTY_DD_5) * 100,2) AS DD_5 \n" + " , ROUND(DC_OUT_QTY_DD_4/DECODE(DC_IN_QTY_DD_4,0,1,DC_IN_QTY_DD_4) * 100,2) AS DD_4 \n" + " , ROUND(DC_OUT_QTY_DD_3/DECODE(DC_IN_QTY_DD_3,0,1,DC_IN_QTY_DD_3) * 100,2) AS DD_3 \n" + " , ROUND(DC_OUT_QTY_DD_2/DECODE(DC_IN_QTY_DD_2,0,1,DC_IN_QTY_DD_2) * 100,2) AS DD_2 \n" + " , ROUND(DC_OUT_QTY_DD_1/DECODE(DC_IN_QTY_DD_1,0,1,DC_IN_QTY_DD_1) * 100,2) AS DD_1 \n" + " , ROUND(DC_OUT_QTY_DD/DECODE(DC_IN_QTY_DD,0,1,DC_IN_QTY_DD) * 100,2) AS DD \n" + " FROM( \n" + "SELECT CUSTOMER AS CUSTOMER \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.AddMonths(-2).ToString("yyyyMM") + "', DC_IN_QTY,0)) AS DC_IN_QTY_MM_2 \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.AddMonths(-1).ToString("yyyyMM") + "', DC_IN_QTY,0)) AS DC_IN_QTY_MM_1 \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.ToString("yyyyMM") + "', DC_IN_QTY,0)) AS DC_IN_QTY_MM \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.AddMonths(-2).ToString("yyyyMM") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_MM_2 \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.AddMonths(-1).ToString("yyyyMM") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_MM_1 \n" + " , SUM(DECODE(WORK_MONTH,'"+ cdvBaseDate.Value.ToString("yyyyMM") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_MM \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_3 + "', DC_IN_QTY,0)) AS DC_IN_QTY_WW_3 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_2 + "', DC_IN_QTY,0)) AS DC_IN_QTY_WW_2 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_1 + "', DC_IN_QTY,0)) AS DC_IN_QTY_WW_1 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week + "', DC_IN_QTY,0)) AS DC_IN_QTY_WW \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_3 + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_WW_3 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_2 + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_WW_2 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week_1 + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_WW_1 \n" + " , SUM(DECODE(PLAN_WEEK,'"+ week + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_WW \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-6).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_6 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-5).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_5 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-4).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_4 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-3).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_3 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-2).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_2 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-1).ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD_1 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.ToString("yyyyMMdd") + "', DC_IN_QTY,0)) AS DC_IN_QTY_DD \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-6).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_6 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-5).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_5 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-4).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_4 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-3).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_3 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-2).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_2 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.AddDays(-1).ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD_1 \n" + " , SUM(DECODE(WORK_DATE,'"+ cdvBaseDate.Value.ToString("yyyyMMdd") + "', DC_OUT_QTY,0)) AS DC_OUT_QTY_DD \n" + " FROM (" + " SELECT A.*, B.PLAN_WEEK FROM RSUMDCLHIS A, MWIPCALDEF B \n" + " WHERE A.WORK_DATE = B.SYS_DATE \n" + " ANd B.CALENDAR_ID = 'SE' \n" + " AND CUSTOMER = '" + cdvCustomer.Text + "' \n" + " AND LOT_ID LIKE '" + txtLotID.Text + "' \n" + " AND MAT_ID LIKE '" + txtSearchProduct.Text + "' \n"; #region 상세 조회에 따른 SQL문 생성 if (udcWIPCondition1.Text != "ALL" && udcWIPCondition1.Text != "") { //QRY += " AND CUSTOMER " + udcWIPCondition1.SelectedValueToQueryString + "\n"; if (udcWIPCondition2.Text != "ALL" && udcWIPCondition2.Text != "") { QRY += " AND FAMILY "+ udcWIPCondition2.SelectedValueToQueryString + "\n"; } } if (udcWIPCondition3.Text != "ALL" && udcWIPCondition3.Text != "") { QRY += " AND PKG "+ udcWIPCondition3.SelectedValueToQueryString + "\n"; } if (udcWIPCondition4.Text != "ALL" && udcWIPCondition4.Text != "") { QRY += " AND TYPE1 "+ udcWIPCondition4.SelectedValueToQueryString + "\n"; } if (udcWIPCondition5.Text != "ALL" && udcWIPCondition5.Text != "") { QRY += " AND TYPE2 "+ udcWIPCondition5.SelectedValueToQueryString + "\n"; } if (udcWIPCondition6.Text != "ALL" && udcWIPCondition6.Text != "") { QRY += " AND LD_COUNT "+ udcWIPCondition6.SelectedValueToQueryString + "\n"; } if (udcWIPCondition7.Text != "ALL" && udcWIPCondition7.Text != "") { QRY += " AND DENSITY "+ udcWIPCondition7.SelectedValueToQueryString + "\n"; } if (udcWIPCondition8.Text != "ALL" && udcWIPCondition8.Text != "") { QRY += " AND GENERATION "+ udcWIPCondition8.SelectedValueToQueryString + "\n"; } if (udcRASCondition6.Text != "ALL" && udcRASCondition6.Text != "") { QRY += " AND (BG_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR SAW_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR DA1_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR DA2_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR DA3_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR WB1_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR WB2_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR WB3_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + "\n"; QRY += " OR MD_RES_ID "+ udcRASCondition6.SelectedValueToQueryString + ")\n"; } #endregion QRY += " )GROUP BY CUSTOMER)"; if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP") { System.Windows.Forms.Clipboard.SetText(QRY.Replace((char)Keys.Tab, ' ')); } dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", QRY.Replace((char)Keys.Tab, ' ')); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return(false); } SS = SS01; SS.DataSource = dt; SS.RPT_AutoFit(false); fnMakeChart(SS, 0); return(true); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); MessageBox.Show(ex.Message); return(false); } finally { LoadingPopUp.LoadingPopUpHidden(); Cursor.Current = Cursors.Default; } }
/// <summary> /// 4. 쿼리 생성 /// </summary> /// <returns></returns> /// private Boolean fnDataFind() { /**************************************************** * comment : 검색조건에 맞는 데이터를 조회한다. * * created by : bee-jae jung(2011-01-17-월요일) * * modified by : bee-jae jung(2011-01-17-월요일) ****************************************************/ DataTable DT = null; String QRY = "", sBoh_Date = "", sEoh_Date = ""; try { Cursor.Current = Cursors.WaitCursor; LoadingPopUp.LoadIngPopUpShow(this); // 2010-07-20-정비재 : Sheet / Listview를 초기화 한다. CmnInitFunction.ClearList(SS01, true); // 2011-01-17-정비재 : BOH, EOH 일자를 조회한다. if (rbBaseTime06.Checked == true) { // 2011-01-17-정비재 : 06시 기준의 일자 sBoh_Date = cdvToDate.SelectedValue() + "06"; sEoh_Date = DateTime.Parse(cdvToDate.Value.ToString("yyyy-MM-dd")).AddDays(+1).ToString("yyyyMMdd") + "06"; } else if (rbBaseTime22.Checked == true) { // 2011-01-17-정비재 : 22시 기준의 일자 sBoh_Date = DateTime.Parse(cdvFromDate.Value.ToString("yyyy-MM-dd")).AddDays(-1).ToString("yyyyMMdd") + "22"; sEoh_Date = cdvToDate.SelectedValue() + "22"; } QRY = "SELECT A.MAT_ID AS MAT_ID" + " , A.OPER AS OPER" + " , SUM(A.BOH_QTY) AS BOH_QTY" + " , SUM(A.OPER_IN_QTY) AS OPER_IN_QTY" + " , SUM(A.START_QTY) AS START_QTY" + " , SUM(A.END_QTY) AS END_QTY" + " , SUM(A.HOLD_QTY) AS HOLD_QTY" + " , SUM(A.LOSS_QTY) AS LOSS_QTY" + " , SUM(A.BONUS_QTY) AS BONUS_QTY" + " , SUM(A.EOH_QTY) AS EOH_QTY" + " FROM (SELECT MAT_ID AS MAT_ID" + " , OPER AS OPER" + " , 0 AS BOH_QTY" + " , SUM(S1_OPER_IN_QTY_1 + S2_OPER_IN_QTY_1 + S3_OPER_IN_QTY_1) AS OPER_IN_QTY" + " , SUM(S1_START_QTY_1 + S2_START_QTY_1 + S3_START_QTY_1) AS START_QTY" + " , SUM(S1_END_QTY_1 + S2_END_QTY_1 + S3_END_QTY_1) AS END_QTY" + " , SUM(S1_TO_HOLD_QTY_1 + S2_TO_HOLD_QTY_1 + S3_TO_HOLD_QTY_1) AS HOLD_QTY" + " , SUM(S1_LOSS_QTY_1 + S2_LOSS_QTY_1 + S3_LOSS_QTY_1) AS LOSS_QTY" + " , SUM(S1_BONUS_QTY_1 + S2_BONUS_QTY_1 + S3_BONUS_QTY_1) AS BONUS_QTY" + " , 0 AS EOH_QTY"; if (rbBaseTime06.Checked == true) { QRY += " FROM CSUMWIPMOV"; // 2011-01-17-정비재 : 06시 기준 } else if (rbBaseTime22.Checked == true) { QRY += " FROM RSUMWIPMOV"; // 2011-01-17-정비재 : 22시 기준 } QRY += " WHERE FACTORY IN ('" + GlobalVariable.gsAssyDefaultFactory + "', '" + GlobalVariable.gsTestDefaultFactory + "')" + " AND WORK_DATE >= '" + cdvFromDate.SelectedValue() + "'" + " AND WORK_DATE <= '" + cdvToDate.SelectedValue() + "'" + " AND LOT_TYPE = 'W'" + " AND MAT_ID LIKE '" + txtMatID.Text + "%'" + " AND CM_KEY_3 LIKE '" + txtLotType.Text + "%'" + " GROUP BY MAT_ID, OPER" + " UNION ALL" + " SELECT MAT_ID AS MAT_ID" + " , OPER AS OPER" + " , SUM(QTY_1) AS BOH_QTY" + " , 0 AS OPER_IN_QTY" + " , 0 AS START_QTY" + " , 0 AS END_QTY" + " , 0 AS HOLD_QTY" + " , 0 AS LOSS_QTY" + " , 0 AS BONUS_QTY" + " , 0 AS EOH_QTY" + " FROM RWIPLOTSTS_BOH" + " WHERE FACTORY IN ('" + GlobalVariable.gsAssyDefaultFactory + "', '" + GlobalVariable.gsTestDefaultFactory + "')" + " AND LOT_TYPE = 'W'" + " AND MAT_ID LIKE '" + txtMatID.Text + "%'" + " AND LOT_CMF_5 LIKE '" + txtLotType.Text + "%'" + " AND CUTOFF_DT = '" + sBoh_Date + "'" + " GROUP BY MAT_ID, OPER" + " UNION ALL" + " SELECT MAT_ID AS MAT_ID" + " , OPER AS OPER" + " , 0 AS BOH_QTY" + " , 0 AS OPER_IN_QTY" + " , 0 AS START_QTY" + " , 0 AS END_QTY" + " , 0 AS HOLD_QTY" + " , 0 AS LOSS_QTY" + " , 0 AS BONUS_QTY" + " , SUM(QTY_1) AS EOH_QTY" + " FROM RWIPLOTSTS_BOH" + " WHERE FACTORY IN ('" + GlobalVariable.gsAssyDefaultFactory + "', '" + GlobalVariable.gsTestDefaultFactory + "')" + " AND LOT_TYPE = 'W'" + " AND MAT_ID LIKE '" + txtMatID.Text + "%'" + " AND LOT_CMF_5 LIKE '" + txtLotType.Text + "%'" + " AND CUTOFF_DT = '" + sEoh_Date + "'" + " GROUP BY MAT_ID, OPER) A" + " GROUP BY A.MAT_ID, A.OPER" + " ORDER BY A.MAT_ID ASC, A.OPER ASC"; if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP") { System.Windows.Forms.Clipboard.SetText(QRY.Replace((char)Keys.Tab, ' ')); } DT = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", QRY.Replace((char)Keys.Tab, ' ')); if (DT.Rows.Count == 0) { DT.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return(false); } SS01.DataSource = DT; SS01.RPT_AutoFit(false); return(true); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); MessageBox.Show(ex.Message); return(false); } finally { LoadingPopUp.LoadingPopUpHidden(); Cursor.Current = Cursors.Default; } }
private bool fnDataFind() { /**************************************************** * comment : database에 저장된 데이터를 조회한다. * * created by : bee-jae jung(2010-07-23-금요일) * * modified by : bee-jae jung(2010-07-23-금요일) ****************************************************/ string qry = ""; string oper = ""; try { Cursor.Current = Cursors.WaitCursor; LoadingPopUp.LoadIngPopUpShow(this); // 2010-07-23-정비재 : Sheet / Listview를 초기화 한다. CmnInitFunction.ClearList(SS01, true); if (rb01.Checked == true) { if (cdvres_grp_3.Text.Trim() == "") { oper = "ALL"; } else { oper = cdvres_grp_3.Text.Trim(); } // 2010-08-03-김민우 : Summary Table에서 설비 가동율을 조회한다. qry = "SELECT FLAG, MONTH_AVERAGE, DD_7, DD_6, DD_5, DD_4, DD_3, DD_2, DD_1 \n" + " FROM RSUMTRNOPR \n" + " WHERE FACTORY = '" + cdvFactory.Text + "' \n" + " AND WORK_DATE = '" + cdvBaseDate.Value.ToString("yyyyMMdd") + "' \n" + " AND OPER = '" + oper + "' \n" + " ORDER BY DECODE(FLAG, '종합가동율', 0, '성능가동율', 1, '시간가동율', 2, 99) ASC"; } else if (rb02.Checked == true) { if (cdvres_grp_3.Text.Trim() == "") { oper = "ALL"; } else { oper = cdvres_grp_3.Text.Trim(); } // 2010-08-03-김민우 : Summary Table에서 설비 가동율을 조회한다. qry = "SELECT MAINT_CODE, MONTH_AVERAGE, DD_7, DD_6, DD_5, DD_4, DD_3, DD_2, DD_1 \n" + " FROM RSUMTRNDWH \n" + " WHERE FACTORY = '" + cdvFactory.Text + "' \n" + " AND WORK_DATE = '" + cdvBaseDate.Value.ToString("yyyyMMdd") + "' \n" + " AND OPER = '" + oper + "' \n" + " ORDER BY MAINT_CODE ASC"; } if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP") { System.Windows.Forms.Clipboard.SetText(qry.Replace((char)Keys.Tab, ' ')); } dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", qry.Replace((char)Keys.Tab, ' ')); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return(false); } SS01.DataSource = dt; fnMakeChart(SS01, 0, 2); return(true); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); MessageBox.Show(ex.Message); return(false); } finally { LoadingPopUp.LoadingPopUpHidden(); Cursor.Current = Cursors.Default; } }
private bool fnDataFind() { /**************************************************** * comment : database에 저장된 데이터를 조회한다. * * created by : bee-jae jung(2010-07-20-화요일) * * modified by : bee-jae jung(2010-07-20-화요일) ****************************************************/ DataTable dt = null; //String sPackage = "", sParameter = ""; String sQuery = ""; try { Cursor.Current = Cursors.WaitCursor; LoadingPopUp.LoadIngPopUpShow(this); // 2010-07-20-정비재 : Sheet / Listview를 초기화 한다. CmnInitFunction.ClearList(SS01, true); // 2011-07-12-정비재 : Queyr문의 실행시간이 오래 걸려서 1시간 Batch job으로 RWIPLOTGCT Table에 입력하고 // : RWIPLOTGCT Table에 데이터를 검색한다. // 2011-07-12-정비재 : 기존 Source Backup /* * // 2010-07-20-정비재 : gct wip report를 검색한다. * sPackage = "PACKAGE_PRD010103.PROC_PRD010103"; * sParameter = "P_MAT_ID:" + txtMatID.Text + "│ P_LOT_TYPE:" + txtLotType.Text; + + dt = CmnFunction.oComm.fnExecutePackage("DYNAMIC", sPackage, sParameter); */ // 2017-07-03-mgkim : MES GCT WIP Manual 수정본과 JOIN하여 VIEW sQuery = "SELECT NVL(C.GCT_PROJECT_NO, A.GCT_PROJECT_NO) AS GCT_PROJECT_NO, B.MAT_CMF_8 AS GCT_DEVICE, NVL(C.PACKAGE, A.PACKAGE) AS PACKAGE, \n" + " NVL(C.LD_COUNT, A.LD_COUNT) AS LD_COUNT, NVL(C.DIMENSION, A.DIMENSION) AS DIMENSION, B.MAT_CMF_7 AS VENDOR_PART_NO, \n" + " NVL(C.WFR_LOT_ID, A.WFR_LOT_ID) AS WFR_LOT_ID, NVL(C.GCT_ASSY_LOT_ID, A.GCT_ASSY_LOT_ID) AS GCT_ASSY_LOT_ID, NVL(C.GCT_TEST_LOT_ID, A.GCT_TEST_LOT_ID) AS GCT_TEST_LOT_ID, \n" + " NVL(C.VENDOR_LOT_ID, A.VENDOR_LOT_ID) AS VENDOR_LOT_ID, NVL(C.PROD_RLSESCHED_NO, A.PROD_RLSESCHED_NO) AS PROD_RLSESCHED_NO, NVL(C.VENDOR_ORDER_NO, A.VENDOR_ORDER_NO) AS VENDOR_ORDER_NO, \n" + " NVL(C.TEST_RCVD_QTY, A.TEST_RCVD_QTY) AS TEST_RCVD_QTY, NVL(C.TEST_RCVD_DATE, A.TEST_RCVD_DATE) AS TEST_RCVD_DATE, NVL(C.TEST_QUE, A.TEST_QUE) AS TEST_QUE,\n" + " NVL(C.TEST_START_DATE, A.TEST_START_DATE) AS TEST_START_DATE, NVL(C.FINAL_TEST_CAS_OS, A.FINAL_TEST_CAS_OS) AS FINAL_TEST_CAS_OS, NVL(C.QA_EL_TEST, A.QA_EL_TEST) AS QA_EL_TEST, \n" + " NVL(C.TEST_HOLD, A.TEST_HOLD) AS TEST_HOLD, NVL(C.LOT_HOLD_DATE, A.LOT_HOLD_DATE) AS LOT_HOLD_DATE, NVL(C.LOT_HOLD_REL_DATE, A.LOT_HOLD_REL_DATE) AS LOT_HOLD_REL_DATE, \n" + " NVL(C.TEST_OUT_QTY, A.TEST_OUT_QTY) AS TEST_OUT_QTY, NVL(C.TEST_OUT_FCST_DATE, A.TEST_OUT_FCST_DATE) AS TEST_OUT_FCST_DATE, NVL(C.TEST_OUT_DATE, A.TEST_OUT_DATE) AS TEST_OUT_DATE, \n" + " NVL(C.VM, A.VM) AS VM, NVL(C.BAKE, A.BAKE) AS BAKE, NVL(C.TNR, A.TNR) AS TNR, \n" + " NVL(C.PACK, A.PACK) AS PACK, NVL(C.PACK_OUT_QTY, A.PACK_OUT_QTY) AS PACK_OUT_QTY, NVL(C.PACK_OUT_DATE, A.PACK_OUT_DATE) AS PACK_OUT_DATE, \n" + " NVL(C.FGS_QTY, A.FGS_QTY) AS FGS_QTY, NVL(C.SHIP_OUT_QTY, A.SHIP_OUT_QTY) AS SHIP_OUT_QTY, NVL(C.FCST_SHIP_DATE, A.FCST_SHIP_DATE) AS FCST_SHIP_DATE, \n" + " NVL(C.ACT_SHIP_TIME, A.ACT_SHIP_TIME) AS ACT_SHIP_TIME, NVL(C.CUST_REQ_DATE, A.CUST_REQ_DATE) AS CUST_REQ_DATE, NVL(C.PR_NO, A.PR_NO) AS PR_NO,\n" + " NVL(C.TEST_PO, A.TEST_PO) AS TEST_PO, NVL(C.HOLD_CODE, A.HOLD_CODE) AS HOLD_CODE, NVL(C.REJECT, A.REJECT) AS REJECT, \n" + " NVL(C.REMARK, A.REMARK) AS REMARK, \n" + " C.UPDATE_TIME \n" + " FROM RWIPLOTGCT A \n" + " , (SELECT DISTINCT MAT_ID AS MAT_ID \n" + " , MAT_CMF_7 AS MAT_CMF_7 \n" + " , MAT_CMF_8 AS MAT_CMF_8 \n" + " FROM MWIPMATDEF \n" + " WHERE MAT_GRP_1 = 'GC') B, \n" + " CWIPLOTGCT@RPTTOMES C \n" + " WHERE A.VENDOR_PART_NO = B.MAT_ID \n" + " AND A.GCT_TEST_LOT_ID = C.GCT_TEST_LOT_ID(+) \n" + " ORDER BY A.GCT_TEST_LOT_ID ASC"; if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP") { System.Windows.Forms.Clipboard.SetText(sQuery); } dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", sQuery.Replace((char)Keys.Tab, ' ')); if (dt.Rows.Count <= 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return(false); } int[] rowType = SS01.RPT_DataBindingWithSubTotal(dt, 0, 0, 1, null, null); int iColPos = 0; for (int iCol = 0; iCol < SS01.ActiveSheet.Columns.Count; iCol++) { if (SS01.ActiveSheet.GetColumnLabel(0, iCol).ToString() == "UPDATE_TIME") { iColPos = iCol; break; } } for (int i = 0; i < SS01.ActiveSheet.RowCount; i++) { if (SS01.ActiveSheet.Cells[i, iColPos].Value != null && SS01.ActiveSheet.Cells[i, iColPos].Value.ToString().Trim() != "") { SS01.ActiveSheet.Rows[i].BackColor = Color.Pink; } } return(true); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); MessageBox.Show(ex.Message); return(false); } finally { LoadingPopUp.LoadingPopUpHidden(); Cursor.Current = Cursors.Default; } }