protected void SetBottons() { /* * if (EST_EMP_ID != gUserInfo.Emp_Ref_ID) * { * this.tdCalcBtnMargin.Visible = false; * this.tdCalcBtn.Visible = false; * }*/ for (int i = 0; i < EMP_ROLES.Count; i++) { //성과 평가 관리자만 string role_ref_id = DataTypeUtility.GetString(EMP_ROLES[i]); if (role_ref_id.Equals("9")) { this.tdCalcBtnMargin.Visible = true; this.tdCalcBtn.Visible = true; this.ibnCalcPrjEstPoint.Enabled = true; this.ibnCalcPrjEstPoint.Visible = true; this.ibnSaveEst.Enabled = true; this.ibnSaveEst.Visible = true; this.ibnConfirmEst.Enabled = true; this.ibnConfirmEst.Visible = true; this.ibnCancelEst.Enabled = true; this.ibnCancelEst.Visible = true; } } }
//리커시브 함수 private int SelectTreeNodeByValue(TreeNodeCollection childNode, string value) { int nodeCnt = childNode.Count; int flag; if (nodeCnt > 0) { for (int i = 0; i < childNode.Count; i++) { flag = SelectTreeNodeByValue(childNode[i].ChildNodes, value); if (flag == 0) { if (DataTypeUtility.GetString(childNode[i].Value).Equals(value)) { childNode[i].Selected = true; return(-1); } } else if (flag == -1) { return(-1); } } } return(nodeCnt); }
public int Remove_Kpi_Eqt_Eql_Ratio(IDbConnection conn, IDbTransaction trx , int estterm_ref_id , DataTable dt_kpi_ref_id) { int affectedRow = 0; string kpi_ref_id_list = ""; for (int i = 0; i < dt_kpi_ref_id.Rows.Count; i++) { if (kpi_ref_id_list.Length > 0) { kpi_ref_id_list += ", "; } kpi_ref_id_list += DataTypeUtility.GetString(dt_kpi_ref_id.Rows[i]["KPI_REF_ID"]); } if (kpi_ref_id_list.Length == 0) { kpi_ref_id_list = "''"; } affectedRow = _data.Delete_Bsc_Kpi_Eqt_Eql_Bulk(conn, trx , estterm_ref_id , kpi_ref_id_list); return(affectedRow); }
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); }
protected DataTable Get_SaveDT_EstComment() { DataTable saveDT = CreateEstSelfDataColumns(); // string self_comment = PageUtility.GetHtmlEncodeChar(this.txtConsult.Text); string self_comment = PageUtility.GetHtmlEncodeChar(this.txtConsult.Value); for (int i = 0; i < ugrdEstComment.Rows.Count; i++) { DataRow dr = saveDT.NewRow(); TemplatedColumn tc = (TemplatedColumn)ugrdEstComment.Rows[i].Cells.FromKey("EST_COMMENT").Column; RadioButtonList rdoEstComment = (RadioButtonList)((CellItem)tc.CellItems[i]).FindControl("rdoEstComment"); string self_top_id = DataTypeUtility.GetString(ugrdEstComment.Rows[i].Cells.FromKey("SELF_TOP_ID").Value); string self_mid_id = DataTypeUtility.GetString(rdoEstComment.SelectedValue); dr["COMP_ID"] = COMP_ID; dr["EST_ID"] = EST_ID; dr["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dr["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID; dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID; dr["TGT_DEPT_ID"] = TGT_DEPT_ID; dr["TGT_EMP_ID"] = TGT_EMP_ID; dr["SELF_TOP_ID"] = self_top_id; dr["SELF_MID_ID"] = self_mid_id; dr["SELF_COMMENT"] = self_comment; saveDT.Rows.Add(dr); } return(saveDT); }
protected void DataList4_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { DataRowView dr = (DataRowView)e.Item.DataItem; string q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]); Biz_QuestionDefines questionDefines = new Biz_QuestionDefines(q_dfn_id, ""); Literal ltrDefName = e.Item.FindControl("ltrLevelDefName") as Literal; Literal ltrDefine = e.Item.FindControl("ltrLevelDefine") as Literal; DataList dalList = e.Item.FindControl("DataList6") as DataList; HtmlTableCell tdHeader = null; ltrDefName.Text = questionDefines.Q_Dfn_Name; ltrDefine.Text = questionDefines.Q_Dfn_Define; if (_q_item_desc_use_yn.Equals("Y")) { tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell; tdHeader.Style.Add("width", "260px"); } Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, q_dfn_id); dalList.DataSource = ds; dalList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { ltrScript.Text = ""; if (!IsPostBack) { Biz_EstInfos estInfo = new Biz_EstInfos(COMP_ID, EST_ID); Biz_TermInfos termInfo = new Biz_TermInfos(ESTTERM_REF_ID); Biz_TermSubs termSubInfo = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID); ESTTERM_STEP_ID = 2; Biz_EmpInfos empInfo = new Biz_EmpInfos(TGT_EMP_ID); Biz_Com_Dept_Info deptInfo = new Biz_Com_Dept_Info(TGT_DEPT_ID); Biz_PositionClasses clsInfo = new Biz_PositionClasses(empInfo.Position_Class_Code); this.lblEstTerm.Text = string.Format("{0}({1})", DataTypeUtility.GetString(termInfo.EstTerm_Name), DataTypeUtility.GetString(termSubInfo.EstTerm_Sub_Name)); this.lblEstName.Text = DataTypeUtility.GetString(estInfo.Est_Name); this.lblEstEmp.Text = string.Format("{1}({0})", DataTypeUtility.GetString(deptInfo.DEPT_NAME), DataTypeUtility.GetString(empInfo.Emp_Name)); this.lblEstEmpClass.Text = DataTypeUtility.GetString(clsInfo.Pos_Cls_Name); txtConsult.ToolbarStartExpanded = false; bindData(); } setSaveBtn(); }
protected void doBind_prjEmp() { UltraWebGrid2.Clear(); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0); MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); string est_id = "3Q";//프로젝트 기여도 평가 EST_ID DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID , COMP_ID , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1"); object point = dtPrj_PM_Data.Rows[0]["POINT"]; PRJ_POINT = DataTypeUtility.GetString(point); UltraWebGrid2.DataSource = DT_PRJ_DATA; UltraWebGrid2.DataBind(); }
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 UltraWebGrid2_InitializeRow(object sender, RowEventArgs e) { //프로젝트 평가점수 바인딩 e.Row.Cells.FromKey("PRJ_POINT").Value = PRJ_POINT; //개인종합평가 평가점수 바인딩 string tgt_dept_id = e.Row.Cells.FromKey("TGT_DEPT_ID").Value.ToString(); string tgt_emp_id = e.Row.Cells.FromKey("TGT_EMP_ID").Value.ToString(); string filter = string.Format("TGT_DEPT_ID={0} AND TGT_EMP_ID={1}", tgt_dept_id, tgt_emp_id); DataTable empEstInfo = DataTypeUtility.FilterSortDataTable(DT_EMP_EST_DATA, filter); string point = ""; if (empEstInfo.Rows.Count > 0) { point = DataTypeUtility.GetString(empEstInfo.Rows[0]["POINT"]); } if (point.Trim().Length == 0) { point = "-"; } e.Row.Cells.FromKey("EST_POINT").Value = point; //PM일 경우 처리 if (tgt_dept_id.Equals("-1") && tgt_emp_id.Equals("-1")) { e.Row.Cells.FromKey("POINT").Value = "-"; e.Row.Cells.FromKey("TGT_DEPT_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_DEPT_NAME"]; e.Row.Cells.FromKey("TGT_EMP_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_EMP_NAME"]; } }
protected void ugrdEstQuestion_InitializeRow(object sender, RowEventArgs e) { string q_sbj_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("Q_SBJ_ID")); Biz_QuestionItems questionItems = new Biz_QuestionItems(); DataTable dt_q_item = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID).Tables[0]; TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("Q_ITEM"); RadioButtonList rdoQuestionItem = (RadioButtonList)((CellItem)tc.CellItems[e.Row.Index]).FindControl("rdoQuestionItem"); rdoQuestionItem.RepeatDirection = RepeatDirection.Horizontal; rdoQuestionItem.RepeatLayout = RepeatLayout.Table; rdoQuestionItem.DataSource = dt_q_item; rdoQuestionItem.DataBind(); Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_DEPT_ID , EST_EMP_ID , TGT_DEPT_ID , TGT_EMP_ID , q_sbj_id); WebUtility.FindByValueRadioButtonList(rdoQuestionItem, questionDatas.Q_Itm_ID); }
protected void writeLog(string msg) { //페이지 열릴대마다 로그 기록 if (WebUtility.GetConfig("USE_PAGE_OPEN_LOG", "N").Equals("Y")) { string base_dir = System.Web.HttpContext.Current.Server.MapPath("~"); string fileName = WebUtility.GetConfig("PAGE_OPEN_LOG_FILE", "~\\log.txt"); string name = fileName.Substring(0, fileName.LastIndexOf(".")); if (name.IndexOf("~") > -1) { name = name.Replace("~\\", base_dir); } string ext = fileName.Substring(fileName.LastIndexOf(".")); string logFile = name + System.DateTime.Now.ToString("_yyyy-MM-dd") + ext; string proxyAddr = DataTypeUtility.GetString(Request.ServerVariables["HTTP_X_FORWARDED_FOR"]); string remoteAddr = DataTypeUtility.GetString(Request.ServerVariables["REMOTE_ADDR"]); string userAddr = string.Format("PROXY:{0}, USER:{1}", proxyAddr, remoteAddr); System.Text.StringBuilder logMsg = new System.Text.StringBuilder(); logMsg.Append(msg); try { MicroBSC.Common.ErrorLogs.WriteFileError(logMsg.ToString(), userAddr, logFile); } catch (Exception ex) { } } }
private void DisplayScore() { writeLog(string.Format("{0} : DisplayScore() Start", Request.PhysicalPath)); string dept_id = ""; string dept_name = ""; string est_dept_id = ""; string bdept_id = ""; string bdept_name = ""; string best_dept_id = ""; Biz_Bsc_Intro_Score bizDeptInfo = new Biz_Bsc_Intro_Score(); DataTable dtbizDeptInfo = bizDeptInfo.GetJeonsaInfo(DataTypeUtility.GetToInt32(IEstTermRefID).ToString() ); if (dtbizDeptInfo.Rows.Count > 0) { est_dept_id = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][0]); dept_name = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][1]); } int score = 0; Biz_Bsc_Intro_Score bizScore = new Biz_Bsc_Intro_Score(); DataTable dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(est_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } } lblTEAMname.Text = dept_name; lblTEAMname.ToolTip = dept_name; lblTEAMscore.Text = String.Format("{0:##0}", score); lblTEAMscore.CssClass = searchColor(score); string ESTTERM_REF_ID = DataTypeUtility.GetToInt32(IEstTermRefID).ToString(); string YMD = IYmd; string SUM_TYPE = "TS"; string url = "BSC0408S6.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}"; //string url = "BSC0408S4.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}"; KPI_URL = string.Format(url, ESTTERM_REF_ID, YMD, SUM_TYPE); writeLog(string.Format("{0} : DisplayScore() End", Request.PhysicalPath)); }
protected bool Confirm_EstQ() { //STATUS 정보 가져오기 int new_status_seq = 0; if (ESTTERM_STEP_ID == 2) { //1차 평가 완료 new_status_seq = 5; } else if (ESTTERM_STEP_ID == 3) { //2차 평가 완료 new_status_seq = 7; } else { this.ltrScript.Text = JSHelper.GetAlertScript("잘못된 평가 차수 데이터입니다."); } int increment_seq = 1; //데이터 수집 DataTable dt = Collect_CheckedData(); //데이터 가공 및 검증 for (int i = 0; i < dt.Rows.Count; i++) { string status_id = DataTypeUtility.GetString(dt.Rows[i]["STATUS_ID"]); Biz_Est_Data bizEstData = new Biz_Est_Data(); Biz_Status new_status = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, status_id, new_status_seq, increment_seq); if (new_status.Status_ID != null && new_status.Status_ID.Trim().Length > 0) { dt.Rows[i]["STATUS_ID"] = new_status.Status_ID; } else { this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name)); return(false); } } dt = Add_Date_User(dt); //데이터 저장 Biz_Datas datas = new Biz_Datas(); return(datas.SaveStatus(dt)); }
protected void doBindConsult() { DataTable dt = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, "SELF_COMMENT IS NOT NULL"); if (dt.Rows.Count > 0) { // txtConsult.Text = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]); txtConsult.Value = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]); } }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { if (EST_TGT_TYPE.Equals("EST")) { if (ESTTERM_STEP_ID == 2) { //질의 별 평균 컬럼 활성 DataTable dt_q_dfn = DataTypeUtility.GetGroupByDataTable(DT_QUESTION_SBJ_POINT, new string[] { "Q_DFN_ID", "Q_DFN_NAME" }); int insert_pos = e.Layout.Bands[0].Columns.FromKey("Q_SBJ_POINT_AVG").Index; for (int i = 0; i < dt_q_dfn.Rows.Count; i++) { string q_dfn_name = DataTypeUtility.GetString(dt_q_dfn.Rows[i]["Q_DFN_NAME"]) + "평균"; string q_dfn_id = DataTypeUtility.GetString(dt_q_dfn.Rows[i]["Q_DFN_ID"]); string key = q_dfn_id; if (!UltraWebGrid1.Columns.Exists(key)) { UltraGridColumn col_q_dfn = new UltraGridColumn(); col_q_dfn.BaseColumnName = key; col_q_dfn.Width = Unit.Pixel(100); col_q_dfn.Key = key; col_q_dfn.Header.Caption = q_dfn_name; col_q_dfn.Header.Style.HorizontalAlign = HorizontalAlign.Center; col_q_dfn.CellStyle.HorizontalAlign = HorizontalAlign.Right; UltraWebGrid1.Columns.Insert(insert_pos + i, col_q_dfn); } } e.Layout.Bands[0].Columns.FromKey("Q_SBJ_POINT_AVG").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_ORG").Hidden = false; //관리자의 경우 점수 조정 컬럼 활성 if (IS_ADMIN) { e.Layout.Bands[0].Columns.FromKey("POINT_AVG").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_STD").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Hidden = false; } } else if (ESTTERM_STEP_ID == 3) { e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Header.Caption = "합계점수"; e.Layout.Bands[0].Columns.FromKey("POINT_ORG_1ST").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG_1ST").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_BALANCE").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Hidden = false; e.Layout.Bands[0].Columns.FromKey("POINT").Hidden = false; } } }
public Biz_Com_Dept_Info(int dept_ref_id) { _data = new Dac_Com_Dept_Info(); DataTable dt = _data.Select_DB(dept_ref_id); if (dt.Rows.Count > 0) { DEPT_NAME = DataTypeUtility.GetString(dt.Rows[0]["DEPT_NAME"]); } }
/// <summary> /// 해당 POS_ID의 데이터 삭제 후 인서트 /// </summary> /// <param name="dt_est_pos_weight">COLUMNS : POS_ID, POS_VALUE, DEPT_TYPE_REF_ID, WEIGHT</param> public int Add_Est_Pos_Weight(int comp_id , int estterm_ref_id , string est_id , DataTable dt_est_pos_weight , string pos_id , int create_user_ref_id) { int affectedRow = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { _data.Delete_DB(conn , trx , comp_id , estterm_ref_id , est_id , pos_id , "" , 0); for (int i = 0; i < dt_est_pos_weight.Rows.Count; i++) { affectedRow += _data.Insert_DB(conn , trx , comp_id , estterm_ref_id , est_id , i + 1 , DataTypeUtility.GetString(dt_est_pos_weight.Rows[i]["POS_ID"]) , DataTypeUtility.GetString(dt_est_pos_weight.Rows[i]["POS_VALUE"]) , DataTypeUtility.GetToInt32(dt_est_pos_weight.Rows[i]["DEPT_TYPE_REF_ID"]) , DataTypeUtility.GetToInt32(dt_est_pos_weight.Rows[i]["WEIGHT"]) , create_user_ref_id); } trx.Commit(); } catch (Exception ex) { trx.Rollback(); affectedRow = 0; } finally { conn.Close(); } return(affectedRow); }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { UltraGridRow row = (UltraGridRow)(e.SelectedRows[0]); PRJ_REF_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("PRJ_REF_ID").Value); PRJ_CODE = DataTypeUtility.GetString(row.Cells.FromKey("PRJ_CODE").Value); EST_DEPT_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("EST_DEPT_ID").Value); EST_EMP_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("EST_EMP_ID").Value); doBind_prjEmp(); }
public string SelectNextDeptID(IDbConnection conn, IDbTransaction trx) { object Result; string query = @" SELECT MAX(DEPT_REF_ID)+1 FROM COM_DEPT_INFO"; Result = DbAgentObj.ExecuteScalar(conn, trx, query, null, CommandType.Text); return(DataTypeUtility.GetString(Result)); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.Q_OBJ_ID = DataTypeUtility.GetString(new Biz_QuestionDeptEmpMaps(COMP_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID , EST_ID, "", TGT_DEPT_ID, TGT_EMP_ID, "P").Q_Obj_ID); TopLabel_Bind(); Grid_Bind(); } setBtnState(); }
private void DrawChart(DataTable dt) { DataTable dtGrph = dt.Copy(); dtGrph.Columns.Add("YMD_NAME"); for (int i = 0; i < dtGrph.Rows.Count; i++) { string ymd = DataTypeUtility.GetString(dtGrph.Rows[i]["YMD"]); string year = ymd.Substring(0, 4); string month = ymd.Replace(year, ""); dtGrph.Rows[i]["YMD_NAME"] = DataTypeUtility.GetToInt32(month).ToString() + "월"; } DundasCharts.DundasChartBase(chart_score , Dundas.Charting.WebControl.ChartImageType.Flash , DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Width.Value)) , DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Height.Value)) , Dundas.Charting.WebControl.BorderSkinStyle.None , Color.FromArgb(181, 64, 1) , 0 , 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 , GradientType.TopBottom , AntiAliasing.None); chart_score.DataSource = dtGrph; string y_value_col_name = "SCORE"; Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(chart_score, y_value_col_name, "Default", "점수", null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, GetChartColor2(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series1.ValueMemberX = "YMD_NAME"; series1.ValueMembersY = y_value_col_name; series1.ToolTip = "#VALY{N0}"; series1.Label = "#VALY{N0}"; DundasAnimations.DundasChartBase(chart_score, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart_score, series1, 0.5, 2.0, true); chart_score.DataBind(); }
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { groupNumber = 0; // 정의별합산점수초기화 noneSelectCount = 0; DataRowView dr = (DataRowView)e.Item.DataItem; string q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]); Biz_QuestionDefines questionDefines = new Biz_QuestionDefines(q_dfn_id, ""); Literal ltrDefName = e.Item.FindControl("ltrLevelDefName") as Literal; Literal ltrDefine = e.Item.FindControl("ltrLevelDefine") as Literal; DataList dalList = e.Item.FindControl("DataList3") as DataList; Label lblText1 = e.Item.FindControl("lblAvgSumText") as Label; Label lblText2 = e.Item.FindControl("lblAvgText") as Label; lblValue1 = e.Item.FindControl("lblAvgSumValue") as Label; lblValue2 = e.Item.FindControl("lblAvgValue") as Label; ltrDefName.Text = questionDefines.Q_Dfn_Name; ltrDefine.Text = questionDefines.Q_Dfn_Define; lblText1.Text = lblName1; lblText2.Text = lblName2; Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, q_dfn_id); dalList.DataSource = ds; dalList.DataBind(); double tmpSum = 0; double tmpSumAvg = 0; if (SUBJECT_ITEM_YN == "1") { lblText1.Text = ""; lblText2.Text = "환산점수"; lblValue2.Text = txtValueText; } else { tmpSum = Math.Round(((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)), 1); tmpSumAvg = Math.Round(((((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)) * ds.Tables[0].Rows.Count) / (ds.Tables[0].Rows.Count - noneSelectCount)), 1); lblValue1.Text = Convert.ToString(tmpSum); lblValue2.Text = Convert.ToString(tmpSumAvg); } TOTALPOINT += DataTypeUtility.GetToDouble(lblValue2.Text); } }
protected bool Confirm_SelfEst() { int new_status_seq = 3;//자기평가 완료 int increment_seq = 1; //데이터 수집 DataTable dt = new DataTable(); string[] cols = new string[this.UltraWebGrid1.Columns.Count - 1]; for (int i = 1; i < this.UltraWebGrid1.Columns.Count; i++) { cols[i - 1] = this.UltraWebGrid1.Columns[i].Key; dt.Columns.Add(cols[i - 1]); } dt = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1, "cBox", "selchk", cols, dt); //데이터 가공 및 검증 for (int i = 0; i < dt.Rows.Count; i++) { string status_id = DataTypeUtility.GetString(dt.Rows[i]["STATUS_ID"]); Biz_Est_Data bizEstData = new Biz_Est_Data(); Biz_Status new_status = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, status_id, new_status_seq, increment_seq); if (new_status.Status_ID != null && new_status.Status_ID.Trim().Length > 0) { dt.Rows[i]["STATUS_ID"] = new_status.Status_ID; } else { this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name)); return(false); } } dt = Add_Date_User(dt); //데이터 저장 Biz_Datas datas = new Biz_Datas(); return(datas.SaveStatus(dt)); }
protected DataTable Get_SaveDT_EstQuestion() { Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(); DataTable saveDT = questionDatas.GetDataTableSchema(); TOTALPOINT = 0; for (int i = 0; i < ugrdEstQuestion.Rows.Count; i++) { DataRow dr = saveDT.NewRow(); TemplatedColumn tc = (TemplatedColumn)ugrdEstQuestion.Rows[i].Cells.FromKey("Q_ITEM").Column; RadioButtonList rdoQuestionItem = (RadioButtonList)((CellItem)tc.CellItems[i]).FindControl("rdoQuestionItem"); string q_obj_id = Q_OBJ_ID; string q_sbj_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value); string q_itm_id = DataTypeUtility.GetString(rdoQuestionItem.SelectedValue); Biz_QuestionItems bizQuestionItm = new Biz_QuestionItems(q_itm_id, q_sbj_id, q_obj_id); double weight = bizQuestionItm.Weight; double point = bizQuestionItm.Point * weight / 100; dr["COMP_ID"] = COMP_ID; dr["EST_ID"] = EST_ID; dr["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dr["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID; dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID; dr["EST_DEPT_ID"] = EST_DEPT_ID; dr["EST_EMP_ID"] = EST_EMP_ID; dr["TGT_DEPT_ID"] = TGT_DEPT_ID; dr["TGT_EMP_ID"] = TGT_EMP_ID; dr["Q_OBJ_ID"] = q_obj_id; dr["Q_SBJ_ID"] = q_sbj_id; dr["Q_ITM_ID"] = q_itm_id; dr["POINT"] = point; dr["GRADE_ID"] = ""; dr["TEXT_VALUE"] = ""; dr["OPINION"] = ""; dr["ATTACH_NO"] = ""; dr["USER"] = gUserInfo.Emp_Ref_ID; TOTALPOINT += point; saveDT.Rows.Add(dr); } return(saveDT); }
protected bool setAverage_Point() { //데이터 수집 DataTable dt = getConfirmed_EstData(); int result = 0; if (dt.Rows.Count > 0) { Biz_Est_Data bizEstData = new Biz_Est_Data(); DataTable dt_Bias_ratio = bizEstData.Get_Bias_AVG_Ratio_STD(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); //데이터 가공 for (int i = 0; i < dt.Rows.Count; i++) { string est_emp_id = DataTypeUtility.GetString(dt.Rows[i]["EST_EMP_ID"]); string filter = string.Format("EST_EMP_ID={0}", est_emp_id); DataTable dt_filtered_ratio = DataTypeUtility.FilterSortDataTable(dt_Bias_ratio, filter); if (dt_filtered_ratio.Rows.Count > 0) { double avg_ratio = DataTypeUtility.GetToDouble(dt_filtered_ratio.Rows[0]["AVG_RATIO"]); double point_org = DataTypeUtility.GetToDouble(dt.Rows[i]["POINT_ORG"]); double point_avg = point_org * avg_ratio; double point_ctrl_org = point_avg; //환산점수 계산용 점수 double point = point_ctrl_org * 100 / 5; //환산점수 dt.Rows[i]["POINT"] = Math.Round(point, 1); dt.Rows[i]["POINT_AVG"] = Math.Round(point_avg, 1); dt.Rows[i]["POINT_STD"] = -1; dt.Rows[i]["POINT_CTRL_ORG"] = Math.Round(point_avg, 1); dt.Rows[i]["STATUS_ID"] = "E";//확정 } } dt = Add_Date_User(dt); result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID); } return(result > 0 ? true : false); }
protected void SetTarget() { //DataTable DT = UltraGridUtility.GetDataSetByCheckedBox(UltraWebGrid1 // , new string[] { "PRJ_ID" } // , "selchk" // , "cBox").Tables[0]; DataTable DT = new DataTable(); DT.Columns.Add("PRJ_ID"); foreach (UltraGridRow row in UltraWebGrid1.Rows) { string status = DataTypeUtility.GetString(row.Cells.FromKey("PRJ_EST_STATUS").Value); if (status.Equals("-")) { TemplatedColumn col_cBox = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked == true) { DT.Rows.Add(row.Cells.FromKey("PRJ_ID").Value); } } } int estterm_step_id = 2; bool Result; Result = bizPrjInfo.Set_Est_Target(DT, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, estterm_step_id, gUserInfo.Emp_Ref_ID); if (DT.Rows.Count > 0) { if (Result) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리되었습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("오류가 발생했습니다.."); } } else { ltrScript.Text = JSHelper.GetAlertScript("이미 적용된 프로젝트입니다."); } }
protected void ugrdSCHD_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { string schd_mid = DataTypeUtility.GetValue(e.Row.Cells.FromKey("schd_mid").Value); string link_dir = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_dir").Value); string link_page_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_page_name").Value); string url = "<a href='{0}{1}'>{2}</a>"; string link = string.Format(url, link_dir, link_page_name, schd_mid); e.Row.Cells.FromKey("schd_mid").Text = link; string schd_mid_desc = DataTypeUtility.GetString(e.Row.Cells.FromKey("schd_mid_desc").Value); e.Row.Cells.FromKey("schd_mid_desc").Value = string.Format("<span title=\"{0}\">{0}</span>", schd_mid_desc); }
/// <summary> /// 프로젝트평가 확정 전 평가하지 않은 피평가자 존재 확인 /// </summary> protected bool Check_TgtEmp_Est_Status() { bool Result = true; for (int i = 0; i < uwgrid_TGT_EMP_LIST.Rows.Count; i++) { object point = uwgrid_TGT_EMP_LIST.Rows[i].Cells.FromKey("POINT").Value; if (DataTypeUtility.GetString(point).Length == 0) { return(false); } } return(Result); }
public int RetrieveDataInterfaceValue(int estterm_ref_id, string ymd, int user_ref_id) { IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); int affectedRow = 0; try { DataTable dt = _data.RetrieveDataInterfaceValue(conn, trx , estterm_ref_id , ymd); for (int i = 0; i < dt.Rows.Count; i++) { string query_ms = DataTypeUtility.GetString(dt.Rows[i]["Q_MS"]); string query_ts = DataTypeUtility.GetString(dt.Rows[i]["Q_TS"]); int kpi_ref_id = DataTypeUtility.GetToInt32(dt.Rows[i]["KPI_REF_ID"]); affectedRow += _data.Update_KPI_Result_From_RetrieveData(conn, trx , query_ms , query_ts , estterm_ref_id , kpi_ref_id , ymd , user_ref_id); } trx.Commit(); } catch (Exception ex) { trx.Rollback(); affectedRow = 0; } finally { conn.Close(); } return(affectedRow); }