private void DoBindingColumn()
{
Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
DataTable dtColumns = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "", "");
if (dtColumns.Rows.Count == 0)
{
if (bizBiasData.InsertInitBiasColumnData(this.ICOMP_ID, this.IEST_ID, gUserInfo.Emp_Ref_ID))
{
dtColumns = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "", "");
}
else
{
return;
}
}
ugrdColumn.DataSource = dtColumns;
ugrdColumn.DataBind();
}
private void DoInitColumn()
{
Biz_BiasDatas bizBaisData = new Biz_BiasDatas();
DataTable dtColumn = bizBaisData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");
UltraGridColumn ucol = null;
foreach (DataRow dr in dtColumn.Rows)
{
ucol = new UltraGridColumn();
ucol.Header.Caption = dr["COL_NAME"].ToString();
ucol.Header.Style.HorizontalAlign = HorizontalAlign.Center;
ucol.Header.Column.Key = ucol.Header.Column.BaseColumnName = dr["COL_KEY"].ToString();
ucol.Width = Unit.Pixel(DataTypeUtility.GetToInt32(dr["COL_WIDTH"]));
ucol.DataType = dr["DATA_TYPE"].ToString();
if (dr["DATA_TYPE"].ToString() == "System.Double")
{
ucol.Format = "##,###,##0.00";
}
ucol.CellStyle.HorizontalAlign = GetAlignColumn(dr["COL_ALIGN"].ToString());
this.ICOLUMN_SORT += dr["COL_ALIGN"].ToString() + ";";
this.ICOLUMN_DATA_TYPE += ucol.DataType + ";";
this.ICOLUMN_FORMAT += ucol.Format + ";";
ugrdBias.Columns.Add(ucol);
}
if (dtColumn.Rows.Count > 0)
{
ucol = new UltraGridColumn();
ucol.Header.Caption = "확정점수";
ucol.Header.Style.HorizontalAlign = HorizontalAlign.Center;
ucol.Header.Column.Key = ucol.Header.Column.BaseColumnName = "POINT";
ucol.Width = Unit.Pixel(80);
ucol.DataType = "System.Double";
ucol.Format = "##,###,##0.00";
ucol.CellStyle.HorizontalAlign = GetAlignColumn("Right");
this.ICOLUMN_SORT += "Right";
this.ICOLUMN_DATA_TYPE += "System.Double";
this.ICOLUMN_FORMAT += "##,###,##0.00";
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "COMP_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "EST_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_REF_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_SUB_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_STEP_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "BIAS_GRP_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_DEPT_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_EMP_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_CLS_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_DUT_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_GRP_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
ucol = new UltraGridColumn();
ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_RNK_ID";
ucol.Header.Column.Hidden = true;
ugrdBias.Columns.Add(ucol);
}
}
protected void ibtnCalc_Click(object sender, ImageClickEventArgs e)
{
string selectQuery = string.Empty;
string joinQuery = string.Empty;
Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
DataTable dtPointType = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");
if (dtPointType.Rows.Count > 0)
{
DataRow[] drPointType = dtPointType.Select("COL_TYPE = 'USERKEY'", "COL_ORDER ASC");
foreach (DataRow dr in drPointType)
{
selectQuery += @"
, " + dr["COL_KEY"].ToString() + ".RTNVALUE AS " + dr["COL_KEY"].ToString();
joinQuery += @"
LEFT OUTER JOIN " + dr["PROC_NAME"].ToString() + "(@COMP_ID, @EST_ID, @ESTTERM_REF_ID, @ESTTERM_SUB_ID, @ESTTERM_STEP_ID, @BIAS_GRP_ID) " + dr["COL_KEY"].ToString()
+ " ON " + dr["COL_KEY"].ToString() + ".TGT_EMP_ID = A.EMP_REF_ID";
}
}
DataTable dtBiasData = bizBiasData.CalcBiasData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, selectQuery, joinQuery);
ugrdBias.DataSource = dtBiasData;
ugrdBias.DataBind();
DoSortColumn();
if (ugrdBias.Rows.Count == 0)
{
ibtnInsert.Visible = false;//ibtnConfirm.Visible =
ltrScript.Text = JSHelper.GetAlertScript("계산된 데이터가 없습니다.");
}
else
{
DataTable dtBank = new DataTable();
string strUserColumnName = string.Empty;
for (int i = 1; i < 11; i++)
{
if (ugrdBias.Columns.FromKey("COL" + i.ToString()) != null)
{
strUserColumnName += "COL" + i.ToString() + ";";
}
}
string[] strUserColumn = { "TGT_DEPT_ID", "TGT_EMP_ID", "TGT_POS_CLS_ID", "TGT_POS_DUT_ID", "TGT_POS_GRP_ID", "TGT_POS_RNK_ID", "", "", "", "", "", "", "", "", "", "" };
if (strUserColumnName != string.Empty)
{
strUserColumnName = strUserColumnName.Substring(0, strUserColumnName.Length - 1);
for (int i = 0; i < strUserColumnName.Split(';').Length; i++)
{
strUserColumn.SetValue(strUserColumnName.Split(';').GetValue(i).ToString(), 6 + i);
}
}
int cntUserColumnName;
if (strUserColumnName.Trim().Length == 0)
{
cntUserColumnName = 0;
}
else
{
cntUserColumnName = strUserColumnName.Split(';').Length;
}
string[] strFinalColumn = new string[6 + cntUserColumnName];
for (int i = 0; i < strFinalColumn.Length; i++)
{
if (strUserColumn.GetValue(i).ToString() != "")
{
strFinalColumn.SetValue(strUserColumn.GetValue(i).ToString(), i);
dtBank.Columns.Add(strUserColumn.GetValue(i).ToString(), (i < 2 ? typeof(int) : typeof(string)));
}
}
//dtBank.Columns.Add("POINT", typeof(double));
DataTable dtCalcData = UltraGridUtility.GetDataTableByAllValue(ugrdBias
, strFinalColumn
, dtBank);
if (dtCalcData.Rows.Count > 0)
{
if (bizBiasData.InsertBiasData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, dtCalcData, gUserInfo.Emp_Ref_ID))
{
DoBindingData();
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 Bias 조정점수 계산을 완료하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("데이터 적용이 실패하였습니다.\\n" + bizBiasData.errMSG.Replace("\n", ""));
}
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("데이터 적용이 실패하였습니다.");
}
}
lblRowCount.Text = ugrdBias.Rows.Count.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
YEAR_YN = WebUtility.GetRequest("YEAR_YN", "N");
MERGE_YN = WebUtility.GetRequest("MERGE_YN", "N");
EST_JOB_IDS = WebUtility.GetRequest("EST_JOB_IDS");
//BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnApplyBiasPoint);
//BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnCalcBiasPoint);
if (!Page.IsPostBack)
{
this.IEST_ID = WebUtility.GetRequest("EST_ID", "");
this.IEST_JOB_IDS = WebUtility.GetRequest("EST_JOB_IDS", "");
lblCalc1.Font.Size = lblCalc2.Font.Size = FontUnit.Point(8);
DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
DropDownListCommom.BindEstTerm(ddlEstTermRefID);
DropDownListCommom.BindDefaultValue(ddlEstTermSubID, "----------", "");
DropDownListCommom.BindDefaultValue(ddlEstTermStepID, "----------", "");
if (this.ICOMP_ID == 0)
{
this.ICOMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID);
}
if (this.IESTTERM_REF_ID == 0)
{
this.IESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);
}
DropDownListCommom.BindEstTermSub(ddlEstTermSubID, this.ICOMP_ID, this.IEST_ID, "");
DropDownListCommom.BindEstTermStep(ddlEstTermStepID, this.ICOMP_ID, this.IEST_ID);
if (this.IESTTERM_SUB_ID == 0)
{
this.IESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
}
if (this.IESTTERM_STEP_ID == 0)
{
this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
}
if (MERGE_YN.Equals("Y"))
{
this.IESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
}
else
{
if (ESTTERM_STEP_ALL_USE_YN.Equals("Y"))
{
this.IESTTERM_STEP_ID = 0;
}
else
{
this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
}
}
//평가마감되었는지 확인
BizUtility.SetButtonVisibleByEstJobID(this.IEST_JOB_IDS
, ibtnCalc
, this.ICOMP_ID
, this.IEST_ID
, this.IESTTERM_REF_ID
, this.IESTTERM_SUB_ID
, this.IESTTERM_STEP_ID);
ibtnInsert.Visible = ddlPointType.Visible = ibtnCalc.Visible;//ibtnConfirm.Visible =
Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
DataTable dtGroup = bizBiasData.GetBiasGroup(this.ICOMP_ID, this.IEST_ID, "Y");
ddlGroup.DataTextField = "BIAS_GRP_NM";
ddlGroup.DataValueField = "BIAS_GRP_ID";
ddlGroup.DataSource = dtGroup;
ddlGroup.DataBind();
ddlGroup.Width = Unit.Pixel(200);
this.IBIAS_GRP_ID = WebUtility.GetIntByValueDropDownList(ddlGroup);
DataTable dtPointType = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");
if (dtPointType.Rows.Count > 0)
{
DataRow[] drPointType = dtPointType.Select("COL_TYPE = 'USERKEY' AND PROC_TYPE = 'Y'", "COL_ORDER ASC");
foreach (DataRow dr in drPointType)
{
ddlPointType.Items.Add(new ListItem(dr["COL_NAME"].ToString(), dr["COL_KEY"].ToString()));
}
if (ddlPointType.Items.Count > 0)
{
ddlPointType.Items[0].Selected = true;
}
}
if (!this.IEST_ID.Equals(""))
{
DoBindingData();
}
else
{
ibtnCalc.Visible = ddlPointType.Visible = ibtnInsert.Visible = ibtnDownload.Visible = false;//ibtnConfirm.Visible =
}
DoBindingBiasMethod();
}
if (YEAR_YN.Equals("Y"))
{
this.IESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID);
}
else
{
this.IESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
}
if (MERGE_YN.Equals("Y"))
{
this.IESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
}
else
{
this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
}
DoSortColumn();
if (ddlPointType.Items.Count == 0)
{
ibtnInsert.Visible = ddlPointType.Visible = false;//ibtnConfirm.Visible =
}
ltrScript.Text = "";
}
