private void GridBinding22(int comp_id, int estterm_ref_id, string est_id)
{
Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();
_dtEstDetail = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();
_dtPosDetail = deptPosDetail.GetDeptPosDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
UltraWebGrid2.Clear();
UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" ");
UltraWebGrid2.DataBind();
}
private void GridBinding3(int comp_id, int estterm_ref_id, int dept_ref_id, string est_id)
{
if (dept_ref_id == 0)
{
return;
}
Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();
_dtPosDetail = deptPosDetail.GetDeptPosDetail(comp_id, estterm_ref_id, dept_ref_id, est_id).Tables[0];
UltraWebGrid3.Clear();
UltraWebGrid3.DataSource = _dtPosDetail;
UltraWebGrid3.DataBind();
}
private string GetWeightName(string est_id, string weight_type, ref string weight)
{
string reVal = "<b>가중치</b><br>";
string weight_name = string.Empty;
if (weight_type.Equals("DPT"))
{
DataRow[] rows = DS_DETAIL.Tables[0].Select(string.Format(" EST_ID = '{0}' ", est_id));
if (rows.Length > 0)
{
weight = (rows[0]["WEIGHT"].ToString().Equals("")) ? "" : rows[0]["WEIGHT"].ToString();
}
else
{
weight = "";
}
if (weight.Equals(""))
{
weight_name = "";
}
else
{
weight_name = " 부서:" + weight + "%";
}
}
else if (weight_type.Equals("POS"))
{
Biz_DeptPosDetails biz = new Biz_DeptPosDetails();
DataSet ds = biz.GetDeptPosDetail(COMP_ID
, ESTTERM_REF_ID
, DataTypeUtility.GetToInt32(TreeView1.SelectedNode.Value)
, est_id);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
string no = " " + row["SEQ"].ToString() + ".";
string pos_id = GetPosName(row["POS_ID"].ToString(), row["POS_VALUE"].ToString());
weight = (row["WEIGHT"].ToString().Equals("")) ? "" : row["WEIGHT"].ToString() + "%" + "<br>";
weight_name += no + pos_id + weight;
}
}
else
{
weight_name = "";
}
}
reVal += weight_name;
if (reVal.Equals("<b>가중치</b><br>"))
{
return("");
}
return(reVal);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraGridUtility.CreateColumns((UltraWebGrid)sender
, COMP_ID
, EST_ID
, DEFAULT_INDEX_COUNT
, out DT_COLUMN_INFO
, (OwnerTypeMode == OwnerType.Dept) ? "D" : "P"
, EST_JOB_IDS.Split(',')
, DEPT_COLUMN_NO_USE_YN);
if (e.Layout.Bands[0].Columns.Exists("selchk"))
{
if (!e.Layout.Bands[0].Columns.FromKey("selchk").Hidden)
{
e.Layout.Bands[0].Columns.FromKey("selchk").Hidden = true;
}
}
// 가중치 컬럼을 사용할 경우
if (COL_WEIGHT_VISIBLE_YN.Equals("Y") ||
COL_GRADE_VISIBLE_YN.Equals("Y"))
{
Biz_DeptEstDetails deptEstDetail = null;
Biz_DeptPosDetails deptPosDetail = null;
DataTable dtDeptDetail = null;
DataRow[] drArrColumn = DT_COLUMN_INFO.Select(@"COL_STYLE_ID = 'BIZ'
AND VISIBLE_YN = 'Y'");
foreach (DataRow drColumn in drArrColumn)
{
if (drColumn["COL_KEY"].ToString().IndexOf("WEIGHT_") < 0)
{
continue;
}
string est_id = drColumn["COL_KEY"].ToString().Replace("WEIGHT_", "");
Biz_EstInfos estSubInfo = new Biz_EstInfos(COMP_ID, est_id);
if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("DPT"))
{
deptEstDetail = new Biz_DeptEstDetails();
dtDeptDetail = deptEstDetail.GetDeptEstDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0];
}
else if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("POS"))
{
deptPosDetail = new Biz_DeptPosDetails();
dtDeptDetail = deptPosDetail.GetDeptPosDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0];
}
if (DT_DEPT_EST_POS_DETAIL == null)
{
DT_DEPT_EST_POS_DETAIL = dtDeptDetail;
}
else
{
DT_DEPT_EST_POS_DETAIL.Merge(dtDeptDetail);
}
}
}
e.Layout.ClientSideEvents.MouseOverHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.MouseOverHandler;
e.Layout.ClientSideEvents.DblClickHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.DblClickHandler;
}