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