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