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