private void DeleteViewData()
{
if (!this.CheckFormData())
{
return;
}
this.IType = "D";
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
objBSC.Iview_ref_id = this.IViewRefID;
int intRtn = objBSC.DeleteData(objBSC.Iview_ref_id,
"N",
gUserInfo.Emp_Ref_ID);
if (objBSC.Transaction_Result == "Y")
{
this.FileUpload(fudViewImage);
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objBSC.Transaction_Message, this.ICCB1, true);
}
else
{
this.IType = "U";
}
}
private void UpdateViewData()
{
if (!this.CheckFormData())
{
return;
}
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(this.IViewRefID);
objBSC.Iview_ref_id = this.IViewRefID;
objBSC.Iview_seq = int.Parse(txtVIEW_SEQ.Text.ToString());
objBSC.Iview_name = txtVIEW_NAME.Text.Trim();
objBSC.Iview_desc = txtVIEW_DESC.Text;
objBSC.Iview_etc = txtVIEW_ETC.Text;
objBSC.Iview_image_name = (fudViewImage.HasFile) ? fudViewImage.FileName : objBSC.Iview_image_name;
objBSC.Create_user = gUserInfo.Emp_Ref_ID;
int intRtn = objBSC.UpdateData(objBSC.Iview_ref_id,
objBSC.Iview_seq,
objBSC.Iview_name,
objBSC.Iview_desc,
objBSC.Iview_etc,
objBSC.Iview_image_name,
gUserInfo.Emp_Ref_ID);
ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
if (objBSC.Transaction_Result == "Y" &&
fudViewImage.HasFile &&
fudViewImage.FileName.Trim() != "")
{
this.FileUpload(fudViewImage);
}
}
private void UgrdView_Bind()
{
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objBSC.GetAllList();
ugrdView.Clear();
if (rDs.Tables.Count > 0)
{
ugrdView.DataSource = rDs;
ugrdView.DataBind();
}
}
private void ViewInfo_ddlBind()
{
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objBSC.GetAllList();
ddlStgViewInfo.Items.Add(new ListItem(":: 전체 ::", "0"));
if (rDs.Tables.Count > 0)
{
for (int i = 0; i < rDs.Tables[0].Rows.Count; i++)
{
ddlStgViewInfo.Items.Add(new ListItem(rDs.Tables[0].Rows[i]["VIEW_NAME"].ToString(), rDs.Tables[0].Rows[i]["VIEW_REF_ID"].ToString()));
}
}
}
private void SetFormData()
{
if (this.IType != "A")
{
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(this.IViewRefID);
this.IViewRefID = objBSC.Iview_ref_id;
txtVIEW_NAME.Text = objBSC.Iview_name;
txtVIEW_SEQ.Text = objBSC.Iview_seq.ToString();
txtVIEW_DESC.Text = objBSC.Iview_desc;
txtVIEW_ETC.Text = objBSC.Iview_etc;
hdfImagePath.Value = objBSC.Iview_image_name;
string virtualPath = "../images/stg/";
string absolutePath = Server.MapPath(virtualPath);
if (!Directory.Exists(absolutePath))
{
DirectoryInfo objFold = Directory.CreateDirectory(absolutePath);
absolutePath = objFold.FullName;
}
imgPreview.ImageUrl = virtualPath + objBSC.Iview_image_name;
}
}
private void SetKpiStatusGraph2()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsGraph = new DataSet();
List <string> listYMDs = new List <string>();
Chart objChart = this.chtPart;
//dsGraph = TempData3();
//관점별 1년치데이타
foreach (string str in GetBeforeMonth(listYMDs))
{
dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList(this.IEstTermRefID
, str
, this.ISumType
, this.IEstDeptID));
}
dsGraph.AcceptChanges();
dsGraph = this.ModifyData(dsGraph);
foreach (DataRow dr in dsGraph.Tables[0].Rows)
{
dr["YMD"] = string.Format("{0}년{1}월", dr["YMD"].ToString().Substring(0, 4), DataTypeUtility.GetToInt32(dr["YMD"].ToString().Substring(4, 2)));
}
if (dsGraph.Tables[0].Rows.Count > 0)
{
DundasCharts.DundasChartBase(objChart
, ChartImageType.Png
, 680
, 130
, BorderSkinStyle.Emboss
, Color.FromArgb(181, 64, 1)
, 2
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0x20, 0x80, 0xD0)
, ChartDashStyle.Solid
, -1
, ChartHatchStyle.None
, GradientType.TopBottom
, AntiAliasing.None);
objChart.DataSource = dsGraph;
objChart.Series.Clear();
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objViewInfo.GetAllList();
if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4)
{
Series series4 = DundasCharts.CreateSeries(objChart, "sp1", "Default", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series1 = DundasCharts.CreateSeries(objChart, "sp2", "Default", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "Default", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series2 = DundasCharts.CreateSeries(objChart, "sp4", "Default", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
series1.ValueMembersY = "ACHV_RATE1";
series2.ValueMembersY = "ACHV_RATE2";
series3.ValueMembersY = "ACHV_RATE3";
series4.ValueMembersY = "ACHV_RATE4";
series1.ValueMemberX = "YMD";
foreach (Series series in objChart.Series)
{
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false;
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False;
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30;
series.Href = HttpContext.Current.Request.Url.ToString().Substring(0
, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX";
}
objChart.DataBind();
}
}
}
private void DrawMapTreeDetail(TreeView iTrvMap, int iEstTermRefID, int iEstDeptRefID, int iMapVersionID, string iSelectedKey)
{
int cntRow = 0;
int cntStg = 0;
int cntKpi = 0;
string strKey = "";
string strVal = "";
strKey = "D" + ";" + Convert.ToString(this.IEstDeptRefID) + ";0";
strVal = this.IEstDeptName + " 전략맵";
TreeNode topNode = new TreeNode(strVal, strKey);
iTrvMap.Nodes.Clear();
iTrvMap.Nodes.Add(topNode);
topNode.ImageUrl = "../images/stg/TREE_D.gif";
TreeNode vNode;
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objView = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet dsView = objView.GetAllList();
TreeNode sNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new Biz_Bsc_Map_Stg();
DataSet dsSTG = new DataSet();
TreeNode kNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new Biz_Bsc_Map_Kpi();
DataSet dsKPI = new DataSet();
cntRow = dsView.Tables[0].Rows.Count;
for (int i = 0; i < cntRow; i++)
{
string imgWork = "<img alt='' src='../images/stg/TREE_W.gif'/>";
string imgExec = "<img alt='' src='../images/stg/TREE_E.gif'/>";
strKey = "V" + ";" + dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString() + ";0";
strVal = dsView.Tables[0].Rows[i]["VIEW_NAME"].ToString();
vNode = new TreeNode(strVal, strKey);
vNode.ImageUrl = "../images/stg/TREE_V.gif";
topNode.ChildNodes.Add(vNode);
if (iSelectedKey == strKey)
{
vNode.Select();
vNode.ExpandAll();
vNode.SelectAction = TreeNodeSelectAction.Select;
}
int stgrefid = 0;
int kpirefid = 0;
dsSTG = objSTG.GetStrategyPerView(IEstTermRefID, IEstDeptRefID, IMapVersionID, int.Parse(dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString()));
cntStg = dsSTG.Tables[0].Rows.Count;
for (int j = 0; j < cntStg; j++)
{
strKey = "S" + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString() + ";0";
stgrefid = Convert.ToInt32(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString());
kpirefid = 0;
strVal = dsSTG.Tables[0].Rows[j]["STG_NAME"].ToString()
+ (WorkCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgWork : "")
+ (ExecCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgExec : "");
sNode = new TreeNode(strVal, strKey);
sNode.ImageUrl = "../images/stg/TREE_S.gif";
vNode.ChildNodes.Add(sNode);
if (iSelectedKey == strKey)
{
sNode.Select();
sNode.ExpandAll();
sNode.SelectAction = TreeNodeSelectAction.Select;
}
dsKPI = objKPI.GetKpiListPerStg(IEstTermRefID, IEstDeptRefID, IMapVersionID, int.Parse(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString()));
cntKpi = dsKPI.Tables[0].Rows.Count;
for (int k = 0; k < cntKpi; k++)
{
strKey = "K" + ";" + dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString() + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString();
kpirefid = Convert.ToInt32(dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString());
strVal = dsKPI.Tables[0].Rows[k]["KPI_NAME"].ToString()
+ (WorkCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgWork : "")
+ (ExecCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgExec : "");
kNode = new TreeNode(strVal, strKey);
kNode.ImageUrl = "../images/stg/TREE_K.gif";
sNode.ChildNodes.Add(kNode);
if (iSelectedKey == strKey)
{
kNode.Select();
kNode.ExpandAll();
kNode.SelectAction = TreeNodeSelectAction.Select;
}
}
}
}
if (iTrvMap.SelectedNode == null)
{
topNode.Select();
}
iTrvMap.ExpandAll();
}
private void SetKpiStatusGraph2()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsGraph = new DataSet();
List <string> listYMDs = new List <string>();
Dundas.Charting.WebControl.Chart objChart = this.chtPart;
//dsGraph = TempData3();
//관점별 1년치데이타
foreach (string str in GetBeforeMonth(listYMDs))
{
dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, str
, this.ISumType
, this.IEstDeptID));
}
dsGraph.AcceptChanges();
dsGraph = this.ModifyData(dsGraph);
if (dsGraph.Tables[0].Rows.Count > 0)
{
DundasCharts.DundasChartBase(objChart
, Dundas.Charting.WebControl.ChartImageType.Flash
, 680, 180
, Dundas.Charting.WebControl.BorderSkinStyle.None
, Color.FromArgb(181, 64, 1)
, 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0x20, 0x80, 0xD0)
, Dundas.Charting.WebControl.ChartDashStyle.Solid
, -1
, Dundas.Charting.WebControl.ChartHatchStyle.None
, Dundas.Charting.WebControl.GradientType.TopBottom
, Dundas.Charting.WebControl.AntiAliasing.None);
objChart.DataSource = dsGraph;
objChart.Series.Clear();
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objViewInfo.GetAllList();
if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4)
{
Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(objChart, "sp1", "AreaView", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series2 = DundasCharts.CreateSeries(objChart, "sp2", "AreaView", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "AreaView", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series4 = DundasCharts.CreateSeries(objChart, "sp4", "AreaView", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series2.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series3.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series4.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series1.MarkerBorderColor = Color.FromArgb(240, 224, 64, 10);
series1.MarkerColor = Color.FromArgb(240, 224, 64, 10);
series2.MarkerBorderColor = Color.FromArgb(240, 192, 192, 192);
series2.MarkerColor = Color.FromArgb(240, 192, 192, 192);
series3.MarkerBorderColor = Color.FromArgb(240, 65, 140, 240);
series3.MarkerColor = Color.FromArgb(240, 65, 140, 240);
series4.MarkerBorderColor = Color.FromArgb(240, 252, 180, 65);
series4.MarkerColor = Color.FromArgb(240, 252, 180, 65);
series1.ValueMembersY = "ACHV_RATE1";
series2.ValueMembersY = "ACHV_RATE2";
series3.ValueMembersY = "ACHV_RATE3";
series4.ValueMembersY = "ACHV_RATE4";
series1.ValueMemberX = "YMD";
foreach (Dundas.Charting.WebControl.Series series in objChart.Series)
{
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false;
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False;
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30;
//series.Url = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX";
}
DundasAnimations.DundasChartBase(objChart, AnimationTheme.None, -1, -1, false, 1);
DundasAnimations.GrowingAnimation(objChart, series1, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series2, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series3, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series4, 0.5, 2.0, true);
objChart.DataBind();
}
}
}