public DataAcquisitionResult SaveRunningState([FromBody] RunningStateAPIParameterA param) { DataAcquisitionResult result = new DataAcquisitionResult(); result.code = "1000"; result.msg = "success"; if (param == null) { param = new RunningStateAPIParameterA(); 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-SaveRunningState 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); } RunningStateDTOA dto = new RunningStateDTOA(); try { dto = Deserialize <RunningStateDTOA>(param.strdata); bool fla = InsertRunningState(dto); if (!fla) { LogHelper.Error(string.Format("新增失败-SaveRunningState:{0}", Serialize(dto))); //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; } }
public bool InsertRunningState(RunningStateDTOA dto) { bool fla = false; try { int re = 0; DbService ds = new DbService(dbnfin, "MySQL"); string str1 = string.Format(@"SELECT * from Sys_RunningState WHERE IsEffective=1;"); bool sult1 = ds.IsExistRecord(str1); if (sult1) { string srt = 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", dto.Describe1, dto.DescribeColor1, dto.Describe2, dto.DescribeColor2, dto.Describe3, dto.DescribeColor3, dto.Describe4, dto.DescribeColor4, dto.Describe5, dto.DescribeColor5, dto.Describe6, dto.DescribeColor6); int sult = ds.InsertSql(srt, out re); if (sult > 0) { fla = true; } } else { string srt = string.Format(@"INSERT INTO Sys_RunningState(Picture_Tip,Picture_Url,Describe1,DescribeColor1,Describe2,DescribeColor2,Describe3,DescribeColor3,Describe4,DescribeColor4,Describe5,DescribeColor5,Describe6,DescribeColor6,CreationTime) VALUES ( '测试显示','/Content/img/product/runningstate/01.png','{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',NOW())", dto.Describe1, dto.DescribeColor1, dto.Describe2, dto.DescribeColor2, dto.Describe3, dto.DescribeColor3, dto.Describe4, dto.DescribeColor4, dto.Describe5, dto.DescribeColor5, dto.Describe6, dto.DescribeColor6); int sult = ds.InsertSql(srt, out re); if (sult > 0) { fla = true; } } } catch (Exception ex) { LogHelper.Error(ex.Message); } return(fla); }