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_IssueSearch_SELECT"; dbA.Procedure.ParamAdd("@From", dtFrom.DateTime.ToString("yyyyMMdd")); dbA.Procedure.ParamAdd("@To", dtTo.DateTime.ToString("yyyyMMdd")); dbA.Procedure.ParamAdd("@CustCode", ctiCustInfo.CustCode); dbA.Procedure.ParamAdd("@DeptCode", _strDeptCode); dbA.Procedure.ParamAdd("@UserId", _strUserID); 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) { grd이슈.DataSource = ds.Tables[0]; } else { grd이슈.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void GetHistroy() { 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_Get고객요청HIS"; dbA.Procedure.ParamAdd("@클레임번호", teCate_ClaimNum.Text); 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) { grd이력.DataSource = ds.Tables[0]; } else { grd이력.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
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()); } }
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"; } }