private void DoBinding_EstEmp() { DataTable DT = bizMulEstTargetPool.Get_MulEstEmp_List(COMP_ID, EMP_REF_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID); UltraWebGrid3.DataSource = DT; UltraWebGrid3.DataBind(); }
private void DoBinding_EST(int est_emp_id) { DataTable dtEST = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_EMP_ID = {0} ", est_emp_id), " EST_DEPT_NAME, EST_EMP_NAME "); UltraWebGrid3.DataSource = dtEST; UltraWebGrid3.DataBind(); }
private void DoBinding_ETC() { MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT_B = bizNHIT.GetEtc(GRP_ONE_ID.B.ToString() , CR_YEAR , CR_MONTH , "T"); UltraWebGrid3.DataSource = dtNHIT_B; UltraWebGrid3.DataBind(); DoDrawingEtcChart(dtNHIT_B, chart3, 4); DataTable dtNHIT_C = bizNHIT.GetEtc(GRP_ONE_ID.C.ToString() , CR_YEAR , CR_MONTH , "T"); UltraWebGrid4.DataSource = dtNHIT_C; UltraWebGrid4.DataBind(); DoDrawingEtcChart(dtNHIT_C, chart4, 17); DataTable dtNHIT_D = bizNHIT.GetEtc(GRP_ONE_ID.D.ToString() , CR_YEAR , CR_MONTH , "T"); UltraWebGrid5.DataSource = dtNHIT_D; UltraWebGrid5.DataBind(); DoDrawingEtcChart(dtNHIT_D, chart5, 13); }
private void DoBinding_ETC() { MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT_B = bizNHIT.GetEtc(GRP_ONE_ID.B.ToString() , CR_YEAR , CR_MONTH , TG_GUBUN); UltraWebGrid3.DataSource = dtNHIT_B; UltraWebGrid3.DataBind(); DataTable dtNHIT_C = bizNHIT.GetEtc(GRP_ONE_ID.C.ToString() , CR_YEAR , CR_MONTH , TG_GUBUN); UltraWebGrid4.DataSource = dtNHIT_C; UltraWebGrid4.DataBind(); DataTable dtNHIT_D = bizNHIT.GetEtc(GRP_ONE_ID.D.ToString() , CR_YEAR , CR_MONTH , TG_GUBUN); UltraWebGrid5.DataSource = dtNHIT_D; UltraWebGrid5.DataBind(); }
protected void Custom_Col_Bind() { DataTable DT = bizPmsColInfo.Get_Custom_Col_List(PRJ_ID); UltraWebGrid3.DataSource = DT; UltraWebGrid3.DataBind(); }
private void SelectBizGridBinding(string pos_knd_id) { Biz_PositionBizs positionBizs = new Biz_PositionBizs(); DataSet ds = positionBizs.GetPositionBizs(); UltraWebGrid3.DataSource = ds; UltraWebGrid3.DataBind(); }
protected void ibnSearch_Click(object sender, ImageClickEventArgs e) { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); DoBinding_Dept(); }
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 DataBindingSchool(string sabun) { string query = @"SELECT SCHOOL.EMP_ENTER_DATE, -- 입학년월 SCHOOL.EMP_GRADUATE_DATE, -- 졸업년월 SCHOOL.EMP_SCHOOL, -- 최종학교 SCHOOL.EMP_STUDY -- 전공 FROM SEM_EMPLOYEE_SCHOOL SCHOOL WHERE SCHOOL.EMP_SABUN_T = '" + sabun + @"'"; UltraWebGrid3.DataSource = GetDataSet(query); UltraWebGrid3.DataBind(); }
protected void lbnSavePOS_Click(object sender, EventArgs e) { Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); Biz_DeptInfos deptInfo = new Biz_DeptInfos(); DataTable dataTable = deptPosScale.GetDataTableSchema(); DataTable dtDept = deptInfo.GetDataTableSchema(); DataRow drRow = null; string[] dept_values = hdfDeptID.Value.Split(','); dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3 , new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" } , dataTable); foreach (string dept_value in dept_values) { drRow = dtDept.NewRow(); drRow["DEPT_REF_ID"] = DataTypeUtility.GetToInt32(dept_value); dtDept.Rows.Add(drRow); } if (dataTable.Rows.Count == 0) { ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다."); return; } foreach (DataRow dataRow in dataTable.Rows) { dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("선택부서의 평가방법을 일괄 적용하였습니다."); GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID); UltraWebGrid3.Clear(); hdfDeptID.Value = ""; } else { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다."); } }
private void SetGrid3() { UltraWebGrid3.Clear(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score(); DataTable dtObj = bizObj.GetOrgRankBonbuAsc(IEstTermRefID, IYmd, "4", "TS", 5); if (dtObj.Rows.Count > 0) { UltraWebGrid3.DataSource = dtObj; UltraWebGrid3.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); } }
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(); }
protected void ibnDelPool_Click(object sender, ImageClickEventArgs e) { UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); if (doDelete_Est_Target_Pool()) { this.ltrScript.Text = JSHelper.GetAlertScript("삭제하였습니다."); } else { this.ltrScript.Text = JSHelper.GetAlertScript("실패했습니다."); } DoBinding_Dept(); }
protected void ibnSavePool_Click(object sender, ImageClickEventArgs e) { if (doSave_Est_Target_Pool()) { this.ltrScript.Text = JSHelper.GetAlertScript("저장하였습니다."); } else { this.ltrScript.Text = JSHelper.GetAlertScript("실패했습니다."); } UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); DoBinding_Dept(); }
protected void ibnInit2_Click(object sender, ImageClickEventArgs e) { Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); Biz_DeptInfos deptInfo = new Biz_DeptInfos(); DataTable dataTable = deptPosScale.GetDataTableSchema(); DataTable dtDept = deptInfo.GetDataTableSchema(); dtDept.Columns.Add("COMP_ID", typeof(int)); dtDept.Columns.Add("EST_ID", typeof(string)); dtDept.Columns.Add("ESTTERM_REF_ID", typeof(int)); dtDept = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2 , "cBox" , "selchk" , new string[] { "DEPT_REF_ID" } , dtDept); if (dtDept.Rows.Count == 0) { ltrScript.Text = JSHelper.GetAlertScript("초기화하려는 부서를 선택하세요."); return; } foreach (DataRow dataRow in dtDept.Rows) { dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID; } bool isOK = deptPosScale.InitDept(dtDept); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 선택부서를 초기화 하였습니다."); GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID); UltraWebGrid3.Clear(); } else { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리되지 않았습니다."); } }
protected void ibnSavePosAll_Click(object sender, ImageClickEventArgs e) { Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); Biz_DeptInfos deptInfo = new Biz_DeptInfos(); DataTable dataTable = deptPosScale.GetDataTableSchema(); DataTable dtDept = deptInfo.GetDataTableSchema(); dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3 , new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" } , dataTable); dtDept = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2 , new string[] { "DEPT_REF_ID" } , dtDept); if (dataTable.Rows.Count == 0) { ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다."); return; } foreach (DataRow dataRow in dataTable.Rows) { dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("모든 부서의 평가방법을 일괄 적용하였습니다."); GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID); UltraWebGrid3.Clear(); } else { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다."); } }
protected void Page_Load(object sender, System.EventArgs e) { Session.LCID = 1033; elt_account_number = Request.Cookies["CurrentUserInfo"]["elt_account_number"]; user_id = Request.Cookies["CurrentUserInfo"]["user_id"]; user_right = Request.Cookies["CurrentUserInfo"]["user_right"]; login_name = Request.Cookies["CurrentUserInfo"]["login_name"]; if (Session["Accounting_sPeriod"] == null) { Response.Redirect("./GLSelection.aspx?parm=bal"); } if (login_name == "imoon") { this.TextBox1.Width = new Unit("100px"); this.TextBox2.Width = new Unit("100px"); } if (!IsPostBack) { ViewState["Count"] = 1; if (Request.UrlReferrer == null) { Response.Redirect(ParentPage); } else { ViewState["Parent"] = Request.UrlReferrer.ToString(); } PerformSearch(); PerformDataBind(); } else { ViewState["Count"] = (int)ViewState["Count"] + 1; } UltraWebGrid1.ExpandAll(true); UltraWebGrid2.ExpandAll(true); UltraWebGrid3.ExpandAll(true); }
private void PerformDataBind() { UltraWebGrid1.DataSource = ds.Tables["HEAD"].DefaultView; UltraWebGrid2.DataSource = ds_AS.Tables["HEAD"].DefaultView; UltraWebGrid3.DataSource = ds_LE.Tables["HEAD"].DefaultView; UltraWebGrid1.DataBind(); UltraWebGrid2.DataBind(); UltraWebGrid3.DataBind(); if (UltraWebGrid1.Rows.Count < 1) { lblNoData.Text = "No Data was found!"; lblNoData.Visible = true; } else { UltraWebGrid1.Visible = false; lblNoData.Visible = false; } }
private void DoBinding_Dept() { MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); DT_EST_DATA = bizEstData.GetEstData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ConESTTERM_STEP_ID , ConDIRECTION_TYPE); DEPT_REF_ID = -1; UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizEmpEstTargetMaps = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map(); DT_ESTTARGETMAP = bizEmpEstTargetMaps.GetEmpEstTargetMap(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ConESTTERM_STEP_ID , 0 , 0 , 0 , 0).Tables[0]; string[] groupBy = { "TGT_DEPT_ID" , "TGT_DEPT_NAME" , "TGT_EMP_ID" , "TGT_EMP_NAME" , "TGT_POS_CLS_ID" , "TGT_POS_CLS_NAME" , "TGT_POS_DUT_ID" , "TGT_POS_DUT_NAME" , "TGT_POS_GRP_ID" , "TGT_POS_GRP_NAME" , "TGT_POS_RNK_ID" , "TGT_POS_RNK_NAME" , "TGT_POS_KND_ID" , "TGT_POS_KND_NAME" , "DIRECTION_TYPE" }; DataTable dtEst = DT_ESTTARGETMAP.Copy(); DataTable dtTgt = DT_ESTTARGETMAP.Copy(); DT_ESTTARGETMAP_GROUPBYEST = DataTypeUtility.GetGroupByDataTable(dtEst, groupBy); DT_ESTTARGETMAP_GROUPBYTGT = DataTypeUtility.GetGroupByDataTable(dtTgt, new string[] { "EST_DEPT_ID", "EST_EMP_ID", "DIRECTION_TYPE" }); MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); DataTable dtMulEstEmp = bizMulEstEmp.GetDeptMapping_DB(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID); // 평가자 목록 (EST_TYPE : EST) /* * DT_ESTEMP = bizMulEstEmp.GetEstEmp_DB(COMP_ID * , EST_ID * , ESTTERM_REF_ID * , ESTTERM_SUB_ID * , 0 * , ""); */ MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp bizRelDeptEmp = new MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp(); DT_DEPTEMP = bizRelDeptEmp.GetRelDeptEmp_DB(0 , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID); DT_DEPTEMP.Columns.Add("TGT_DEPT_ID"); DT_DEPTEMP.Columns.Add("TGT_EMP_ID"); DT_DEPTEMP.Columns.Add("TGT_EMP_NAME"); DT_DEPTEMP.Columns.Add("TGT_CLASS_CODE"); DT_DEPTEMP.Columns.Add("TGT_CLS_NAME"); DT_DEPTEMP.Columns.Add("TGT_GRP_CODE"); DT_DEPTEMP.Columns.Add("TGT_GRP_NAME"); DT_DEPTEMP.Columns.Add("TGT_RANK_CODE"); DT_DEPTEMP.Columns.Add("TGT_RANK_NAME"); DT_DEPTEMP.Columns.Add("TGT_DUTY_CODE"); DT_DEPTEMP.Columns.Add("TGT_DUT_NAME"); DT_DEPTEMP.Columns.Add("TGT_KIND_CODE"); DT_DEPTEMP.Columns.Add("TGT_KND_NAME"); //랜덤 지정/해제 버튼 보이기 상태 setRndButtonVisible(); //매핑 확정/취소 버튼 보이기상태 if (CheckPossiblityCancelConfirm()) { ibnAddEstData.Visible = true; ibnDelEstData.Visible = true; } else { ibnAddEstData.Visible = false; ibnDelEstData.Visible = false; } //바인드 UltraWebGrid1.DataSource = dtMulEstEmp; UltraWebGrid1.DataBind(); if (dtMulEstEmp.Rows.Count > 0) { ibnRandom.Enabled = true; ibnDelRandom.Enabled = true; } else { ibnRandom.Enabled = false; ibnDelRandom.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { try { svcSCPPHH.SCPP_HHClient d = new svcSCPPHH.SCPP_HHClient(); BC.SCPP_HH bc = new BC.SCPP_HH(); DataSet ds = new DataSet();//d.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today); //DataSet ds = bc.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today); //List<DataSet> lds = d.SyncServHHLDS(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today); //List<StringReader[]> lxmlDS = bc.SyncServHH(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today); //DataSet beRes = new DataSet(); //List<DataSet> lds = new List<DataSet>(); //foreach (StringReader[] xmlSR in lxmlDS) //{ // beRes.Clear(); // beRes = new DataSet(); // beRes.ReadXmlSchema(xmlSR[0]); // beRes.ReadXml(xmlSR[1], XmlReadMode.Auto); // lds.Add(beRes); //} //DataTable dt = d.TablasCatalogosHH(); DataTable dt = null; try { dt = d.Login("a", "a"); } catch { } try { dt = d.ObtenerSupervisorPorDefecto(42); } catch { } DataSet xmlDS = new DataSet(); DataSet ds2 = new DataSet(); try { StringReader xmlSchema = new StringReader(ds.GetXmlSchema().ToString()); StringReader xmlInfo = new StringReader(ds.GetXml().ToString()); StringReader[] xmlDataSet = { xmlSchema, xmlInfo }; ds2.ReadXmlSchema(xmlDataSet[0]); ds2.ReadXml(xmlDataSet[1], XmlReadMode.Auto); } catch { } if (ds2.Tables.Count > 0) { UltraWebGrid1.DataSource = ds2.Tables[0]; String tableName = ds2.Tables[1].TableName.Substring(3).ToString(); ObtenerUpdate(ds2.Tables[1], tableName); UltraWebGrid2.DataSource = ds2.Tables[1]; UltraWebGrid3.DataSource = ds2.Tables[2]; } int i = d.ActualizarColorPieza(21, 3); UltraWebGrid1.DataBind(); UltraWebGrid2.DataBind(); UltraWebGrid3.DataBind(); } catch (Exception er) { CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('" + er.Message.Replace("'", "\"") + "');</script>"); Console.Write("Error:" + er.Message); } }
protected void ibnPMS_IF_Click(object sender, EventArgs e) { int Pms_Com_Info_Idx = 1; bool Result; object start_date = prj_sDate.Value; object end_date = prj_eDate.Value; DataTable dtPrj_ID = bizPmsInfo.Get_Vw_ProjectID((DateTime)start_date, (DateTime)end_date); dtPrj_ID = DataTypeUtility.FilterSortDataTable(dtPrj_ID, " STATUS_ID IS NULL"); Result = bizPmsColInfo.Sync_Col_Info(Pms_Com_Info_Idx, dtPrj_ID, gUserInfo.Emp_Ref_ID.ToString()); if (Result) { /* * for (int i = 0; i < dtPrj_ID.Rows.Count; i++) * { * string prj_id = dtPrj_ID.Rows[i]["PROJECTID"].ToString(); * * DataTable dtColList = bizPmsColInfo.Get_Col_Info_List(prj_id); * System.Text.StringBuilder colList = new StringBuilder(); * for (int j = 0; j < dtColList.Rows.Count; j++) * { * if (colList.Length > 0) * colList.Append(", "); * colList.Append(dtColList.Rows[j]["PRJ_COL_ID"].ToString()); * } * Result = bizPmsInfo.Add_Project_Info_To_Pms((DateTime)start_date, (DateTime)end_date, prj_id, colList.ToString()); * * if (!Result) * break; * } */ DataTable dtComInfo = bizPmsComInfo.Get_Pms_Com_Info(Pms_Com_Info_Idx); string srcIF_COL_ID = dtComInfo.Rows[0]["IF_COL_ID"].ToString(); string tgtIF_COL_ID = ""; string tmpIF_COL_ID; string[] arrIF_COL_ID = bizPmsColInfo.Remove_Escape_Blank_Char(srcIF_COL_ID).Split(','); for (int i = 0; i < arrIF_COL_ID.Length; i++) { string col_type = bizPmsColInfo.Proc_Col_Type(arrIF_COL_ID[i]); if (col_type.Equals("B")) { tmpIF_COL_ID = arrIF_COL_ID[i]; } else { tmpIF_COL_ID = arrIF_COL_ID[i].Substring(0, arrIF_COL_ID[i].IndexOf("(")); } if (tgtIF_COL_ID.Length > 0) { tgtIF_COL_ID += ", "; } tgtIF_COL_ID += tmpIF_COL_ID; } string prj_id_list = ""; for (int i = 0; i < dtPrj_ID.Rows.Count; i++) { if (prj_id_list.Length > 0) { prj_id_list += ", "; } prj_id_list += "'" + dtPrj_ID.Rows[i]["PROJECTID"].ToString() + "'"; } Result = bizPmsInfo.Add_Project_Info_To_Pms((DateTime)start_date, (DateTime)end_date, prj_id_list, tgtIF_COL_ID); } if (Result) { this.ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다."); } else { this.ltrScript.Text = JSHelper.GetAlertScript("저장에 실패하였습니다."); } UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid2.Bands[0].ResetColumns(); UltraWebGrid3.Clear(); this.TxtBox_Soosik.Text = ""; Project_Bind(); }