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