public DataAcquisitionResult DeleteTaskList([FromBody] TaskListAPIParameterB param) { //记时 LogHelper.Info("DeleteTaskList--开始"); Stopwatch timeWatcher = new Stopwatch(); long checkTime = 0; timeWatcher.Restart(); //开始计时 DataAcquisitionResult result = new DataAcquisitionResult(); result.code = "1000"; result.msg = "success"; if (param == null) { param = new TaskListAPIParameterB(); this.Request.GetQueryNameValuePairs(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 param.operator_name = request.Form["operator_name"]; param.operator_time = request.Form["operator_time"]; param.sign = request.Form["sign"]; param.strdata = request.Form["strdata"]; LogHelper.Info("WebApi-DeleteTaskList param from forms"); } if (!VerifyMiddleSign(param.operator_name, param.operator_time, param.sign)) { LogHelper.Info(string.Format("operator_name{0},operation_time{1},sign{2}", param.operator_name, param.operator_time, param.sign)); result.msg = "签名错误"; result.code = "1040"; return(result); } List <TaskListBDTO> dto = new List <TaskListBDTO>(); try { dto = Deserialize <List <TaskListBDTO> >(param.strdata); foreach (var item in dto) { bool fla = DeleteTaskList(item); if (!fla) { LogHelper.Error(string.Format("删除失败-DeleteTaskList:{0}", Serialize(item))); } } } catch (Exception ex) { LogHelper.Error(ex.Message); result.msg = ex.Message; result.code = "1060"; return(result); } timeWatcher.Stop();//结束计时 checkTime = timeWatcher.ElapsedMilliseconds; LogHelper.Info(string.Format("DeleteTaskList--结束,执行时间:{0} ", checkTime)); return(result); }
public DataAcquisitionResult SaveDataAcquisitionJiadongRate([FromBody] DataAcquisitionJiadongRateAPIParameter param) { DataAcquisitionResult result = new DataAcquisitionResult(); result.code = "1000"; result.msg = "success"; if (param == null) { param = new DataAcquisitionJiadongRateAPIParameter(); this.Request.GetQueryNameValuePairs(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 param.operator_name = request.Form["operator_name"]; param.operator_time = request.Form["operator_time"]; param.sign = request.Form["sign"]; param.strdata = request.Form["strdata"]; LogHelper.Info("WebApi-SaveDataAcquisitionJiadongRate param from forms"); } //else LogHelper.Info(string.Format("WebApi-SaveDataAcquisition param from body{0}", Serialize(param))); if (!VerifyMiddleSign(param.operator_name, param.operator_time, param.sign)) { LogHelper.Info(string.Format("operator_name{0},operation_time{1},sign{2}", param.operator_name, param.operator_time, param.sign)); result.msg = "签名错误"; result.code = "1040"; return(result); } List <DataAcquisitionJiadongRateDTO> dto = new List <DataAcquisitionJiadongRateDTO>(); try { dto = Deserialize <List <DataAcquisitionJiadongRateDTO> >(param.strdata); foreach (var item in dto) { bool fla = UpdateDataAcquisitionJiadongRate(item); if (!fla) { LogHelper.Error(string.Format("更新失败-SaveDataAcquisitionJiadongRate:{0}", Serialize(item))); //result.msg = "数据更新失败"; //result.code = "1050"; //return result; } } } catch (Exception ex) { LogHelper.Error(ex.Message); result.msg = ex.Message; result.code = "1060"; return(result); } return(result); }
private void button6_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); RunningStateDTOA dto = new RunningStateDTOA(); dto.Describe1 = "CNC1发那科<br>运行中"; dto.DescribeColor1 = "#23ab33"; dto.Describe2 = "CNC2发那科<br>运行中"; dto.DescribeColor2 = "#23ab33"; dto.Describe3 = "CNC3发那科<br>待机"; dto.DescribeColor3 = "yellow"; dto.Describe4 = "CMM2海克斯康<br>离线"; dto.DescribeColor4 = "#c8c8c8"; dto.Describe5 = "Robot<br>未就绪"; dto.DescribeColor5 = "#0fcdfd"; dto.Describe6 = "清洗机<br>待机"; dto.DescribeColor6 = "#0865e3"; string server = "http://localhost:15988/api/AutomationLine/SaveRunningState"; RunningStateAPIParameterA param = new RunningStateAPIParameterA(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dto; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
private void button2_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); List <DataAcquisitionDetailDTO> dtos = new List <DataAcquisitionDetailDTO>(); DataAcquisitionDetailDTO dto = new DataAcquisitionDetailDTO(); dto.devicename = "CNC1发那科"; dto.spindlespeed = 1100; dto.feedspeed = 8000; dto.runtime = DateTime.Now.ToString(); dtos.Add(dto); dto = new DataAcquisitionDetailDTO(); dto.devicename = "CNC2发那科"; dto.spindlespeed = 1100; dto.feedspeed = 8000; dto.runtime = DateTime.Now.ToString(); dtos.Add(dto); string server = "http://localhost:15988/api/AutomationLine/SaveDataAcquisitionDetail"; DataAcquisitionDetailAPIParameter param = new DataAcquisitionDetailAPIParameter(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dtos; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
private void button3_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); List <EquipmentListOneDTO> dtos = new List <EquipmentListOneDTO>(); EquipmentListOneDTO dto = new EquipmentListOneDTO(); dto.equipmentname = "CNC01"; dto.moldno = "JD1"; dto.workpiecesname = "JDM-007"; dto.colour = "red"; dtos.Add(dto); dto = new EquipmentListOneDTO(); dto.equipmentname = "CNC02"; dto.moldno = "JD2"; dto.workpiecesname = "JDM-008"; dto.colour = "yellow"; dtos.Add(dto); string server = "http://localhost:15988/api/TeamTask/SaveEquipmentMachining"; EquipmentListAPIParameterA param = new EquipmentListAPIParameterA(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dtos; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
private void button5_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); List <TaskListDTO> dtos = new List <TaskListDTO>(); TaskListDTO dto = new TaskListDTO(); dto.processid = 1008; dto.state = "yellow"; dtos.Add(dto); dto = new TaskListDTO(); dto.processid = 1010; dto.state = "red"; dtos.Add(dto); string server = "http://localhost:15988/api/TeamTask/SaveTaskListColour"; TaskListAPIParameter param = new TaskListAPIParameter(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dtos; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
private void button8_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); RunningStateDTOB dto = new RunningStateDTOB(); dto.Describe7 = "38;2;3;0;0;10"; dto.DescribeColor7 = "#D24D57;#26A65B;#EB7347;#84AF9B;#FC9D99;#00CCFF"; dto.Describe8 = "39;0;29;0;0;20"; dto.DescribeColor8 = "#D24D57;#26A65B;#EB7347;#84AF9B;#FC9D99;#00CCFF"; string server = "http://localhost:15988/api/AutomationLine/SaveRunningStateStockBin"; RunningStateAPIParameterB param = new RunningStateAPIParameterB(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dto; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
private void button1_Click(object sender, EventArgs e) { DataAcquisitionResult result = new DataAcquisitionResult(); List <DataAcquisitionEntity> dtos = new List <DataAcquisitionEntity>(); DataAcquisitionEntity dto = new DataAcquisitionEntity(); dto.DeviceName = "CNC1发那科"; dto.DeviceRunStatus = "运行中"; dto.DeviceUrl = ""; dto.DeviceLndicatorLight = "yellow"; dto.TodayOutput = 10; dto.TodayJiadong = 10; dto.SpindleSpeed = 10; dto.FeedSpeed = 10; dto.SpindleRatio = 10; dto.FeedRatio = 10; dto.LoadRatio = 10; dtos.Add(dto); dto = new DataAcquisitionEntity(); dto.DeviceName = "CNC2发那科"; dto.DeviceRunStatus = "宕机"; dto.DeviceUrl = ""; dto.DeviceLndicatorLight = "red"; dto.TodayOutput = 0; dto.TodayJiadong = 0; dto.SpindleSpeed = 0; dto.FeedSpeed = 0; dto.SpindleRatio = 0; dto.FeedRatio = 0; dto.LoadRatio = 0; dtos.Add(dto); string server = "http://localhost:15988/api/AutomationLine/SaveDataAcquisition"; DataAcquisitionAPIParameter param = new DataAcquisitionAPIParameter(); param.operator_name = "WebApi"; param.operator_time = GenerateTimeStamp(DateTime.Now); param.sign = GenSign(param.operator_name, param.operator_time); param.data = dtos; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("operator_name", param.operator_name); dic.Add("operator_time", param.operator_time); dic.Add("sign", param.sign); dic.Add("strdata", Serialize(param.data)); try { HttpWebResponse response = CreatePostHttpResponse(server, dic, null, null, Encoding.UTF8, null); System.IO.StreamReader sr = new System.IO.StreamReader(response.GetResponseStream()); string responseContent = sr.ReadToEnd(); sr.Close(); DataAcquisitionResult rtn = Deserialize <DataAcquisitionResult>(responseContent); if (rtn.code != "1000") { return; } } catch (Exception ex) { return; } }
public DataAcquisitionResult SaveDataAcquisition([FromBody] DataAcquisitionAPIParameter param) { DataAcquisitionResult result = new DataAcquisitionResult(); result.code = "1000"; result.msg = "success"; if (param == null) { param = new DataAcquisitionAPIParameter(); this.Request.GetQueryNameValuePairs(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 param.operator_name = request.Form["operator_name"]; param.operator_time = request.Form["operator_time"]; param.sign = request.Form["sign"]; param.strdata = request.Form["strdata"]; LogHelper.Info("WebApi-SaveDataAcquisition param from forms"); } //else LogHelper.Info(string.Format("WebApi-SaveDataAcquisition param from body{0}", Serialize(param))); if (!VerifyMiddleSign(param.operator_name, param.operator_time, param.sign)) { LogHelper.Info(string.Format("operator_name{0},operation_time{1},sign{2}", param.operator_name, param.operator_time, param.sign)); result.msg = "签名错误"; result.code = "1040"; return(result); } List <DataAcquisitionEntity> dto = new List <DataAcquisitionEntity>(); try { string o1 = ""; string o2 = ""; string o3 = ""; string o4 = ""; string o5 = ""; string o6 = ""; string c1 = ""; string c2 = ""; string c3 = ""; string c4 = ""; string c5 = ""; string c6 = ""; dto = Deserialize <List <DataAcquisitionEntity> >(param.strdata); foreach (var item in dto) { bool fla = InsertDataAcquisition(item); if (!fla) { LogHelper.Error(string.Format("新增失败-SaveDataAcquisition:{0}", Serialize(item))); //result.msg = "数据插入失败"; //result.code = "1050"; //return result; } if (item.DeviceName == "CNC1发那科") { o1 = item.DeviceName + "<br>" + item.DeviceRunStatus; c1 = Colour(item.DeviceRunStatus); } else if (item.DeviceName == "CNC2发那科") { o2 = item.DeviceName + "<br>" + item.DeviceRunStatus; c2 = Colour(item.DeviceRunStatus); } else if (item.DeviceName == "CNC3发那科") { o3 = item.DeviceName + "<br>" + item.DeviceRunStatus; c3 = Colour(item.DeviceRunStatus); } else if (item.DeviceName == "Robot") { o4 = item.DeviceName + "<br>" + item.DeviceRunStatus; c4 = Colour(item.DeviceRunStatus); } else if (item.DeviceName == "清洗机") { o5 = item.DeviceName + "<br>" + item.DeviceRunStatus; c5 = Colour(item.DeviceRunStatus); } else if (item.DeviceName == "CMM2海克斯康") { o6 = item.DeviceName + "<br>" + item.DeviceRunStatus; c6 = Colour(item.DeviceRunStatus); } } #region Sys_RunningState 运行状态 if (!string.IsNullOrEmpty(o1)) { try { int re = 0; DbService ds = new DbService(dbnfin, "MySQL"); string str = string.Format(@"SELECT * from Sys_RunningState WHERE IsEffective=1;"); bool sult = ds.IsExistRecord(str); if (sult) { string str1 = string.Format(@"UPDATE Sys_RunningState SET Describe1='{0}',DescribeColor1='{1}',Describe2='{2}',DescribeColor2='{3}',Describe3='{4}',DescribeColor3='{5}', Describe4='{6}',DescribeColor4='{7}',Describe5='{8}',DescribeColor5='{9}',Describe6='{10}',DescribeColor6='{11}' Where IsEffective=1", o1, c1, o2, c2, o3, c3, o4, c4, o5, c5, o6, c6); int sult1 = ds.InsertSql(str1, out re); if (sult1 <= 0) { LogHelper.Error(string.Format("修改语句错误-Sys_RunningState:{0}", str1)); } } else { string str1 = string.Format(@"INSERT INTO Sys_RunningState(Picture_Url,Describe1,DescribeColor1,Describe2,DescribeColor2,Describe3,DescribeColor3,Describe4,DescribeColor4,Describe5,DescribeColor5,Describe6,DescribeColor6,CreationTime) VALUES( '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',NOW())", "/Content/img/product/runningstate/01.png", o1, c1, o2, c2, o3, c3, o4, c4, o5, c5, o6, c6); int sult1 = ds.InsertSql(str1, out re); if (sult1 <= 0) { LogHelper.Error(string.Format("新增语句错误-Sys_RunningState:{0}", str1)); } } } catch (Exception ex) { LogHelper.Error(ex.Message); } } #endregion } catch (Exception ex) { LogHelper.Error(ex.Message); result.msg = ex.Message; result.code = "1060"; return(result); } return(result); }