private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString(0)); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //by John //1.Griid 합계 표시 spdData.DataSource = dt; spdData.RPT_ColumnConfigFromTable(btnSort); //2. 칼럼 고정(필요하다면..) //spdData.Sheets[0].FrozenColumnCount = 10; //3. Total부분 셀머지 //spdData.RPT_FillDataSelectiveCells("Total", 0, 4, 0, 9, true, Align.Center, VerticalAlign.Center); //4. Column Auto Fit4 spdData.RPT_AutoFit(false); // 1번 그래프 그리도록 이벤트 발생 //cboChart.SelectedIndex = 0; } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 조회 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { //if (!CheckField()) return; DataTable dt = null; GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } spdData.DataSource = dt; //그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴 //int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2); ////by John (한줄짜리) ////1.Griid 합계 표시 //int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 9, null, null, btnSort); ////2. 칼럼 고정(필요하다면..) //spdData.Sheets[0].FrozenColumnCount = 10; ////3. Total부분 셀머지 //spdData.RPT_FillDataSelectiveCells("Total", 0, 9, 0, 1, true, Align.Center, VerticalAlign.Center); //4. Column Auto Fit spdData.RPT_AutoFit(false); dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 3.조회 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { if (!CheckField()) { return; } DataTable dt = null; GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴 int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2); int[] rowType = spdData.RPT_DataBindingWithSubTotalAndDivideRows(dt, 0, sub + 1, 8, 9, 3, cdvFromToDate.SubtractBetweenFromToDate + 1, btnSort); spdData.RPT_FillDataSelectiveCells("Total", 0, 8, 0, 3, true, Align.Center, VerticalAlign.Center); spdData.RPT_FillColumnData(8, new string[] { "IN", "OUT", "YIELD" }); spdData.RPT_AutoFit(false); for (int i = 0; i < cdvFromToDate.SubtractBetweenFromToDate + 1; i++) { SetGrandYield(4, cdvFromToDate.SubtractBetweenFromToDate + 9 - i); } dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// Excel Export /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExcelExport_Click(object sender, EventArgs e) { if (spdData.ActiveSheet.Rows.Count == 0) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD002", GlobalVariable.gcLanguage)); return; } // Excel 바로 보이기 //ExcelHelper.Instance.subMakeExcel(spdData, this.lblTitle.Text, " ^ ", " ^ ", true); spdData.ExportExcel(); }
/// <summary> /// 6. View 버튼 Action /// </summary> /// private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } GridColumnInit(); spdData_Sheet1.RowCount = 0; try { LoadingPopUp.LoadIngPopUpShow(this); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴 int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2); int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 12, null, null, btnSort); //데이타테이블, 토탈 시작할 셀넘버, 시작 부터 서브토탈 몇개 쓸건지, 첫셀부터 몇번째 셀까지 TOTAL 적용안함 //spdData.Sheets[0].FrozenColumnCount = 3; //spdData.RPT_AutoFit(false); //Total부분 셀머지 spdData.RPT_FillDataSelectiveCells("Total", 0, 12, 0, 1, true, Align.Center, VerticalAlign.Center); spdData.RPT_AutoFit(false); spdData.RPT_SetPerSubTotalAndGrandTotal(0, 13, 12, 15); dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 6. View ¹öÆ° Action /// </summary> /// private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } GridColumnInit(); spdData_Sheet1.RowCount = 0; try { LoadingPopUp.LoadIngPopUpShow(this); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //±×·çÇÎ ¼ø¼ 1¼øÀ§¸¸ SubTotalÀ» »ç¿ëÇϱâ À§Çؼ ù¹ø° °ªÀ» °¡Á®¿È //int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2); //int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub+1, 11, null, null, btnSort); //µ¥ÀÌŸÅ×À̺í, ÅäÅ» ½ÃÀÛÇÒ ¼¿³Ñ¹ö, ½ÃÀÛ ºÎÅÍ ¼ºêÅäÅ» ¸î°³ ¾µ°ÇÁö, ù¼¿ºÎÅÍ ¸î¹ø° ¼¿±îÁö TOTAL Àû¿ë¾ÈÇÔ //spdData.Sheets[0].FrozenColumnCount = 3; //spdData.RPT_AutoFit(false); //TotalºÎºÐ ¼¿¸ÓÁö //spdData.RPT_FillDataSelectiveCells("Total", 0, 11, 0, 1, true, Align.Center, VerticalAlign.Center); spdData.DataSource = dt; spdData.RPT_AutoFit(false); dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// Insert RWEBGRPDEF Table. /// </summary> /// <returns>bool : True or False</returns> private bool Create_Security_Group() { string QueryCond, InsertValue = ""; string sysCurrentDate; DataTable rtDataTable = new DataTable(); try { sysCurrentDate = ""; sysCurrentDate = CmnFunction.GetSysDateTime(); if (sysCurrentDate == null) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage)); return(false); } QueryCond = ""; QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory); QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtSecGrp.Text); rtDataTable = CmnFunction.oComm.SelectData("RWEBGRPDEF", "1", QueryCond); if (rtDataTable.Rows.Count < 0) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD016", GlobalVariable.gcLanguage)); return(false); } else { InsertValue = ""; InsertValue = FwxCmnFunction.PackCondition(InsertValue, GlobalVariable.gsCentralFactory); InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtSecGrp.Text.Trim()); InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtDesc.Text.Trim()); InsertValue = FwxCmnFunction.PackCondition(InsertValue, GlobalVariable.gsUserID); InsertValue = FwxCmnFunction.PackCondition(InsertValue, sysCurrentDate); InsertValue = FwxCmnFunction.PackCondition(InsertValue, ""); InsertValue = FwxCmnFunction.PackCondition(InsertValue, ""); if (CmnFunction.oComm.InsertData("RWEBGRPDEF", "1", InsertValue) != true) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage)); return(false); } return(true); } } catch (Exception ex) { CmnFunction.ShowMsgBox("SEC1102.Create_Security_Group() : " + ex.ToString()); return(false); } }
public double RPT_4_AddData(DataTable dt, int[] Rows, int[] Columns, SeriseType SerType, DataTypes type) { double Max = 0; try { // Serise Type 으로 Row 선택한 경우 if (SerType == SeriseType.Rows) { for (int serise = 0; serise < Rows.Length; serise++, SerCount++) { for (int x = 0; x < Columns.Length; x++) { if (dt.Rows[Rows[serise]][Columns[x]] != null && dt.Rows[Rows[serise]][Columns[x]] != DBNull.Value) { //this.Value[x, SerCount] = Convert.ToDouble(dt.Rows[Rows[serise]][Columns[x]]) * GetCrossValue(type); //Max = Math.Max(Max, this.Value[x, SerCount]); this.Series[x].Points.AddXY(dt.Rows[Rows[serise]][x].ToString(), dt.Rows[Rows[serise]][Columns[x]].ToString()); //chart1.Series[0].Points.AddXY(dt_graph.Columns[i + 1].ToString(), Convert.ToInt32(dt_graph.Rows[0][i + 1])); Max = Math.Max(Max, this.Series[x].Points.FindMaxByValue().YValues[0]); } } } } else { // Serise Type 으로 컬럼을 선택한 경우 for (int serise = 0; serise < Columns.Length; serise++, SerCount++) { for (int x = 0; x < Rows.Length; x++) { if (dt.Rows[Rows[x]][Columns[serise]] != null && dt.Rows[Rows[x]][Columns[serise]] != DBNull.Value) { //this.Value[SerCount, x] = Convert.ToDouble(dt.Rows[Rows[x]][Columns[serise]]) * GetCrossValue(type); //Max = Math.Max(Max, this.Value[SerCount, x]); this.Series[SerCount].Points.AddXY(dt.Rows[Rows[x]][serise].ToString(), dt.Rows[Rows[x]][Columns[serise]].ToString()); //this.Series[serise].Points.AddXY(Convert.ToDouble(dt.Rows[x][serise]), Convert.ToDouble(dt.Rows[x][serise + 1])); Max = Math.Max(Max, this.Series[SerCount].Points.FindMaxByValue().YValues[0]); } } } } return(Max); } catch (Exception ex) { throw new Exception(RptMessages.GetMessage("STD096", GlobalVariable.gcLanguage) + ex.Message); } }
// x 축 좌표 셋팅 public void RPT_7_SetXAsixTitle(string[] Titles) { if (XCount < Titles.Length) { throw new Exception(RptMessages.GetMessage("STD084", GlobalVariable.gcLanguage) + XCount.ToString()); } for (int i = 0; i < Titles.Length; i++) { this.Series[0].Points[i].AxisLabel = Titles[i]; } //this.Legend[i] = Titles[i]; }
public void RPT_7_SetXAsixTitleUsingSpreadHeader(FpSpread spread, int startHeaderRow, int[] HeaderColumn) { if (XCount < HeaderColumn.Length) { throw new Exception(RptMessages.GetMessage("STD084", GlobalVariable.gcLanguage) + XCount.ToString()); } for (int i = 0; i < HeaderColumn.Length; i++) { this.Series[0].Points[i].AxisLabel = spread.ActiveSheet.ColumnHeader.Cells[startHeaderRow, HeaderColumn[i]].Text; } //this.Legend[i] = spread.ActiveSheet.ColumnHeader.Cells[startHeaderRow, HeaderColumn[i]].Text; }
private void btnDelete_Click(object sender, EventArgs e) { if (CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF002", GlobalVariable.gcLanguage), "", MessageBoxButtons.YesNo, 2) != System.Windows.Forms.DialogResult.Yes) { return; } if (Update_EQErr_Data("DELETE") == true) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF001", GlobalVariable.gcLanguage)); View_EQErr_List(); } }
public double RPT_4_AddData(FpSpread spread, int[] Rows, int[] Columns, SeriseType SerType, DataTypes type) { double Max = 0; try { // Serise Type 으로 Row 선택한 경우 if (SerType == SeriseType.Rows) { for (int serise = 0; serise < Rows.Length; serise++, SerCount++) { for (int x = 0; x < Columns.Length; x++) { //this.Value[SerCount, x] = Convert.ToDouble(spread.ActiveSheet.Cells[Rows[serise], Columns[x]].Value) * GetCrossValue(type); //Max = Math.Max(Max, this.Value[SerCount, x]); //if (spread.ActiveSheet.Cells[Rows[serise], Columns[x]].Value != null && spread.ActiveSheet.Cells[Rows[serise], Columns[x]].Value != DBNull.Value) //{ //this.Series[SerCount].Points.AddXY(spread.ActiveSheet.Cells[Rows[serise], x].Value, spread.ActiveSheet.Cells[Rows[serise], Columns[x]].Value); this.Series[SerCount].Points.AddY(Convert.ToDouble(spread.ActiveSheet.Cells[Rows[serise], Columns[x]].Value) * GetCrossValue(type)); Max = Math.Max(Max, this.Series[SerCount].Points.FindMaxByValue().YValues[0]); //Max //} } } } else { // Serise Type 으로 컬럼을 선택한 경우 for (int serise = 0; serise < Columns.Length; serise++, SerCount++) { for (int x = 0; x < Rows.Length; x++) { //this.Value[SerCount, x] = Convert.ToDouble(spread.ActiveSheet.Cells[Rows[x], Columns[serise]].Value) * GetCrossValue(type); //Max = Math.Max(Max, this.Value[SerCount, x]); this.Series[SerCount].Points.AddY(Convert.ToDouble(spread.ActiveSheet.Cells[Rows[x], Columns[serise]].Value) * GetCrossValue(type)); Max = Math.Max(Max, this.Series[SerCount].Points.FindMaxByValue().YValues[0]); // Max } } } return(Max); } catch (Exception ex) { throw new Exception(RptMessages.GetMessage("STD096", GlobalVariable.gcLanguage) + ex.Message); } }
private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } GridColumnInit(); spdData_Sheet1.RowCount = 0; try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } spdData.DataSource = dt; for (int i = 1; i < spdData.ActiveSheet.Rows.Count; i++) { if (spdData.ActiveSheet.Cells[i, 6].Value.Equals("Y")) { spdData.ActiveSheet.Rows[i].BackColor = Color.Red; } } //4. Column Auto Fit spdData.RPT_AutoFit(false); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
private void btnView_Click(object sender, EventArgs e) { if (CheckField() == false) { return; } DataTable dt = null; GridColumnInit(); try { spdData_Sheet1.RowCount = 0; this.Refresh(); LoadingPopUp.LoadIngPopUpShow(this); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } ////by John (한줄짜리) ////1.Griid 합계 표시 int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, 1, 11, null, null, btnSort); // 토탈 시작할 셀넘버, 시작 부터 서브토탈 몇개 쓸건지, 첫셀부터 몇번째 셀까지 TOTAL 적용안함 ////2. 칼럼 고정(필요하다면..) //spdData.Sheets[0].FrozenColumnCount = 9; ////3. Total부분 셀머지 spdData.RPT_FillDataSelectiveCells("Total", 0, 11, 0, 1, true, Align.Center, VerticalAlign.Center); //4. Column Auto Fit spdData.RPT_AutoFit(false); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
private Boolean CheckField() { if (cdvFactory.Text.TrimEnd() == "") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD001", GlobalVariable.gcLanguage)); return(false); } if (cdvOper.FromText.TrimEnd() == "" || cdvOper.ToText.TrimEnd() == "") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD005", GlobalVariable.gcLanguage)); return(false); } return(true); }
private void btnView_Click(object sender, EventArgs e) { //DurationTime_Check(); DataTable dt = null; if (CheckField() == false) { return; } spdData_Sheet1.RowCount = 0; try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); GridColumnInit(); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } int[] rowType = spdData.RPT_DataBindingWithSubTotalAndDivideRows(dt, 0, 1, 3, 4, 5, cdvOper.SelectCount, btnSort); //3. Total부분 셀머지 spdData.RPT_FillDataSelectiveCells("Total", 0, 3, 0, 5, true, Align.Center, VerticalAlign.Center); spdData.RPT_FillColumnData(3, new string[] { "BOH", "IN", "OUT", "EOH", "LOSS" }); //4. Column Auto Fit spdData.RPT_AutoFit(false); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary 5. View> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); GridColumnInit(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴 int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(1); //1.Griid 합계 표시 int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 6, null, null, btnSort); // 토탈 시작할 셀넘버, 시작 부터 서브토탈 몇개 쓸건지, 첫셀부터 몇번째 셀까지 TOTAL 적용안함 //3. Total부분 셀머지 spdData.RPT_FillDataSelectiveCells("Total", 0, 6, 0, 1, true, Align.Center, VerticalAlign.Center); //4. Column Auto Fit spdData.RPT_AutoFit(false); //2010-03-19-임종우 : 영역별 SubTotal, GrandTotal 구하기 SetTotalValue(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
private void btnCreate_Click(object sender, EventArgs e) { if (View_EQErr(true) == false) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD012", GlobalVariable.gcLanguage)); return; } if (Update_EQErr_Data("INSERT") == true) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF001", GlobalVariable.gcLanguage)); View_EQErr_List(); } }
private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == true) { GridColumnInit(); spdData_Sheet1.RowCount = 0; } if (cdvFactory.Text.Equals("HMKE1") || cdvFactory.Text.Equals(GlobalVariable.gsTestDefaultFactory) || cdvFactory.Text.Equals("FGS")) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD052", GlobalVariable.gcLanguage)); return; } try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); //데이터 저장 if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //1.Griid 합계 표시 int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, 0, 1, null, null, btnSort); //2. Total부분 셀머지 spdData.RPT_FillDataSelectiveCells("Total", 0, 11, 0, 1, true, Align.Center, VerticalAlign.Center); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 조회 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { if (!CheckField()) { return; } DataTable dt = null; GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } spdData.DataSource = dt; spdData.RPT_AutoFit(false); //1. column header for (int i = 0; i <= 4; i++) { spdData.ActiveSheet.Columns[i].BackColor = Color.LemonChiffon; } dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary 1. 유효성 검사> /// <remarks></remarks> /// </summary> /// <returns></returns> private Boolean CheckField() { if (cdvChartID.Text == "ALL") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD042", GlobalVariable.gcLanguage)); return(false); } if (cdvCharID.Text == "ALL") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD043", GlobalVariable.gcLanguage)); return(false); } return(true); }
// 시리즈 Legend를 셋팅 public void RPT_8_SetSeriseLegend(string [] SeriseTitle, SoftwareFX.ChartFX.Docked dock) { if (SerCount < SeriseTitle.Length) { throw new Exception(RptMessages.GetMessage("STD085", GlobalVariable.gcLanguage) + SerCount.ToString()); } this.SerLegBox = true; this.SerLegBoxObj.Docked = dock; for (int i = 0; i < SeriseTitle.Length; i++) { this.SerLeg[i] = SeriseTitle [i]; } }
private void cdvMat_ButtonPress(object sender, EventArgs e) { if (cdvFactory.Text.TrimEnd() == "") { MessageBox.Show(RptMessages.GetMessage("STD001", GlobalVariable.gcLanguage), "STD1208"); return; } cdvMat.Init(); CmnInitFunction.InitListView(cdvMat.GetListView); cdvMat.Columns.Add("KEY_1", 30, HorizontalAlignment.Left); cdvMat.Columns.Add("DATA_1", 70, HorizontalAlignment.Left); cdvMat.SelectedSubItemIndex = 0; RptListFunction.ViewMatList(cdvMat.GetListView, cdvFactory.Text, ""); }
public void RPT_8_SetSeriseLegend(FpSpread spread, int Rows, int [] Columns, SoftwareFX.ChartFX.Docked dock) { if (SerCount < Columns.Length) { throw new Exception(RptMessages.GetMessage("STD085", GlobalVariable.gcLanguage) + SerCount.ToString()); } this.SerLegBox = true; this.SerLegBoxObj.Docked = dock; for (int i = 0; i < Columns.Length; i++) { this.SerLeg[i] = spread.ActiveSheet.Cells [Rows, Columns [i]].Text; } }
private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; if (CheckField() == false) { return; } GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } spdData.DataSource = dt; // 첫 컬럼 색상 지정 spdData.ActiveSheet.Columns[0].BackColor = Color.YellowGreen; if (spdData.ActiveSheet.RowCount > 0) { ShowChart(0); } dt.Dispose(); } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
/// <summary> /// 조회 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { if (!CheckField()) { return; } DataTable dt = null; GridColumnInit(); try { LoadingPopUp.LoadIngPopUpShow(this); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } spdData.DataSource = dt; spdData.isShowZero = true; spdData.RPT_AutoFit(false); //Chart 생성 if (spdData.ActiveSheet.RowCount > 0) { ChartShow(0); } } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
//private void Chart_Xbar_SetData(DataTable a_dt, int iValue1) //{ // //Series series = null; // chart1.Series.Clear(); // int iValue25 = iValue1 + 25; // Value_25까지 있기 때문에,, // DataTable dt = new DataTable(); // 새로운 DataTable dt를 만들어서 // dt = a_dt; // dt에다가 받아온 a_dt 를 넣어준다. // dt.Columns.Add("AVG", typeof(String)); // 각 ROW별로 VALUE_1~25까지 컬럼값의 평균을 넣어줄것이다. // //1. 평균 구하기(Xbar) // for (int i = 0; i < dt.Rows.Count; i++) // { // spc.clear(); // for (int j = iValue1; j < iValue25; j++) // { // if (dt.Rows[i][j].Equals(" ") || dt.Rows[i][j].Equals("")) // 값이 없으면 그 뒤로도 없기 때문에 // { // break; // } // else // { // double x = Convert.ToDouble(dt.Rows[i][j]); // x에 컬럼값들 대입한다음에 // spc.Add(x); //spc.Add에 x값을 넣어주면 spc.clear() 호출하지 않는 이상 계속 축적되어 더해지고(sum), 자기네들끼리 비교해서 min,max값 구해놓고 있다,. // } // } // dt.Rows[i]["AVG"] = spc.mean(); // 각 row별 (value1~25까지의) 평균을 넣어준다. // } // // 2. 표준편차 구하기 : 표준편차는 모든 값들에(dt에 있는) 대한 표준편차를 구한다,(여동욱k께 문의한 결과) // spc.clear(); // for (int i = 0; i < dt.Rows.Count; i++) // { // for (int j = iValue1; j < iValue25; j++) // { // if (dt.Rows[i][j].Equals(" ") || dt.Rows[i][j].Equals("")) // { // break; // } // else // { // double x = Convert.ToDouble(dt.Rows[i][j]); // spc.Add(x); // } // } // } // dSt = spc.stdev(); // 표준편차 구해서(spc.stdev()) dSt 에 넣어준다. // //3. 새로운 DataTabe(dtX)를 생성해준다. // dtX = new DataTable(); // if (dtX.Columns.Count == 0) // X-bar용 // { // // 새로운 Datatable에 넣을 column도 정의하고 // DataColumn dc = new DataColumn(); // dc.DataType = System.Type.GetType("System.String"); // dc.ColumnName = "LOT_ID"; // dc.Caption = "LOT_ID"; // dc.DefaultValue = ""; // dtX.Columns.Add(dc); // DataColumn dd = new DataColumn(); // dd.DataType = System.Type.GetType("System.Double"); // dd.ColumnName = "AVG"; // dd.Caption = "AVG"; // dd.DefaultValue = 0.00; // dtX.Columns.Add(dd); // } // // 4. 1번에서 구한 각Row들의 평균을 날짜별로 Group By 해서 각각 총 평균을 구해서 DATE, AVG 컬럼만 뽑아서 // // 새로운 DataTable(dtX)를 생성해서 넣어준다. // // TranTime 기준을 Lot ID 기준으로 변경 - Xbar Chart 기준 변경..여동욱K요청(2009.09.28 임종우) // spc.clear(); // 수학관련해서 모두 초기화하고 // string sLot = " "; // int k = 0; // for (int i = 0; i < dt.Rows.Count; i++) // { // if (!sLot.Equals(dt.Rows[i][0])) // { // if (i == 0) // 만약 맨 첫줄이라면 // { // //dtX.Rows.Add(); // 아무일도 안한다. // } // else if (i != 0) // { // dtX.Rows.Add(); // row한줄 추가하고 // dtX.Rows[k]["LOT_ID"] = sLot; // 바로 전의 값들을 새로운 DataTable dtX에 넣어준다. Lot ID넣어주고 // dtX.Rows[k]["AVG"] = spc.mean(); // 평균넣어주고 // spc.clear(); // 수학관련해서 초기화해주고: 왜냐하면 다음 번 값들을 새로 받아야 하니깐 // k++; // } // sLot = Convert.ToString(dt.Rows[i][0]); // sLot 에 해당 컬럼값(LOT ID) 대입하고 // double x = Convert.ToDouble(dt.Rows[i]["AVG"]); // spc.Add(x); // } // else // { // if (i == dt.Rows.Count - 1) // { // dtX.Rows.Add(); // dtX.Rows[k]["LOT_ID"] = sLot; // dtX.Rows[k]["AVG"] = spc.mean(); // } // else // { // double x = Convert.ToDouble(dt.Rows[i]["AVG"]); // spc.Add(x); // } // } // } // // Chart에 뿌려주기 위해서 모든 AVG값들의 평균을 구하고 2번에서 구한 표준편차를 이용해서 Chart에 넘겨줄 UCL, LCL, USL, LSL을 구한다. // if (dtX.Rows.Count != 0) // { // spc.clear(); // dAvg = 0.0; // for (int i = 0; i < dtX.Rows.Count; i++) // { // double x = Convert.ToDouble(dtX.Rows[i]["AVG"]); // spc.Add(x); // } // dAvg = Math.Round(spc.mean(), 2); // dUcl = Math.Round(dAvg + (3 * dSt), 2); // dLcl = Math.Round(dAvg - (3 * dSt), 2); // dUsl = Math.Round(dAvg + (4 * dSt), 2); // dLsl = Math.Round(dAvg - (4 * dSt), 2); // // Chart 그리고 // //RPT_3_1_SetData(dtX, "X-bar Chart"); // //DataTable dtNew = new DataTable(); // 새로운 DataTable dt를 만들어서 // //dtNew = dtX; // dt에다가 받아온 a_dt 를 넣어준다. // // MS 차트 데이터 바인딩 로직 넣어야함... // //this.DataSource = dtNew; // //this.AxisX.Title.Text = sTitle; // DataTable dtNew = new DataTable(); // dtNew = dtX; // series = new Series(); // series.ChartType = SeriesChartType.Line; // series.IsValueShownAsLabel = true; // series.IsVisibleInLegend = false; // chart1.Series.Add(series); // for (int i = 0; i < dtNew.Rows.Count; i++) // { // chart1.Series[0].Points.AddXY(dtNew.Rows[i][0].ToString(), Convert.ToDouble(dtNew.Rows[i][1])); // } // //chart1.Series[0].YAxisType = AxisType.Secondary; // chart1.Series[0].Color = Color.Black; // chart1.Series[0].MarkerStyle = MarkerStyle.Circle; // chart1.Series[0].MarkerSize = 10; // chart1.Series[0].BorderWidth = 3; // //chart1.ChartAreas[0].CursorX.AutoScroll = true; // chart1.ChartAreas[0].CursorX.IsUserEnabled = true; // chart1.ChartAreas[0].CursorX.IsUserSelectionEnabled = true; // //chart1.ChartAreas[0].AxisX.ScaleView.Zoomable = true; // //chart1.ChartAreas[0].AxisX.ScaleView.SizeType = DateTimeIntervalType.Number; // chart1.ChartAreas[0].AxisX.ScrollBar.Size = 10; // chart1.ChartAreas[0].AxisX.ScrollBar.IsPositionedInside = true; // chart1.ChartAreas[0].AxisX.MajorGrid.LineWidth = 0; // chart1.ChartAreas[0].AxisY.MajorGrid.LineWidth = 1; // chart1.ChartAreas[0].AxisY2.MajorGrid.LineWidth = 1; // chart1.ChartAreas[0].AxisY.Maximum = dUsl; // chart1.ChartAreas[0].AxisY.Minimum = dLsl; // chart1.ChartAreas[0].AxisY2.Enabled = AxisEnabled.True; // chart1.ChartAreas[0].AxisY2.Minimum = 0; // chart1.ChartAreas[0].AxisY2.Maximum = 8; // chart1.ChartAreas[0].AxisY2.CustomLabels.Add(dLcl, dLcl, "LCL=" + "\n" + dLcl); // //this.AxisY2.Label[1] = "LCL=" + "\n" + dLcl; // /* // StripLine stripLow = new StripLine(); // stripLow.IntervalOffset = 1; // stripLow.StripWidth = 6; // stripLow.BackColor = Color.Red; // StripLine stripMed = new StripLine(); // stripMed.IntervalOffset = 2; // stripMed.StripWidth = 4; // stripMed.BackColor = Color.Yellow; // StripLine stripHigh = new StripLine(); // stripHigh.IntervalOffset = 3; // stripHigh.StripWidth = 2; // stripHigh.BackColor = Color.Chartreuse; // StripLine stripCL = new StripLine(); // stripCL.IntervalOffset = 4; // stripCL.StripWidth = 0; // stripCL.BorderColor = Color.DimGray; // stripCL.BorderWidth = 1; // chart1.ChartAreas[0].AxisY2.StripLines.Add(stripLow); // chart1.ChartAreas[0].AxisY2.StripLines.Add(stripMed); // chart1.ChartAreas[0].AxisY2.StripLines.Add(stripHigh); // chart1.ChartAreas[0].AxisY2.StripLines.Add(stripCL); // */ // //chart1.ChartAreas[0].AxisY2.CustomLabels.Add(0, 1, "LCL=" + "\n" + dLcl); // //RPT_3_2_SetColor(dLcl, dAvg, dUcl, dUsl, dLsl); // 색깔 칠해주고 // /* // // Y2 좌표를 총 8등분해서 나타낸다(나중에 색깔 칠하고 값넣기 편하게) // this.AxisY2.Min = 0; // this.AxisY2.Max = 8; // this.AxisY2.Step = 1; // //////// 색깔칠하기 // this.Series[0].Color = System.Drawing.Color.Black; // SoftwareFX.ChartFX.AxisSection section1 = this.AxisY2.Sections[0]; // section1.From = 1; // section1.To = 7; // section1.BackColor = System.Drawing.Color.Red; // SoftwareFX.ChartFX.AxisSection section2 = this.AxisY2.Sections[1]; // section2.From = 2; // section2.To = 6; // section2.BackColor = System.Drawing.Color.Yellow; // SoftwareFX.ChartFX.AxisSection section3 = this.AxisY2.Sections[2]; // section3.From = 3; // section3.To = 5; // section3.BackColor = System.Drawing.Color.Chartreuse; // // LCL, CL, UCL 값에 가져온 값들과 함께 하기와 같이 표기한다. // this.AxisY2.Label[1] = "LCL=" + "\n" + dLcl; // this.AxisY2.Label[4] = "CL=" + "\n" + dCl; // this.AxisY2.Label[7] = "UCL=" + "\n" + dUcl; // //////CL가운데 선긋기 : 평균값을 보여주기 위해서,,,근데 0일때,,,,,,,,도 같이 줄이 보이니,,,,,,,,문제점 발견<<<해결요망////// // SoftwareFX.ChartFX.ConstantLine constantLine = this.ConstantLines[0]; // constantLine.Value = 4; // constantLine.Color = System.Drawing.Color.DimGray; // constantLine.Axis = SoftwareFX.ChartFX.AxisItem.Y2; // // Y축의 min과 max값도 정해주고 보여줄 필요 없기 때문에 visible=false 했음 // this.AxisY.Max = dUsl; // this.AxisY.Min = dLsl; // this.AxisY.Visible = false; // */ // } //} /* * private void Chart_R_SetData(DataTable a_dt, int iValue1) * { * chart2.Series.Clear(); * * * int iValue25 = iValue1 + 25; * * DataTable dt = new DataTable(); // 새로운 DataTable dt를 만들어서 * dt = a_dt; // dt에다가 받아온 a_dt 를 넣어준다. * dt.Columns.Add("MIN", typeof(String)); * dt.Columns.Add("MAX", typeof(String)); * * * //1. 각 Row 별로 MIN, MAX 값 구하기 * for (int i = 0; i < dt.Rows.Count; i++) * { * spc.clear(); * * for (int j = iValue1; j < iValue25; j++) * { * if (dt.Rows[i][j].Equals(" ") || dt.Rows[i][j].Equals("")) * { * break; * } * else * { * double x = Convert.ToDouble(dt.Rows[i][j]); * spc.Add(x); * } * * } * dt.Rows[i]["MIN"] = spc.min(); * dt.Rows[i]["MAX"] = spc.max(); * } * * * //2. 새로운 DataTabe(dtR)를 생성해준다. * dtR = new DataTable(); * * if (dtR.Columns.Count == 0) // R-bar용 * { * // 새로운 Datatable에 넣을 column도 정의하고 * DataColumn dc = new DataColumn(); * dc.DataType = System.Type.GetType("System.String"); * dc.ColumnName = "LOT_ID"; * dc.Caption = "LOT_ID"; * dc.DefaultValue = ""; * dtR.Columns.Add(dc); * * DataColumn dd = new DataColumn(); * dd.DataType = System.Type.GetType("System.Double"); * dd.ColumnName = "R"; * dd.Caption = "R"; * dd.DefaultValue = 0.00; * dtR.Columns.Add(dd); * } * * // 3. 1번에서 구한 각Row들의 MIN, MAX 값 가지고 LOT_ID로 Group By 해서 각각 총 평균을 구해서 LOT_ID, R값(MAX-MIN) 을 * // 새로운 DataTable(dtR)를 생성해서 넣어준다. * * spc.clear(); // 수학관련해서 모두 초기화하고 * string sLot = " "; * int k = 0; * * for (int i = 0; i < dt.Rows.Count; i++) * { * * if (!sLot.Equals(dt.Rows[i][0])) * { * if (i == 0) // 만약 맨 첫줄이라면 * { * // dtR.Rows.Add(); * // 아무일도 안한다. * } * else if (i != 0) * { * dtR.Rows.Add(); * dtR.Rows[k]["LOT_ID"] = sLot; // 바로 전의 값들을 새로운 DataTable dtR에 넣어준다. LOT_ID넣어주ㅗㄱ * dtR.Rows[k]["R"] = spc.gap(); // max-min값넣어주고 * spc.clear(); // 수학관련해서 초기화해주고: 왜냐하면 다음 번 값들을 새로 받아야 하니깐 * k++; * } * sLot = Convert.ToString(dt.Rows[i][0]); // sLot 에 해당 컬럼값(LOT_ID) 대입하고 * * * * for (int s = dt.Columns.IndexOf("MIN") - 1; s < dt.Columns.IndexOf("MIN") + 1; s++) * { * double x = Convert.ToDouble(dt.Rows[i][s]); * spc.Add(x); // x값들이 모아져서 sum...... * } * } * else * { * if (i == dt.Rows.Count - 1) * { * dtR.Rows.Add(); * dtR.Rows[k]["LOT_ID"] = sLot; * dtR.Rows[k]["R"] = spc.gap(); * } * else * { * for (int s = dt.Columns.IndexOf("MIN") - 1; s < dt.Columns.IndexOf("MIN") + 1; s++) * { * double x = Convert.ToDouble(dt.Rows[i][s]); * spc.Add(x); // x값들이 모아져서 sum...... * } * } * } * * } * * //RPT_3_1_SetData(dtR, "R Chart"); * * DataTable dtNew = new DataTable(); * dtNew = dtR; * * series = new Series(); * series.ChartType = SeriesChartType.Line; * series.IsValueShownAsLabel = true; * series.IsVisibleInLegend = false; * * chart2.Series.Add(series); * * for (int i = 0; i < dtNew.Rows.Count; i++) * { * chart2.Series[0].Points.AddXY(dtNew.Rows[i][0].ToString(), Convert.ToDouble(dtNew.Rows[i][1])); * } * * chart2.Series[0].MarkerStyle = MarkerStyle.Circle; * chart2.Series[0].MarkerSize = 10; * chart2.Series[0].BorderWidth = 3; * * chart2.ChartAreas[0].CursorX.IsUserEnabled = true; * chart2.ChartAreas[0].CursorX.IsUserSelectionEnabled = true; * chart2.ChartAreas[0].AxisX.ScrollBar.Size = 10; * chart2.ChartAreas[0].AxisX.ScrollBar.IsPositionedInside = true; * * * chart2.ChartAreas[0].AxisX.MajorGrid.LineWidth = 0; * * chart2.ChartAreas[0].AxisY.Minimum = 0; * chart2.ChartAreas[0].AxisY.IsInterlaced = true; * chart2.ChartAreas[0].AxisY.InterlacedColor = Color.FromArgb(80, Color.DarkGray); * * //this.AxisY.Min = 0; // R Chart는 무조건 Y축 최소값이 0 * //this.AxisY.Gridlines = true; * }*/ #endregion #region " Button Event " /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnView_Click(object sender, EventArgs e) { if (CheckField() == false) { return; } LoadingPopUp.LoadIngPopUpShow(this); //dt = null; dtview = null; try { this.Refresh(); //LoadingPopUp.LoadIngPopUpShow(this); GridColumnInit(); dtview = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); //dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dtview.Rows.Count == 0) //dt.Rows.Count == 0 { dtview.Dispose(); //dt.Dispose(); LoadingPopUp.LoadingPopUpHidden(); //udcChartFXSpc1.RPT_1_ChartInit(); //udcChartFXSpc1.RPT_2_ClearData(); CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage)); return; } //// 값을 뿌려주기 위해서 새로운 Chart를 불러낸다 ShowChart(); dtview = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2()); //dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString2()); spdData.DataSource = dtview; //spdData.DataSource = dt; } catch (Exception ex) { LoadingPopUp.LoadingPopUpHidden(); CmnFunction.ShowMsgBox(ex.Message); } finally { LoadingPopUp.LoadingPopUpHidden(); } }
private Boolean CheckField() { if (cdvCustom.Text.Trim() == "") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD033", GlobalVariable.gcLanguage)); return(false); } if (cdvPkg.Text.Trim() == "") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD081", GlobalVariable.gcLanguage)); return(false); } return(true); }
private Boolean CheckField() { Boolean Check = false; if (cdvFactory.Text.TrimEnd() == "") { MessageBox.Show(RptMessages.GetMessage("STD001", GlobalVariable.gcLanguage), "STD1501"); Check = false; } else { Check = true; } return(Check); }
/// <summary> /// 1. 유효성 검사 /// </summary> /// <returns></returns> private Boolean CheckField() { if (cdvFactory.txtValue.Trim() == "") { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD001", GlobalVariable.gcLanguage)); return(false); } if (cdvCustomer.Text.Equals("") || cdvCustomer.Text.Equals("ALL")) { CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD038", GlobalVariable.gcLanguage)); return(false); } return(true); }