protected void Page_Load(object sender, EventArgs e)
{
COMP_ID = GetRequestByInt("COMP_ID");
REL_GRP_ID = GetRequest("REL_GRP_ID");
EST_ID = GetRequest("EST_ID");
ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID");
ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
SENTENCE = BizUtility.GetRelGroupWhereString(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, REL_GRP_ID
, "TM");
if (!Page.IsPostBack)
{
Biz_EstInfos estInfo = new Biz_EstInfos(COMP_ID, EST_ID);
OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type);
DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, COMP_ID, "");
GridBinding(WebUtility.GetIntByValueDropDownList(ddlEstTermSubID), OwnerTypeMode);
}
ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
ltrScript.Text = "";
}
private void BindingGrid(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
{
int tgt_emp_id = 0;
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type);
if (OwnerTypeMode == OwnerType.Dept)
{
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_EMP_NAME").Hidden = true;
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_CLS_NAME").Hidden = true;
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_DUT_NAME").Hidden = true;
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_GRP_NAME").Hidden = true;
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_RNK_NAME").Hidden = true;
UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_KND_NAME").Hidden = true;
}
Biz_EmpEstTargetMaps empEstTgtMap = new Biz_EmpEstTargetMaps();
DataSet ds = empEstTgtMap.GetEmpEstTargetMap(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, 0
, 0
, 0
, 0
, tgt_emp_id
, OwnerTypeMode);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
}
private void CheckPosGrid(int comp_id, string est_id)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type);
if (OwnerTypeMode == OwnerType.Dept)
{
uwgRelGrpPosInfo.Visible = false;
uwgRelGrpPosData.Visible = false;
trRelPos.Visible = false;
trRelPosData.Visible = false;
}
}
private void DataBindingGrid(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, string year_yn
, string merge_yn
, string owner_type)
{
_eOwnerType = BizUtility.GetOwnerType(owner_type);
Biz_Datas data = new Biz_Datas();
DT_EST_DATA = data.GetData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, 0
, 0
, 0
, 0
, year_yn
, merge_yn
, _eOwnerType).Tables[0];
Biz_Grades grade = new Biz_Grades();
DT_GRADE = grade.GetEstGrades(comp_id).Tables[0];
DataTable dataDept = BizUtility.GetDeptTree(" ");
if (_eOwnerType == OwnerType.Dept)
{
dataDept.Columns.Add("B_POINT", typeof(double));
dataDept.Columns.Add("A_POINT", typeof(double));
dataDept.Columns.Add("B_GRADE", typeof(string));
dataDept.Columns.Add("A_GRADE", typeof(string));
dataDept.Columns.Add("IS_EST", typeof(string));
foreach (DataRow dataRow in dataDept.Rows)
{
dataRow["B_POINT"] = "0";
dataRow["A_POINT"] = "0";
dataRow["B_GRADE"] = "-";
dataRow["A_GRADE"] = "-";
dataRow["IS_EST"] = "N";
}
foreach (DataRow drDept in dataDept.Rows)
{
DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"]));
foreach (DataRow dataEstData in drEstData)
{
drDept["A_POINT"] = DataTypeUtility.GetToDouble(dataEstData["POINT"]);
drDept["A_GRADE"] = DataTypeUtility.GetValue(dataEstData["GRADE_ID"]);;
drDept["IS_EST"] = "Y";
}
}
}
else if (_eOwnerType == OwnerType.Emp_User)
{
foreach (DataRow drGrade in DT_GRADE.Rows)
{
dataDept.Columns.Add("B_" + drGrade["GRADE_ID"].ToString(), typeof(string));
dataDept.Columns.Add("A_" + drGrade["GRADE_ID"].ToString(), typeof(string));
}
dataDept.Columns.Add("IS_EST", typeof(string));
foreach (DataRow dataRow in dataDept.Rows)
{
foreach (DataRow drGrade in DT_GRADE.Rows)
{
dataRow["B_" + drGrade["GRADE_ID"].ToString()] = "0";
dataRow["A_" + drGrade["GRADE_ID"].ToString()] = "0";
dataRow["IS_EST"] = "N";
}
}
foreach (DataRow drDept in dataDept.Rows)
{
DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"]));
foreach (DataRow dataEstData in drEstData)
{
if (dataEstData["GRADE_ID"] != DBNull.Value)
{
drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])] = DataTypeUtility.GetToInt32(drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])]) + 1;
}
drDept["IS_EST"] = "Y";
}
}
DataRow dr = dataDept.NewRow();
dr["DEPT_REF_ID"] = -9999;
dr["DEPT_NAME"] = "<div align='center'><b>합 계</b></center>";
dr["IS_EST"] = "T";
dataDept.Rows.Add(dr);
foreach (DataRow drGrade in DT_GRADE.Rows)
{
foreach (DataRow drEstSum in dataDept.Rows)
{
if (DataTypeUtility.GetToInt32(drEstSum["DEPT_REF_ID"]) > 0)
{
dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]
= DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])])
+ DataTypeUtility.GetToInt32(drEstSum["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]);
dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]
= DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])])
+ DataTypeUtility.GetToInt32(drEstSum["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]);
}
}
}
}
UltraWebGrid1.DataSource = dataDept;
UltraWebGrid1.DataBind();
//GridView1.DataSource = dataDept;
//GridView1.DataBind();
}
