private void setTopList() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_TotalStateMngList_Top_SELECT"; try { DataSet ds = db.ProcedureToDataSet(); lueChannel.Properties.ValueMember = "코드"; lueChannel.Properties.DisplayMember = "경로"; lueChannel.Properties.DataSource = ds.Tables[1]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } DataTable dt_DateGubun_Detail = new DataTable(); dt_DateGubun_Detail.Columns.Add("코드구분"); dt_DateGubun_Detail.Columns.Add("코드명"); dt_DateGubun_Detail.Rows.Add("", "전체"); dt_DateGubun_Detail.Rows.Add("미확인", "미확인"); dt_DateGubun_Detail.Rows.Add("확인", "확인"); dt_DateGubun_Detail.Rows.Add("고객접촉완료", "고객접촉완료"); dt_DateGubun_Detail.Rows.Add("처리완료", "처리완료"); dt_DateGubun_Detail.Rows.Add("미처리전체", "미처리전체"); lueProcState.Properties.ValueMember = "코드구분"; lueProcState.Properties.DisplayMember = "코드명"; lueProcState.Properties.DataSource = dt_DateGubun_Detail; }
/// <summary> /// 조회 버튼 클릭 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATELIST_SELECT"; db.Procedure.ParamAdd("@RecvStartDate", deStart_Date.Text.Replace("-", "").Replace("-", "")); db.Procedure.ParamAdd("@RecvEndDate", deEnd_Date.Text.Replace("-", "").Replace("-", "")); db.Procedure.ParamAdd("@DeptCode", luePro_Dept.EditValue == null ? "" : luePro_Dept.EditValue); db.Procedure.ParamAdd("@UserID", luePro_User.EditValue == null ? "" : luePro_User.EditValue); db.Procedure.ParamAdd("@Industry", lueWork_Gubun.EditValue == null ? "" : lueWork_Gubun.EditValue); db.Procedure.ParamAdd("@DeptCode_Login", strDeptCode); db.Procedure.ParamAdd("@Category", lue_BigCate.EditValue == null ? "" : lue_BigCate.EditValue); db.Procedure.ParamAdd("@DelayTime", lueDelayTime.EditValue == null ? "" : lueDelayTime.EditValue); try { this.Cursor = Cursors.WaitCursor; DateTime de = DateTime.Now; DataSet ds = db.ProcedureToDataSetCompress(); DateTime de1 = DateTime.Now; //ds.Tables[0].Rows.Count(); this.Cursor = Cursors.Default; MessageBox.Show(de.TimeOfDay.ToString() + "/" + de1.TimeOfDay.ToString() + "/" + ds.Tables[1].Rows[0][1].ToString()); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { //XtraMessageBox.Show("조회할 항목이 없습니다."); return; } dt_Work = ds.Tables[0]; gcStateList.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void setLueBugsEquip() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORY_BUGEQUIP_SELECT"; try { DataSet ds = db.ProcedureToDataSet(); lueBugs.Properties.ValueMember = "코드"; lueBugs.Properties.DisplayMember = "선택"; lueBugs_S.Properties.ValueMember = "코드"; lueBugs_S.Properties.DisplayMember = "선택"; lueEquip.Properties.ValueMember = "코드"; lueEquip.Properties.DisplayMember = "선택"; if (ds.Tables[0].Rows.Count > 0) { lueEquip.Properties.DataSource = ds.Tables[0]; } if (ds.Tables[1].Rows.Count > 0) { lueBugs.Properties.DataSource = ds.Tables[1]; } if (ds.Tables[2].Rows.Count > 0) { lueBugs_S.Properties.DataSource = ds.Tables[2]; } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void setUserGubun() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_USERGUBUN"; db.Procedure.ParamAdd("@USERID", strUserID); try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { return; } else { if (ds.Tables[0].Rows[0][0].ToString() == "Y") { lueDistr_Work_Dept.Properties.ReadOnly = true; lueDistr_Work_User.Properties.ReadOnly = true; btnSave_Dist.Enabled = true; } else { lueDistr_Work_Dept.Properties.ReadOnly = true; lueDistr_Work_User.Properties.ReadOnly = true; btnSave_Dist.Enabled = false; } } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void setBigList() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_TotalStateCate_Big_SELECT_MULTI"; // "CESCOEIS.dbo.SP_VOC_TotalStateCate_Big_SELECT_TEMP"; db.Procedure.ParamAdd("@DATE_FROM", deDate_From.Text.Replace("-", "")); db.Procedure.ParamAdd("@DATE_TO", deDate_To.Text.Replace("-", "")); db.Procedure.ParamAdd("@DEPTCODE", lueDept.EditValue); db.Procedure.ParamAdd("@PROBLEMYN", rgVOC_A.Checked == true ? "A" : "P"); db.Procedure.ParamAdd("@PROBLEMLV", rgVOC_A.Checked == true ? "" : lue_ProblemLv.EditValue.ToString()); try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { gcbigList.DataSource = null; return; } gvbigList.Columns.Clear(); gcbigList.DataSource = ds.Tables[0]; gvbigList.BestFitColumns(); gvbigList.OptionsView.ColumnAutoWidth = false; gvbigList.Columns[1].Caption = "대분류"; gvbigList.Columns[0].Visible = false; gvbigList.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; gvbigList.Columns[1].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; gvbigList.Columns[1].Width = 200; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void btnSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { Cesco.FW.Global.DBAdapter.DBAdapters dbA = new Cesco.FW.Global.DBAdapter.DBAdapters(); dbA.LocalInfo = new Cesco.FW.Global.DBAdapter.LocalInfo(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); dbA.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CurrentState_SELECT_MULTI"; //SP_VOC_CurrentState_SELECT_MULTI 다중처리자 적용 프로시저 dbA.Procedure.ParamAdd("@From", dtFrom.DateTime.ToString("yyyyMMdd")); dbA.Procedure.ParamAdd("@To", dtTo.DateTime.ToString("yyyyMMdd")); dbA.Procedure.ParamAdd("@DeptCode", luePro_Dept.EditValue.ToString()); dbA.Procedure.ParamAdd("@UserID", luePro_User.EditValue.ToString()); dbA.Procedure.ParamAdd("@PartCode", luePro_Part.EditValue == null ? "" : luePro_Part.EditValue.ToString()); Cesco.FW.Global.DBAdapter.Utils.DebugingTools debug = new Cesco.FW.Global.DBAdapter.Utils.DebugingTools(); string sqlQuery = debug.GetExcuteSqlString(dbA.Procedure); this.Cursor = Cursors.WaitCursor; DataSet ds = dbA.ProcedureToDataSetCompress(); if (ds.Tables[0].Rows.Count > 0) { pv현황.RefreshData(); pv현황.DataSource = null; pv현황.DataSource = ds.Tables[0]; this.Cursor = Cursors.Default; } else { pv현황.RefreshData(); pv현황.DataSource = null; this.Cursor = Cursors.Default; } } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.ToString()); } }
/// <summary> /// 업종구분 LUE 세팅 /// </summary> private void setlueWork_Gubun() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_GUBUN_SELECT_SDH"; try { DataSet ds = db.ProcedureToDataSet(); lueWork_Gubun.Properties.ValueMember = "업종코드"; lueWork_Gubun.Properties.DisplayMember = "업종명"; lue_BigCate.Properties.ValueMember = "대분류코드"; lue_BigCate.Properties.DisplayMember = "대분류명"; //lueDelayTime.Properties.ValueMember = "지연시간"; //lueDelayTime.Properties.DisplayMember = "지연시간명"; lueProState.Properties.ValueMember = "코드구분"; lueProState.Properties.DisplayMember = "코드명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { return; } lueWork_Gubun.Properties.DataSource = ds.Tables[0]; lue_BigCate.Properties.DataSource = ds.Tables[1]; //lueDelayTime.Properties.DataSource = ds.Tables[2]; lueProState.Properties.DataSource = ds.Tables[5]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
//private void btnSMS2_Click(object sender, EventArgs e) //{ // sendSMS(lueDistr_Part_User.EditValue.ToString(), lueDistr_Part_Dept.EditValue.ToString(), teCustCode.Text); //} //private void btnSMS3_Click(object sender, EventArgs e) //{ // sendSMS(lueDistr_Team_User.EditValue.ToString(), lueDistr_Team_Dept.EditValue.ToString(), teCustCode.Text); //} #endregion private void btnSave_Dist_Click(object sender, EventArgs e) { if (luePro_State.EditValue.ToString() == "RY01") { MessageBox.Show("이미 처리완료된 접수입니다.", "변경 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Object ob_Roll; Cesco.FW.Global.DBAdapter.DBAdapters db_Roll = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db_Roll.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_USERGUBUN"; db_Roll.Procedure.ParamAdd("@USERID", strUserID); try { ob_Roll = db_Roll.ProcedureToScalar(); if (Convert.ToString(ob_Roll) == "N") { MessageBox.Show("팀장만 변경할 수 있습니다.", "변경 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } save1(); MessageBox.Show("처리담당자가 변경되었습니다.", "처리담당자 저장", MessageBoxButtons.OK, MessageBoxIcon.Information); return; }
private void setlueCategory_Big() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORY_LARGE2_SELECT"; try { DataSet ds = db.ProcedureToDataSet(); lueCategory_Big.Properties.ValueMember = "대분류VOCID"; lueCategory_Big.Properties.DisplayMember = "대분류명"; lueCategory_Big.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void save1() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_WORK_DISTR_SDH"; db.Procedure.ParamAdd("@WORK_USERID", lueDistr_Work_User2.EditValue); db.Procedure.ParamAdd("@WORK_DEPTCODE", lueDistr_Work_Dept2.EditValue); db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strVCNO); db.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); try { DataSet ds = db.ProcedureToDataSet(); } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
/// <summary> /// 부서 세팅 /// </summary> /// <param name="lueNm"></param> /// <param name="i"></param> /// <param name="paramValue"></param> /// <param name="valMem"></param> /// <param name="disMem"></param> private void setLue(LookUpEdit lueNm, int i, string paramValue, string valMem, string disMem) { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_ALL"; db.Procedure.ParamAdd("@부서코드", paramValue); if (strUserID == "15897" || strUserID == "18251" || strUserID == "18146") { db.Procedure.ParamAdd("@파트코드", ""); } else { db.Procedure.ParamAdd("@파트코드", i == 4 ? strOriPartCode.Replace(" ", "") : ""); } try { DataSet ds = db.ProcedureToDataSet(); lueNm.Properties.ValueMember = valMem; lueNm.Properties.DisplayMember = disMem; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } lueNm.Properties.DataSource = ds.Tables[i]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
public VOC_VoluntaryReport(string pUserID, string pCustCode, string pClaimNum) { InitializeComponent(); _strUserID = pUserID; _CustCode = pCustCode; _ClaimNum = pClaimNum; Cesco.FW.Global.DBAdapter.DBAdapters dbA = new Cesco.FW.Global.DBAdapter.DBAdapters(); dbA.LocalInfo = new Cesco.FW.Global.DBAdapter.LocalInfo(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); dbA.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_VoluntaryReport_SELECT"; dbA.Procedure.ParamAdd("@CustCode", _CustCode); dbA.Procedure.ParamAdd("@CLAIMNUM", _ClaimNum); Cesco.FW.Global.DBAdapter.Utils.DebugingTools debug = new Cesco.FW.Global.DBAdapter.Utils.DebugingTools(); string sqlQuery = debug.GetExcuteSqlString(dbA.Procedure); DataSet ds = dbA.ProcedureToDataSetCompress(); if (ds.Tables[0].Rows.Count > 0) { dt = ds.Tables[0]; txt고객코드.Text = ds.Tables[0].Rows[0]["CUSTCODE"].ToString(); txt대분류.Text = ds.Tables[0].Rows[0]["대분류"].ToString(); txt중분류.Text = ds.Tables[0].Rows[0]["중분류"].ToString(); txt클레임번호.Text = ds.Tables[0].Rows[0]["CLAIMNUM"].ToString(); } else { MessageBox.Show("Before Voice 건이 없습니다.", "확인", MessageBoxButtons.OK, MessageBoxIcon.Information); strYN = "N"; //this.Close(); //grd자진신고.DataSource = null; //strYN = "N"; } }
private void btnProcMemo1_Save_Click(object sender, EventArgs e) { string strProUser = string.Empty; string str직책코드 = string.Empty; string str직책코드_Log = string.Empty; Cesco.FW.Global.DBAdapter.DBAdapters db_Pro = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db_Pro.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_SMALLESSEN_PRO_CHECK_SDH"; db_Pro.Procedure.ParamAdd("@RegNum", strRegNum); db_Pro.Procedure.ParamAdd("@VCNO", strVCNO); db_Pro.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); db_Pro.Procedure.ParamAdd("@STAFFID", strUserID); try { DataSet ds = db_Pro.ProcedureToDataSet(); strProUser = ds.Tables[0].Rows[0]["처리사원"].ToString(); str직책코드 = ds.Tables[0].Rows[0]["직책코드"].ToString(); str직책코드_Log = ds.Tables[1].Rows[0]["직책코드"].ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (strUserID != strProUser) { if (str직책코드 != "B39" && str직책코드 != "B41" && str직책코드 != "B42" && str직책코드 != "B43" && str직책코드 != "B45") { MessageBox.Show("처리 담당자만 저장할 수 있습니다.", "저장 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (str직책코드_Log != "B39" && str직책코드_Log != "B41" && str직책코드_Log != "B42" && str직책코드_Log != "B43" && str직책코드_Log != "B45") { MessageBox.Show("처리 담당자만 저장할 수 있습니다.", "저장 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (mePro_Memo1.Text == "") { MessageBox.Show("처리내용은 필수 항목입니다.", "처리내용 미입력", MessageBoxButtons.OK, MessageBoxIcon.Information); mePro_Memo1.Focus(); return; } Cesco.FW.Global.DBAdapter.DBAdapters db2 = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db2.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_SMALLESSEN_CHECK_SDH"; db2.Procedure.ParamAdd("@RegNum", strRegNum); db2.Procedure.ParamAdd("@VCNO", strVCNO); db2.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); try { DataSet ds = db2.ProcedureToDataSet(); DataRow[] dRow_A = ds.Tables[0].Select("SUBCLASSESSEN = 'A'"); if (dRow_A.Length > 0) { string strMid = string.Empty; for (int i = 0; i < dRow_A.Length; i++) { strMid += dRow_A[i]["VOCNAME"].ToString(); if (i < dRow_A.Length - 1) { strMid += strMid + ", "; } } if (strDeptCode == "10220") { if (ds.Tables[1].Rows.Count < 1) { MessageBox.Show("중분류 [ " + strMid + " ] 는 소분류 선택이 필수인 항목입니다.", "소분류 선택", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } DataRow[] dRow_B = ds.Tables[0].Select("SUBCLASSESSEN = 'B'"); if (dRow_B.Length > 0) { string strMid = string.Empty; for (int i = 0; i < dRow_B.Length; i++) { strMid += dRow_B[i]["VOCNAME"].ToString(); if (i < dRow_B.Length - 1) { strMid += strMid + ", "; } } if (strUserID == strProUser) { if (ds.Tables[2].Rows.Count < 1) { MessageBox.Show("중분류 [ " + strMid + " ] 는 소분류 선택이 필수인 항목입니다.\n소분류를 선택해주세요.", "소분류 선택", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_PROCESS_SAVE_SDH"; db.Procedure.ParamAdd("@PROMEMO1", mePro_Memo1.Text); db.Procedure.ParamAdd("@PROUSER", strUserID); db.Procedure.ParamAdd("@PRODEPT", strDeptCode); db.Procedure.ParamAdd("@PROSTATE", luePro_State.EditValue.ToString()); db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strVCNO); db.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); try { DataSet ds = db.ProcedureToDataSet(); MessageBox.Show("저장되었습니다.", "저장 완료", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void VOC_TotalStateMng_Category_Load(object sender, EventArgs e) { setDate(); setDateGubun(); setlueDept(); setLueProb(); if (strGubun == "2") { lueDept.Enabled = false; if (strDept == "") { lueDept.EditValue = ""; } else { if (strDept.Substring(0, 1) == "5") { lueDept.EditValue = strDept; } else { setDeptNmCheck(); lueDept.EditValue = strDeptNm; } } lueDeptDetail.EditValue = strDeptDetail; lueDate_Gubun.EditValue = strDateGubun; lueGubun_Detail.EditValue = strGubun_Detail; deDate_From.EditValue = strDateFrom; deDate_To.EditValue = strDateTo; if (strrgVOC == "A") { rgVOC_A.Checked = true; rgVOC_P.Checked = false; } else { rgVOC_A.Checked = false; rgVOC_P.Checked = true; } lue_ProblemLv.EditValue = strVOC_Prob; } else { lueDeptDetail.EditValue = strDeptDetail; if (Convert.ToInt32(strDeptCode) >= 10280 && Convert.ToInt32(strDeptCode) < 50030) { //본부조회 Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_PARENT_SEARCH"; db.Procedure.ParamAdd("@DEPTCODE", strDeptCode); try { object ob = db.ProcedureToScalar(); lueDept.EditValue = ob; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } lueDeptDetail.EditValue = strDeptCode; lueDeptDetail.Enabled = false; } else if (Convert.ToInt32(strDeptCode) >= 51000 && Convert.ToInt32(strDeptCode) <= 59000) { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_Include"; db.Procedure.ParamAdd("@부서코드", strDeptCode); try { DataSet ds = db.ProcedureToDataSet(); lueDept.Properties.ValueMember = "부서코드"; lueDept.Properties.DisplayMember = "부서명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { // XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } lueDept.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } lueDept.EditValue = strDeptCode; lueDept.Enabled = true; } else { lueDept.Enabled = true; lueDeptDetail.Enabled = true; } } rgVOC1.EditValue = strrgVOC; // lue_ProblemLv.EditValue = strVOC_Prob; lueGubun_Detail.Enabled = false; barButtonItem1_ItemClick(null, null); gvbigList_FocusedRowChanged(null, null); //저장한 행 선택되어있도록 ColumnView view = (ColumnView)gcbigList.FocusedView; GridColumn column = view.Columns["VOCID"]; if (column != null) { int columnFound = view.LocateByDisplayText(0, column, strVOCID_BIG); if (columnFound != GridControl.InvalidRowHandle) { view.FocusedRowHandle = columnFound; } } if (strVOCID_MID != "") { //저장한 행 선택되어있도록 ColumnView view2 = (ColumnView)gcMidList.FocusedView; GridColumn column2 = view.Columns["VOCID"]; if (column2 != null) { int columnFound = view2.LocateByDisplayText(0, column2, strVOCID_MID); if (columnFound != GridControl.InvalidRowHandle) { view2.FocusedRowHandle = columnFound; } } } if (strVOCID_SM != "") { //저장한 행 선택되어있도록 ColumnView view3 = (ColumnView)gcSmList.FocusedView; GridColumn column3 = view.Columns["VOCID"]; if (column3 != null) { int columnFound = view3.LocateByDisplayText(0, column3, strVOCID_SM); if (columnFound != GridControl.InvalidRowHandle) { view3.FocusedRowHandle = columnFound; } } } }
private void getDTCustWork() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_PROCESS_SELECT_SDH_VER2"; db.Procedure.ParamAdd("@RegDate", strRegDate.Replace("-", "").Replace("-", "").Substring(0, 8)); db.Procedure.ParamAdd("@RegUser", strRegUser); db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strVCNO); db.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); db.Procedure.ParamAdd("@USERID", strUserID); try { DataSet ds = db.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 0) { teCustCode.Text = ds.Tables[0].Rows[0]["고객코드"].ToString(); teCustNm.Text = ds.Tables[0].Rows[0]["고객명"].ToString(); teCustAddr1.Text = ds.Tables[0].Rows[0]["주소1"].ToString(); teCustAddr2.Text = ds.Tables[0].Rows[0]["주소2"].ToString(); teCustMng_Dept.Text = ds.Tables[0].Rows[0]["고객담당부서명"].ToString(); teCustMng.Text = ds.Tables[0].Rows[0]["고객담당사원"].ToString(); teCustMngDept.Text = ds.Tables[0].Rows[0]["고객담당부서코드"].ToString(); teCustMngUser.Text = ds.Tables[0].Rows[0]["고객담당자"].ToString(); teCall_TellNum.Text = ds.Tables[0].Rows[0]["고객전화번호"].ToString(); teCall_CellNum.Text = ds.Tables[0].Rows[0]["고객휴대전화"].ToString(); teCate_ClaimNum.Text = ds.Tables[0].Rows[0]["클레임번호"].ToString(); lueCall_BigCate.EditValue = ds.Tables[0].Rows[0]["대분류"].ToString().Trim(); strOriPartCode = ds.Tables[0].Rows[0]["PartCode"].ToString(); lueDistr_Work_Dept.EditValue = ds.Tables[0].Rows[0]["처리부서"].ToString(); lueDistr_Work_User.EditValue = ds.Tables[0].Rows[0]["처리사원"].ToString(); teRecei_Dept.Text = ds.Tables[0].Rows[0]["접수사원부서명"].ToString(); teRecei_User.Text = ds.Tables[0].Rows[0]["접수사원명"].ToString(); teRecei_UserID.Text = ds.Tables[0].Rows[0]["접수사원"].ToString(); meReceiMemo.Text = ds.Tables[0].Rows[0]["접수내용"].ToString(); deRecei_Date.Text = ds.Tables[0].Rows[0]["접수일자"].ToString(); luePro_State.EditValue = ds.Tables[0].Rows[0]["처리여부코드"].ToString(); dePro_Date.Text = ds.Tables[0].Rows[0]["처리일자"].ToString(); tePro_OverTime.Text = ds.Tables[0].Rows[0]["대기시간"].ToString(); mePro_Memo1.Text = ds.Tables[0].Rows[0]["처리내용"].ToString(); lueDistr_Work_Dept2.EditValue = strDeptCode; lueDistr_Work_User2.EditValue = strUserID; if (strDeptCode == "10259" || strDeptCode == "10225" || strDeptCode == "10226" || strDeptCode == "10227" || strDeptCode == "10228") { lueDistr_Work_Dept2.Properties.ReadOnly = false; } else { lueDistr_Work_Dept2.Properties.ReadOnly = true; } //if (teCustCode.Text == "EO0521") //{ // btnDept.Visible = true; // btnStaff.Visible = true; //} } if (ds.Tables[1].Rows.Count > 0) { gc1.DataSource = ds.Tables[1]; } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void btnAuth_Add_Click(object sender, EventArgs e) { if (gcUserList.DataSource != null) { DataTable dt_UserList = gcUserList.DataSource as DataTable; //if (dt_UserList.Rows.Count > 0) //{ // MessageBox.Show("최대 한명만 지정할 수 있습니다.", "인원 초과", MessageBoxButtons.OK, MessageBoxIcon.Information); // teEmp.Text = ""; // return; //} } dtAuthAdd2 = gcUserList.DataSource as DataTable; dtAuthAdd = gcUserList.DataSource as DataTable; Cesco.FW.Global.DBAdapter.DBAdapters conn = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); conn.Procedure.ProcedureName = "ASSI.dbo.SP_CategoryMng_AuthMng_Category_AddUser"; conn.Procedure.ParamAdd("@UserNmID", teEmp.Text); DataSet ds = conn.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 1) { VOC_UserCheck UC = new VOC_UserCheck(teEmp.Text, gcUserList.DataSource as DataTable); UC.StartPosition = FormStartPosition.CenterParent; UC.ShowDialog(); if (UC.str_CheckedUserID == "") { teEmp.Text = ""; return; } if (dtAuthAdd == null) { dtAuthAdd = new DataTable("dtAuthAdd"); dtAuthAdd.Columns.Add("한글성명", Type.GetType("System.String")); dtAuthAdd.Columns.Add("사번", Type.GetType("System.String")); dtAuthAdd.Columns.Add("부서코드", Type.GetType("System.String")); dtAuthAdd.Columns.Add("부서명", Type.GetType("System.String")); } DataRow dRow = dtAuthAdd.NewRow(); dRow["한글성명"] = UC.str_CheckedUser; dRow["사번"] = UC.str_CheckedUserID; dRow["부서코드"] = UC.str_CheckedUserDeptCode; dRow["부서명"] = UC.str_CheckedUserDept; if (dtAuthAdd2 == null) { dtAuthAdd.Rows.Add(dRow); gcUserList.DataSource = dtAuthAdd; teEmp.Text = ""; } else { DataRow[] drows = dtAuthAdd2.Select(string.Format("사번 = '" + ds.Tables[0].Rows[0]["사번"].ToString() + "'")); //중복 검사 if (drows != null && drows.Length > 0) { dtAuthAdd2.Rows.Remove(drows[0]); } DataRow[] oDRDept = dtAuthAdd2.Select(string.Format("부서코드 = '" + ds.Tables[0].Rows[0]["부서코드"].ToString() + "'")); //중복 검사 //if (oDRDept != null && oDRDept.Length > 0) //{ // MessageBox.Show("부서에 1명만 존재가능합니다.", "조회 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} dtAuthAdd.Rows.Add(dRow); dtAuthAdd2.Merge(dtAuthAdd); gcUserList.DataSource = dtAuthAdd2; teEmp.Text = ""; } } else { if (ds.Tables[0].Rows.Count < 1 || ds == null) { MessageBox.Show("조회 가능한 직원이 없습니다.", "조회 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (dtAuthAdd == null) { dtAuthAdd = new DataTable("dtAuthAdd"); dtAuthAdd.Columns.Add("한글성명", Type.GetType("System.String")); dtAuthAdd.Columns.Add("사번", Type.GetType("System.String")); dtAuthAdd.Columns.Add("부서코드", Type.GetType("System.String")); dtAuthAdd.Columns.Add("부서명", Type.GetType("System.String")); } DataRow dRow = dtAuthAdd.NewRow(); dRow["한글성명"] = ds.Tables[0].Rows[0]["한글성명"].ToString(); dRow["사번"] = ds.Tables[0].Rows[0]["사번"].ToString(); dRow["부서코드"] = ds.Tables[0].Rows[0]["부서코드"].ToString(); dRow["부서명"] = ds.Tables[0].Rows[0]["부서명"].ToString(); if (dtAuthAdd2 == null) { dtAuthAdd.Rows.Add(dRow); gcUserList.DataSource = dtAuthAdd; } else { DataRow[] drows = dtAuthAdd2.Select(string.Format("사번 = '" + ds.Tables[0].Rows[0]["사번"].ToString() + "'")); //중복 검사 if (drows != null && drows.Length > 0) { dtAuthAdd2.Rows.Remove(drows[0]); } DataRow[] oDRDept = dtAuthAdd2.Select(string.Format("부서코드 = '" + ds.Tables[0].Rows[0]["부서코드"].ToString() + "'")); //중복 검사 //if (oDRDept != null && oDRDept.Length > 0) //{ // MessageBox.Show("부서에 1명만 존재가능합니다.", "조회 불가", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} dtAuthAdd.Rows.Add(dRow); dtAuthAdd2.Merge(dtAuthAdd); gcUserList.DataSource = dtAuthAdd2; } teEmp.Text = ""; } }
private void VOC_State_Load(object sender, EventArgs e) { setlueDept(); setlueWork_Gubun(); setDate(); setLue(); luePro_Dept.EditValue = strDeptCode; luePro_User.EditValue = strUserID; if (Convert.ToInt32(strDeptCode) >= 10280 && Convert.ToInt32(strDeptCode) < 50030) { strAuth = "D"; if (_cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B31" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B33") { //strAuth = "Y"; luePro_Dept.Enabled = false; luePro_User.Enabled = true; } else { luePro_Dept.Enabled = false; luePro_User.Enabled = false; } } else if (Convert.ToInt32(strDeptCode) >= 51000 && Convert.ToInt32(strDeptCode) <= 59000) { strAuth = "D"; Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_Include"; db.Procedure.ParamAdd("@부서코드", strDeptCode); try { DataSet ds = db.ProcedureToDataSet(); luePro_Dept.Properties.ValueMember = "부서코드"; luePro_Dept.Properties.DisplayMember = "부서명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { // XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } luePro_Dept.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } luePro_Dept.EditValue = strDeptCode; luePro_User.EditValue = strUserID; luePro_Dept.Enabled = true; luePro_User.Enabled = true; } else { strAuth = "H"; luePro_Dept.Enabled = true; luePro_User.Enabled = true; } }
private void VOC_TotalStatMng_List_Load(object sender, EventArgs e) { setDate(); setTopList(); setDateGubun(); setlueCategory_Big(); setlueDept(); setLueProb(); //if (strExcelAuth == "Y") // btnExcel.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; //else // btnExcel.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; if (strGubun == "A") { deDate_From.EditValue = strDateFrom; deDate_To.EditValue = strDateTo; lueProcState.EditValue = strStateCode; if (strDist_Proc != "") { lueDept.EditValue = strDist_Proc; } lueUser.EditValue = strUserID_Proc; if (strRgVOC == "A") { rgVOC_A.Checked = true; rgVOC_P.Checked = false; } else { rgVOC_A.Checked = false; rgVOC_P.Checked = true; lue_ProblemLv.EditValue = strVoc_Prob; } //lueDept.EditValue = strDist_Proc; setList(); } else { if (Convert.ToInt32(strDeptCode) >= 10280 && Convert.ToInt32(strDeptCode) < 50030) { strAuth = "D"; //if (_cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B31" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B33") //{ // //strAuth = "Y"; // lueDept.Enabled = false; // lueUser.Enabled = true; //} //else //{ lueDept.EditValue = strDeptCode; luePro_Part.EditValue = ""; lueUser.EditValue = strUserID; lueDept.Enabled = false; lueUser.Enabled = true; //} } else if (Convert.ToInt32(strDeptCode) >= 51000 && Convert.ToInt32(strDeptCode) <= 59000) { strAuth = "D"; Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_Include"; db.Procedure.ParamAdd("@부서코드", strDeptCode); try { DataSet ds = db.ProcedureToDataSet(); lueDept.Properties.ValueMember = "부서코드"; lueDept.Properties.DisplayMember = "부서명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { // XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } lueDept.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } lueDept.EditValue = strDeptCode; luePro_Part.EditValue = ""; lueUser.EditValue = strUserID; lueDept.Enabled = true; lueUser.Enabled = true; } else { strAuth = "H"; lueDept.Enabled = true; lueUser.Enabled = true; } rgVOC_A.Checked = true; rgVOC_P.Checked = false; } lueGubun_Detail.Enabled = false; }
private void getDTCustWork() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); if (strGubun == "A") { db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_PROCESS_SELECT"; db.Procedure.ParamAdd("@RegDate", strRegDate.Replace("-", "").Replace("-", "").Substring(0, 8)); db.Procedure.ParamAdd("@RegUser", strRegUser); db.Procedure.ParamAdd("@RegNum", strRegNum); } else { db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_POP_SELECT"; db.Procedure.ParamAdd("@CRAIMCODE", strCraimCode); } try { DataSet ds = db.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 0) { teCustCode.Text = ds.Tables[0].Rows[0]["고객코드"].ToString(); teCustNm.Text = ds.Tables[0].Rows[0]["고객명"].ToString(); teCustAddr1.Text = ds.Tables[0].Rows[0]["주소1"].ToString(); teCustAddr2.Text = ds.Tables[0].Rows[0]["주소2"].ToString(); lueCustMng_Dept.EditValue = ds.Tables[0].Rows[0]["담당부서"].ToString(); teCustMng.Text = ds.Tables[0].Rows[0]["고객담당사원"].ToString(); meReceiMemo.Text = ds.Tables[0].Rows[0]["접수내용"].ToString(); teCate_Receive.Text = ds.Tables[0].Rows[0]["접수차수"].ToString(); // dePro_Date.Text = DateTime.Now.ToString(); deRecei_Date.Text = ds.Tables[0].Rows[0]["접수일자"].ToString(); lueRecei_Dept.EditValue = ds.Tables[0].Rows[0]["접수부서"].ToString(); lueRecei_User.EditValue = ds.Tables[0].Rows[0]["접수사원"].ToString(); teCate_ClaimNum.Text = ds.Tables[0].Rows[0]["크레임번호"].ToString(); lueDistr_Work_Dept.EditValue = ds.Tables[0].Rows[0]["처리부서"].ToString(); lueDistr_Work_User.EditValue = ds.Tables[0].Rows[0]["처리사원"].ToString(); lueDistr_Recei_Dept.EditValue = ds.Tables[0].Rows[0]["접수부서"].ToString(); lueDistr_Recei_User.EditValue = ds.Tables[0].Rows[0]["접수사원"].ToString(); teCall_TellNum.Text = ds.Tables[0].Rows[0]["고객전화번호"].ToString(); teCall_CellNum.Text = ds.Tables[0].Rows[0]["고객휴대전화"].ToString(); lueDistr_Recei_Dept.EditValue = ds.Tables[0].Rows[0]["사업소접수부서"].ToString(); lueDistr_Recei_User.EditValue = ds.Tables[0].Rows[0]["사업소접수자"].ToString(); rgCallYN.EditValue = ds.Tables[0].Rows[0]["통화여부"].ToString(); rgRegYN.EditValue = ds.Tables[0].Rows[0]["사업소접수여부"].ToString(); teCallTime.Text = ds.Tables[0].Rows[0]["통화시간"].ToString(); teCustMngDept.Text = ds.Tables[0].Rows[0]["통화시간"].ToString(); teCustMngUser.Text = ds.Tables[0].Rows[0]["고객담당자"].ToString(); lueCall_BigCate.EditValue = ds.Tables[0].Rows[0]["TM접수구분"].ToString(); lueDistr_Part_Dept.EditValue = ds.Tables[0].Rows[0]["처리부서"].ToString(); lueDistr_Team_Dept.EditValue = ds.Tables[0].Rows[0]["처리부서"].ToString(); lueDistr_Part_User.EditValue = ds.Tables[0].Rows[0]["배분파트장"].ToString(); lueDistr_Team_User.EditValue = ds.Tables[0].Rows[0]["배분팀장"].ToString(); tePro_OverTime.Text = ds.Tables[0].Rows[0]["대기시간"].ToString(); if (ds.Tables[0].Rows[0]["전화요청"].ToString() == "Y") { chkCall.Checked = true; } else { chkCall.Checked = false; } if (ds.Tables[0].Rows[0]["방문요청"].ToString() == "Y") { chkVisit.Checked = true; } else { chkVisit.Checked = false; } // 처리내용 탭 luePro_State.EditValue = ds.Tables[0].Rows[0]["처리여부코드"].ToString(); mePro_Memo1.Text = ds.Tables[0].Rows[0]["처리내용"].ToString(); mePro_Memo2.Text = ds.Tables[0].Rows[0]["처리내용2"].ToString(); dePro_Date.EditValue = ds.Tables[0].Rows[0]["처리일자2"].ToString(); } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } // DataRow[] dRow_CustWork = dtCustWork.Select("고객코드 = '" + strCustCode + "' AND 접수순번 = '"+ strRegNum +"'"); // teCustCode.Text = dRow_CustWork[0]["고객코드"].ToString(); // teCustNm.Text = dRow_CustWork[0]["고객명"].ToString(); // teCustAddr1.Text = dRow_CustWork[0]["주소1"].ToString(); // teCustAddr2.Text = dRow_CustWork[0]["주소2"].ToString(); // lueCustMng_Dept.EditValue = dRow_CustWork[0]["담당부서"].ToString(); // teCustMng.Text = dRow_CustWork[0]["고객담당자"].ToString(); // meReceiMemo.Text = dRow_CustWork[0]["접수내용"].ToString(); // teCate_Receive.Text = dRow_CustWork[0]["접수차수"].ToString(); //// dePro_Date.Text = DateTime.Now.ToString(); // deRecei_Date.Text = dRow_CustWork[0]["접수일자"].ToString(); // lueRecei_Dept.EditValue = dRow_CustWork[0]["접수부서"].ToString(); // lueRecei_User.EditValue = dRow_CustWork[0]["접수사원"].ToString(); // teCate_ClaimNum.Text = dRow_CustWork[0]["크레임번호"].ToString(); // lueDistr_Work_Dept.EditValue = dRow_CustWork[0]["처리부서"].ToString(); // lueDistr_Work_User.EditValue = dRow_CustWork[0]["처리사원"].ToString(); // lueDistr_Recei_Dept.EditValue = dRow_CustWork[0]["접수부서"].ToString(); // lueDistr_Recei_User.EditValue = dRow_CustWork[0]["접수사원"].ToString(); // teCall_TellNum.Text = dRow_CustWork[0]["고객전화번호"].ToString(); // teCall_CellNum.Text = dRow_CustWork[0]["고객휴대전화"].ToString(); // lueDistr_Recei_Dept.EditValue = dRow_CustWork[0]["사업소접수부서"].ToString(); // lueDistr_Recei_User.EditValue = dRow_CustWork[0]["사업소접수자"].ToString(); // rgCallYN.EditValue = dRow_CustWork[0]["통화여부"].ToString(); // rgRegYN.EditValue = dRow_CustWork[0]["사업소접수여부"].ToString(); // teCallTime.Text = dRow_CustWork[0]["통화시간"].ToString(); // teCustMngDept.Text = dRow_CustWork[0]["통화시간"].ToString(); // teCustMngUser.Text = dRow_CustWork[0]["고객담당자"].ToString(); // lueCall_BigCate.EditValue = dRow_CustWork[0]["TM접수구분"].ToString(); // lueDistr_Part_Dept.EditValue = dRow_CustWork[0]["처리부서"].ToString(); // lueDistr_Team_Dept.EditValue = dRow_CustWork[0]["처리부서"].ToString(); // lueDistr_Part_User.EditValue = dRow_CustWork[0]["배분파트장"].ToString(); // lueDistr_Team_User.EditValue = dRow_CustWork[0]["배분팀장"].ToString(); // tePro_OverTime.Text = dRow_CustWork[0]["대기시간"].ToString(); // if (dRow_CustWork[0]["전화요청"].ToString() == "Y") // chkCall.Checked = true; // else // chkCall.Checked = false; // if (dRow_CustWork[0]["방문요청"].ToString() == "Y") // chkVisit.Checked = true; // else // chkVisit.Checked = false; }
private void gv_Medium_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (!this.CanFocus) { return; } //if (gv_Medium.GetFocusedRowCellValue(col중분류VOCID.FieldName) == null || gv_Medium.GetFocusedRowCellValue(col중분류명.FieldName) == null) if (gv_Medium.RowCount < 1) { return; } else { text_M_vocid.Text = gv_Medium.GetFocusedRowCellValue(col중분류VOCID.FieldName).ToString(); text_M_Name.Text = gv_Medium.GetFocusedRowCellValue(col중분류명.FieldName).ToString(); } text_M_Code.Text = gv_Medium.GetFocusedRowCellValue(col중분류VOCID.FieldName).ToString(); text_M_MediumName.Text = gv_Medium.GetFocusedRowCellValue(col중분류명.FieldName).ToString(); text_M_vocid.Text = gv_Medium.GetFocusedRowCellValue(col중분류VOCID.FieldName).ToString(); text_M_Name.Text = gv_Medium.GetFocusedRowCellValue(col중분류명.FieldName).ToString(); rdio_M_Usegubun.EditValue = gv_Medium.GetFocusedRowCellValue(col중분류USEYN.FieldName).ToString(); sp_M_Num.EditValue = gv_Medium.GetFocusedRowCellValue(col중분류순번.FieldName).ToString(); lu_S_Multi.EditValue = gv_Medium.GetFocusedRowCellValue(col소분류멀티.FieldName).ToString(); lu_S_Essen.EditValue = gv_Medium.GetFocusedRowCellValue(col소분류필수.FieldName).ToString(); lue_M_ProblemLv.EditValue = gv_Medium.GetFocusedRowCellValue(col문제VOC_LV.FieldName).ToString(); //te_EquipCD.Text = gv_Medium.GetFocusedRowCellValue(col장비코드.FieldName).ToString(); lueEquip.EditValue = gv_Medium.GetFocusedRowCellValue(col장비코드.FieldName).ToString(); lueBugs.EditValue = gv_Medium.GetFocusedRowCellValue(col해충코드.FieldName).ToString(); lu_M_GubunCode.EditValue = gv_Medium.GetFocusedRowCellValue(col타입코드).ToString(); lu_M_Kind.EditValue = gv_Medium.GetFocusedRowCellValue(col업종구분M).ToString(); if (gv_Medium.GetFocusedRowCellValue(col문제VOC_M.FieldName).ToString() == "Y") { chkProb_MVOC.Checked = true; } else { chkProb_MVOC.Checked = false; } if (gv_Medium.GetFocusedRowCellValue(col소분류수.FieldName).Equals(0)) { text_S_Code.Text = ""; text_S_SmallName.Text = ""; sp_S_Num.EditValue = "0"; rdio_S_Usegubun.EditValue = "Y"; gc_Small.DataSource = null; return; } getSmall(); Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORY_BUGEQUIP_SELECT"; db.Procedure.ParamAdd("@BUGSCLS", gv_Medium.GetFocusedRowCellValue("해충코드").ToString()); try { DataSet ds = db.ProcedureToDataSet(); lueBugs_S.Properties.ValueMember = "코드"; lueBugs_S.Properties.DisplayMember = "선택"; if (ds.Tables[2].Rows.Count > 0) { lueBugs_S.Properties.DataSource = ds.Tables[2]; } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void SSave() { if (text_S_Code.Text.Equals("")) { MessageBox.Show("소분류의 신규 버튼을 눌러주세요.", "저장 실패", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string strLCode = text_L_Code.Text; string strMCode = text_M_Code.Text; string strSCode = text_S_Code.Text; try { Cesco.FW.Global.DBAdapter.DBAdapters dbA = new Cesco.FW.Global.DBAdapter.DBAdapters(); dbA.LocalInfo = new Cesco.FW.Global.DBAdapter.LocalInfo(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); dbA.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_SMALL_INSERT_NEW"; dbA.Procedure.ParamAdd("@VOCID", text_S_Code.Text); dbA.Procedure.ParamAdd("@PARENTID", text_M_Code.Text); dbA.Procedure.ParamAdd("@VOCNAME", text_S_SmallName.Text); dbA.Procedure.ParamAdd("@USEYN", rdio_S_Usegubun.EditValue); dbA.Procedure.ParamAdd("@ORDERNO", sp_S_Num.EditValue); dbA.Procedure.ParamAdd("@PROBLEMYN", chkProb_SVOC.Checked ? "Y" : "N"); dbA.Procedure.ParamAdd("@PROBLEMLV", lue_S_ProblemLv.EditValue == null ? "" : lue_S_ProblemLv.EditValue.ToString()); dbA.Procedure.ParamAdd("@TYPECODE", lu_S_GubunCode.EditValue == null ? "" : lu_S_GubunCode.EditValue.ToString()); dbA.Procedure.ParamAdd("@REGID", _strUserID); dbA.Procedure.ParamAdd("@KINDGB", lu_S_Kind.EditValue == null ? "" : lu_S_Kind.EditValue.ToString()); DataSet ds = dbA.ProcedureToDataSetCompress(); MessageBox.Show("저장 완료하였습니다.", "저장 완료", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } MRefresh(); SRefresh(); SNew(); //저장된 행 선택되어 있도록 ColumnView view = (ColumnView)gc_Large.FocusedView; GridColumn column = view.Columns["대분류VOCID"]; if (column != null) { int rhFound = view.LocateByValue(0, column, strLCode); if (rhFound != GridControl.InvalidRowHandle) { view.FocusedRowHandle = rhFound; } } ColumnView view2 = (ColumnView)gc_Medium.FocusedView; GridColumn column2 = view2.Columns["중분류VOCID"]; if (column2 != null) { int rhFound = view2.LocateByValue(0, column2, strMCode); if (rhFound != GridControl.InvalidRowHandle) { view2.FocusedRowHandle = rhFound; } } ColumnView view3 = (ColumnView)gc_Small.FocusedView; GridColumn column3 = view3.Columns["소분류VOCID"]; if (column3 != null) { int rhFound = view3.LocateByValue(0, column3, strSCode); if (rhFound != GridControl.InvalidRowHandle) { view3.FocusedRowHandle = rhFound; } } //gv_Large_FocusedRowChanged(null, null); //gv_Medium_FocusedRowChanged(null, null); //gv_Small_FocusedRowChanged(null, null); }
private void MSave() { if (text_M_Code.Text.Equals("")) { MessageBox.Show("중분류의 신규 버튼을 눌러주세요.", "저장 실패", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //if (te_EquipCD.Text.Equals("") && gv_Large.GetFocusedRowCellValue("대분류VOCID").ToString() == "Q") //{ // MessageBox.Show("장비코드를 입력해주세요.", "저장 실패", MessageBoxButtons.OK, MessageBoxIcon.Error); // return; //} if (lueEquip.EditValue.ToString().Equals("") && gv_Large.GetFocusedRowCellValue("대분류VOCID").ToString() == "Q") { MessageBox.Show("장비코드를 입력해주세요.", "저장 실패", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string strLCode = text_L_Code.Text; string strMCode = text_M_Code.Text; try { Cesco.FW.Global.DBAdapter.DBAdapters dbA = new Cesco.FW.Global.DBAdapter.DBAdapters(); dbA.LocalInfo = new Cesco.FW.Global.DBAdapter.LocalInfo(_strUserID, System.Reflection.MethodBase.GetCurrentMethod()); dbA.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_MEDIUM_INSERT_NEW"; dbA.Procedure.ParamAdd("@VOCID", text_M_Code.Text); dbA.Procedure.ParamAdd("@PARENTID", text_L_vocid.Text); dbA.Procedure.ParamAdd("@VOCNAME", text_M_MediumName.Text); dbA.Procedure.ParamAdd("@MULTIYN", lu_M_Multi.EditValue); dbA.Procedure.ParamAdd("@USEYN", rdio_M_Usegubun.EditValue); dbA.Procedure.ParamAdd("@ORDERNO", sp_M_Num.EditValue); dbA.Procedure.ParamAdd("@SUBCLASSESSEN", lu_S_Essen.EditValue); dbA.Procedure.ParamAdd("@PROBLEMYN", chkProb_MVOC.Checked ? "Y" : "N"); dbA.Procedure.ParamAdd("@PROBLEMLV", lue_M_ProblemLv.EditValue == null ? "" : lue_M_ProblemLv.EditValue.ToString()); dbA.Procedure.ParamAdd("@EQUICODE", lueEquip.EditValue == null ? "" : lueEquip.EditValue.ToString()); dbA.Procedure.ParamAdd("@TYPECODE", lu_M_GubunCode.EditValue); dbA.Procedure.ParamAdd("@REGID", _strUserID); dbA.Procedure.ParamAdd("@KINDGB", lu_M_Kind.EditValue == null ? "" : lu_M_Kind.EditValue.ToString()); dbA.Procedure.ParamAdd("@BUGCODE", lueBugs.EditValue == null ? "" : lueBugs.EditValue.ToString()); DataSet ds = dbA.ProcedureToDataSetCompress(); MessageBox.Show("저장 완료하였습니다.", "저장 완료", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } MRefresh(); MNew(); //저장된 행 선택되어 있도록 ColumnView view = (ColumnView)gc_Large.FocusedView; GridColumn column = view.Columns["대분류VOCID"]; if (column != null) { int rhFound = view.LocateByValue(0, column, strLCode); if (rhFound != GridControl.InvalidRowHandle) { view.FocusedRowHandle = rhFound; } } ColumnView view2 = (ColumnView)gc_Medium.FocusedView; GridColumn column2 = view2.Columns["중분류VOCID"]; if (column2 != null) { int rhFound = view2.LocateByValue(0, column2, strMCode); if (rhFound != GridControl.InvalidRowHandle) { view2.FocusedRowHandle = rhFound; } } }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { string strMidCate = string.Empty; string strSmCate = string.Empty; DataTable dt = new DataTable(); //((DataTable)trCategoryList.DataSource).AcceptChanges(); //dt.AcceptChanges(); btnSearch.Focus(); dt = ((DataTable)trCategoryList.DataSource); DataRow[] dRow_Cate = dt.Select("선택 = 'Y'"); if (dRow_Cate.Length < 1) { MessageBox.Show("선택된 카테고리가 없습니다.", "카테고리 미 선택", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } try { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_CATEGORY_DELETE_SDH"; db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strClaimNum); db.Procedure.ParamAdd("@VCTP", strBigCate.Trim()); DataSet ds = db.ProcedureToDataSet(); } catch (Exception ex) { MessageBox.Show(ex.Message); } for (int i = 0; i < dRow_Cate.Length; i++) { string strGubun = dRow_Cate[i]["IMAGEINDEX"].ToString(); if (strGubun == "0") { strMidCate = dRow_Cate[i]["카테고리코드"].ToString(); strSmCate = ""; } else { strMidCate = dRow_Cate[i]["부모카테고리코드"].ToString(); strSmCate = dRow_Cate[i]["카테고리코드"].ToString(); } try { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_CATEGORY_SAVE_SDH"; db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strClaimNum); db.Procedure.ParamAdd("@VCTP", strBigCate.Trim()); db.Procedure.ParamAdd("@REGUSER", strUserID); db.Procedure.ParamAdd("@REGDATE", strRegDate); db.Procedure.ParamAdd("@GUBUN", strGubun); db.Procedure.ParamAdd("@MIDCATEGORY", strMidCate); db.Procedure.ParamAdd("@SMCATEGORY", strSmCate); DataSet ds = db.ProcedureToDataSet(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); return; } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); return; } MessageBox.Show("저장이 완료되었습니다.", "저장 완료", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void VOC_State_Load(object sender, EventArgs e) { setlueDept(); setlueWork_Gubun(); setDate(); //setLue(); luePro_Dept.EditValue = strDeptCode; luePro_Part.EditValue = strPart; luePro_User.EditValue = strUserID; //if (strExcelAuth == "Y") // barButtonItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; //else // barButtonItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; //2017.12.14 전산업무 요청서 처리 //B31 지사장 B33 지사팀장 B34 지사팀장보 B35 지사파트장 B44 SM if (Convert.ToInt32(strDeptCode) >= 10280 && Convert.ToInt32(strDeptCode) < 50030) { strAuth = "D"; if (_cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B31" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B33" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B34" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B35" || _cesnetUserInfo.UserInfo.ResponOfOfficeCode == "B44") { luePro_Dept.Enabled = false; luePro_User.Enabled = true; barButtonItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; } else { luePro_Dept.Enabled = false; luePro_User.Enabled = true; barButtonItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; } } else if (Convert.ToInt32(strDeptCode) >= 51000 && Convert.ToInt32(strDeptCode) <= 59000) { strAuth = "D"; Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_Include"; db.Procedure.ParamAdd("@부서코드", strDeptCode); try { DataSet ds = db.ProcedureToDataSet(); luePro_Dept.Properties.ValueMember = "부서코드"; luePro_Dept.Properties.DisplayMember = "부서명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { // XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } luePro_Dept.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } luePro_Dept.EditValue = strDeptCode; luePro_User.EditValue = strUserID; luePro_Dept.Enabled = true; luePro_User.Enabled = true; } else { strAuth = "H"; luePro_Dept.Enabled = true; luePro_User.Enabled = true; } Cesco.FW.Global.DevExpressUtil.Grid.ViewToDataTable vtt = new Cesco.FW.Global.DevExpressUtil.Grid.ViewToDataTable(); dtListH = vtt.GetDataTable(gvStateList); //dtListD = vtt.GetDataTable(gvStateListD); //tListD.TableName = "Detail"; dsSource = new DataSet(); dsSource.Tables.AddRange(new DataTable[] { dtListH }); DataColumn[] dColumns = new DataColumn[] { dtListH.Columns[gridColumn21.FieldName] }; //DataColumn[] dColumns_D = new DataColumn[] { dtListD.Columns[gridColumn27.FieldName]} ; //dsSource.Relations.Add("Detail", dColumns, dColumns_D, false); DataView dv = new DataView(dtListH); gcStateList.DataSource = dv; }
private void VOC_TotalStateMng_Category_Load(object sender, EventArgs e) { setDate(); setDateGubun(); setlueDept(); setLueProb(); lueGubun_Detail.Enabled = false; lueDept.EditValue = strDept; lueDate_Gubun.EditValue = strGubun == null ? "" : strGubun; lueGubun_Detail.EditValue = strGubun_Detail == null ? "" : strGubun_Detail; if (lueDate_Gubun.EditValue.ToString() == "") { lueDate_Gubun.EditValue = "D"; } if (lueGubun_Detail.EditValue.ToString() == "") { lueGubun_Detail.EditValue = "선택"; } rgVOC1.EditValue = strRgVOC == "" ? "A" : strRgVOC; if (strRgVOC == "A") { rgVOC_A.Checked = true; rgVOC_P.Checked = false; } else if (strRgVOC == "P") { rgVOC_A.Checked = false; rgVOC_P.Checked = true; } else { rgVOC_A.Checked = true; rgVOC_P.Checked = false; lue_ProblemLv.Enabled = false; } lue_ProblemLv.EditValue = strVoc_Prob; if (strDateFrom.Trim() != "") { deDate_From.EditValue = strDateFrom; } else { DateTime mToday = DateTime.Today; deDate_From.EditValue = mToday; } if (strDateTo.Trim() != "") { deDate_To.EditValue = strDateTo; } else { DateTime mToday = DateTime.Today; deDate_To.EditValue = mToday; } if (strDeptGubun == "Y") { if (Convert.ToInt32(strDeptCode) >= 10280 && Convert.ToInt32(strDeptCode) < 50030) { strAuth = "D"; lueDept.EditValue = strDeptCode; lueDept.Enabled = false; } else if (Convert.ToInt32(strDeptCode) >= 51000 && Convert.ToInt32(strDeptCode) <= 59000) { strAuth = "D"; Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESNET2.dbo.SP_DEPT_SEARCH_Include"; db.Procedure.ParamAdd("@부서코드", strDeptCode); try { DataSet ds = db.ProcedureToDataSet(); lueDept.Properties.ValueMember = "부서코드"; lueDept.Properties.DisplayMember = "부서명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { // XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } lueDept.Properties.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } lueDept.EditValue = strDeptCode; lueDept.Enabled = true; } else { strAuth = "H"; lueDept.Enabled = true; } } else { setBigList(); gvbigList_FocusedRowChanged(null, null); } }
private void VOC_WORK_Load(object sender, EventArgs e) { luePro_State.EditValueChanged -= luePro_State_EditValueChanged; //접수일자 처리일자 세팅 setDeDate(); //대분류 세팅 setlueWork_Gubun(); //상세리스트세팅 getDTCustWork(); //처리담당자부서세팅 setlueDept(); //중분류,세분류 세팅 setgcCategory(); //처리담당자 세팅 setUserGubun(); //대분류 조건 if (lueCall_BigCate.Text == "") { btnCate_Change.Enabled = false; } else { btnCate_Change.Enabled = true; } //처리담당자와 로그인사원이 같을 시 읽음으로 변경로직 if (lueDistr_Work_User.EditValue.ToString() == strUserID) { //if (luePro_State.EditValue.ToString() == "I") // I == 입력완료 RY08 , N == 미처리 RY04 if (luePro_State.EditValue.ToString() == "RY04") //미처링일때 읽음으로 표시 { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); strPROMEMOGubun = "2"; db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_READ_SAVE_SDH"; //db.Procedure.ParamAdd("@PROSTATE", "R"); //읽음 RY07 db.Procedure.ParamAdd("@PROSTATE", "RY07"); //읽음 RY07 db.Procedure.ParamAdd("@REGDATE", deRecei_Date.Text.Replace("-", "").Replace("-", "")); db.Procedure.ParamAdd("@REGUSER", strUserID); db.Procedure.ParamAdd("@REGDEPT", strDeptCode); db.Procedure.ParamAdd("@REGNUM", strRegNum); db.Procedure.ParamAdd("@VCNO", strVCNO); db.Procedure.ParamAdd("@VCTP", strVCTP.Trim()); try { DataSet ds = db.ProcedureToDataSet(); // luePro_State.EditValue = "R";//읽음 RY07 luePro_State.EditValue = "RY07";//읽음 RY07 } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } } } if (strAuth == "D") { teRecei_Dept.Visible = false; teRecei_User.Visible = false; } else { teRecei_Dept.Visible = true; teRecei_User.Visible = true; } if (luePro_State.EditValue.ToString() == "RY01") //RY01 처리완료 { mePro_Memo1.Properties.ReadOnly = true; btnProcMemo1_Save.Enabled = false; btnSave_Dist.Enabled = false; dePro_Date.Enabled = false; luePro_State.Enabled = false; btnCate_Change.Enabled = false; btnSMS1.Enabled = false; // 20170706 이보현 추가 요청서 상신 // 20171211 이보현 추가내용 요청서 상신 mePro_Memo2.Properties.ReadOnly = false; btnProcMemo2_Save.Enabled = true; } luePro_State.EditValueChanged += luePro_State_EditValueChanged; }