private void spdData_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { DataTable dtDetail = null; string QueryCond = null; if (e.Row > 0) { QueryCond = FwxCmnFunction.PackCondition(QueryCond, Convert.ToString(spdData.Sheets[0].GetValue(e.Row, 0))); QueryCond = FwxCmnFunction.PackCondition(QueryCond, StartDate()); QueryCond = FwxCmnFunction.PackCondition(QueryCond, EndDate()); spdDataDetail_Sheet1.RowCount = 0; this.Refresh(); dtDetail = CmnFunction.oComm.GetFuncDataTable("TST1107_1", QueryCond); if (dtDetail.Rows.Count > 0) { spdDataDetail.Visible = true; } else { spdDataDetail.Visible = false; } //spdDataDetail_Sheet1.DataSource = dtDetail; //SubTotal사용 CmnSpdFunction.DataBindingWithSubTotal(spdDataDetail, dtDetail, 0, 1, 3); CmnFunction.FitColumnHeader(spdDataDetail); spdDataDetail.Sheets[0].Columns[3].Width = 120; dtDetail.Dispose(); } }
private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; CheckField(); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString()); if (dt.Rows.Count == 0) { spdData.Visible = false; } else { spdData.Visible = true; } CmnSpdFunction.DataBindingWithSubTotal(spdData, dt, 0, 1, 2); ultraChart1.Visible = false; if (dt.Rows.Count > 0) { CmnFunction.FitColumnHeader(spdData); MakeChart(dt); ultraChart1.SaveTo(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures) + @"\myChart.png", System.Drawing.Imaging.ImageFormat.Png); } dt.Dispose(); }
private void btnView_Click(object sender, EventArgs e) { DataTable dt = null; string QueryCond = null; try { QueryCond = FwxCmnFunction.PackCondition(QueryCond, StartDate()); QueryCond = FwxCmnFunction.PackCondition(QueryCond, EndDate()); spdData_Sheet1.RowCount = 0; this.Refresh(); dt = CmnFunction.oComm.GetFuncDataTable("TST1107", QueryCond); if (dt.Rows.Count == 0) { spdData.Visible = false; } else { spdData.Visible = true; } //SubTotal사용 CmnSpdFunction.DataBindingWithSubTotal(spdData, dt, 0, 0, 1); ultraChart1.Visible = false; if (dt.Rows.Count > 0) { CmnFunction.FitColumnHeader(spdData); spdData.Sheets[0].Columns[2].Width = 120; MakeChart(dt); ultraChart1.SaveTo(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures) + @"\myChart.png", System.Drawing.Imaging.ImageFormat.Png); dt.Dispose(); } } catch (Exception ex) { throw ex; } finally { dt.Dispose(); } }