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