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);
}
