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