public DataTable GetDataResult(string idicode, string sPreYMD, string sCurYMD, int itxr_user)
{
Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(idicode, itxr_user);
string sQry = objBSC.IQuery;
int isource_id = objBSC.ISource_Id;
bool bisSucc = false;
string sRtnMsg = "";
int iAffRow = 0;
sQry = sQry.Replace(QueryOperator.ParamCurrYmd, "'" + sCurYMD + "'");
sQry = sQry.Replace(QueryOperator.ParamPrevYmd, "'" + sPreYMD + "'");
DataSet rDs = new DataSet();
Biz_Bsc_Interface_Datasource objDS = new Biz_Bsc_Interface_Datasource();
Object objCon = objDS.GetConnection(isource_id, out bisSucc, out sRtnMsg);
if (bisSucc && sQry.Trim().Length > 0)
{
if (objCon.GetType() == typeof(SqlConnection))
{
SqlConnection conn = (SqlConnection)objCon;
SqlCommand cmmd = new SqlCommand(sQry, conn);
SqlDataAdapter dadt = new SqlDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OracleConnection))
{
OracleConnection conn = (OracleConnection)objCon;
OracleCommand cmmd = new OracleCommand(sQry, conn);
OracleDataAdapter dadt = new OracleDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OleDbConnection))
{
OleDbConnection conn = (OleDbConnection)objCon;
OleDbCommand cmmd = new OleDbCommand(sQry, conn);
OleDbDataAdapter dadt = new OleDbDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
if (rDs.Tables.Count > 0)
{
return(rDs.Tables[0]);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
private void DoInitControl()
{
WebCommon.SetEstTermDropDownList(ddlEstTerm);
for (int i = 1; i < 13; i++)
{
ddlMonth.Items.Insert(ddlMonth.Items.Count, new ListItem(i.ToString() + "월", i.ToString("00")));
}
ddlSumType.Items.Insert(0, new ListItem("개별", "1"));
ddlSumType.Items.Insert(1, new ListItem("누적", "2"));
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
if (objTerm.GetReleasedMonth().Substring(4, 2) != "00")
{
PageUtility.FindByValueDropDownList(ddlMonth, objTerm.GetReleasedMonth().Substring(4, 2));
}
MicroBSC.BSC.Biz.Biz_Bsc_Interface_Dicode objInterface = new MicroBSC.BSC.Biz.Biz_Bsc_Interface_Dicode();
DataTable dtDiCode = objInterface.GetDiCodeUseYNDailyKpiYN("Y", "Y");
ddlDiCode.DataTextField = "NAME";
ddlDiCode.DataValueField = "DICODE";
ddlDiCode.DataSource = dtDiCode;
ddlDiCode.DataBind();
ddlDiCode.Items.Insert(0, new ListItem("::선택::", ""));
//ddlChart.Items.Add(new ListItem("ThreeLineBreak", "ThreeLineBreak"));
//ddlChart.Items.Add(new ListItem("Stock", "Stock"));
ddlChart.Items.Add(new ListItem("StepLine", "StepLine"));
//ddlChart.Items.Add(new ListItem("StackedColumn100", "StackedColumn100"));
//ddlChart.Items.Add(new ListItem("StackedColumn", "StackedColumn"));
//ddlChart.Items.Add(new ListItem("StackedBar100", "StackedBar100"));
//ddlChart.Items.Add(new ListItem("StackedBar", "StackedBar"));
//ddlChart.Items.Add(new ListItem("StackedArea100", "StackedArea100"));
//ddlChart.Items.Add(new ListItem("StackedArea", "StackedArea"));
//ddlChart.Items.Add(new ListItem("SplineRange", "SplineRange"));
//ddlChart.Items.Add(new ListItem("SplineArea", "SplineArea"));
ddlChart.Items.Add(new ListItem("Spline", "Spline"));
//ddlChart.Items.Add(new ListItem("Renko", "Renko"));
ddlChart.Items.Add(new ListItem("RangeColumn", "RangeColumn"));
//ddlChart.Items.Add(new ListItem("Range", "Range"));
ddlChart.Items.Add(new ListItem("Radar", "Radar"));
//ddlChart.Items.Add(new ListItem("Pyramid", "Pyramid"));
//ddlChart.Items.Add(new ListItem("Polar", "Polar"));
//ddlChart.Items.Add(new ListItem("PointAndFigure", "PointAndFigure"));
ddlChart.Items.Add(new ListItem("Point", "Point"));
//ddlChart.Items.Add(new ListItem("Pie", "Pie"));
ddlChart.Items.Add(new ListItem("Line", "Line"));
//ddlChart.Items.Add(new ListItem("Kagi", "Kagi"));
//ddlChart.Items.Add(new ListItem("Gantt", "Gantt"));
//ddlChart.Items.Add(new ListItem("Funnel", "Funnel"));
ddlChart.Items.Add(new ListItem("FastLine", "FastLine"));
//ddlChart.Items.Add(new ListItem("ErrorBar", "ErrorBar"));
//ddlChart.Items.Add(new ListItem("Doughnut", "Doughnut"));
ddlChart.Items.Add(new ListItem("Column", "Column"));
//ddlChart.Items.Add(new ListItem("CandleStick", "CandleStick"));
ddlChart.Items.Add(new ListItem("Bubble", "Bubble"));
//ddlChart.Items.Add(new ListItem("BoxPlot", "BoxPlot"));
//ddlChart.Items.Add(new ListItem("Bar", "Bar"));
//ddlChart.Items.Add(new ListItem("Area", "Area"));
PageUtility.FindByValueDropDownList(ddlChart, "FastLine");
}
