public DASHBOARD_SHOW_DATA Get_DashBoard_Data_List(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE, string REFRESH)
{
try
{
DASHBOARD_SHOW_DATA DASHBOARD_SHOW_data = new DASHBOARD_SHOW_DATA();
DASHBOARD_SHOW_data = DASHBOARDSHOW_DATA(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, 1);
return(DASHBOARD_SHOW_data);
}
catch (Exception)
{
return(null);
}
finally
{
}
}
public string DASHBOARDSHOWInquiry(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE)
{
string JsonResponse;
try
{
DASHBOARD_SHOW_DATA DASHBOARD_SHOW_data = new DASHBOARD_SHOW_DATA();
DASHBOARD_SHOW_data = DASHBOARDSHOW_DATA(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, 2);
JsonResponse = "{\"SUCCESS\":true, \"Data\": " + JsonConvert.SerializeObject(DASHBOARD_SHOW_data);
JsonResponse += "}";
}
catch (Exception)
{
JsonResponse = "{\"SUCCESS\":false, \"Data\": " + JsonConvert.SerializeObject(null);
JsonResponse += "}";
}
finally { }
return(JsonResponse);
}
public ActionResult DASHBOARDSHOWView()
//public ActionResult DASHBOARDSHOWView(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime? TRX_DATE, string REFRESH)
{
ViewData["FACTORY_CD_Param"] = Request["factory"];
ViewData["LINE_CODE_Param"] = Request["line"];
string FACTORY_CD = Request["factory"];
string LINE_CODE = Request["line"];
DASHBOARDBLL DashboardBLL = new DASHBOARDBLL(Request["factory"]);
DASHBOARD_SHOW_DATA DASHBOARD_SHOW_data = new DASHBOARD_SHOW_DATA();
DASHBOARD_SHOW_data = DashboardBLL.Get_DashBoard_Data_List(FACTORY_CD, LINE_CODE, null, null, null); //(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, REFRESH);
if (DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION == null)
{
return(View());
}
string preferredLang = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.LANGUAGE;
IEnumerable <OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION> data = DashboardBLL.PROC_GET_DASHBOARD_FORM_DEFINITION("DASHBOARDSHOW", preferredLang);
foreach (MvcDashBoard.Model.DASHBOARD.Models.OTHER.PROC_GET_DASHBOARD_FORM_DEFINITION item in data)
{
ViewData[item.CONTROLLER_ID.ToString()] = (item.CONTROLLER_DESC == null ? "" : item.CONTROLLER_DESC.ToString());
}
return(View(DASHBOARD_SHOW_data));
}
public DASHBOARD_SHOW_DATA DASHBOARDSHOW_DATA(string FACTORY_CD, String LINE_CODE, string SHIFT_CODE, DateTime?TRX_DATE, int Flag)
{
DASHBOARD_SHOW_DATA DASHBOARD_SHOW_data = new DASHBOARD_SHOW_DATA();
try
{
BASICINFORMATION_DATA BASICINFORMATION_data = new BASICINFORMATION_DATA();
//读文件的基本信息
COMMONPROCESS ReadAndWrite_File = new COMMONPROCESS(FACTORY_CD, LINE_CODE);
BASICINFORMATION_data = ReadAndWrite_File.Read_BASICINFORMATION_File();
if (BASICINFORMATION_data == null)
{
return(DASHBOARD_SHOW_data);
}
RUNNING_BASIC_INFORMATION RUNNING_BASIC_INFORMATION = new RUNNING_BASIC_INFORMATION();
//if (LINE_CODE == BASICINFORMATION_data.LINE_CODE1)
//{
// // SHIFT_CODE = BASICINFORMATION_data.SHIFT_CODE1; //remark by sunny 20180312
//}
//else if (LINE_CODE == BASICINFORMATION_data.LINE_CODE2)
//{
// // SHIFT_CODE = BASICINFORMATION_data.SHIFT_CODE2; //remark by sunny 20180312
//}
//else if (LINE_CODE == BASICINFORMATION_data.LINE_CODE3)
//{
// SHIFT_CODE = BASICINFORMATION_data.SHIFT_CODE3;
//}
//else
//{
// return DASHBOARD_SHOW_data;
//}
RUNNING_BASIC_INFORMATION = GET_RUNNING_BASIC_INFORMATION(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, BASICINFORMATION_data);
//tangyh 2018.05.16
if (LINE_CODE == BASICINFORMATION_data.LINE_CODE3)
{
SHIFT_CODE = BASICINFORMATION_data.SHIFT_CODE3;
}
else
{
SHIFT_CODE = RUNNING_BASIC_INFORMATION.SHIFT_CODE;
}
DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION = RUNNING_BASIC_INFORMATION;
DASHBOARD_SHOW_data.BASICINFORMATION_data = BASICINFORMATION_data;
if (string.IsNullOrEmpty(FACTORY_CD))
{
FACTORY_CD = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.FACTORY_CD;
}
if (string.IsNullOrEmpty(LINE_CODE))
{
LINE_CODE = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.LINE_CODE;
}
if (string.IsNullOrEmpty(SHIFT_CODE))
{
SHIFT_CODE = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.SHIFT_CODE;
}
if (TRX_DATE == null)
{
TRX_DATE = DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.TRX_DATE;
}
if (RUNNING_BASIC_INFORMATION.CHANGESHIFT.Equals("Y") == true)
{
return(DASHBOARD_SHOW_data);
}
//数据处理
dashboarddal.PROC_DASHBOARD_GET_PRODUCTION_QTY(FACTORY_CD, LINE_CODE);
if (Flag == 1 && (string.IsNullOrEmpty(FACTORY_CD) == false))
{ //启动时处理考勤
GETEMPLOYEEATTENDTIMEINSERT(FACTORY_CD, LINE_CODE, RUNNING_BASIC_INFORMATION.HR_MAX_TIME_DIFFERENCE.ToString(), RUNNING_BASIC_INFORMATION.HR_REFRESH_INTERVAL.ToString());
dashboarddal.PROC_DASHBOARD_GET_EMPLOYEE_ATTENDTIME(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, DASHBOARD_SHOW_data.RUNNING_BASIC_INFORMATION.Only1Line);
}
//end 数据处理
FN_DASHBOARD_SHOW_DATA_Result FN_DASHBOARD_SHOW_DATA_Result = new FN_DASHBOARD_SHOW_DATA_Result();
FN_DASHBOARD_SHOW_DATA_Result = dashboarddal.Get_DashBoard_Data(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, RUNNING_BASIC_INFORMATION.TARGET_TOTAL_QTY, RUNNING_BASIC_INFORMATION.TARGET_WORK_HOUR);
DASHBOARD_SHOW_data.FN_DASHBOARD_SHOW_DATA_Result = FN_DASHBOARD_SHOW_DATA_Result;
FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result = new FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result();
FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result = dashboarddal.Get_DashBoard_Previous_Data(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, RUNNING_BASIC_INFORMATION.TARGET_TOTAL_QTY, RUNNING_BASIC_INFORMATION.TARGET_WORK_HOUR);
DASHBOARD_SHOW_data.FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result = FN_DASHBOARD_SHOW_PREVIOUS_DATA_Result;
List <FN_DASHBOARD_TIME_INTERVAL_QTY_Result> FN_DASHBOARD_TIME_INTERVAL_QTY_Result = new List <FN_DASHBOARD_TIME_INTERVAL_QTY_Result>();
FN_DASHBOARD_TIME_INTERVAL_QTY_Result = dashboarddal.Get_DashBoard_Time_Interval_Qty(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE, RUNNING_BASIC_INFORMATION.TARGET_TOTAL_QTY, RUNNING_BASIC_INFORMATION.TARGET_WORK_HOUR);
DASHBOARD_SHOW_data.FN_DASHBOARD_TIME_INTERVAL_QTY_Result = FN_DASHBOARD_TIME_INTERVAL_QTY_Result;
List <DEFECT_TOP> DEFECT_TOP = new List <DEFECT_TOP>();
DEFECT_TOP = dashboarddal.Get_DEFECT_TOP(FACTORY_CD, LINE_CODE, SHIFT_CODE, TRX_DATE);
DASHBOARD_SHOW_data.DEFECT_TOP = DEFECT_TOP;
}
catch (Exception)
{
}
finally { }
return(DASHBOARD_SHOW_data);
}
