/// <summary>
/// 조회 함수
/// </summary>
void SearchEmsFailList()
{
try
{
//var _USER_ID = this.BaseInfo.user_id.ToString();
EmsCommCode repDev = cboChkRepDev.SelectedItem as EmsCommCode;
//DateTime start = new DateTime(searchStart.DateTime.Year, searchStart.DateTime.Month, searchStart.DateTime.Day);
//DateTime end = new DateTime(searchEnd.DateTime.Year, searchEnd.DateTime.Month, searchEnd.DateTime.Day);
var strStartDate = this.BaseClass.GetCalendarValue(this.searchStart);
var strEndDate = this.BaseClass.GetCalendarValue(this.searchEnd);
var strFailType = this.BaseClass.ComboBoxSelectedKeyValue(this.cboChkRepDev);
var param = new Dictionary <string, object>
{
{ "P_CENTER_CD", this.BaseClass.CenterCD },
{ "P_FROM_DT", strStartDate },
{ "P_TO_DT", strEndDate },
{ "P_FAIL_DEV_CD", strFailType }
};
var strOutParam = new[] { "P_EMS_FAIL_LIST" };
string callProc = "PK_EMS_ECHK002.SP_EMS_FAIL_LIST_SEL";
using (BaseDataAccess da = new BaseDataAccess())
{
var outData = da.GetSpDataSet(
callProc // 호출 프로시저
, param // Input 파라메터
, strOutParam // Output 파라메터
);
if (null != EmsFailList)
{
EmsFailList.Clear();
EmsFailList = null;
}
EmsFailList = new ObservableCollection <EmsFail>();
if (outData.Tables[0].Rows.Count > 0)
{
EmsFailList.ToObservableCollection(outData.Tables[0]);
}
gridMain.ItemsSource = EmsFailList;
if (outData.Tables[0].Rows.Count > 0)
{
if (-1 < focused_handle)
{
gridMain.View.FocusedRowHandle = focused_handle;
gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsFail>)[focused_handle];
}
else
{
gridMain.View.FocusedRowHandle = 0;
gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsFail>)[0];
}
}
}
}
catch (Exception ex)
{
this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE);
}
}
/// <summary>
/// 조회 함수
/// </summary>
void SearchEmsChkPlan()
{
try
{
//var _USER_ID = this.BaseInfo.user_id.ToString();
EmsCommCode dptDev = cboChkDptDev.SelectedItem as EmsCommCode;
EmsCommCode rstDev = cboChkRstDev.SelectedItem as EmsCommCode;
var strDeptDev = this.BaseClass.ComboBoxSelectedKeyValue(this.cboChkDptDev);
var strRstDev = this.BaseClass.ComboBoxSelectedKeyValue(this.cboChkRstDev);
//DateTime start = new DateTime(searchStart.DateTime.Year, searchStart.DateTime.Month, searchStart.DateTime.Day);
//DateTime end = new DateTime(searchEnd.DateTime.Year, searchEnd.DateTime.Month, searchEnd.DateTime.Day);
var strStartDate = this.BaseClass.GetCalendarValue(this.searchStart);
var strEndDate = this.BaseClass.GetCalendarValue(this.searchEnd);
var param = new Dictionary <string, object>
{
{ "P_CENTER_CD", this.BaseClass.CenterCD },
{ "P_CHK_DEV_CD", strDeptDev },
{ "P_FROM_DT", strStartDate },
{ "P_TO_DT", strEndDate },
{ "P_CHK_RST_DEV", strRstDev }
};
var strOutParam = new[] { "P_EMS_CHK_LIST" };
string callProc = "PK_EMS_ECHK001.SP_EMS_CHK_PLAN_SEL";
using (BaseDataAccess da = new BaseDataAccess())
{
var outData = da.GetSpDataSet(
callProc // 호출 프로시저
, param // Input 파라메터
, strOutParam // Output 파라메터
);
if (null != EmsChkPlanList)
{
EmsChkPlanList.Clear();
EmsChkPlanList = null;
}
EmsChkPlanList = new ObservableCollection <EmsChkPlan>();
if (outData.Tables[0].Rows.Count > 0)
{
EmsChkPlanList.ToObservableCollection(outData.Tables[0]);
this.EmsChkPlanList.Where(p => p.CHK_STAT_CD != "F").ForEach(p => p.CHK_STAT_CD = "N");
//this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("CMPT_INQ"));
}
else
{
//this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("NO_INQ_DATA"));
}
gridMain.ItemsSource = EmsChkPlanList;
if (outData.Tables[0].Rows.Count > 0)
{
if (-1 < focused_handle)
{
gridMain.View.FocusedRowHandle = focused_handle;
gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsChkPlan>)[focused_handle];
}
else
{
gridMain.View.FocusedRowHandle = 0;
gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsChkPlan>)[0];
}
}
//this.btnSaveHigh.IsEnabled = true;
//this.btnEditHigh.IsEnabled = true;
//this.btnRowAddHigh.IsEnabled = true;
//this.btnRowDeleteHigh.IsEnabled = true;
}
}
catch (Exception ex)
{
this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE);
}
}
