protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_Scopes scopes = new Biz_Scopes();
DataTable dtInsert = scopes.GetSchema();
DataRow drNew = null;
foreach (UltraGridRow ugRow in UltraWebGrid1.Rows)
{
if (CheckRow(ugRow) == false)
{
ltrScript.Text = JSHelper.GetAlertScript("입력되지 않았습니다. 값을 입력해주세요.", false);
break;
}
//TemplatedColumn tcol_ScaleId = (TemplatedColumn)ugRow.Band.Columns.FromKey( "DDLSCALE_ID" );
//DropDownList ddl_ScaleId = (DropDownList)( (CellItem)tcol_ScaleId.CellItems[ugRow.BandIndex] ).FindControl( "ddlScaleId" );
TemplatedColumn tcol_StartScope = (TemplatedColumn)ugRow.Band.Columns.FromKey("TXTSTART_SCOPE");
TextBox txtStartScope = (TextBox)((CellItem)tcol_StartScope.CellItems[ugRow.BandIndex]).FindControl("txtStartScope");
TemplatedColumn tcol_EndScope = (TemplatedColumn)ugRow.Band.Columns.FromKey("TXTEND_SCOPE");
TextBox txtEndScope = (TextBox)((CellItem)tcol_EndScope.CellItems[ugRow.BandIndex]).FindControl("txtEndScope");
//TemplatedColumn tcol_ScopeUnitId = (TemplatedColumn)ugRow.Band.Columns.FromKey( "DDLSCOPE_UNIT_ID" );
//DropDownList ddl_ScopeUnitId = (DropDownList)( (CellItem)tcol_ScopeUnitId.CellItems[ugRow.BandIndex] ).FindControl( "ddlScopeUnitId" );
TemplatedColumn tcol_GradeToPoint = (TemplatedColumn)ugRow.Band.Columns.FromKey("TXTGRADE_TO_POINT");
TextBox txtGradeToPoint = (TextBox)((CellItem)tcol_GradeToPoint.CellItems[ugRow.BandIndex]).FindControl("txtGradeToPoint");
drNew = dtInsert.NewRow();
drNew["COMP_ID"] = COMP_ID;
drNew["EST_ID"] = EST_ID;
drNew["GRADE_ID"] = ugRow.Cells.FromKey("GRADE_ID").Value;
drNew["SCALE_ID"] = SCALE_ID;
drNew["START_SCOPE"] = DataTypeUtility.GetToDouble(txtStartScope.Text.Trim());
drNew["END_SCOPE"] = DataTypeUtility.GetToDouble(txtEndScope.Text.Trim());
drNew["SCOPE_UNIT_ID"] = new Biz_ScopeUnits().GetScopeUnitIDByScaleID(SCALE_ID);
drNew["GRADE_TO_POINT"] = DataTypeUtility.GetToDouble(txtGradeToPoint.Text.Trim());
dtInsert.Rows.Add(drNew);
}
bool isOK = scopes.AddScope(dtInsert
, DateTime.Now
, EMP_REF_ID);
if (isOK)
{
BindGrid(COMP_ID, EST_ID, SCALE_ID);
//ButtonStatusInit();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("항목이 입력되지 않았습니다. 각 항목을 입력해주세요.");
return;
}
}
private void BindGrid(int comp_id, string est_id, string scale_id)
{
Biz_Scopes scopes = new Biz_Scopes();
DataSet ds = scopes.GetScopeGradeEstID(comp_id, est_id, scale_id);
if (ds.Tables[0].Rows.Count == 0)
{
Biz_Grades grades = new Biz_Grades();
DataSet dsGrade = grades.GetEstGrades(comp_id);
UltraWebGrid1.DataSource = dsGrade;
UltraWebGrid1.DataBind();
}
else
{
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
}
}
/// <summary>
/// 그리드 바인딩 메소드
/// </summary>
/// <param name="comp_id"></param>
/// <param name="est_id"></param>
/// <param name="estterm_ref_id"></param>
/// <param name="estterm_sub_id"></param>
/// <param name="estterm_step_id"></param>
private void GridBidingData(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
if (!estInfo.IsExists(comp_id, est_id))
{
return;
}
// 만약 주기가 년간일 경우
if (YEAR_YN.Equals("Y"))
{
ESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID);
}
// 만약 차수가 합산일 경우
if (MERGE_YN.Equals("Y"))
{
ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
}
if (estInfo.Owner_Type != null && estInfo.Owner_Type.Equals("D"))
{
OwnerTypeMode = OwnerType.Dept;
}
else
{
OwnerTypeMode = OwnerType.Emp_User;
}
//if (estInfo.Owner_Type.Equals("D"))
// OwnerTypeMode = OwnerType.Dept;
//else
// OwnerTypeMode = OwnerType.Emp_User;
ScaleTypeMode = estInfo.Scale_Type;
WeightTypeMode = estInfo.Weight_Type;
if (estInfo.Bias_YN.Equals("Y"))
{
BiasYN = YesNo.Yes;
}
else
{
BiasYN = YesNo.No;
}
if (estInfo.Grade_Confirm_YN.Equals("Y"))
{
GradeConfirmYN = YesNo.Yes;
}
else
{
GradeConfirmYN = YesNo.No;
}
Biz_Datas est_data = new Biz_Datas();
int est_emp_id = 0;;
int tgt_dept_id = 0;
int tgt_emp_id = 0;
if (OwnerTypeMode == OwnerType.Dept && DEPT_COLUMN_NO_USE_YN.Equals("Y"))
{
OwnerTypeMode = OwnerType.Emp_User;
}
else if (OwnerTypeMode == OwnerType.Emp_User && DEPT_COLUMN_NO_USE_YN.Equals("Y"))
{
OwnerTypeMode = OwnerType.Dept;
}
if (OwnerTypeMode == OwnerType.Dept)
{
if (EST_TGT_TYPE.Equals("EST"))
{
est_emp_id = 0;
tgt_dept_id = TGT_DEPT_ID;
tgt_emp_id = -1;
}
else if (EST_TGT_TYPE.Equals("TGT"))
{
est_emp_id = 0;
tgt_dept_id = TGT_DEPT_ID;
tgt_emp_id = -1;
}
}
else if (OwnerTypeMode == OwnerType.Emp_User)
{
if (EST_TGT_TYPE.Equals("EST"))
{
est_emp_id = 0;
tgt_dept_id = 0;
tgt_emp_id = TGT_EMP_ID;
}
else if (EST_TGT_TYPE.Equals("TGT"))
{
est_emp_id = 0;
tgt_dept_id = 0;
tgt_emp_id = TGT_EMP_ID;
}
}
DT_EST_DATA = est_data.GetEstData(comp_id
, est_id
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, est_emp_id
, tgt_dept_id
, tgt_emp_id
, YEAR_YN
, MERGE_YN
, OwnerTypeMode).Tables[0];
// 조회된 데이터가 존재할 경우
if (DT_EST_DATA != null)
{
// 만약 가중치 보이기 Y 일때
if (COL_WEIGHT_VISIBLE_YN.Equals("Y"))
{
//2012.01.16 박효동 : 하위평가를 가져오니 문제가 있어서 수정
// - MBO의 하위평가를 가져오도록 평가컬럼설정이 되있는데 현재는 현재평가의 하위차수를 가져오니 안나오더라
// - 해서 평가컬럼설정에 등록되어있는 POINT_평가아이디에 해당하는 평가아이디를 가져오도록 수정 휴~~
// 하위평가 정보를 가지고 온다.
//DataTable _dtEstID = estInfo.GetEstInfoByUpEstID(comp_id, est_id).Tables[0];
DataTable _dtEstID = estInfo.GetEstInfoByUpEstID(comp_id, est_id).Tables[0];
_dtEstID.Rows.Clear();
Biz_ColumnInfos colInfo = new Biz_ColumnInfos();
DataTable dtEstID = colInfo.GetColumnInfo(COMP_ID, EST_ID).Tables[0];
foreach (DataRow dr in dtEstID.Rows)
{
string colnames = dr[6].ToString();
if (colnames.Length > 5)
{
if (colnames.Substring(0, 6) == "POINT_" && colnames.Length == 8)
{
DataRow insertDR = _dtEstID.NewRow();
insertDR["EST_ID"] = colnames.Remove(0, 6);
_dtEstID.Rows.Add(insertDR);
insertDR = null;
}
}
}
foreach (DataRow dataRow in _dtEstID.Rows)
{
DT_EST_DATA.Columns.Add(string.Format("WEIGHT_{0}", dataRow["EST_ID"]), typeof(double));
// 평가별 점수 보이기 여부에 따라
if (COL_POINT_VISIBLE_YN.Equals("Y"))
{
DT_EST_DATA.Columns.Add(string.Format("POINT_{0}", dataRow["EST_ID"]), typeof(double));
DataTable dtEstData = est_data.GetData(comp_id
, dataRow["EST_ID"].ToString()
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, est_emp_id
, tgt_dept_id
, tgt_emp_id
, YEAR_YN
, MERGE_YN
, OwnerTypeMode).Tables[0];
foreach (DataRow drEstData in dtEstData.Rows)
{
DataRow[] drArrEstData = DT_EST_DATA.Select(string.Format(@"ESTTERM_REF_ID = {0}
AND ESTTERM_SUB_ID = {1}
AND ESTTERM_STEP_ID = {2}
AND TGT_DEPT_ID = {3}
AND TGT_EMP_ID = {4}"
, drEstData["ESTTERM_REF_ID"]
, drEstData["ESTTERM_SUB_ID"]
, drEstData["ESTTERM_STEP_ID"]
, drEstData["TGT_DEPT_ID"]
, drEstData["TGT_EMP_ID"]));
if (drArrEstData.Length > 0)
{
drArrEstData[0][string.Format("POINT_{0}", dataRow["EST_ID"])] = drEstData["POINT"];
}
}
}
}
}
// 등급 컬럼 보이기가 Y 일경우 (이건 DT_EST_DATA 과 관계 없음)
if (COL_GRADE_VISIBLE_YN.Equals("Y") ||
COL_GRADE_TO_POINT_VISIBLE_YN.Equals("Y"))
{
Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();
DT_DEPT_SCALE = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
DT_POS_SCALE = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0];
Biz_Scopes scope = new Biz_Scopes();
DT_SCOPE = scope.GetScope(comp_id, est_id).Tables[0];
DT_EST_DATA.Columns.Add("RANK", typeof(double));
DT_EST_DATA.Columns.Add("SCALE_ID", typeof(string));
DT_EST_DATA.Columns.Add("SCALE_NAME", typeof(string));
DT_EST_DATA.Columns.Add("GRADE_CALC_ID", typeof(string));
}
if (COL_ESTTERM_SUB_AGG_VISIBLE_YN.Equals("Y"))
{
}
if (COL_ESTTERM_STEP_AGG_VISIBLE_YN.Equals("Y"))
{
}
if (COL_CTRL_POINT_VISIBLE_YN.Equals("Y") ||
COL_CTRL_GRADE_VISIBLE_YN.Equals("Y"))
{
Biz_CtrlEstMaps ctrlEstDeptMap = new Biz_CtrlEstMaps();
DT_CTRL_INFO = ctrlEstDeptMap.GetCtrlInfoByEstID(COMP_ID, EST_ID).Tables[0];
DT_CTRL_EST_DEPT_MAP = ctrlEstDeptMap.GetCtrlEstDeptByEstID(COMP_ID, EST_ID).Tables[0];
if (COL_CTRL_POINT_VISIBLE_YN.Equals("Y"))
{
Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas();
DT_CTRL_POINT_DATA = ctrlPointData.GetCtrlPointData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, 0
, 0
, 0
, 0).Tables[0];
}
if (COL_CTRL_GRADE_VISIBLE_YN.Equals("Y"))
{
Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas();
DT_CTRL_GRADE_DATA = ctrlGradeData.GetCtrlGradeData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, 0
, 0
, 0
, 0).Tables[0];
}
}
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = DT_EST_DATA;
UltraWebGrid1.DataBind();
}
}
