private void SetCtrlSetting(int estterm_ref_id, int est_dept_ref_id)
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
//DataSet dsMap = bizMap.GetWorkMapTotalList(estterm_ref_id, est_dept_ref_id);
DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(estterm_ref_id, est_dept_ref_id);
if (dsMap.Tables[0].Rows.Count > 0)
{
ltrStgMapVision.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString();
ltrStgMapChamp.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
this.IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]);
}
Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
string strYMD = bizTerm.GetReleasedMonth();
this.IYMD = (strYMD == "000000" ? DataTypeUtility.GetToInt32(DateTime.Now.ToString("yyyyMM")) : DataTypeUtility.GetToInt32(strYMD));
SetViewScoreGrid(estterm_ref_id, est_dept_ref_id, this.IYMD);
string view_kpi_str = (ViewKPI) ? "1" : "0";
string url = "../usr/usr_stg_map.aspx?ESTTERM_REF_ID=" + estterm_ref_id.ToString()
+ "&EST_DEPT_REF_ID=" + est_dept_ref_id.ToString()
+ "&MAP_VERSION_ID=" + this.IMAP_VERSION_ID
+ "&TMCODE=" + this.IYMD
+ "&LINE_TYPE=0"
+ "&SHOW_KPI_LIST=" + view_kpi_str
+ "&WORKINGMAPYN=T";
ifm.Attributes.Add("src", Server.UrlDecode(url));
}
private void DoBindingTree()
{
trvStgMap.Nodes.Clear();
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DeptInfos objDept = new DeptInfos(this.IEST_DEPT_REF_ID);
DataSet dsMap = bizMap.GetWorkMapTree(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID, this.IMAP_VERSION_ID);
string topNodeID = "D" + this.IEST_DEPT_REF_ID.ToString();
TreeNode topNode = new TreeNode(objDept.Dept_Name + " 과제체계도", topNodeID, "../images/stg/TREE_D.gif");
trvStgMap.Nodes.Add(topNode);
if (dsMap.Tables[0].Rows.Count > 0)
{
TreeNode tn;
foreach (DataRow dr in dsMap.Tables[0].Rows)
{
tn = new TreeNode(dr["TREE_NAME"].ToString(), dr["TREE_ID"].ToString(), dr["TREE_IMAGE"].ToString());
trvStgMap.FindNode(topNodeID + dr["VALUE_PATH"].ToString()).ChildNodes.Add(tn);
if (tn.Value.Substring(0, 1) == "V")
{
tn.SelectAction = TreeNodeSelectAction.None;
}
}
}
if (trvStgMap.SelectedNode == null)
{
topNode.Select();
}
trvStgMap.ExpandAll();
}
private void DoBindingWork()
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet ds = bizMap.GetWorkMapWorkExec(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID, this.ITREE_SELECT_TYPE, this.ITREE_SELECT_VALUE, this.IMAP_VERSION_ID);
ugrdWorkList.Clear();
ugrdWorkList.DataSource = ds;
ugrdWorkList.DataBind();
}
private void DoBindingAddList()
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet dsMap = bizMap.GetWorkMapWorkExecList(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID, PageUtility.GetByValueDropDownList(ddlWorkType), txtEstDeptNameF.Text.Trim(), txtEmpID.Text.Trim()
, txtEmpName.Text.Trim(), txtWorkCode.Text.Trim(), txtWorkName.Text.Trim(), PageUtility.GetByValueDropDownList(ddlCompleteYN));
ugrdWorkAll.Clear();
ugrdWorkAll.DataSource = dsMap;
ugrdWorkAll.DataBind();
}
protected void ibtnWorkAdd_Click(object sender, ImageClickEventArgs e)
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
CheckBox chkCheck;
TemplatedColumn Col_Check;
DataTable dtWork = new DataTable();
dtWork.Columns.Add("WORK_REF_ID", typeof(int));
dtWork.Columns.Add("EXEC_REF_ID", typeof(int));
int work_id;
foreach (UltraGridRow gRow in ugrdWorkAll.Rows)
{
Col_Check = (TemplatedColumn)gRow.Band.Columns.FromKey("selchk");
chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[gRow.BandIndex]).FindControl("cBox");
if (chkCheck.Checked)
{
work_id = DataTypeUtility.GetToInt32(gRow.Cells.FromKey("WORK_REF_ID").Value.ToString());
DataRow iDR = dtWork.NewRow();
iDR["WORK_REF_ID"] = (gRow.Cells.FromKey("WORK_TYPE").Value.ToString() == "C" ? work_id : 0);
iDR["EXEC_REF_ID"] = (gRow.Cells.FromKey("WORK_TYPE").Value.ToString() == "E" ? work_id : 0);
dtWork.Rows.Add(iDR);
}
}
if (dtWork.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("추가할 과제를 선택하세요!");
return;
}
if (bizMap.InsertWorkMap(this.IESTTERM_REF_ID
, this.IEST_DEPT_REF_ID
, this.ITREE_SELECT_VALUE
, dtWork
, gUserInfo.Emp_Ref_ID))
{
ltrScript.Text = JSHelper.GetAlertScript("추가하였습니다.");
DoBindingTree();
DoBindingSTG();
DoBindingAddList();
DoFocusTree();
return;
}
ltrScript.Text = JSHelper.GetAlertScript("추가 실패!");
}
private void DoBinding()
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet dsMap = bizMap.GetWorkMapList(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, txtWorkCode.Text.Trim()
, txtWorkName.Text.Trim()
, txtEmpName.Text.Trim()
, PageUtility.GetIntByValueDropDownList(ddlEstDept)
, PageUtility.GetByValueDropDownList(ddlWorkType)
, PageUtility.GetByValueDropDownList(ddlCompleteYN)
, (txtEmpID.Text.Trim() == "" ? 0 : DataTypeUtility.GetToInt32(txtEmpID.Text.Trim())));
lblRowCount.Text = (dsMap.Tables[0].Rows.Count > 0 ? dsMap.Tables[0].Rows.Count.ToString() : "0");
ugrdWorkList.Clear();
ugrdWorkList.DataSource = dsMap;
ugrdWorkList.DataBind();
}
private void DoBindingSTG()
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet ds = bizMap.GetWorkMapWorkExec(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID, this.ITREE_SELECT_TYPE, this.ITREE_SELECT_VALUE, this.IMAP_VERSION_ID);
ugrdWorkPreView.Clear();
ugrdWorkPreView.DataSource = ds;
ugrdWorkPreView.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
lblWorkListCount.Text = "중점과제: " + ds.Tables[0].Compute("COUNT(WORK_TYPE)", "WORK_TYPE='C'").ToString() + " / 실행과제: " + ds.Tables[0].Compute("COUNT(WORK_TYPE)", "WORK_TYPE='E'").ToString() + " ";
}
else
{
lblWorkListCount.Text = "중점과제: 0 : 실행과제: 0 ";
}
}
private void DoBindingMaster()
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet dsMaster = bizMap.GetWorkMapMaster(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID);
if (dsMaster.Tables[0].Rows.Count > 0)
{
lblEstDeptName.Text = dsMaster.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString();
txtTermDesc.Text = dsMaster.Tables[0].Rows[0]["ESTTERM_NAME"].ToString();
txtEstDeptName.Text = dsMaster.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString();
txtBSCChampion.Text = dsMaster.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
txtDeptVision.Text = dsMaster.Tables[0].Rows[0]["DEPT_VISION"].ToString();
txtMapVersionID.Text = dsMaster.Tables[0].Rows[0]["MAP_VERSION_ID"].ToString();
txtMapVersionName.Text = dsMaster.Tables[0].Rows[0]["MAP_VERSION_NAME"].ToString();
txtMapDesc.Text = dsMaster.Tables[0].Rows[0]["MAP_DESC"].ToString();
this.IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMaster.Tables[0].Rows[0]["MAP_VERSION_ID"]);
}
}
private void DoBinding()
{
ltEstDeptName.Text = lblSTGMapName.Text = lblChampName.Text = "";
this.IESTTERM_REF_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID);
IMAP_VERSION_ID = 1;
if (dsMap.Tables[0].Rows.Count > 0)
{
ltEstDeptName.Text = dsMap.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString();
lblSTGMapName.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString();
lblChampName.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]);
}
Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
DataSet dsTerm = bizTerm.GetAllList(IESTTERM_REF_ID);
if (dsTerm.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString();
}
if (ITERM_MONTH == "")
{
Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info();
DataSet dsMap2 = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID);
if (dsMap2.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString();
}
}
DataSet dsList = bizMap.GetWorkMapTotalList_DB();
ugrdStgList.Clear();
ugrdStgList.DataSource = dsList.Tables[0];
ugrdStgList.DataBind();
}
