public List <Abnormal_event_ViewModel> SelectAbnormal_Event_byStage(string stage, string category, string application_unit, DateTime startdate, DateTime enddate)
{
Abnormal_event_Model abnormal_Event_Model = new Abnormal_event_Model();
List <Abnormal_event_Model> abnormal_Event_Models = abnormal_Event_Model.SelectAbnormal_event_byStage(stage, category, application_unit, startdate, enddate);
List <Abnormal_event_ViewModel> abnormal_Event_ViewModels = new List <Abnormal_event_ViewModel>();
foreach (var row in abnormal_Event_Models)
{
Abnormal_event_ViewModel abnormal_Event_ViewModel = new Abnormal_event_ViewModel();
abnormal_Event_ViewModel.Abnormal_event_no = row.Abnormal_event_no;
abnormal_Event_ViewModel.Abnormal_event_ID = row.Abnormal_event_ID;
abnormal_Event_ViewModel.Abnormal_event = row.Abnormal_event;
abnormal_Event_ViewModel.Volunteer_name = row.Volunteer_name;
abnormal_Event_ViewModel.Application_unit = row.Application_unit;
abnormal_Event_ViewModel.event_category = row.event_category;
abnormal_Event_ViewModel.Stage = row.Stage;
abnormal_Event_ViewModel.Notification_date = row.Notification_date;
abnormal_Event_ViewModel.Closing_date = row.Closing_date;
abnormal_Event_ViewModel.Supervisor = row.Supervisor;
abnormal_Event_ViewModel.Unit_descrition = row.Unit_descrition;
abnormal_Event_ViewModel.Volunteer_description = row.Volunteer_description;
abnormal_Event_ViewModel.Supervisor_description = row.Supervisor_description;
abnormal_Event_ViewModel.Result = row.Result;
abnormal_Event_ViewModel.Volunteer_leader = row.Volunteer_leader;
abnormal_Event_ViewModel.Supervisor_heads = row.Supervisor_heads;
abnormal_Event_ViewModels.Add(abnormal_Event_ViewModel);
}
return(abnormal_Event_ViewModels);
}
public List <Abnormal_event_analysis_ViewModel> SelectAbnormal_event_analysis(DateTime startdate, DateTime enddate, string event_category, List <string> unit_lists)
{
Abnormal_event_Model abnormal_Event_Model = new Abnormal_event_Model();
List <Abnormal_event_Model> abnormal_Events = abnormal_Event_Model.SelectAbnormal_event_byDate(startdate, enddate, event_category, unit_lists);
List <Abnormal_event_analysis_ViewModel> abnormal_Event_Analysis_ViewModels = new List <Abnormal_event_analysis_ViewModel>();
foreach (var row in abnormal_Events)
{
Abnormal_event_analysis_ViewModel abnormal_Event_Analysis_ViewModel = new Abnormal_event_analysis_ViewModel();
abnormal_Event_Analysis_ViewModel.Abnormal_event_no = row.Abnormal_event_no;
abnormal_Event_Analysis_ViewModel.Abnormal_event_ID = row.Abnormal_event_ID;
abnormal_Event_Analysis_ViewModel.Abnormal_event = row.Abnormal_event;
abnormal_Event_Analysis_ViewModel.Volunteer_name = row.Volunteer_name;
abnormal_Event_Analysis_ViewModel.Application_unit = row.Application_unit;
abnormal_Event_Analysis_ViewModel.Event_category = row.event_category;
abnormal_Event_Analysis_ViewModel.Stage = row.Stage;
abnormal_Event_Analysis_ViewModel.Notification_date = row.Notification_date;
abnormal_Event_Analysis_ViewModel.Closing_date = row.Closing_date;
abnormal_Event_Analysis_ViewModel.Supervisor = row.Supervisor;
abnormal_Event_Analysis_ViewModel.Unit_descrition = row.Unit_descrition;
abnormal_Event_Analysis_ViewModel.Volunteer_description = row.Volunteer_description;
abnormal_Event_Analysis_ViewModel.Supervisor_description = row.Supervisor_description;
abnormal_Event_Analysis_ViewModel.Result = row.Result;
abnormal_Event_Analysis_ViewModel.Volunteer_leader = row.Volunteer_leader;
abnormal_Event_Analysis_ViewModel.Supervisor_heads = row.Supervisor_heads;
abnormal_Event_Analysis_ViewModel.Rejection_Reason = row.Rejection_Reason;
abnormal_Event_Analysis_ViewModels.Add(abnormal_Event_Analysis_ViewModel);
}
//異常事件類別統計
Compute_Event_type(abnormal_Event_Analysis_ViewModels);
Compute_Application_unit(abnormal_Event_Analysis_ViewModels, unit_lists);
Compute_Event_month(abnormal_Event_Analysis_ViewModels, startdate, enddate);
return(abnormal_Event_Analysis_ViewModels);
}
public void SelectAbnormal_event_byAbnormal_event_ID(string event_ID)
{
Abnormal_event_Model abnormal_Event_Model = new Abnormal_event_Model();
abnormal_Event_Model.SelectAbnormal_event_byAbnormal_event_ID(event_ID);
Abnormal_event_no = abnormal_Event_Model.Abnormal_event_no;
Abnormal_event_ID = abnormal_Event_Model.Abnormal_event_ID;
Abnormal_event = abnormal_Event_Model.Abnormal_event;
Volunteer_name = abnormal_Event_Model.Volunteer_name;
Application_unit = abnormal_Event_Model.Application_unit;
event_category = abnormal_Event_Model.event_category;
Stage = abnormal_Event_Model.Stage;
Notification_date = abnormal_Event_Model.Notification_date;
Closing_date = abnormal_Event_Model.Closing_date;
Supervisor = abnormal_Event_Model.Supervisor;
Unit_descrition = abnormal_Event_Model.Unit_descrition;
Volunteer_description = abnormal_Event_Model.Volunteer_description;
Supervisor_description = abnormal_Event_Model.Supervisor_description;
Result = abnormal_Event_Model.Result;
Volunteer_leader = abnormal_Event_Model.Volunteer_leader;
Supervisor_heads = abnormal_Event_Model.Supervisor_heads;
Rejection_Reason = abnormal_Event_Model.Rejection_Reason;
}
