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_ALL"; db.Procedure.ParamAdd("@부서코드", paramValue); 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, "처리되지 않은 에러"); } }
/// <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.Procedure-Name = "CESCOEIS.dbo.SP_VOC_STATELIST_ADDPROSTATE_SELECT"; //SP_VOC_STATELIST_SELECT -- 지연시간 조회추가된 프로시저 db.Procedure.ProcedureName = "CESCOEIS.dbo.USP_VOC_PROCESS_Ver1"; 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("@ProState", lueProState.EditValue == null ? "" : lueProState.EditValue); db.Procedure.ParamAdd("@PartCode", luePro_Part.EditValue == null ? "" : luePro_Part.EditValue); // db.Procedure.ParamAdd("@DelayTime", lueDelayTime.EditValue == null ? "" : lueDelayTime.EditValue); try { this.Cursor = Cursors.WaitCursor; //DateTime de = DateTime.Now; DataSet ds = db.ProcedureToDataSet(); if (ds.Tables.Count > 0) { dtListH.Clear(); dtListH.Merge(ds.Tables[0]); dtListH.AcceptChanges(); //dtListD.Clear(); //dtListD.Merge(ds.Tables[1]); } //if (ds.Tables[1].Rows.Count > 0) //{ // int iCount = 0; // foreach (DataRow dRow in dtListD.Rows) // { // if (dRow["접수번호"].ToString() != "") // { // gvStateList.SetMasterRowExpanded(iCount, true); // } // iCount += 1; // } //} } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } finally { this.Cursor = Cursors.Default; } }
private void setCategoryList() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORYSTD_Big_SELECT"; try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } tr_stdMng.ParentFieldName = "대분류PARENTID"; tr_stdMng.KeyFieldName = "대분류VOCID"; tr_stdMng.DataSource = ds.Tables[0]; //tr_stdMng.ExpandAll(); } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void btnSave_Dist_Click(object sender, EventArgs 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_STATE_WORK_DISTR"; db.Procedure.ParamAdd("@WORK_USERID", lueDistr_Work_User.EditValue); db.Procedure.ParamAdd("@WORK_DEPTCODE", lueDistr_Work_Dept.EditValue); db.Procedure.ParamAdd("@REGDATE", deRecei_Date.Text.Replace("-", "").Replace("-", "")); db.Procedure.ParamAdd("@REGUSERID", lueRecei_User.EditValue); db.Procedure.ParamAdd("@REGNUM", strRegNum); try { DataSet ds = db.ProcedureToDataSet(); } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } MessageBox.Show("처리담당자가 변경되었습니다.", "처리담당자 저장", MessageBoxButtons.OK, MessageBoxIcon.Information); return; }
private void setMonitoringList() //string strCategoryNo { //Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); //db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_DIVIDE_MONITORING_SENDHIS"; //SP_VOC_DIVIDE_MONITORING_SELECT //db.Procedure.ParamAdd("@REGDATE", deRecei_Date.Text.Replace("-", "").Replace("-", "")); //db.Procedure.ParamAdd("@REGUSER", lueRecei_User.EditValue); //db.Procedure.ParamAdd("@REGNUM", strRegNum); //db.Procedure.ParamAdd("@CLAIMCODE", teCate_ClaimNum.Text); //try //{ // DataSet ds = db.ProcedureToDataSet(); // if (ds.Tables[0].Rows.Count > 0) // { // gcMonitoringList.DataSource = ds.Tables[0]; // } // if (ds.Tables[1].Rows.Count > 0) // { // gcChgHis.DataSource = ds.Tables[1]; // } // ////tePro_OverTime.Text = ds.Tables[0].Rows[0][""].ToString(); // //teFitProTime.Text = ds.Tables[0].Rows[0]["권장처리시간"].ToString(); // //teMaxProTime.Text = ds.Tables[0].Rows[0]["MAX처리시간"].ToString(); //} //catch (Cesco.FW.Global.DBAdapter.WcfException ex) //{ // MessageBox.Show(ex.Message, "DB 에러"); //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message, "처리되지 않은 에러"); //} Cesco.FW.Global.DBAdapter.DBAdapters db2 = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db2.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_DIVIDE_MONITORING_SELECT"; //SP_VOC_DIVIDE_MONITORING_SELECT db2.Procedure.ParamAdd("@BIGCATEGORY", lueCall_BigCate.EditValue); try { DataSet ds = db2.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 0) { teFitProTime.Text = ds.Tables[0].Rows[0]["권장처리시간"].ToString(); teMaxProTime.Text = ds.Tables[0].Rows[0]["MAX처리시간"].ToString(); } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void btnProcMemo2_Save_Click(object sender, EventArgs 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_STATE_PROCESS_SAVE_SDH"; db.Procedure.ParamAdd("@PROMEMO1", mePro_Memo2.Text); db.Procedure.ParamAdd("@PROUSER", strUserID); db.Procedure.ParamAdd("@PRODEPT", strDeptCode); db.Procedure.ParamAdd("@PROSTATE", "RY09"); 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); getDTCustWork(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void setgcCategory() { 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_SELECT"; db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_CATEGORY_SELECT_SDH"; db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strVCNO); try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { return; } gcCategory.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 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.USP_VOC_DELETE_HIS"; //db.Procedure.ProcedureName = "BACKUPDB.dbo.USP_VOC_DELETE_HIS"; db.Procedure.ParamAdd("@DTSTART", deStart_Date.Text.Replace("-", "").Replace("-", "")); db.Procedure.ParamAdd("@DTEND", deEnd_Date.Text.Replace("-", "").Replace("-", "")); try { this.Cursor = Cursors.WaitCursor; DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { XtraMessageBox.Show("조회할 항목이 없습니다."); return; } gcStateList.DataSource = ds.Tables[0]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } finally { this.Cursor = Cursors.Default; } }
private void lueCategory_Mid_EditValueChanged(object sender, EventArgs e) { lueCategory_Sm.EditValue = ""; 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_SMALL2_SELECT"; db.Procedure.ParamAdd("@SMALLPID", lueCategory_Mid.EditValue); try { DataSet ds = db.ProcedureToDataSet(); lueCategory_Sm.Properties.ValueMember = "소분류VOCID"; lueCategory_Sm.Properties.DisplayMember = "소분류명"; lueCategory_Sm.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 lueDistr_Work_Dept_EditValueChanged(object sender, EventArgs e) { setLue(lueDistr_Work_User, 1, lueDistr_Work_Dept.EditValue.ToString(), "사번", "한글성명"); Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_PROMNG_SELECT"; db.Procedure.ParamAdd("@DEPTCODE", lueDistr_Work_Dept.EditValue); db.Procedure.ParamAdd("@VOCID", lueCall_BigCate.EditValue);///////////////////////////////////// try { DataSet ds = db.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 0) { lueDistr_Work_User.EditValue = ds.Tables[0].Rows[0]["처리담당자사원"]; } } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
//private void lueDistr_Part_Dept_EditValueChanged(object sender, EventArgs e) //{ // setLue(lueDistr_Part_User, 1, lueDistr_Part_Dept.EditValue.ToString(), "사번", "한글성명"); //} //private void lueDistr_Team_Dept_EditValueChanged(object sender, EventArgs e) //{ // setLue(lueDistr_Team_User, 1, lueDistr_Team_Dept.EditValue.ToString(), "사번", "한글성명"); //} #endregion #region 대분류 세팅 ★★★★★★★★★★★★ /// <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"; db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_STATE_GUBUN_SELECT_SDH"; try { DataSet ds = db.ProcedureToDataSet(); lueCall_BigCate.Properties.ValueMember = "대분류코드"; lueCall_BigCate.Properties.DisplayMember = "대분류명"; luePro_State.Properties.ValueMember = "코드구분"; luePro_State.Properties.DisplayMember = "코드명"; if (ds == null || ds.Tables.Count < 1 || ds.Tables[1].Rows.Count == 0) { return; } lueCall_BigCate.Properties.DataSource = ds.Tables[4]; luePro_State.Properties.DataSource = ds.Tables[3]; } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void VOC_CurrentState_Load(object sender, EventArgs e) { setLue(luePro_Dept, 0, "", "부서코드", "부서명", ""); dtFrom.DateTime = DateTime.Now; dtTo.DateTime = DateTime.Now; if (Convert.ToInt32(_strDeptCode) >= 10280 && Convert.ToInt32(_strDeptCode) < 50030) { luePro_Dept.EditValue = _strDeptCode; luePro_Dept.Enabled = false; luePro_User.Enabled = true; } 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(); 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_Part.EditValue = ""; luePro_User.EditValue = _strUserID; luePro_Dept.Enabled = true; luePro_User.Enabled = true; } else { luePro_Dept.Enabled = true; luePro_User.Enabled = true; } }
private void barBtnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string strVocID = string.Empty; try { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); //db.Procedure.ProcedureName = "BACKUPDB.dbo.SP_VOC_CATEGORYSTD_Mnger_DELETE"; db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORYSTD_Mnger_DELETE"; db.Procedure.ParamAdd("@VOCID", tr_stdMng.FocusedNode["대분류VOCID"].ToString()); DataSet ds = db.ProcedureToDataSet(); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (gvUserList.DataRowCount > 0) { try { for (int i = 0; i < gvUserList.DataRowCount; i++) { strVocID = tr_stdMng.FocusedNode["대분류VOCID"].ToString(); Cesco.FW.Global.DBAdapter.DBAdapters db2 = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); //db2.Procedure.ProcedureName = "BACKUPDB.dbo.SP_VOC_CATEGORYSTD_Mnger_SAVE"; db2.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORYSTD_Mnger_SAVE"; db2.Procedure.ParamAdd("@VOCID", tr_stdMng.FocusedNode["대분류VOCID"].ToString()); db2.Procedure.ParamAdd("@Sabun", gvUserList.GetRowCellValue(i, "사번").ToString()); db2.Procedure.ParamAdd("@DeptCode", gvUserList.GetRowCellValue(i, "부서코드").ToString()); db2.Procedure.ParamAdd("@DeptName", gvUserList.GetRowCellValue(i, "부서명").ToString()); DataSet ds = db2.ProcedureToDataSet(); } } 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); setCategoryList(); //저장된 행 선택되어 있도록 tr_stdMng.FocusedNode = tr_stdMng.FindNodeByFieldValue("대분류VOCID", strVocID); }
private void setList() { //strGubun A, B구분 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_SELECT_MULTI"; //SP_VOC_TotalStateMngList_SELECT_MULTI //db.Procedure.ProcedureName = "BACKUPDB.dbo.SP_VOC_TotalStateMngList_SELECT_MULTI"; //SP_VOC_TotalStateMngList_SELECT_MULTI db.Procedure.ParamAdd("@DATE_FROM", deDate_From.Text.Replace("-", "")); db.Procedure.ParamAdd("@DATE_TO", deDate_To.Text.Replace("-", "")); db.Procedure.ParamAdd("@DEPTCODE", lueDept.EditValue == null ? "" : lueDept.EditValue); db.Procedure.ParamAdd("@USERID", lueUser.EditValue == null ? "" : lueUser.EditValue); db.Procedure.ParamAdd("@PROSTATE", lueProcState.EditValue == null ? "" : lueProcState.EditValue); db.Procedure.ParamAdd("@CATEGORY_BIG", lueCategory_Big.EditValue == null ? "" : lueCategory_Big.EditValue); db.Procedure.ParamAdd("@CATEGORY_MID", lueCategory_Mid.EditValue == null ? "" : lueCategory_Mid.EditValue); db.Procedure.ParamAdd("@CATEGORY_SM", lueCategory_Sm.EditValue == null ? "" : lueCategory_Sm.EditValue); db.Procedure.ParamAdd("@DELAYSTATE", lueDelayState.EditValue == null ? "" : lueDelayState.EditValue); db.Procedure.ParamAdd("@CUSTNM", teCustNm.Text); db.Procedure.ParamAdd("@CHANNEL", lueChannel.EditValue == null ? "" : lueChannel.EditValue); db.Procedure.ParamAdd("@PROBLEMYN", rgVOC_A.Checked == true ? "A" : "P"); db.Procedure.ParamAdd("@PARTCODE", luePro_Part.EditValue == null ? "" : luePro_Part.EditValue.ToString()); db.Procedure.ParamAdd("@MONITORING_GUBUN", strMonitoring); db.Procedure.ParamAdd("@PROBLEMLV", rgVOC_A.Checked == true ? "" : lue_ProblemLv.EditValue.ToString()); db.Procedure.ParamAdd("@CALLDEPT", lueCallDept.EditValue == null ? "" : lueCallDept.EditValue.ToString()); db.Procedure.ParamAdd("@CALLEMP", lueCallEmp.EditValue == null ? "" : lueCallEmp.EditValue.ToString()); try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { gcMngList.DataSource = null; return; } gcMngList.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 setSmList() { 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_Sm_SELECT_MULTI"; //"CESCOEIS.dbo.SP_VOC_TotalStateCate_Sm_SELECT_TEMP"; db.Procedure.ParamAdd("@DATE_FROM", deDate_From.Text.Replace("-", "")); db.Procedure.ParamAdd("@DATE_TO", deDate_To.Text.Replace("-", "")); db.Procedure.ParamAdd("@MIDCATEGORY", gvMidList.GetFocusedRowCellValue("VOCID") == null ? "" : gvMidList.GetFocusedRowCellValue("VOCID").ToString()); 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) { gcSmList.DataSource = null; return; } gcSmList.DataSource = null; gvSmList.Columns.Clear(); gcSmList.DataSource = ds.Tables[0]; gvSmList.BestFitColumns(); gvSmList.OptionsView.ColumnAutoWidth = false; gvSmList.Columns[1].Caption = "소분류"; gvSmList.Columns[0].Visible = false; gvSmList.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; gvSmList.Columns[1].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; gvSmList.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 setCategoryList() { 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_CategoryList_SDH"; db.Procedure.ParamAdd("@RegNum", strRegNum); db.Procedure.ParamAdd("@VCNO", strClaimNum); db.Procedure.ParamAdd("@VCTP", strBigCate.Trim()); try { DataSet ds = db.ProcedureToDataSet(); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { XtraMessageBox.Show("조회된 데이터가 없습니다."); return; } trCategoryList.ParentFieldName = "부모카테고리코드"; trCategoryList.KeyFieldName = "카테고리코드"; trCategoryList.ImageIndexFieldName = "IMAGEINDEX"; if (trCategoryList.Nodes.ParentNode != null) { trCategoryList.Nodes.ParentNode.ImageIndex = 0; } if (trCategoryList.Nodes.LastNode != null) { trCategoryList.Nodes.LastNode.ImageIndex = 1; } trCategoryList.DataSource = ds.Tables[0]; trCategoryList.ExpandAll(); } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
private void tr_stdMng_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { if (!this.CanFocus) { return; } gcUserList.DataSource = null; teEmp.Text = ""; meApplyDelay.Text = ""; meProDelay.Text = ""; Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); //db.Procedure.ProcedureName = "BACKUPDB.dbo.SP_VOC_CATEGORYSTD_User_SELECT"; db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_CATEGORYSTD_User_SELECT"; db.Procedure.ParamAdd("@VOCID", tr_stdMng.FocusedNode["대분류VOCID"].ToString()); try { DataSet ds = db.ProcedureToDataSet(); if (ds.Tables[0].Rows.Count > 0) { gcUserList.DataSource = ds.Tables[0]; } //if (ds.Tables[1].Rows.Count > 0) //{ // meApplyDelay.Text = ds.Tables[1].Rows[0]["접수지연안내문구"].ToString(); // meProDelay.Text = ds.Tables[1].Rows[0]["처리지연안내문구"].ToString(); //} } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); return; } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); return; } }
private void setDeptNmCheck() { Cesco.FW.Global.DBAdapter.DBAdapters db = new Cesco.FW.Global.DBAdapter.DBAdapters(strUserID, System.Reflection.MethodBase.GetCurrentMethod()); db.Procedure.ProcedureName = "CESCOEIS.dbo.SP_VOC_TotalStateMng_DeptNM"; db.Procedure.ParamAdd("@DEPTNM", strDept); try { DataSet ds = db.ProcedureToDataSet(); strDeptNm = ds.Tables[0].Rows[0]["부서코드"].ToString(); } catch (Cesco.FW.Global.DBAdapter.WcfException ex) { MessageBox.Show(ex.Message, "DB 에러"); } catch (Exception ex) { MessageBox.Show(ex.Message, "처리되지 않은 에러"); } }
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; }
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 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="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; DataSet ds = db.ProcedureToDataSet(); this.Cursor = Cursors.Default; if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count == 0) { XtraMessageBox.Show("조회할 항목이 없습니다."); return; } ds.Tables[0].DefaultView.Sort = ds.Tables[1].Rows[0]["Sortfield"].ToString(); 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 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_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 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; }
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 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 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); } }