private void ViewOne(string status_id, string status_style_id) { Biz_Status status = new Biz_Status(status_id, status_style_id); txtStatusID.Text = status.Status_ID.ToString(); txtStatusName.Text = status.Status_Name; }
public static void CreateStatusHtmlTable(Table tbl, string est_id) { if (tbl != null && tbl.Rows.Count > 0) { for (int i = 0; i < tbl.Rows.Count; i++) { tbl.Rows.RemoveAt(0); } } Biz_Status status = new Biz_Status(); DataTable dataTable = status.GetStatusByEstID(est_id).Tables[0]; tbl.CellPadding = 0; tbl.CellSpacing = 0; tbl.BorderWidth = 0; TableRow tblRow = new TableRow(); foreach (DataRow dataRow in dataTable.Rows) { TableCell tblCell = new TableCell(); tblCell.Style.Add("padding-right", "5px"); tblCell.Text = string.Format("<img src='{0}' alt='{1}' /> {2} ", dataRow["STATUS_IMG_PATH"], dataRow["STATUS_DESC"], dataRow["STATUS_NAME"]); tblRow.Cells.Add(tblCell); } tbl.Rows.Add(tblRow); }
private void DoConfig() { string strStatusStyleID = "0004"; DropDownListCommom.BindComp(ddlCompID, lblCompTitle); DropDownListCommom.BindEstTerm(ddlEstTermRefID); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID , WebUtility.GetIntByValueDropDownList(ddlCompID) , "N"); TreeViewCommom.BindEst(TreeView1, WebUtility.GetIntByValueDropDownList(ddlCompID)); Biz_Status status = new Biz_Status(); DataSet ds = status.GetStatuses(strStatusStyleID); UltraWebGrid1.Columns.FromKey("STATUS_YN").ValueList.DataSource = ds.Tables[0]; UltraWebGrid1.Columns.FromKey("STATUS_YN").ValueList.DisplayMember = "STATUS_NAME"; UltraWebGrid1.Columns.FromKey("STATUS_YN").ValueList.ValueMember = "STATUS_ID"; UltraWebGrid1.Columns.FromKey("STATUS_YN").ValueList.DataBind(); Biz_TermSteps termStep = new Biz_TermSteps(); DataSet dsStep = termStep.GetTermSteps(WebUtility.GetIntByValueDropDownList(ddlCompID), "Y"); UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.DataSource = dsStep.Tables[0]; UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.DisplayMember = "ESTTERM_STEP_NAME"; UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.ValueMember = "ESTTERM_STEP_ID"; UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.DataBind(); UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.ValueListItems.RemoveAt(0); UltraWebGrid1.Columns.FromKey("STEP_ID").ValueList.ValueListItems.Insert(0, new ValueListItem("-", 0)); }
//public static bool SetConfirmButtonVisible(int comp_id // , string est_id // , int estterm_ref_id // , int estterm_sub_id // , int estterm_step_id // , string est_job_id // , ImageButton ibnConfirm // , ImageButton ibnConfirmCancel // , string status_yn // , DateTime date // , int user // , Literal ltrScript) //{ // if(status_yn.Equals("")) // { // status_yn = GetStatusYN( comp_id // , est_id // , estterm_ref_id // , estterm_sub_id // , estterm_step_id // , est_job_id); // } // else // { // Biz_JobInfos jobInfo = new Biz_JobInfos(est_job_id); // Biz_JobDetails jobDetail = new Biz_JobDetails(); // // 만약 종속 작업 ID 가 존재하고 현재 작업을 확정하려고 할 때 // if( !jobInfo.Est_Job_Depen_IDs.Equals("") // && status_yn.Equals("Y")) // { // string[] est_job_depen_ids = jobInfo.Est_Job_Depen_IDs.Split(';'); // foreach(string est_job_depen_id in est_job_depen_ids) // { // string status_depen_yn = GetStatusYN( comp_id // , est_id // , estterm_ref_id // , estterm_sub_id // , estterm_step_id // , est_job_depen_id); // if(status_depen_yn.Equals("N")) // { // Biz_JobInfos depenJobInfo = new Biz_JobInfos(est_job_depen_id); // if(ltrScript != null) // ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 작업을 우선 확정하신 후에 현재 작업이 확정 가능합니다.", depenJobInfo.Est_Job_Name)); // return false; // } // } // } // } // return true; //} public static string GetStatusHtml(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id , string[] est_job_ids) { string temp = ""; Biz_JobDetails jobDetail = null; foreach (string est_job_id in est_job_ids) { jobDetail = new Biz_JobDetails(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id , est_job_id); Biz_Status status = new Biz_Status(jobDetail.Status_YN, "0004"); if (!jobDetail.Est_Job_Name.Equals("") && !jobDetail.Status_YN.Equals("")) { temp += string.Format("<img src='{1}'> {0} ", jobDetail.Est_Job_Name, status.Status_Img_Path); } } return(temp); }
public static void BindStatus(DropDownList ddl, string strStatusStyleID) { Biz_Status status = new Biz_Status(); ddl.DataSource = status.GetStatuses(strStatusStyleID); ddl.DataTextField = "STATUS_NAME"; ddl.DataValueField = "STATUS_ID"; ddl.DataBind(); }
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)); }
private void GridBinding() { Biz_Status status = new Biz_Status(); DataSet ds = status.GetStatuses(""); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); lblRowCount.Text = ds.Tables[0].Rows.Count.ToString(); }
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)); }
private void DoInitControl() { tblViewStatus.CellPadding = 0; tblViewStatus.CellSpacing = 0; tblViewStatus.BorderWidth = 0; TableRow tblRow = new TableRow(); TableCell tblCell = null; tblViewStatus.Rows.Add(tblRow); Biz_Status bizStatus = new Biz_Status(); DataSet dsStatus = bizStatus.GetStatuses("0003"); foreach (DataRow dataRow in dsStatus.Tables[0].Rows) { tblCell = new TableCell(); tblCell.Style.Add("padding-right", "5px"); tblCell.Text = string.Format("<img src='{0}' alt='{1}' /> {2} ", dataRow["STATUS_IMG_PATH"], dataRow["STATUS_DESC"], dataRow["STATUS_NAME"]); tblRow.Cells.Add(tblCell); } DropDownListCommom.BindComp(ddlCompID, lblCompTitle); ICOMP_ID = GetRequestByInt("COMP_ID", PageUtility.GetIntByValueDropDownList(ddlCompID)); PageUtility.FindByValueDropDownList(ddlCompID, ICOMP_ID); DropDownListCommom.BindEstTerm(ddlEstTerm); IESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID", PageUtility.GetIntByValueDropDownList(ddlEstTerm)); PageUtility.FindByValueDropDownList(ddlEstTerm, IESTTERM_REF_ID); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID , ICOMP_ID , "N"); IESTTERM_SUB_ID = GetRequestByInt("ESTTERM_SUB_ID", PageUtility.GetIntByValueDropDownList(ddlEstTermSubID)); PageUtility.FindByValueDropDownList(ddlEstTermSubID, IESTTERM_SUB_ID); DropDownListCommom.BindEstTermStep(ddlEstTermStepID, ICOMP_ID, IEST_ID, "N"); if (ddlEstTermStepID.Items.Count > 0) { ddlEstTermStepID.Items.Insert(0, new ListItem("::전체::", "0")); ddlEstTermStepID.SelectedIndex = 0; ESTTERM_STEP_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermStepID); } WebCommon.SetComDeptDropDownList(ddlComDept, true); //PageUtility.FindByValueDropDownList(ddlComDept, BizUtility.GetDeptID(gUserInfo.Emp_Ref_ID)); }
protected void ibnDelete_Click(object sender, ImageClickEventArgs e) { string strStatusID = hdfStatusID.Value.Trim(); Biz_Status status = new Biz_Status(); bool bResult = status.RemoveStatus(strStatusID); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 삭제되었습니다.", false); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("삭제될 대상이 선택되지 않았습니다."); return; } }
protected void ibnCheckID_Click(object sender, ImageClickEventArgs e) { string strStatusID = txtStatusID.Text.Trim(); if (strStatusID.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("상태 ID를 입력해주세요."); return; } Biz_Status status = new Biz_Status(); bool bDuplicate = status.IsExist(strStatusID); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 상태 ID가 있습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("사용가능한 상태 ID 입니다."); } }
private bool SaveQuestionData(string commandName) { Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(); Biz_Datas datas = new Biz_Datas(); DataTable dtQData = questionDatas.GetDataTableSchema(); if (DataList1.Items.Count > 0) { dtQData = GetQuestionDataTable(dtQData, DataList1); } if (DataList2.Items.Count > 0) { dtQData = GetQuestionSubDataTable(dtQData, DataList2); } DataTable dtEstData = AddNewEstDataRow(datas.GetDataTableSchema()); //------------------------- 상태 순서 체크 시작 ---------------------------------------- if (!commandName.Equals("BIZ_Q_FEEDBACK_REJECT")) { if (dtEstData.Rows.Count > 0) { if (datas.IsExist(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)) { datas = new Biz_Datas(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); Biz_Status status_data = new Biz_Status(datas.Status_ID, _status_style_id); Biz_Status status_new = new Biz_Status(DataTypeUtility.GetValue(dtEstData.Rows[0]["STATUS_ID"]), _status_style_id); if (status_data.Seq + 1 != status_new.Seq && status_data.Seq != status_new.Seq) { ltrScript.Text = JSHelper.GetAlertScript(string.Format(@"[{0}] 단계에서 [{1}] 단계로 진행될 수 없어 정상적으로 처리할 수 없습니다." , status_data.Status_Name , status_new.Status_Name) , true); return(false); } } else { Biz_Status status_new = new Biz_Status(DataTypeUtility.GetValue(dtEstData.Rows[0]["STATUS_ID"]), _status_style_id); if (status_new.Seq != 2) { ltrScript.Text = JSHelper.GetAlertScript(string.Format(@"[{0}] 단계은 두번째 단계가 아니여서 정상적으로 처리할 수 없습니다." , status_new.Status_Name) , true); return(false); } } } } //------------------------- 상태 순서 체크 끝 ---------------------------------------- bool isSuccessed = questionDatas.SaveQuestionData(dtQData, dtEstData, gUserInfo.Emp_Ref_ID); return(isSuccessed); }
protected bool doSave() { Biz_Est_Self_Data bizEstSelfData = new Biz_Est_Self_Data(); Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(); Biz_Datas datas = new Biz_Datas(); Biz_EstInfos bizEstInfo = new Biz_EstInfos(COMP_ID, EST_ID); int est_dept_id = TGT_DEPT_ID; int est_emp_id = TGT_EMP_ID; string status_style_id = DataTypeUtility.GetString(bizEstInfo.Status_Style_ID); Biz_Status self_status = new Biz_Status(); DataTable dt_status = self_status.GetStatuses(status_style_id).Tables[0]; string status_id = DataTypeUtility.GetString(DataTypeUtility.FilterSortDataTable(dt_status, "SEQ=2").Rows[0]["STATUS_ID"]); DataTable dtQData = Get_SaveDT_EstQuestion(); DataTable dtEstData = AddNewEstDataRow(datas.GetDataTableSchema(), status_id); DataTable dtEstSelfData = Get_SaveDT_EstComment(); //------------------------- 상태 순서 체크 시작 ---------------------------------------- if (dtEstData.Rows.Count > 0) { if (datas.IsExist(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)) { datas = new Biz_Datas(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); Biz_Status status_data = new Biz_Status(datas.Status_ID, status_style_id); Biz_Status status_new = new Biz_Status(DataTypeUtility.GetValue(dtEstData.Rows[0]["STATUS_ID"]), status_style_id); if (status_data.Seq + 1 != status_new.Seq && status_data.Seq != status_new.Seq) { ltrScript.Text = JSHelper.GetAlertScript(string.Format(@"[{0}] 단계에서 [{1}] 단계로 진행될 수 없어 정상적으로 처리할 수 없습니다." , status_data.Status_Name , status_new.Status_Name) , true); return(false); } } else { Biz_Status status_new = new Biz_Status(DataTypeUtility.GetValue(dtEstData.Rows[0]["STATUS_ID"]), status_style_id); if (status_new.Seq != 2) { ltrScript.Text = JSHelper.GetAlertScript(string.Format(@"[{0}] 단계은 두번째 단계가 아니여서 정상적으로 처리할 수 없습니다." , status_new.Status_Name) , true); return(false); } } } //------------------------- 상태 순서 체크 끝 ---------------------------------------- bool isSuccessed = bizEstSelfData.Save_Self_Est(dtEstData, dtQData, dtEstSelfData, gUserInfo.Emp_Ref_ID); return(isSuccessed); }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string strStatusID = txtStatusID.Text.Trim(); string strStatusName = txtStatusName.Text.Trim(); Biz_Status status = new Biz_Status(); bool bResult = false; if (PageWriteMode == WriteMode.New) { bool bDuplicate = status.IsExist(strStatusID); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 상태 ID가 있습니다."); } bResult = status.AddStatus(strStatusID , 0 , strStatusName , "" , "" , "" , DateTime.Now , EMP_REF_ID); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); return; } } else if (PageWriteMode == WriteMode.Modify) { bResult = status.ModifyStatus(strStatusID , 0 , strStatusName , "" , "" , hdfStatusStyleID.Value , DateTime.Now , EMP_REF_ID); if (bResult == true) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되었습니다."); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("수정 중 오류가 발생하였습니다."); return; } } }
protected bool saveEstQ() { Biz_Est_Data bizEstData = new Biz_Est_Data(); DataTable dt = DT_EST_DATA.Clone(); int balance_plus_cnt = 0; int balance_minus_cnt = 0; for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { DataRow dr = dt.NewRow(); DataRow dr_final = dt.NewRow(); string comp_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("COMP_ID").Value); string est_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_ID").Value); string estterm_ref_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value); string estterm_sub_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_SUB_ID").Value); string estterm_step_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_STEP_ID").Value); string est_dept_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_DEPT_ID").Value); string est_emp_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_EMP_ID").Value); string tgt_dept_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("TGT_DEPT_ID").Value); string tgt_emp_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("TGT_EMP_ID").Value); string status_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("STATUS_ID").Value); double point_org = DataTypeUtility.GetToDouble(UltraWebGrid1.Rows[i].Cells.FromKey("POINT_ORG").Value); string filter = "COMP_ID='{0}' AND EST_ID='{1}' AND ESTTERM_REF_ID='{2}' AND ESTTERM_SUB_ID='{3}' AND ESTTERM_STEP_ID='{4}' AND EST_DEPT_ID='{5}' AND EST_EMP_ID='{6}' AND TGT_DEPT_ID='{7}' AND TGT_EMP_ID='{8}'"; filter = string.Format(filter, 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); DataTable dt_tmp = DataTypeUtility.FilterSortDataTable(DT_EST_DATA, filter); if (dt_tmp.Rows.Count == 1) { for (int j = 0; j < dt_tmp.Columns.Count; j++) { dr_final[j] = dt_tmp.Rows[0][j]; } } else { this.ltrScript.Text = JSHelper.GetAlertScript("평가데이터에 오류가 있습니다."); return(false); } Biz_Status new_status = bizEstData.Get_New_Est_Status(DataTypeUtility.GetToInt32(comp_id), est_id, status_id, 6, 5); if (new_status.Status_ID == null && new_status.Status_ID.Trim().Length > 0) { this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name)); return(false); } TemplatedColumn tc = (TemplatedColumn)UltraWebGrid1.Columns.FromKey("POINT_BALANCE"); Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[i]).FindControl("POINT_BALANCE"); double point_balance = DataTypeUtility.GetToDouble(ne.Value); if (point_balance > 0) { balance_plus_cnt++; } else if (point_balance < 0) { balance_minus_cnt++; } double point_ctrl_org = point_org + point_balance; double point = point_ctrl_org * 100 / 5;//환산점수 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["POINT"] = point; dr["POINT_ORG"] = point_org; dr["POINT_AVG"] = -1; dr["POINT_STD"] = -1; dr["POINT_CTRL_ORG"] = point_ctrl_org; dr["STATUS_ID"] = new_status.Status_ID; dr_final["COMP_ID"] = comp_id; dr_final["EST_ID"] = est_id; dr_final["ESTTERM_REF_ID"] = estterm_ref_id; dr_final["ESTTERM_SUB_ID"] = estterm_sub_id; dr_final["ESTTERM_STEP_ID"] = "1"; dr_final["EST_DEPT_ID"] = est_dept_id; dr_final["EST_EMP_ID"] = est_emp_id; dr_final["TGT_DEPT_ID"] = tgt_dept_id; dr_final["TGT_EMP_ID"] = tgt_emp_id; dr_final["POINT"] = point; dr_final["POINT_ORG"] = point_org; dr_final["POINT_AVG"] = -1; dr_final["POINT_STD"] = -1; dr_final["POINT_CTRL_ORG"] = point_ctrl_org; dr_final["STATUS_ID"] = new_status.Status_ID; dt.Rows.Add(dr); dt.Rows.Add(dr_final); } int balance_limit = DT_EST_DATA.Rows.Count / 10; if (balance_plus_cnt > balance_limit || balance_minus_cnt > balance_limit) { this.ltrScript.Text = JSHelper.GetAlertScript("점수조정 가능인원을 초과하였습니다."); return(false); } int result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID); return(result > 0 ? true : false); }
protected bool doSave() { bool result = false; double total_point = 0; int count = 0; DataTable dtSaveQuestiondata = new DataTable(); dtSaveQuestiondata.Columns.Add("COMP_ID"); dtSaveQuestiondata.Columns.Add("EST_ID"); dtSaveQuestiondata.Columns.Add("ESTTERM_REF_ID"); dtSaveQuestiondata.Columns.Add("ESTTERM_SUB_ID"); dtSaveQuestiondata.Columns.Add("ESTTERM_STEP_ID"); dtSaveQuestiondata.Columns.Add("EST_DEPT_ID"); dtSaveQuestiondata.Columns.Add("EST_EMP_ID"); dtSaveQuestiondata.Columns.Add("TGT_DEPT_ID"); dtSaveQuestiondata.Columns.Add("TGT_EMP_ID"); dtSaveQuestiondata.Columns.Add("Q_OBJ_ID"); dtSaveQuestiondata.Columns.Add("Q_SBJ_ID"); dtSaveQuestiondata.Columns.Add("Q_ITM_ID"); dtSaveQuestiondata.Columns.Add("Q_DFN_ID"); dtSaveQuestiondata.Columns.Add("POINT"); dtSaveQuestiondata.Columns.Add("GRADE_ID"); dtSaveQuestiondata.Columns.Add("TEXT_VALUE"); dtSaveQuestiondata.Columns.Add("OPINION"); dtSaveQuestiondata.Columns.Add("ATTACH_NO"); dtSaveQuestiondata.Columns.Add("USER"); for (int i = 0; i < ugrdEstQuestion.Rows.Count; i++) { TemplatedColumn tc = (TemplatedColumn)ugrdEstQuestion.Rows.Band.Columns.FromKey("Q_FIRST"); Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[i]).FindControl("Q_FIRST"); double point = DataTypeUtility.GetToDouble(ne.Value); if (point > 0) { DataRow dr = dtSaveQuestiondata.NewRow(); string q_obj_id = Q_OBJ_ID; string q_sbj_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value); string q_dfn_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_DFN_ID").Value); 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_DFN_ID"] = q_dfn_id; dr["USER"] = EMP_REF_ID; //Biz_QuestionItems questionItems = new Biz_QuestionItems(); //DataTable dt_item = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID).Tables[0]; //string filter = string.Format("POINT={0}", point); //DataTable dt_item_filtered = DataTypeUtility.FilterSortDataTable(dt_item, filter); //dr["Q_ITM_ID"] = DataTypeUtility.GetString(dt_item_filtered.Rows[0]["Q_ITM_ID"]); dr["Q_ITM_ID"] = DBNull.Value; dr["POINT"] = Math.Round(point, 1); //가중치 DataTable dt_est_question_filtered = DataTypeUtility.FilterSortDataTable(DT_EST_QUESTION, string.Format("Q_SBJ_ID='{0}'", q_sbj_id)); int weight = DataTypeUtility.GetToInt32(dt_est_question_filtered.Rows[0]["WEIGHT"]); total_point += point * weight / 100; //count += new MicroBSC.Integration.EST.Biz.Biz_Est_Question_Data().Insert("1", "3N", ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID // , EST_DEPT_ID, EST_EMP_ID, TGT_DEPT_ID, TGT_EMP_ID // , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_OBJ_ID").Value) // , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value) // , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_ITM_ID").Value) // , point, EMP_REF_ID); dtSaveQuestiondata.Rows.Add(dr); count++; } else { count = 0; break; } } if (count > 0) { MicroBSC.Estimation.Biz.Biz_QuestionDatas questionDatas = new MicroBSC.Estimation.Biz.Biz_QuestionDatas(); Biz_Est_Data bizEstData = new Biz_Est_Data(); Biz_Status bizStatus = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, STATUS_ID, 4, 1); if (bizStatus.Status_ID != null && bizStatus.Status_ID.Trim().Length > 0) { DataTable dtSaveEstData = AddNewEstDataRow(); double point_org = Math.Round(total_point, 1); dtSaveEstData.Rows[0]["POINT_ORG"] = point_org; dtSaveEstData.Rows[0]["POINT_CTRL_ORG"] = point_org; dtSaveEstData.Rows[0]["POINT"] = point_org * 100 / 5;//환산점수 dtSaveEstData.Rows[0]["STATUS_ID"] = bizStatus.Status_ID; result = questionDatas.SaveQuestionData(dtSaveQuestiondata, dtSaveEstData, gUserInfo.Emp_Ref_ID); } else { this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없습니다.", bizStatus.Status_Name)); } } return(result); }