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();
}
}
