private void DoBinding_TgtEmp()
{
DataTable DT = bizMulEstTargetPool.Get_MulTgtEmp_List(COMP_ID, DEPT_REF_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID);
UltraWebGrid2.DataSource = DT;
UltraWebGrid2.DataBind();
}
private void DataBindingMenuRole(int menu_ref_id)
{
RoleInfos role = new RoleInfos();
UltraWebGrid2.DataSource = role.GetMenuRoles(menu_ref_id);
UltraWebGrid2.DataBind();
}
protected void doBind_prjEmp()
{
UltraWebGrid2.Clear();
MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0);
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
string est_id = "3Q";//프로젝트 기여도 평가 EST_ID
DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID
, COMP_ID
, est_id
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1");
object point = dtPrj_PM_Data.Rows[0]["POINT"];
PRJ_POINT = DataTypeUtility.GetString(point);
UltraWebGrid2.DataSource = DT_PRJ_DATA;
UltraWebGrid2.DataBind();
}
private void DoBinding_Emp(int dept_ref_id)
{
DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID = {0} ", dept_ref_id), " EMP_NAME ");
UltraWebGrid2.DataSource = dtDeptEmp;
UltraWebGrid2.DataBind();
//if (rdoEstTypeList.SelectedIndex.Equals(0))
//{
// MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();
//}
//else
//{
//}
if (dtDeptEmp.Rows.Count > 0)
{
ibnEmp.Enabled = true;
}
else
{
ibnEmp.Enabled = false;
}
}
private void DataLoad()
{
ApprovalLines app = new ApprovalLines();
UltraWebGrid2.DataSource = app.GetApprovalLine(biz_type_code, EmpID);
UltraWebGrid2.DataBind();
}
private void DataBindingRole()
{
Biz_RoleInfos role = new Biz_RoleInfos();
UltraWebGrid2.DataSource = role.GetRoleInfos();
UltraWebGrid2.DataBind();
}
private void Reload()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
DataBindingUnitType();
DataBindingUnit(hdfUnitGroup.Value);
txtUnitGroup.Text = "";
}
private void DataBindingUnit(string unit_type)
{
UnitTypeInfos unitInfo = new UnitTypeInfos(unit_type);
DataSet ds = unitInfo.GetAllUnitTypeInfo(unit_type);
UltraWebGrid2.DataSource = ds;
UltraWebGrid2.DataBind();
}
protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid3.Clear();
DoBinding_Dept();
}
private void DoBinding_InPower()
{
MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
DataTable dtNHIT = bizNHIT.GetInPower(CR_YEAR);
UltraWebGrid2.DataSource = dtNHIT;
UltraWebGrid2.DataBind();
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
UltraWebGrid2.Clear();
string TGT_DEPT_ID = e.SelectedRows[0].Cells.FromKey("TGT_DEPT_ID").Value.ToString();
DoBinding_Emp(TGT_DEPT_ID);
}
private void BindingPosBiz(string pos_knd_id)
{
Biz_PositionKindBizMaps posKndBiz = new Biz_PositionKindBizMaps();
DataSet ds = posKndBiz.GetPosKndBizMap(pos_knd_id, "");
UltraWebGrid2.DataSource = ds;
UltraWebGrid2.DataBind();
}
private void KndBizMapGridBinding()
{
Biz_PositionKindBizMaps maps = new Biz_PositionKindBizMaps();
DataSet ds = maps.GetPosKndBizMaps();
UltraWebGrid2.DataSource = ds;
UltraWebGrid2.DataBind();
}
protected void Project_Detail_Bind()
{
object StartDate = this.prj_sDate.Value;
object EndDate = this.prj_eDate.Value;
DataTable DT = bizPmsInfo.Get_Project_Detail(PRJ_ID, (DateTime)StartDate, (DateTime)EndDate);
UltraWebGrid2.DataSource = DT;
UltraWebGrid2.DataBind();
}
private void DetailGridBinding(string pos_id)
{
Biz_Positions positions = new Biz_Positions("EST_POSITION_" + pos_id, pos_id);
DataSet ds = positions.GetPositions();
UltraWebGrid2.DataSource = ds;
UltraWebGrid2.DataBind();
InitForm();
}
private void BindQuestionGrid()
{
Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps();
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, "");
UltraWebGrid1.DataBind();
}
// 평가단계별 등급코드를 가져온다
private void BindThresholdStepList()
{
Biz_Bsc_Threshold_Step biz = new Biz_Bsc_Threshold_Step();
string strLevel = GetValue(ddlLevel.SelectedValue);
DataSet ds = biz.GetThresholdLevelList(strLevel);
UltraWebGrid2.DataSource = ds;
UltraWebGrid2.DataBind();
}
protected void ibnEmp_Click(object sender, ImageClickEventArgs e)
{
int cnt = UltraWebGrid2.Rows.Count;
string emp_ref_id_list = string.Empty;
for (int i = 0; i < cnt; i++)
{
UltraGridRow row = UltraWebGrid2.Rows[i];
TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked)
{
emp_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("EMP_REF_ID").Value);
}
}
DataTable dtEmp = new DataTable();
if (emp_ref_id_list.Length > 0)
{
emp_ref_id_list = emp_ref_id_list.Remove(0, 1);
dtEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EMP_REF_ID IN ({0}) ", emp_ref_id_list));
}
DataTable dtDelEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID IN ({0}) ", DEPT_REF_ID));
MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp BizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();
string okMsg = BizMulEstEmp.AddEstEmp(dtDelEmp
, dtEmp
, COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, rdoEstTypeList.SelectedValue
, DateTime.Now
, this.gUserInfo.Emp_Ref_ID);
if (okMsg.Length == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false);
DoBinding_Dept();
DEPT_REF_ID = -1;
UltraWebGrid2.Clear();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(okMsg);
}
}
protected void iBtnSearch_Click(object sender, ImageClickEventArgs e)
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid2.Bands[0].ResetColumns();
UltraWebGrid3.Clear();
this.TxtBox_Soosik.Text = "";
Project_Bind();
}
private void DoBinding_Emp(string TGT_DEPT_ID)
{
UltraWebGrid2.Clear();
Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data();
DataTable DT = bizMulEstData.Get_Est_Status_By_Emp(hdfEstID.Value, ESTTERM_REF_ID.ToString(), ESTTERM_SUB_ID.ToString(), TGT_DEPT_ID);
UltraWebGrid2.DataSource = DT;
UltraWebGrid2.DataBind();
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
UltraWebGrid2.Clear();
UltraWebGrid2.Bands[0].ResetColumns();
PRJ_ID = e.SelectedRows[0].Cells.FromKey("PROJECTID").Value.ToString();
Project_Detail_Bind();
Custom_Col_Bind();
Soosik_Bind();
}
private void BindingCommandNameRoleMap(int role_ref_id)
{
Biz_ButtonCommandRoleMaps btnCmdRoleMap = new Biz_ButtonCommandRoleMaps();
_dtButtonCommandRole = btnCmdRoleMap.GetButtonCommandRoleMap(role_ref_id, "").Tables[0];
Biz_ButtonCommandInfos btnCmdInfo = new Biz_ButtonCommandInfos();
UltraWebGrid2.DataSource = btnCmdInfo.GetButtonCommandInfos();
UltraWebGrid2.DataBind();
}
protected void ibnSearchAll_Click(object sender, ImageClickEventArgs e)
{
EST_EMP_ID = 0;
BindingPosBizByTgt();
BindingTgtEmp(EST_EMP_ID);
hdfTgtEmpID.Value = "";
hdfTgtPosKndID.Value = "";
UltraWebGrid2.Clear();
}
private void DataBindingFamily(string sabun)
{
string query = @"SELECT FAMILY.EMP_SABUN_T,
FAMILY.EMP_RELATION, -- 관계
FAMILY.EMP_NAME, -- 가족 명
FAMILY.EMP_BRTH_DATE, -- 생년월일
FAMILY.EMP_JOB -- 직업
FROM SEM_EMPLOYEE_FAMILY FAMILY
WHERE FAMILY.EMP_SABUN_T = '" + sabun + @"'";
UltraWebGrid2.DataSource = GetDataSet(query);
UltraWebGrid2.DataBind();
}
private void BindEstJob(int comp_id, string est_id)
{
if (!est_id.Equals(""))
{
Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps();
_dtEstJobMap = jobEstMap.GetJobEstMap(comp_id, est_id, "").Tables[0];
}
Biz_JobInfos jobInfo = new Biz_JobInfos();
UltraWebGrid2.DataSource = jobInfo.GetJobInfos("N");
UltraWebGrid2.DataBind();
}
private void GridBinding2(int comp_id, int estterm_ref_id, string est_id)
{
Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();
_dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
_dtPosScale = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0];
UltraWebGrid2.Clear();
UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" ");
UltraWebGrid2.DataBind();
}
private void DoBinding_Emp(string cr_year, string cr_month, string project_name)
{
UltraWebGrid2.Clear();
MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
DataTable dtNHIT = bizNHIT.GetEmpProjectDetail(cr_year
, cr_month
, project_name);
UltraWebGrid2.DataSource = dtNHIT;
UltraWebGrid2.DataBind();
lblEmpTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count);
}
private void SetGrid2()
{
UltraWebGrid2.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score();
DataTable dtObj = bizObj.GetOrgRankBonbuDesc(IEstTermRefID, IYmd, "4", "TS", 5);
if (dtObj.Rows.Count > 0)
{
UltraWebGrid2.DataSource = dtObj;
UltraWebGrid2.DataBind();
}
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
UltraWebGrid2.Clear();
UltraWebGrid3.Clear();
if (e.SelectedRows.Count > 0)
{
string dept_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("DEPT_NAME").Value);
lblTitleDept.Text = string.Format("({0})", dept_name);
DEPT_REF_ID = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("DEPT_REF_ID").Value);
DoBinding_Emp(DEPT_REF_ID);
}
}
protected void doBind_project()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
string est_id = "3Q";
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
this.lblRowCount.Text = DT_ENDED_PRJ.Rows.Count.ToString();
UltraWebGrid1.DataSource = DT_ENDED_PRJ;
UltraWebGrid1.DataBind();
}
