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);
}
}
