private void GetWorkDay() { DateTime Now = cdvDate.Value; FindWeek_SOP_A = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); FindWeek_SOP_T = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "SE"); FindWeek_RTF = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "QC"); }
/// <summary> /// 2. 헤더 생성 /// </summary> private void GridColumnInit() { spdData.RPT_ColumnInit(); FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); try { spdData.RPT_AddBasicColumn("PKG", 0, 0, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("CODE", 0, 1, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("차수", 0, 2, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("CHIP", 0, 3, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("STACK", 0, 4, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("weight", 0, 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("WIP", 0, 6, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("FRONT", 1, 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("FRONT conversion", 1, 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("B/E", 1, 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("TOTAL", 1, 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 6, 4); spdData.RPT_AddBasicColumn("PLAN", 0, 10, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("2주", 1, 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("4주", 1, 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 10, 2); spdData.RPT_AddBasicColumn("WIP days", 0, 12, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("2주", 1, 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double1, 70); spdData.RPT_AddBasicColumn("4주", 1, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double1, 70); spdData.RPT_MerageHeaderColumnSpan(0, 12, 2); spdData.RPT_MerageHeaderRowSpan(0, 0, 2); spdData.RPT_MerageHeaderRowSpan(0, 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 2, 2); spdData.RPT_MerageHeaderRowSpan(0, 3, 2); spdData.RPT_MerageHeaderRowSpan(0, 4, 2); spdData.RPT_MerageHeaderRowSpan(0, 5, 5); spdData.RPT_ColumnConfigFromTable(btnSort); } catch (Exception ex) { CmnFunction.ShowMsgBox(ex.Message); } }
/// <summary> /// 2. 헤더 생성 /// </summary> private void GridColumnInit() { GetDayArray(); spdData.RPT_ColumnInit(); spdData2.RPT_ColumnInit(); FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "SE"); FindWeek_RTF = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "QC"); try { spdData.RPT_AddBasicColumn("Customer", 0, 0, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 80); spdData.RPT_AddBasicColumn("Family", 0, 1, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 80); spdData.RPT_AddBasicColumn("LD Count", 0, 2, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Package", 0, 3, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 80); spdData.RPT_AddBasicColumn("Type1", 0, 4, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Type2", 0, 5, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Density", 0, 6, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Generation", 0, 7, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Pin Type", 0, 8, Visibles.False, Frozen.True, Align.Left, Merge.True, Formatter.String, 130); spdData.RPT_AddBasicColumn("Product", 0, 9, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 180); spdData.RPT_AddBasicColumn("Cust Device", 0, 10, Visibles.False, Frozen.True, Align.Left, Merge.True, Formatter.String, 180); spdData.RPT_AddBasicColumn("Next week (WW" + FindWeek.NextWeek.Substring(4, 2) + ")", 0, 11, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("RTF", 1, 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("SOP", 1, 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 11, 2); spdData.RPT_AddBasicColumn("금주(WW" + FindWeek.ThisWeek.Substring(4, 2) + ")", 0, 13, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("RTF", 1, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("SOP", 1, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("actual", 1, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("RTF remaining", 1, 16, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("COB remaining amount", 1, 17, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_MerageHeaderColumnSpan(0, 13, 5); spdData.RPT_AddBasicColumn("CHIP remaining amount", 0, 18, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("RTF", 1, 18, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("SOP", 1, 19, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_MerageHeaderColumnSpan(0, 18, 2); spdData.RPT_AddBasicColumn("INPUT", 0, 20, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("D0", 1, 20, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("actual", 1, 21, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("residual quantity", 1, 22, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("D1", 1, 23, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("D2", 1, 24, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("D3", 1, 25, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 20, 6); spdData.RPT_AddBasicColumn("WIP", 0, 26, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("TOTAL", 1, 26, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("STOCK", 1, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("L/N", 1, 28, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("B/G", 1, 29, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("LABEL_PRINT", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100); spdData.RPT_AddBasicColumn("SAW", 1, 31, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("UV", 1, 32, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("AVI", 1, 33, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("PVI", 1, 34, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("HMK3", 1, 35, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("PACKING", 1, 36, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("HMK4", 1, 37, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 26, 12); spdData.RPT_AddBasicColumn(DateArray[0].ToString(), 0, 38, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 38, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("actual", 1, 39, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("residual quantity", 1, 40, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 38, 3); spdData.RPT_AddBasicColumn(DateArray[1].ToString(), 0, 41, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 41, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(DateArray[2].ToString(), 0, 42, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 42, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(DateArray[3].ToString(), 0, 43, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 43, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(DateArray[4].ToString(), 0, 44, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 44, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(DateArray[5].ToString(), 0, 45, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 45, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(DateArray[6].ToString(), 0, 46, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 46, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("D1 change plan", 0, 47, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 47, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("the day's performance", 1, 48, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("D0 + D1 remaining", 1, 49, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 47, 3); spdData.RPT_AddBasicColumn("Net Die", 0, 50, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, 0, 2); spdData.RPT_MerageHeaderRowSpan(0, 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 2, 2); spdData.RPT_MerageHeaderRowSpan(0, 3, 2); spdData.RPT_MerageHeaderRowSpan(0, 4, 2); spdData.RPT_MerageHeaderRowSpan(0, 5, 2); spdData.RPT_MerageHeaderRowSpan(0, 6, 2); spdData.RPT_MerageHeaderRowSpan(0, 7, 2); spdData.RPT_MerageHeaderRowSpan(0, 8, 2); spdData.RPT_MerageHeaderRowSpan(0, 9, 2); spdData.RPT_MerageHeaderRowSpan(0, 10, 2); spdData.RPT_MerageHeaderRowSpan(0, 50, 2); spdData.RPT_ColumnConfigFromTable(btnSort); //Group항목이 있을경우 반드시 선언해줄것. spdData2.RPT_AddBasicColumn("Notice", 0, 0, Visibles.True, Frozen.True, Align.Center, Merge.False, Formatter.String, 180); spdData2.RPT_AddBasicColumn("FACTORY", 0, 1, Visibles.True, Frozen.True, Align.Center, Merge.False, Formatter.String, 80); spdData2.RPT_AddBasicColumn("MAT_ID", 0, 2, Visibles.True, Frozen.True, Align.Left, Merge.False, Formatter.String, 180); spdData2.RPT_AddBasicColumn("PLAN_DAY", 0, 3, Visibles.True, Frozen.True, Align.Center, Merge.False, Formatter.String, 80); spdData2.RPT_AddBasicColumn("PLAN_QTY", 0, 4, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 80); } catch (Exception ex) { CmnFunction.ShowMsgBox(ex.Message); } }
/// <summary> /// 2. 헤더 생성 /// </summary> private void GridColumnInit() { FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); try { spdData.RPT_ColumnInit(); spdData.RPT_AddBasicColumn("PRODUCT", 0, 0, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 150); spdData.RPT_AddBasicColumn("PIN TYPE", 0, 1, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 150); spdData.RPT_AddBasicColumn("Material type", 0, 2, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("MATCODE", 0, 3, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 80); spdData.RPT_AddBasicColumn("categories", 0, 4, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 250); spdData.RPT_AddBasicColumn("Process group", 0, 5, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Operation", 0, 6, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Unit", 0, 7, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("USAGE", 0, 8, Visibles.True, Frozen.True, Align.Right, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Remaining amount compared to production plan", 0, 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn(FindWeek.ThisWeek.Substring(4, 2) + "WW", 1, 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.NextWeek.Substring(4, 2) + "WW", 1, 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W2_Week.Substring(4, 2) + "WW", 1, 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W3_Week.Substring(4, 2) + "WW", 1, 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W4_Week.Substring(4, 2) + "WW", 1, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W5_Week.Substring(4, 2) + "WW", 1, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_MerageHeaderColumnSpan(0, 9, 6); spdData.RPT_AddBasicColumn("Material Acquisition Status", 0, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("On-site inventory", 1, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("Warehouse stock", 1, 16, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("Safety stock warning", 1, 17, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 120); spdData.RPT_AddBasicColumn("Daily requirement", 1, 18, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("Estimated exhaustion date", 1, 19, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("Material delivery date", 1, 20, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn("Order quantity", 1, 21, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn("Order Warning", 1, 22, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 100); spdData.RPT_MerageHeaderColumnSpan(0, 15, 8); spdData.RPT_AddBasicColumn("over and short quantity by work week", 0, 23, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 80); spdData.RPT_AddBasicColumn(FindWeek.ThisWeek.Substring(4, 2) + "WW", 1, 23, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.NextWeek.Substring(4, 2) + "WW", 1, 24, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W2_Week.Substring(4, 2) + "WW", 1, 25, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W3_Week.Substring(4, 2) + "WW", 1, 26, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W4_Week.Substring(4, 2) + "WW", 1, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_AddBasicColumn(FindWeek.W5_Week.Substring(4, 2) + "WW", 1, 28, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80); spdData.RPT_MerageHeaderColumnSpan(0, 23, 6); spdData.RPT_MerageHeaderRowSpan(0, 0, 2); spdData.RPT_MerageHeaderRowSpan(0, 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 2, 2); spdData.RPT_MerageHeaderRowSpan(0, 3, 2); spdData.RPT_MerageHeaderRowSpan(0, 4, 2); spdData.RPT_MerageHeaderRowSpan(0, 5, 2); spdData.RPT_MerageHeaderRowSpan(0, 6, 2); spdData.RPT_MerageHeaderRowSpan(0, 7, 2); spdData.RPT_MerageHeaderRowSpan(0, 8, 2); spdData.RPT_ColumnConfigFromTable(btnSort); } catch (Exception ex) { CmnFunction.ShowMsgBox(ex.Message); LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 4. 쿼리 생성 /// </summary> /// <returns></returns> private string MakeSqlString() { StringBuilder strSqlString = new StringBuilder(); FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); string QueryCond1; string QueryCond2; string QueryCond3; //string QueryCond4; string Yesterday; string sD0; string sD1; string sD2; string sTime; string sKpcsValue; // Kpcs 구분에 의한 나누기 분모 값 string sD; sD = cdvDate.Value.AddDays(-6).ToString("yyyyMMdd"); sD0 = cdvDate.Value.ToString("yyyyMMdd"); sD1 = cdvDate.Value.AddDays(1).ToString("yyyyMMdd"); sD2 = cdvDate.Value.AddDays(2).ToString("yyyyMMdd"); Yesterday = cdvDate.Value.AddDays(-1).ToString("yyyyMMdd"); udcTableForm tableForm = (udcTableForm)btnSort.BindingForm; QueryCond1 = tableForm.SelectedValueToQueryContainNull; QueryCond2 = tableForm.SelectedValue2ToQueryContainNull; QueryCond3 = tableForm.SelectedValue3ToQueryContainNull; //QueryCond4 = tableForm.SelectedValue4ToQueryContainNull; // kpcs 선택에 의한 분모 값 저장 한다. if (ckbKpcs.Checked == true) { sKpcsValue = "1000"; } else { sKpcsValue = "1"; } sTime = cdvVersion.Text.Substring(18, 2); //strSqlString.Append(" , ROUND(SUM(NVL(SHP_TODAY, 0)) / " + sKpcsValue + ", 0) AS SHP_TODAY" + "\n"); //strSqlString.Append(" , ROUND(SUM(NVL(WIP.HMK3A, 0)) / " + sKpcsValue + ", 0) AS HMK3A" + "\n"); //strSqlString.Append(" , ROUND(SUM(NVL(WIP.QC_GATE, 0)) / " + sKpcsValue + ", 0) AS QC_GATE" + "\n"); //strSqlString.Append(" , ROUND(SUM(NVL(WIP.PVI, 0)) / " + sKpcsValue + ", 0) AS PVI" + "\n"); //strSqlString.Append(" , ROUND(SUM(NVL(WIP.BAKE,0)) / " + sKpcsValue + ", 0) AS BAKE" + "\n"); if (ckbWF.Checked == true) { strSqlString.Append("SELECT " + QueryCond3 + ", MAT.OPER" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SLP.SO_QTY, 0) / WF_NET_DIE), 0) AS SO_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(WIP.WIP_QTY, 0) / WF_NET_DIE), 0) AS WIP_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR_Y.Y_STEP_TARGET, 0) / WF_NET_DIE), 0) AS ORIGIN_PLAN" + "\n"); strSqlString.Append(" , ROUND(SUM((NVL(SHP.LAST_END_QTY, 0) + NVL(MOV_T.D0_STEP_MOVE, 0)) / WF_NET_DIE), 0) AS REV_PLAN" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SHP.END_QTY, 0) / WF_NET_DIE), 0) AS END_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM((NVL(SHP.END_QTY, 0) - (NVL(SHP.LAST_END_QTY, 0) + NVL(MOV_T.D0_STEP_MOVE, 0))) / WF_NET_DIE), 0) AS GAP" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(MOV_T.D1_STEP_MOVE, 0) / WF_NET_DIE), 0) AS D1_STEP_MOVE" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(MOV_T.D2_STEP_MOVE, 0) / WF_NET_DIE), 0) AS D2_STEP_MOVE" + "\n"); //strSqlString.Append(" , ROUND(SUM((NVL(TAR.D0_STEP_TARGET, 0) + NVL(SHP.END_QTY, 0)) / WF_NET_DIE), 0) AS D0_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR_Y.Y_STEP_TARGET, 0) / WF_NET_DIE), 0) AS D0_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR.D1_STEP_TARGET, 0) / WF_NET_DIE), 0) AS D1_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR.D2_STEP_TARGET, 0) / WF_NET_DIE), 0) AS D2_STEP_TARGET" + "\n"); } else { strSqlString.Append("SELECT " + QueryCond3 + ", MAT.OPER" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SLP.SO_QTY, 0)) / " + sKpcsValue + ", 0) AS SO_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(WIP.WIP_QTY, 0)) / " + sKpcsValue + ", 0) AS WIP_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR_Y.Y_STEP_TARGET, 0)) / " + sKpcsValue + ", 0) AS ORIGIN_PLAN" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SHP.LAST_END_QTY, 0) + NVL(MOV_T.D0_STEP_MOVE, 0)) / " + sKpcsValue + ", 0) AS REV_PLAN" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SHP.END_QTY, 0)) / " + sKpcsValue + ", 0) AS END_QTY" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(SHP.END_QTY, 0) - (NVL(SHP.LAST_END_QTY, 0) + NVL(MOV_T.D0_STEP_MOVE, 0))) / " + sKpcsValue + ", 0) AS GAP" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(MOV_T.D1_STEP_MOVE, 0)) / " + sKpcsValue + ", 0) AS D1_STEP_MOVE" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(MOV_T.D2_STEP_MOVE, 0)) / " + sKpcsValue + ", 0) AS D2_STEP_MOVE" + "\n"); //strSqlString.Append(" , ROUND(SUM(NVL(TAR.D0_STEP_TARGET, 0) + NVL(SHP.END_QTY, 0)) / " + sKpcsValue + ", 0) AS D0_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR_Y.Y_STEP_TARGET, 0)) / " + sKpcsValue + ", 0) AS D0_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR.D1_STEP_TARGET, 0)) / " + sKpcsValue + ", 0) AS D1_STEP_TARGET" + "\n"); strSqlString.Append(" , ROUND(SUM(NVL(TAR.D2_STEP_TARGET, 0)) / " + sKpcsValue + ", 0) AS D2_STEP_TARGET" + "\n"); } strSqlString.Append(" FROM (" + "\n"); strSqlString.Append(" SELECT A.*, B.OPER" + "\n"); strSqlString.Append(" FROM VWIPMATDEF A" + "\n"); strSqlString.Append(" , MWIPFLWOPR@RPTTOMES B" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND A.FACTORY = B.FACTORY" + "\n"); strSqlString.Append(" AND A.FIRST_FLOW = B.FLOW" + "\n"); strSqlString.Append(" AND A.FACTORY = '" + cdvFactory.Text + "'" + "\n"); strSqlString.Append(" AND A.DELETE_FLAG = ' '" + "\n"); strSqlString.Append(" AND A.MAT_TYPE = 'FG'" + "\n"); #region 상세 조회에 따른 SQL문 생성 if (udcWIPCondition1.Text != "ALL" && udcWIPCondition1.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_1 {0}" + "\n", udcWIPCondition1.SelectedValueToQueryString); } if (udcWIPCondition2.Text != "ALL" && udcWIPCondition2.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_2 {0} " + "\n", udcWIPCondition2.SelectedValueToQueryString); } if (udcWIPCondition3.Text != "ALL" && udcWIPCondition3.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_3 {0} " + "\n", udcWIPCondition3.SelectedValueToQueryString); } if (udcWIPCondition4.Text != "ALL" && udcWIPCondition4.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_4 {0} " + "\n", udcWIPCondition4.SelectedValueToQueryString); } if (udcWIPCondition5.Text != "ALL" && udcWIPCondition5.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_5 {0} " + "\n", udcWIPCondition5.SelectedValueToQueryString); } if (udcWIPCondition6.Text != "ALL" && udcWIPCondition6.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_6 {0} " + "\n", udcWIPCondition6.SelectedValueToQueryString); } if (udcWIPCondition7.Text != "ALL" && udcWIPCondition7.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_7 {0} " + "\n", udcWIPCondition7.SelectedValueToQueryString); } if (udcWIPCondition8.Text != "ALL" && udcWIPCondition8.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_8 {0} " + "\n", udcWIPCondition8.SelectedValueToQueryString); } if (udcWIPCondition9.Text != "ALL" && udcWIPCondition9.Text != "") { strSqlString.AppendFormat(" AND A.MAT_GRP_9 {0} " + "\n", udcWIPCondition9.SelectedValueToQueryString); } #endregion strSqlString.Append(" AND A.MAT_ID LIKE '" + txtProduct.Text + "'" + "\n"); strSqlString.Append(" ) MAT" + "\n"); strSqlString.Append(" , (" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER " + "\n"); strSqlString.Append(" , SUM(QTY_1) AS WIP_QTY" + "\n"); // 금일조회 기준 if (DateTime.Now.ToString("yyyyMMdd") == sD0) { strSqlString.Append(" FROM RWIPLOTSTS " + "\n"); strSqlString.Append(" WHERE 1=1 " + "\n"); } else { strSqlString.Append(" FROM RWIPLOTSTS_BOH " + "\n"); strSqlString.Append(" WHERE CUTOFF_DT = '" + sD0 + "22' " + "\n"); } strSqlString.Append(" AND FACTORY = '" + cdvFactory.Text + "'" + "\n"); strSqlString.Append(" AND LOT_DEL_FLAG = ' '" + "\n"); strSqlString.Append(" AND LOT_TYPE = 'W'" + "\n"); if (cdvType.Text != "ALL") { strSqlString.Append(" AND LOT_CMF_5 LIKE '" + cdvType.Text + "' " + "\n"); } strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); strSqlString.Append(" ) WIP" + "\n"); strSqlString.Append(" , ( " + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER" + "\n"); strSqlString.Append(" , SUM(LAST_END_QTY) AS LAST_END_QTY" + "\n"); strSqlString.Append(" , SUM(END_QTY) AS END_QTY" + "\n"); strSqlString.Append(" FROM (" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER " + "\n"); strSqlString.Append(" , (S1_END_QTY_1+S2_END_QTY_1+S3_END_QTY_1) AS LAST_END_QTY" + "\n"); strSqlString.Append(" , 0 AS END_QTY" + "\n"); strSqlString.Append(" FROM RSUMWIPMOV_BOH" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND CM_KEY_1 = '" + cdvFactory.Text + "'" + "\n"); strSqlString.Append(" AND WORK_DATE = '" + sD0 + "'" + "\n"); strSqlString.Append(" AND WORK_TIME = '" + sTime + "'" + "\n"); strSqlString.Append(" AND LOT_TYPE = 'W'" + "\n"); if (cdvType.Text != "ALL") { strSqlString.Append(" AND CM_KEY_3 LIKE '" + cdvType.Text + "' " + "\n"); } strSqlString.Append(" UNION ALL" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER" + "\n"); strSqlString.Append(" , 0 AS LAST_END_QTY" + "\n"); strSqlString.Append(" , (S1_END_QTY_1+S2_END_QTY_1+S3_END_QTY_1) AS END_QTY" + "\n"); strSqlString.Append(" FROM RSUMWIPMOV" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND CM_KEY_1 = '" + cdvFactory.Text + "'" + "\n"); strSqlString.Append(" AND WORK_DATE = '" + sD0 + "'" + "\n"); strSqlString.Append(" AND LOT_TYPE = 'W'" + "\n"); if (cdvType.Text != "ALL") { strSqlString.Append(" AND CM_KEY_3 LIKE '" + cdvType.Text + "' " + "\n"); } strSqlString.Append(" )" + "\n"); strSqlString.Append(" WHERE OPER NOT IN (' ', 'AZ010', 'T000N')" + "\n"); strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); strSqlString.Append(" ) SHP" + "\n"); //strSqlString.Append(" , ( " + "\n"); //strSqlString.Append(" SELECT MAT_ID, OPER, SUM(OUT_UNIT_QTY) AS Y_STEP_MOVE" + "\n"); //strSqlString.Append(" FROM SCHMGR.SOUTOPRMOV@RPTTOMES" + "\n"); //strSqlString.Append(" WHERE 1=1" + "\n"); //strSqlString.Append(" AND VERSION_HR = '" + Yesterday + "22'" + "\n"); //strSqlString.Append(" AND WORK_DATE = '" + sD0 + "'" + "\n"); //strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); //strSqlString.Append(" ) MOV_Y" + "\n"); strSqlString.Append(" , (" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER" + "\n"); strSqlString.Append(" , SUM(DECODE(WORK_DATE, '" + sD0 + "', OUT_UNIT_QTY, 0)) AS D0_STEP_MOVE" + "\n"); strSqlString.Append(" , SUM(DECODE(WORK_DATE, '" + sD1 + "', OUT_UNIT_QTY, 0)) AS D1_STEP_MOVE" + "\n"); strSqlString.Append(" , SUM(DECODE(WORK_DATE, '" + sD2 + "', OUT_UNIT_QTY, 0)) AS D2_STEP_MOVE" + "\n"); strSqlString.Append(" FROM SCHMGR.SOUTOPRMOV@RPTTOMES" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND VERSION = '" + cdvVersion.Text + "'" + "\n"); strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); strSqlString.Append(" ) MOV_T " + "\n"); strSqlString.Append(" , (" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER" + "\n"); strSqlString.Append(" , SUM(DECODE(TARGET_DATE, '" + sD0 + "', OUT_TARGET_QTY, 0)) AS D0_STEP_TARGET" + "\n"); strSqlString.Append(" , SUM(DECODE(TARGET_DATE, '" + sD1 + "', OUT_TARGET_QTY, 0)) AS D1_STEP_TARGET" + "\n"); strSqlString.Append(" , SUM(DECODE(TARGET_DATE, '" + sD2 + "', OUT_TARGET_QTY, 0)) AS D2_STEP_TARGET" + "\n"); strSqlString.Append(" FROM SCHMGR.SOUTSTPTGT@RPTTOMES" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND VERSION = '" + cdvVersion.Text + "'" + "\n"); strSqlString.Append(" AND FACTORY = '" + cdvFactory.Text + "'" + "\n"); if (cdvWeek.Text == "W0") { strSqlString.Append(" AND PLAN_WEEK = '" + FindWeek.ThisWeek + "'" + "\n"); } else if (cdvWeek.Text == "W1") { strSqlString.Append(" AND PLAN_WEEK IN ('" + FindWeek.ThisWeek + "','" + FindWeek.NextWeek + "')" + "\n"); } else { strSqlString.Append(" AND PLAN_WEEK IN ('" + FindWeek.ThisWeek + "','" + FindWeek.NextWeek + "','" + FindWeek.W2_Week + "')" + "\n"); } strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); strSqlString.Append(" ) TAR" + "\n"); strSqlString.Append(" , (" + "\n"); strSqlString.Append(" SELECT MAT_ID, OPER" + "\n"); strSqlString.Append(" , SUM(OUT_TARGET_QTY) AS Y_STEP_TARGET" + "\n"); strSqlString.Append(" FROM SCHMGR.SOUTSTPTGT@RPTTOMES" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND VERSION_HR = '" + Yesterday + "22'" + "\n"); strSqlString.Append(" AND TARGET_DATE BETWEEN '" + sD + "' AND '" + sD0 + "'" + "\n"); strSqlString.Append(" AND FACTORY = '" + cdvFactory.Text + "'" + "\n"); if (cdvWeek.Text == "W0") { strSqlString.Append(" AND PLAN_WEEK = '" + FindWeek.ThisWeek + "'" + "\n"); } else if (cdvWeek.Text == "W1") { strSqlString.Append(" AND PLAN_WEEK IN ('" + FindWeek.ThisWeek + "','" + FindWeek.NextWeek + "')" + "\n"); } else { strSqlString.Append(" AND PLAN_WEEK IN ('" + FindWeek.ThisWeek + "','" + FindWeek.NextWeek + "','" + FindWeek.W2_Week + "')" + "\n"); } strSqlString.Append(" GROUP BY MAT_ID, OPER" + "\n"); strSqlString.Append(" ) TAR_Y" + "\n"); strSqlString.Append(" , (" + "\n"); strSqlString.Append(" SELECT PROD_CODE AS MAT_ID, 'A0000' AS OPER" + "\n"); strSqlString.Append(" , SUM(CHIP_QTY) AS SO_QTY" + "\n"); strSqlString.Append(" FROM CWIPSECSLP@RPTTOMES" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND RECV_FLAG = ' '" + "\n"); strSqlString.Append(" AND TO_AREA IN ('HMK2')" + "\n"); strSqlString.Append(" AND FACTORY = '" + GlobalVariable.gsAssyDefaultFactory + "'" + "\n"); strSqlString.Append(" AND ISSUE_YMD >= '" + Yesterday + "'" + "\n"); strSqlString.Append(" GROUP BY PROD_CODE" + "\n"); strSqlString.Append(" UNION ALL" + "\n"); strSqlString.Append(" SELECT DEVICE AS MAT_ID, 'A0000' AS OPER" + "\n"); strSqlString.Append(" , SUM(DIE_QTY) AS SO_QTY " + "\n"); strSqlString.Append(" FROM CWIPHSOHIS@RPTTOMES" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND RECV_FLAG = ' '" + "\n"); strSqlString.Append(" AND WORK_DATE >= '" + Yesterday + "'" + "\n"); strSqlString.Append(" GROUP BY DEVICE" + "\n"); strSqlString.Append(" ) SLP" + "\n"); strSqlString.Append(" WHERE 1=1" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = WIP.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = SHP.MAT_ID(+)" + "\n"); //strSqlString.Append(" AND MAT.MAT_ID = MOV_Y.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = MOV_T.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = TAR.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = TAR_Y.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.MAT_ID = SLP.MAT_ID(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = SHP.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = WIP.OPER(+)" + "\n"); //strSqlString.Append(" AND MAT.OPER = MOV_Y.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = MOV_T.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = TAR.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = TAR_Y.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.OPER = SLP.OPER(+)" + "\n"); strSqlString.Append(" AND MAT.FACTORY = '" + cdvFactory.Text + "'" + "\n"); strSqlString.Append(" AND MAT.DELETE_FLAG = ' '" + "\n"); strSqlString.Append(" AND MAT.MAT_TYPE = 'FG'" + "\n"); if (cdvOper.Text != "ALL" && cdvOper.Text != "") { strSqlString.Append(" AND MAT.OPER " + cdvOper.SelectedValueToQueryString + "\n"); } strSqlString.Append(" AND NVL(WIP.WIP_QTY,0) + NVL(SHP.LAST_END_QTY,0) + NVL(SHP.END_QTY,0) +" + "\n"); strSqlString.Append(" NVL(MOV_T.D0_STEP_MOVE,0) + NVL(MOV_T.D1_STEP_MOVE,0) + NVL(MOV_T.D2_STEP_MOVE,0) +" + "\n"); strSqlString.Append(" NVL(TAR.D0_STEP_TARGET,0) + NVL(TAR.D1_STEP_TARGET,0) + NVL(TAR.D2_STEP_TARGET,0) +" + "\n"); strSqlString.Append(" NVL(TAR_Y.Y_STEP_TARGET,0) + NVL(SLP.SO_QTY,0) > 0" + "\n"); strSqlString.AppendFormat(" GROUP BY {0}, MAT.OPER " + "\n", QueryCond1); if (ckbPlan.Checked == true) { strSqlString.Append("HAVING SUM(NVL(SHP.LAST_END_QTY, 0) + NVL(MOV_T.D0_STEP_MOVE, 0)) > 0" + "\n"); } strSqlString.AppendFormat(" ORDER BY {0}, MAT.OPER " + "\n", QueryCond2); if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP") { System.Windows.Forms.Clipboard.SetText(strSqlString.ToString()); } return(strSqlString.ToString()); }
/// <summary> /// 2. 헤더 생성 /// </summary> private void GridColumnInit() { spdData.RPT_ColumnInit(); LabelTextChange(); String ss = DateTime.Now.ToString("MM-dd"); FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); try { spdData.RPT_AddBasicColumn("Customer", 0, 0, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 60); spdData.RPT_AddBasicColumn("Layer", 0, 1, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Bumping Type", 0, 2, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Operation Flow", 0, 3, Visibles.False, Frozen.True, Align.Left, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("PKG Type", 0, 4, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("RDL Plating", 0, 5, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Final Bump", 0, 6, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Sub. Material", 0, 7, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Size", 0, 8, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Thickness", 0, 9, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Flat Type", 0, 10, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Wafer Orientation", 0, 11, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Product", 0, 12, Visibles.False, Frozen.True, Align.Left, Merge.True, Formatter.String, 80); spdData.RPT_AddBasicColumn("Monthly plan", 0, 13, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Monthly Plan Rev", 0, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Production Status", 0, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("actual", 1, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Progress rate (%)", 1, 16, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double1, 90); spdData.RPT_AddBasicColumn("Difference", 1, 17, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 15, 3); spdData.RPT_AddBasicColumn("a daily goal", 0, 18, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Daily Performance", 0, 19, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(FindWeek.ThisWeek.Substring(0, 4) + "." + FindWeek.ThisWeek.Substring(4, 2) + " 주차", 0, 20, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("Plan", 1, 20, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("actual", 1, 21, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 90); spdData.RPT_AddBasicColumn("residual quantity", 1, 22, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 90); spdData.RPT_MerageHeaderColumnSpan(0, 20, 3); spdData.RPT_AddBasicColumn("HMK3B", 0, 23, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PACKING", 0, 24, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("OGI", 0, 25, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("AVI", 0, 26, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SORT", 0, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("FINAL_INSP", 0, 28, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("BUMP", 0, 29, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("REFLOW", 1, 29, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("BALL_MOUNT", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("ETCH", 1, 31, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SNAG_PLAT", 1, 32, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("CU_PLAT", 1, 33, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PHOTO", 1, 34, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SPUTTER", 1, 35, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_MerageHeaderColumnSpan(0, 29, 7); //BUMP spdData.RPT_AddBasicColumn("PSV3", 0, 36, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("PHOTO", 1, 36, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("RDL3", 0, 37, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("ETCH", 1, 37, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PLAT", 1, 38, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PHOTO", 1, 39, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SPUTTER", 1, 40, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_MerageHeaderColumnSpan(0, 37, 4); //RDL3 spdData.RPT_AddBasicColumn("PSV2", 0, 41, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("PHOTO", 1, 41, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("RDL2", 0, 42, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("ETCH", 1, 42, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PLAT", 1, 43, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PHOTO", 1, 44, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SPUTTER", 1, 45, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_MerageHeaderColumnSpan(0, 42, 4); //RDL2 spdData.RPT_AddBasicColumn("PSV1", 0, 46, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("PHOTO", 1, 46, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("RDL1", 0, 47, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("ETCH", 1, 47, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PLAT", 1, 48, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("PHOTO", 1, 49, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("SPUTTER", 1, 50, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_MerageHeaderColumnSpan(0, 50, 4); //RDL1 spdData.RPT_AddBasicColumn("RCF", 0, 51, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("PHOTO", 1, 51, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("I-STOCK", 0, 52, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("IQC", 0, 53, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("HMK2B", 0, 54, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_AddBasicColumn("TOTAL", 0, 55, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 60); spdData.RPT_MerageHeaderRowSpan(0, 0, 2); spdData.RPT_MerageHeaderRowSpan(0, 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 2, 2); spdData.RPT_MerageHeaderRowSpan(0, 3, 2); spdData.RPT_MerageHeaderRowSpan(0, 4, 2); spdData.RPT_MerageHeaderRowSpan(0, 5, 2); spdData.RPT_MerageHeaderRowSpan(0, 6, 2); spdData.RPT_MerageHeaderRowSpan(0, 7, 2); spdData.RPT_MerageHeaderRowSpan(0, 8, 2); spdData.RPT_MerageHeaderRowSpan(0, 9, 2); spdData.RPT_MerageHeaderRowSpan(0, 10, 2); spdData.RPT_MerageHeaderRowSpan(0, 11, 2); spdData.RPT_MerageHeaderRowSpan(0, 12, 2); spdData.RPT_MerageHeaderRowSpan(0, 13, 2); spdData.RPT_MerageHeaderRowSpan(0, 14, 2); spdData.RPT_MerageHeaderRowSpan(0, 18, 2); spdData.RPT_MerageHeaderRowSpan(0, 19, 2); spdData.RPT_MerageHeaderRowSpan(0, 23, 2); spdData.RPT_MerageHeaderRowSpan(0, 24, 2); spdData.RPT_MerageHeaderRowSpan(0, 25, 2); spdData.RPT_MerageHeaderRowSpan(0, 26, 2); spdData.RPT_MerageHeaderRowSpan(0, 27, 2); spdData.RPT_MerageHeaderRowSpan(0, 28, 2); spdData.RPT_MerageHeaderRowSpan(0, 52, 2); spdData.RPT_MerageHeaderRowSpan(0, 53, 2); spdData.RPT_MerageHeaderRowSpan(0, 54, 2); spdData.RPT_MerageHeaderRowSpan(0, 55, 2); spdData.RPT_ColumnConfigFromTable(btnSort); } catch (Exception ex) { CmnFunction.ShowMsgBox(ex.Message); } }
/// <summary> /// 2. 헤더 생성 /// </summary> private void GridColumnInit() { FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); dtOper = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2()); spdData.RPT_ColumnInit(); LabelTextChange(); try { spdData.RPT_AddBasicColumn("Customer", 0, 0, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Major Code", 0, 1, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Family", 0, 2, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Package", 0, 3, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("LD Count", 0, 4, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Type1", 0, 5, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Type2", 0, 6, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Pin Type", 0, 7, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Density", 0, 8, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Generation", 0, 9, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50); spdData.RPT_AddBasicColumn("Product", 0, 10, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Cust Device", 0, 11, Visibles.False, Frozen.True, Align.Left, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("PKG CODE", 0, 12, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 70); spdData.RPT_AddBasicColumn("Monthly plan", 0, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Cumulative Performance", 0, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("residual quantity", 0, 15, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("Progress rate", 0, 16, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("a daily goal", 0, 17, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn(cdvDate.Value.ToString("MM-dd"), 0, 18, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.String, 70); spdData.RPT_AddBasicColumn("plan", 1, 18, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("residual quantity", 1, 19, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_AddBasicColumn("actual", 1, 20, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 18, 3); int headerCount = 21; spdData.RPT_AddBasicColumn("Status of work", 0, 21, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 70); for (int i = 0; i < dtOper.Rows.Count; i++) { spdData.RPT_AddBasicColumn(dtOper.Rows[i][0].ToString(), 1, headerCount, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); headerCount++; } spdData.RPT_AddBasicColumn("sum", 1, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderColumnSpan(0, 21, dtOper.Rows.Count + 1); spdData.RPT_AddBasicColumn("Previous day's goal", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("The previous day's performance", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("Performance difference", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("GOAL", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("Today's goal", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("Remarks(Reasons for disruptions)", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("HOLD", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("Expected Results", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_AddBasicColumn("CHIP", 0, spdData.ActiveSheet.Columns.Count, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70); spdData.RPT_MerageHeaderRowSpan(0, spdData.ActiveSheet.Columns.Count - 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 0, 2); spdData.RPT_MerageHeaderRowSpan(0, 1, 2); spdData.RPT_MerageHeaderRowSpan(0, 2, 2); spdData.RPT_MerageHeaderRowSpan(0, 3, 2); spdData.RPT_MerageHeaderRowSpan(0, 4, 2); spdData.RPT_MerageHeaderRowSpan(0, 5, 2); spdData.RPT_MerageHeaderRowSpan(0, 6, 2); spdData.RPT_MerageHeaderRowSpan(0, 7, 2); spdData.RPT_MerageHeaderRowSpan(0, 8, 2); spdData.RPT_MerageHeaderRowSpan(0, 9, 2); spdData.RPT_MerageHeaderRowSpan(0, 10, 2); spdData.RPT_MerageHeaderRowSpan(0, 11, 2); spdData.RPT_MerageHeaderRowSpan(0, 12, 2); spdData.RPT_MerageHeaderRowSpan(0, 13, 2); spdData.RPT_MerageHeaderRowSpan(0, 14, 2); spdData.RPT_MerageHeaderRowSpan(0, 15, 2); spdData.RPT_MerageHeaderRowSpan(0, 16, 2); spdData.RPT_MerageHeaderRowSpan(0, 17, 2); spdData.RPT_ColumnConfigFromTable(btnSort); } catch (Exception ex) { CmnFunction.ShowMsgBox(ex.Message); } }
private void GetWorkDay() { FindWeek = CmnFunction.GetWeekInfo(cdvDate.SelectedValue(), "OTD"); }