public static bool SetMachine_Yield(DateTime dateTime, string MES_Customer_Name, string MES_Station_Name, int num, int Machine_Station_UID) { bool isMachine_Yield = false; try { for (int i = 0; i < num; i++) { List <Machine_YieldDTO> Machine_YieldDTOs = new List <Machine_YieldDTO>(); List <Machine_Schedule_ConfigDTO> Machine_Schedule_ConfigDTOs = new List <Machine_Schedule_ConfigDTO>(); Machine_Schedule_ConfigDTO machine_Schedule_ConfigDTO = new Machine_Schedule_ConfigDTO(); DateTime startTime = dateTime.AddMinutes(i * 30); DateTime endTime = startTime.AddMinutes(30); machine_Schedule_ConfigDTO.MES_Customer_Name = MES_Customer_Name; machine_Schedule_ConfigDTO.MES_Station_Name = MES_Station_Name; machine_Schedule_ConfigDTO.StarTime = startTime; machine_Schedule_ConfigDTO.EndTime = endTime; machine_Schedule_ConfigDTO.Machine_Station_UID = Machine_Station_UID; machine_Schedule_ConfigDTO.Created_Date = DateTime.Now; Machine_Schedule_ConfigDTOs.Add(machine_Schedule_ConfigDTO); // var apiUrl = string.Format("pis/pdcaNgSummary?Customer={0}&Station={1}&StartTime={2}&EndTime={3}", "SHH-CTU-Housing", "Milan-HSG-UMP1", "2018-05-03 14:10", "2018-05-03 16:10"); // var apiUrl = string.Format("http://CNCTUG0IT777D:8080/pis/pdcaNgSummary?Customer={0}&Station={1}&StartTime={2}&EndTime={3}", MES_Customer_Name, MES_Station_Name, startTime.ToString("yyyy-MM-dd HH:mm"), endTime.ToString("yyyy-MM-dd HH:mm")); var apiUrl = string.Format("pis/pdcaNgSummary?Customer={0}&Station={1}&StartTime={2}&EndTime={3}", MES_Customer_Name, MES_Station_Name, startTime.ToString("yyyy-MM-dd HH:mm"), endTime.ToString("yyyy-MM-dd HH:mm")); var result = HttpGet(WebAPIPath + apiUrl); JObject josnData = (JObject)JsonConvert.DeserializeObject(result); var list = JsonConvert.DeserializeObject <List <MachineYield> >(josnData["data"].ToString()); SetMachine_YieldDTOs(list, Machine_YieldDTOs, Machine_Station_UID, startTime, endTime); //下面写执行插入语句.插入报表数据。 string message = InsertMachine_YieldAndMachineConfig(Machine_YieldDTOs, Machine_Schedule_ConfigDTOs); //AddMESSyncFailedLog("Machine", "机台数据同步", WebAPIPath + apiUrl, message); if (message != "SUCCESS") { AddMESSyncFailedLog("Machine", "机台数据同步", WebAPIPath + apiUrl, message); AddLog("Machine", "机台数据同步", message); } } isMachine_Yield = true; //下面写执行插入语句.插入报表数据。 // InsertMachine_YieldAndMachineConfig(Machine_YieldDTOs, Machine_Schedule_ConfigDTOs); } catch (Exception ex) { //获取错误信息 AddLog("Machine", "机台数据同步", ex.Message.ToString()); isMachine_Yield = false; } return(isMachine_Yield); }
/// <summary> /// 解析url 生成Machine_Schedule_ConfigDTO; /// </summary> /// <param name="apiurl"></param> /// <returns></returns> public Machine_Schedule_ConfigDTO GetMachine_Schedule_ConfigDTOs(string apiurl) { // "http://CNCTUG0WEBOA01:9800/pis/pdcaNgSummary?Customer=Milan-CTU-Housing&Station=Milan-Laser(Band)&StartTime=2018-05-18 07:30&EndTime=2018-05-18 08:00"; Machine_Schedule_ConfigDTO machine_Schedule_ConfigDTO = new Machine_Schedule_ConfigDTO(); var strMachine_Schedule_ConfigDTO = apiurl.Substring(apiurl.LastIndexOf("?") + 1); var machine_Schedule_ConfigDTOs = strMachine_Schedule_ConfigDTO.Split('&'); string Customer = machine_Schedule_ConfigDTOs[0].Substring(machine_Schedule_ConfigDTOs[0].LastIndexOf("=") + 1); string Station = machine_Schedule_ConfigDTOs[1].Substring(machine_Schedule_ConfigDTOs[1].LastIndexOf("=") + 1); string StartTime = machine_Schedule_ConfigDTOs[2].Substring(machine_Schedule_ConfigDTOs[2].LastIndexOf("=") + 1); string EndTime = machine_Schedule_ConfigDTOs[3].Substring(machine_Schedule_ConfigDTOs[3].LastIndexOf("=") + 1); machine_Schedule_ConfigDTO.StarTime = Convert.ToDateTime(StartTime); machine_Schedule_ConfigDTO.EndTime = Convert.ToDateTime(EndTime); machine_Schedule_ConfigDTO.MES_Customer_Name = Customer; machine_Schedule_ConfigDTO.MES_Station_Name = Station; machine_Schedule_ConfigDTO.Machine_Station_UID = GetMachine_Station_UID(Customer, Station); machine_Schedule_ConfigDTO.Created_Date = DateTime.Now; return(machine_Schedule_ConfigDTO); }