private void InsertViewData()
{
if (!this.CheckFormData())
{
return;
}
Biz_MenuInfo objMenuInfo = new Biz_MenuInfo();
objMenuInfo.Menu_ref_id = DataTypeUtility.GetToInt32(this.txtMenuRefID.Text.Trim());
objMenuInfo.Up_menu_id = DataTypeUtility.GetToInt32(this.hdfUpMenuID.Value);
objMenuInfo.Menu_name = txtMenuName.Text.Trim();
objMenuInfo.Menu_dir = txtMenuDir.Text.Trim();
objMenuInfo.Menu_page_name = txtMenuPageName.Text.Trim();
objMenuInfo.Menu_param = txtMenuParam.Text.Trim();
objMenuInfo.Menu_full_path = txtMenuFullPath.Text.Trim();
objMenuInfo.Menu_desc = txtMenuDesc.Text.Trim();
objMenuInfo.Menu_priority = DataTypeUtility.GetToInt32(txtMenuPriority.Text.Trim());
objMenuInfo.Menu_auth_type = WebUtility.GetByValueDropDownList(ddlMenuAuthType);
objMenuInfo.Menu_type = WebUtility.GetByValueDropDownList(ddlMenuType);
objMenuInfo.Menu_name_image_path = txtMenuNameImagePath.Text.Trim();
objMenuInfo.Menu_name_image_path_u = txtMenuNameImagePathU.Text.Trim();
objMenuInfo.Menu_prev_icon_path = txtMenuPrevIconPath.Text.Trim();
objMenuInfo.Show_left_menu = WebUtility.GetByValueDropDownList(ddlShowLeftMenu);
bool result = objMenuInfo.AddMenuinfo(objMenuInfo.Menu_ref_id
, objMenuInfo.Up_menu_id
, objMenuInfo.Menu_name
, objMenuInfo.Menu_dir
, objMenuInfo.Menu_page_name
, objMenuInfo.Menu_param
, objMenuInfo.Menu_full_path
, objMenuInfo.Menu_desc
, objMenuInfo.Menu_priority
, objMenuInfo.Menu_auth_type
, objMenuInfo.Menu_type
, objMenuInfo.Menu_name_image_path
, objMenuInfo.Menu_name_image_path_u
, objMenuInfo.Menu_prev_icon_path
, DateTime.Now
, objMenuInfo.Show_left_menu);
if (result)
{
this.IType = "U";
this.SetFormData();
this.SetButton();
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("메뉴등록이 성공되었습니다.", this.ICCB1, true);
}
else
{
hdfMenuRefID.Value = "";
ltrScript.Text = JSHelper.GetAlertScript("메뉴등록이 실패했습니다.", false);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int result = 0;
for (int i = 0; i < ugrdKpiDept.Rows.Count; i++)
{
UltraGridRow row = ugrdKpiDept.Rows[i];
TemplatedColumn Col_Check = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[row.BandIndex]).FindControl("cBox");
if (chkCheck.Checked)
{
result += new Biz_Bsc_Kpi_Pool().KpiCreateDeptRemove(DataTypeUtility.GetToInt32((row.Cells.FromKey("KPI_REF_ID").Value)));
}
}
if (result > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("삭제 되었습니다.");
ugrdKpiDept.Clear();
KpiPool_GridBind();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("삭제 실패.");
return;
}
}
public bool RemoveRelGroupPosData(DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _relGroupPosData.Delete(conn
, trx
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["REL_GRP_POS_DATA_ID"].ToString()
, "");
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void UltraWebGrid3_InitializeRow(object sender, RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
// 구분
if (htPositionName == null)
{
BindHashTablePositionName();
}
e.Row.Cells.FromKey("NAMEPOS_NAME").Value = htPositionName[drw["POS_ID"].ToString()].ToString();
// 직급명
DataRow[] drName = dtPositionAll.Select(string.Format(@"POS = '{0}'
AND POS_ID = '{1}'"
, drw["POS_ID"].ToString()
, drw["POS_VALUE"].ToString()));
if (drName.Length > 0)
{
e.Row.Cells.FromKey("NAMEPOS_VALUE").Value = drName[0]["POS_NAME"].ToString();
}
// 상태
DataRow[] drArr = _dtPosScale.Select(string.Format(@"ESTTERM_REF_ID = {0}
AND DEPT_REF_ID = {1}
AND EST_ID = '{2}'"
, ESTTERM_REF_ID
, DataTypeUtility.GetToInt32(hdfDeptRefID.Value)
, EST_ID));
}
protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
{
TreeNodeCollection treeNodeCol = treeEmp.CheckedNodes;
DataTable insertDT = new DataTable();
insertDT.Columns.Add("EMP_REF_ID", typeof(int));
foreach (TreeNode node in treeNodeCol)
{
if (node.ToolTip == "EMP")
{
DataRow insertDR = insertDT.NewRow();
insertDR["EMP_REF_ID"] = DataTypeUtility.GetToInt32(node.Value);
insertDT.Rows.Add(insertDR);
}
}
Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
if (bizBiasData.InsertBiasGroupEmp(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IBIAS_GRP_ID, insertDT, gUserInfo.Emp_Ref_ID))
{
DoBindingEmpTree(this.IBIAS_GRP_ID);
DoBindingGroup();
if (this.IBIAS_GRP_ID > 0)
{
DoBindingGroupSelect();
}
ltrScript.Text = JSHelper.GetAlertScript("설정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("저장 실패!");
}
}
private void DoBinding(int estTermRefID, int deptID)
{
UltraWebGrid1.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID);
if (dtBscKpiInfo.Rows.Count > 0)
{
this.ChartView.Visible = true;
UltraWebGrid1.DataSource = dtBscKpiInfo;
UltraWebGrid1.DataBind();
UltraWebGrid1.Rows[0].Activated = true;
int kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]);
string kpi_name = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]);
DoCharting(kpi_ref_id, kpi_name);
}
else
{
this.ChartView.Visible = false;
//chartMM.Visible = false;
//chartDal.Visible = false;
}
}
protected void iBtnDelete_Click(object sender, ImageClickEventArgs e)
{
//Biz_BiasDatas bizBias = new Biz_BiasDatas();
//if (bizBias.DeleteBiasGroup(this.ICOMP_ID
// , this.IEST_ID
// , DataTypeUtility.GetToInt32(hdfBIAS_GRP_ID.Value)))
//{
// hdfChangeYN.Value = "1";
// hdfBIAS_GRP_ID.Value = "0";
// txtBIAS_GRP_CD.Text = txtBIAS_GRP_NM.Text = txtBIAS_GRP_DESC.Text = string.Empty;
// chkUSE_YN.Checked = true;
// DoBinding();
// ltrScript.Text = JSHelper.GetAlertScript("삭제되었습니다.");
//}
//else
// ltrScript.Text = JSHelper.GetAlertScript(string.Format("삭제 실패!\\n{0}", bizBias.errMSG.Replace("\\", "").Replace("'", "")));
MicroBSC.Integration.EST.Biz.Biz_Est_Bias_Group bizEstBiasGroup = new MicroBSC.Integration.EST.Biz.Biz_Est_Bias_Group();
bool isOK = bizEstBiasGroup.RemoveEstBiasGroup_DB(DataTypeUtility.GetToInt32(hdfBIAS_GRP_ID.Value));
if (isOK)
{
hdfChangeYN.Value = "1";
hdfBIAS_GRP_ID.Value = "0";
txtBIAS_GRP_CD.Text = txtBIAS_GRP_NM.Text = txtBIAS_GRP_DESC.Text = string.Empty;
chkUSE_YN.Checked = true;
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("삭제되었습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("삭제 실패!");
}
}
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));
}
public Dac_Prj_Schedule(int iprj_ref_id, int itask_ref_id)
{
DataSet ds = this.GetOneList(iprj_ref_id, itask_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
_iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_itask_ref_id = DataTypeUtility.GetToInt32(dr["TASK_REF_ID"]);
_itask_name = DataTypeUtility.GetValue(dr["TASK_NAME"]);
_itask_type = DataTypeUtility.GetValue(dr["TASK_TYPE"]);
_itask_weight = DataTypeUtility.GetToDecimal(dr["TASK_WEIGHT"]);
_iup_task_ref_id = DataTypeUtility.GetToInt32(dr["UP_TASK_REF_ID"]);
_itask_code = DataTypeUtility.GetValue(dr["TASK_CODE"]);
_iplan_start_date = dr["PLAN_START_DATE"];
_iplan_end_date = dr["PLAN_END_DATE"];
_iactual_start_date = dr["ACTUAL_START_DATE"];
_iactual_end_date = dr["ACTUAL_END_DATE"];
_iproceed_rate = DataTypeUtility.GetToDecimal(dr["PROCEED_RATE"]);
_iatt_file = DataTypeUtility.GetValue(dr["ATT_FILE"]);
_icomplete_yn = DataTypeUtility.GetValue(dr["COMPLETE_YN"]);
_iisdelete = DataTypeUtility.GetValue(dr["ISDELETE"]);
_inode_depth = DataTypeUtility.GetToInt32(dr["NODE_DEPTH"]);
_iafter_task_ref_id = DataTypeUtility.GetToInt32(dr["AFTER_TASK_REF_ID"]);
_idesction = DataTypeUtility.GetString(dr["DESCTION"]);
_icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]);
_icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]);
_iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
_iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_ButtonCommandRoleMaps btnCmdRoleMap = new Biz_ButtonCommandRoleMaps();
DataTable dataTable = btnCmdRoleMap.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "COMMAND_NAME" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["ROLE_REF_ID"] = hdfRoleRefID.Value;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = btnCmdRoleMap.SaveButtonCommandRoleMap(dataTable, DataTypeUtility.GetToInt32(hdfRoleRefID.Value));
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다.", false);
//if (isOK)
//{
// ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
// return;
//}
//else
//{
// //ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
//}
}
protected void Page_Load(object sender, EventArgs e)
{
bizPmsColInfo = new Biz_Pms_Col_Info();
bizPrjData = new Biz_Prj_Data();
PRJ_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("PRJ_REF_ID"));
PRJ_CODE = WebUtility.GetRequest("PRJ_CODE");
COMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("COMP_ID"));
EST_ID = WebUtility.GetRequest("EST_ID");
ESTTERM_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_REF_ID"));
ESTTERM_SUB_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_SUB_ID"));
ESTTERM_STEP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_STEP_ID"));
EST_DEPT_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_DEPT_ID"));
EST_EMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_EMP_ID"));
ltrScript.Text = "";
if (!IsPostBack && PRJ_REF_ID > 0 && PRJ_CODE.Length > 0)
{
Weight_Col_Bind();
Difficulty_Col_Bind();
Common_Soosik_Bind();
Prj_Est_Point_Bind();
SetBottons();
}
Prj_Data_Bind();
}
public Biz_Prj_QuestionPrjMap(int comp_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, string est_id
, string q_obj_id
, int prj_ref_id)
{
DataSet ds = null;
ds = _questionPrjMap.Select(comp_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_id
, q_obj_id
, prj_ref_id);
DataRow dr;
if (ds != null && ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
private void DoBindingList()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();
DataSet ds = objBSC.GetKpiListPerUser(this.IESTTERM_REF_ID
, ""
, txtKPICode.Text.Trim()
, txtKPIName.Text.Trim()
, ""
, txtChamName.Text.Trim()
, (ddlComDept.SelectedValue.Trim() == "") ? -1 : int.Parse(ddlComDept.SelectedValue)
, PageUtility.GetByValueDropDownList(ddlKpiGroupRefID)
, "Y"
, int.Parse(gUserInfo.Emp_Ref_ID.ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Group objGroup = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Group();
DataTable dtExists = objGroup.GetGroupMapList(this.IESTTERM_REF_ID, 0);
if (dtExists.Rows.Count > 0)
{
foreach (DataRow dr in dtExists.Rows)
{
DataRow[] drExists = ds.Tables[0].Select("KPI_REF_ID = " + DataTypeUtility.GetToInt32(dr["KPI_REF_ID"]));
if (drExists.Length > 0)
{
drExists[0].Delete();
}
}
}
}
ugrdKpiList.Clear();
ugrdKpiList.DataSource = ds;
ugrdKpiList.DataBind();
}
public int NewIdx(int comp_id, int estterm_ref_id, int dept_ref_id, string est_id)
{
string query = @"SELECT MAX(SEQ) FROM EST_DEPT_POS_DETAIL
WHERE COMP_ID = @COMP_ID
AND ESTTERM_REF_ID = @ESTTERM_REF_ID
AND DEPT_REF_ID = @DEPT_REF_ID
AND EST_ID = @EST_ID";
IDbDataParameter[] paramArray = CreateDataParameters(4);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[1].Value = estterm_ref_id;
paramArray[2] = CreateDataParameter("@DEPT_REF_ID", SqlDbType.Int);
paramArray[2].Value = dept_ref_id;
paramArray[3] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar);
paramArray[3].Value = est_id;
try
{
object max = DbAgentObj.ExecuteScalar(query, paramArray, CommandType.Text);
if (max == DBNull.Value)
{
return(1);
}
return(DataTypeUtility.GetToInt32(max) + 1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
hdfEstTermSubID.Value = e.SelectedRows[0].Cells.FromKey("ESTTERM_SUB_ID").Value.ToString();
ViewOne(COMP_ID, DataTypeUtility.GetToInt32(hdfEstTermSubID.Value));
ButtonStatusModify();
}
public void SetKpiPoolGrid()
{
//MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
//DataSet ds = objBSC.GetAllList(txtKPIName.Text.Trim(),
// PageUtility.GetByValueDropDownList(ddlKpiType),
// PageUtility.GetByValueDropDownList(ddlUseYn));
//ugrdKPIPool.Clear();
//ugrdKPIPool.DataSource = ds.Tables[0].DefaultView;
//ugrdKPIPool.DataBind();
//lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB(txtKPIName.Text.Trim(),
PageUtility.GetByValueDropDownList(ddlKpiType),
PageUtility.GetByValueDropDownList(ddlUseYn),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiVersion)),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiTemplete)));
ugrdKPIPool.Clear();
ugrdKPIPool.DataSource = dtBscKpiPool;
ugrdKPIPool.DataBind();
lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString();
}
public bool RemoveCtrlEstDeptMap(DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _ctrlDeptMap.Delete(conn
, trx
, DataTypeUtility.GetValue(dataRow["CTRL_ID"])
, DataTypeUtility.GetToInt32(dataRow["DEPT_REF_ID"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void ugrdColumn_SelectedRowsChange(object sender, Infragistics.WebUI.UltraWebGrid.SelectedRowsEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.UltraGridRow ugrd = e.SelectedRows[0];
this.ISEQ = DataTypeUtility.GetToInt32(ugrd.Cells.FromKey("SEQ").Value);
if (ugrd.Cells.FromKey("COL_TYPE").Value.ToString() == "FIXEDKEY")
{
iBtnSave.Visible = false;
}
else
{
iBtnSave.Visible = true;
}
WebUtility.FindByValueRadioButtonList(rblVISIBLE_YN, ugrd.Cells.FromKey("VISIBLE_YN").Value.ToString());
WebUtility.FindByValueRadioButtonList(rblUSE_YN, ugrd.Cells.FromKey("USE_YN").Value.ToString());
txtCOL_ORDER.Text = ugrd.Cells.FromKey("COL_ORDER").Value.ToString();
txtCOL_KEY.Text = ugrd.Cells.FromKey("COL_KEY").Value.ToString();
txtCOL_NAME.Text = ugrd.Cells.FromKey("COL_NAME").Value.ToString();
txtCOL_DESC.Text = ugrd.Cells.FromKey("COL_DESC").Value.ToString();
WebUtility.FindByValueDropDownList(ddlTYPE, ugrd.Cells.FromKey("COL_TYPE").Value.ToString());
txtCOL_WIDTH.Text = ugrd.Cells.FromKey("COL_WIDTH").Value.ToString();
WebUtility.FindByValueDropDownList(ddlALIGN, ugrd.Cells.FromKey("COL_ALIGN").Value.ToString());
WebUtility.FindByValueDropDownList(ddlDATATYPE, ugrd.Cells.FromKey("DATA_TYPE").Value.ToString());
txtPROC_NAME.Text = ugrd.Cells.FromKey("PROC_NAME").Value.ToString();
WebUtility.FindByValueDropDownList(ddlPROCTYPE, ugrd.Cells.FromKey("PROC_TYPE").Value.ToString());
}
protected void iBtnSearch_Click(object sender, ImageClickEventArgs e)
{
//WIDTH = DataTypeUtility.GetToInt32(ddlResolution.SelectedItem.Text);
double tempWidth = DataTypeUtility.GetToInt32(WIDTH) * 0.32;
double tempHeight = DataTypeUtility.GetToInt32(HEIGHT) * 0.34;
ChartWidth = DataTypeUtility.GetToInt32(Math.Round(tempWidth, 0));
ChartHeight = DataTypeUtility.GetToInt32(Math.Round(tempHeight, 0));
//if (ddlResolution.SelectedIndex == 0)
//{
// ChartWidth = 330; // 1024 768
// ChartHeight = 245;
//}
//else
//{
// ChartWidth = 415; // 1280 800
// ChartHeight = 250;
//}
//if (!txtWidth.Text.Equals(""))
//{
// ChartWidth = DataTypeUtility.GetToInt32(txtWidth.Text);
// ChartHeight = DataTypeUtility.GetToInt32(txtHeight.Text);
//}
DoBinding_JeonSa();
DoBinding_InPower();
DoBinding_ETC();
}
public Biz_Boards(string board_id, string board_category_id)
{
DataSet ds = _board.Select(board_id, board_category_id, 0, "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_board_id = DataTypeUtility.GetValue(dr["BOARD_ID"]);
_board_category_id = DataTypeUtility.GetValue(dr["BOARD_CATEGORY_ID"]);
_subject_text = DataTypeUtility.GetValue(dr["SUBJECT_TEXT"]);
_content_text = DataTypeUtility.GetValue(dr["CONTENT_TEXT"]);
_read_count = DataTypeUtility.GetToInt32(dr["READ_COUNT"]);
_attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]);
_p_board_id = DataTypeUtility.GetValue(dr["P_BOARD_ID"]);
_group_id = DataTypeUtility.GetValue(dr["GROUP_ID"]);
_level_id = DataTypeUtility.GetToInt32(dr["LEVEL_ID"]);
_seq_id = DataTypeUtility.GetToInt32(dr["SEQ_ID"]);
_start_date = DataTypeUtility.GetToDateTime(dr["START_DATE"]);
_end_date = DataTypeUtility.GetToDateTime(dr["END_DATE"]);
_menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]);
_pop_up_yn = DataTypeUtility.GetValue(dr["POP_UP_YN"]);
_write_emp_id = DataTypeUtility.GetToInt32(dr["WRITE_EMP_ID"]);
_write_emp_name = DataTypeUtility.GetValue(dr["WRITE_EMP_NAME"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
protected void btnIn_Click(object sender, ImageClickEventArgs e)
{
string striType = "";
int cntRow = ugrdKpiList.Rows.Count;
CheckBox chkCheck;
UltraGridRow ugrdRow;
TemplatedColumn col_Check = (TemplatedColumn)ugrdKpiList.Bands[0].Columns.FromKey("selchk");
Biz_Bsc_Kpi_Prj objKpiPrj = new Biz_Bsc_Kpi_Prj();
int iRtn = 0;
for (int i = 0; i < ugrdKpiList.Rows.Count; i++)
{
chkCheck = (CheckBox)((CellItem)col_Check.CellItems[ugrdKpiList.Rows[i].BandIndex]).FindControl("cBox");
ugrdRow = ugrdKpiList.Rows[i];
if (chkCheck.Checked)
{
objKpiPrj.IEstterm_Ref_Id = DataTypeUtility.GetToInt32(ugrdRow.Cells.FromKey("ESTTERM_REF_ID"));
objKpiPrj.IKpi_Ref_Id = DataTypeUtility.GetToInt32(ugrdRow.Cells.FromKey("KPI_REF_ID"));
objKpiPrj.IPrj_Ref_Id = this.IPrjRefID;
if (!objKpiPrj.IsExist(objKpiPrj.IEstterm_Ref_Id, objKpiPrj.IKpi_Ref_Id, objKpiPrj.IPrj_Ref_Id))
{
iRtn += objKpiPrj.InsertData(objKpiPrj.IEstterm_Ref_Id, objKpiPrj.IKpi_Ref_Id, objKpiPrj.IPrj_Ref_Id, gUserInfo.Emp_Ref_ID);
}
}
}
this.setKpiPrjData();
this.setKpiData();
}
private void SetPageData()
{
if (!IsPostBack)
{
WebCommon.SetEstTermDropDownList(ddlEstTermInfo);
}
this.IEstTermRefID = int.Parse(ddlEstTermInfo.SelectedValue);
WebCommon.SetTermMonthDropDownList(ddlEstTermMonth, this.IEstTermRefID);
MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp bizRel = new MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp();
int estDeptID = DataTypeUtility.GetToInt32(bizRel.Get_Dept_ID_of_Emp_ID(gUserInfo.Emp_Ref_ID.ToString()));
//WebCommon.FillEstMappingTree_NW(trvEstDept, this.IEstTermRefID, estDeptID, TreeNodeSelectAction.Select);
WebCommon.FillEstTree(trvEstDept, this.IEstTermRefID, gUserInfo.Emp_Ref_ID);
trvEstDept.ExpandAll();
if (trvEstDept.Nodes.Count > 0)
{
trvEstDept.Nodes[0].Select();
this.IEstDeptRefID = (trvEstDept.SelectedNode == null) ? IEstDeptRefID : int.Parse(trvEstDept.SelectedNode.Value);
this.SetFormData(gUserInfo.Dept_Ref_ID);
}
else
{
ltEstDeptName.Text = "";
lblChampName.Text = "";
lblSTGMapName.Text = "";
ugrdStgList.Clear();
this.IEstDeptRefID = 0;
}
}
private void DoBinding()
{
Biz_Datas biz = new Biz_Datas();
int dept_ref_id = DataTypeUtility.GetToInt32(ddlComDept.SelectedValue);
int estterm_step_id = this.IESTTERM_STEP_ID;
DataSet ds = biz.Get3GADataEstData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, estterm_step_id, dept_ref_id);
ugrdMBO.Clear();
ugrdMBO.DataSource = ds.Tables[0];
ugrdMBO.DataBind();
lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
if (ds.Tables[1].Rows.Count > 0)
{
this.IEST_STATUS = ds.Tables[1].Rows[0]["STATUS_YN"].ToString();
}
if (ds.Tables[2].Rows.Count > 0)
{
this.IEST_COMPLETE = "N";
}
else
{
this.IEST_COMPLETE = "Y";
}
}
public DataTable GetFullAppLine(string biz_type, int emp_ref_id)
{
/* 수정일자 : 2012.7.2
* 수정작자 : 장동건
* 수정내용 : 하나이 던 것을 세개로 분리
* 주석 처리한 아래 메서드 따라 가 볼껏
* return base.GetFullAppLine(biz_type, emp_ref_id);
* */
int intPlusCount = 0;
int intLastStep = 0;
DataTable dtPlusCount = base.GetPlusCountOfFullAppLine(biz_type);
if (dtPlusCount.Rows.Count > 0)
{
intPlusCount = DataTypeUtility.GetToInt32(dtPlusCount.Rows[0][0]);
}
DataTable dtLastStep = GetLastStepOfFullAppLine(biz_type, emp_ref_id);
if (dtLastStep.Rows.Count > 0)
{
intLastStep = DataTypeUtility.GetToInt32(dtLastStep.Rows[0][0]);
}
return(base.GetFullAppLine(intPlusCount, intLastStep, biz_type, emp_ref_id));
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
object status_yn = e.Row.Cells.FromKey("STATUS_YN").Value;
if (status_yn == null)
{
e.Row.Cells.FromKey("STATUS_IMG").Value = "<img src='../Images/status/N.gif'>";
}
else
{
if (status_yn.Equals("Y"))
{
e.Row.Cells.FromKey("STATUS_IMG").Value = "<img src='../Images/status/E.gif'>";
}
else
{
e.Row.Cells.FromKey("STATUS_IMG").Value = "<img src='../Images/status/N.gif'>";
}
}
int step_id = DataTypeUtility.GetToInt32(e.Row.Cells.FromKey("ESTTERM_STEP_ID").Value);
Biz_TermSteps biz = new Biz_TermSteps(COMP_ID, step_id);
e.Row.Cells.FromKey("ESTTERM_STEP_NAME").Value = biz.EstTerm_Step_Name;
}
protected void Page_Load(object sender, EventArgs e)
{
COMP_ID = GetRequestByInt("COMP_ID");
EST_ID = GetRequest("EST_ID");
if (!Page.IsPostBack)
{
bool isOK = CheckValidation(ltrScript);
if (!isOK)
{
return;
}
EST_EMP_ID = 0;
BindingPosBizByTgt();
BindingEmp();
ibnSave.Attributes.Add("onclick", "return confirm('사원 직무를 저장하시겠습니까?');");
}
TGT_EMP_ID = DataTypeUtility.GetToInt32(hdfTgtEmpID.Value);
TGT_POS_KND_ID = hdfTgtPosKndID.Value;
ltrScript.Text = "";
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
if (e.SelectedRows[0] != null)
{
imgAdd.Visible = true;
iBtnPrjRemove.Visible = true;
ibnConfirm.Visible = true;
this.ugrdPrjList.Clear();
this.hdfEstEmpID.Value = e.SelectedRows[0].Cells.FromKey("EST_EMP_ID").Value.ToString();
this.hdfEstDeptID.Value = e.SelectedRows[0].Cells.FromKey("EST_DEPT_ID").Value.ToString();
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataSet ds = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("EST_DEPT_ID").Value)
, DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("EST_EMP_ID").Value)
, 0);
ugrdPrjList.DataSource = ds;
ugrdPrjList.DataBind();
}
}
private void DoLineSortChange(bool isUp)
{
int app_emp_ref_id = DataTypeUtility.GetToInt32(ugrdSignerEmp.DisplayLayout.SelectedRows[0].Cells.FromKey("EMP_REF_ID"));
object[] objDraftEmp = new object[ugrdDraftEmp.Rows.Count];
objDraftEmp = GetInsertDraftEmpList(ugrdDraftEmp.Rows.Count);
Biz_Com_Approval_Info bizComApp = new Biz_Com_Approval_Info();
if (bizComApp.ChangeLineSort(this.IBIZ_TYPE, isUp, objDraftEmp, app_emp_ref_id, gUserInfo.Emp_Ref_ID))
{
int sort_order = (isUp ? DataTypeUtility.GetToInt32(ugrdSignerEmp.DisplayLayout.SelectedRows[0].Cells.FromKey("SORT_ORDER")) - 1 : DataTypeUtility.GetToInt32(ugrdSignerEmp.DisplayLayout.SelectedRows[0].Cells.FromKey("SORT_ORDER")) + 1);
if (isUp)
{
ugrdSignerEmp.Rows[ugrdSignerEmp.DisplayLayout.SelectedRows[0].Index - 1].Cells.FromKey("SORT_ORDER").Value = sort_order + 1;
}
else
{
ugrdSignerEmp.Rows[ugrdSignerEmp.DisplayLayout.SelectedRows[0].Index + 1].Cells.FromKey("SORT_ORDER").Value = sort_order - 1;
}
ugrdSignerEmp.DisplayLayout.SelectedRows[0].Cells.FromKey("SORT_ORDER").Value = sort_order;
ugrdSignerEmp.Bands[0].SortedColumns.Clear();
ugrdSignerEmp.Columns.FromKey("SORT_ORDER").SortIndicator = SortIndicator.Ascending;
ugrdSignerEmp.Bands[0].SortedColumns.Add(ugrdSignerEmp.Columns.FromKey("SORT_ORDER"), true);
DoFocusLine(ugrdSignerEmp, app_emp_ref_id);
}
else
{
MsgOnUP(UpdatePanel1, "실패하였습니다!\\n" + bizComApp.Transaction_Message);
}
}
protected void AllSave_Eqt_Eql_Ratio()
{
int eqtValue = DataTypeUtility.GetToInt32(this.txtEqtValue.Text);
int eqlValue = DataTypeUtility.GetToInt32(this.txtEqlValue.Text);
DataTable dt = new DataTable();
dt.Columns.Add("KPI_REF_ID");
dt = UltraGridUtility.GetDataTableByCheckValue(this.ugrdKpiList, "cBox", "selchk", new string[] { "KPI_REF_ID" }, dt);
bool result = bizBscKpiEqtEql.Set_Kpi_Eqt_Eql_Ratio(ESTTERM_REF_ID
, dt
, eqtValue
, eqlValue
, gUserInfo.Emp_Ref_ID);
if (result)
{
this.ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저리되었습니다.");
doBind_Kpi_Eqt_Eql_List();
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("오류가 발생했습니다.");
}
}
public bool Add_Self_Est_Question(IDbConnection conn, IDbTransaction trx, DataTable dt, int create_user_ref_id)
{
int affectedRow = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
int comp_id = DataTypeUtility.GetToInt32(dt.Rows[i]["COMP_ID"]);
string est_id = DataTypeUtility.GetString(dt.Rows[i]["EST_ID"]);
int estterm_ref_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_REF_ID"]);
int estterm_sub_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_SUB_ID"]);
int estterm_step_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_STEP_ID"]);
int tgt_dept_id = DataTypeUtility.GetToInt32(dt.Rows[i]["TGT_DEPT_ID"]);
int tgt_emp_id = DataTypeUtility.GetToInt32(dt.Rows[i]["TGT_EMP_ID"]);
int self_top_id = DataTypeUtility.GetToInt32(dt.Rows[i]["SELF_TOP_ID"]);
int self_mid_id = DataTypeUtility.GetToInt32(dt.Rows[i]["SELF_MID_ID"]);
string self_comment = DataTypeUtility.GetString(dt.Rows[i]["SELF_COMMENT"]);
affectedRow += _data.Insert_Self_Est_Question(conn, trx
, comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, tgt_dept_id
, tgt_emp_id
, self_top_id
, self_mid_id
, self_comment
, create_user_ref_id);
}
return(affectedRow > 0 ? true : false);
}
