76 lines
2.7 KiB
C#
76 lines
2.7 KiB
C#
using bizFacade;
|
|
using DataLinkMesWork;
|
|
using DoWhatPlc;
|
|
using MesServerWork;
|
|
using Newtonsoft.Json;
|
|
using System;
|
|
using System.Collections;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace MisDataSaveDate
|
|
{
|
|
public partial class Funtion
|
|
{
|
|
|
|
private static void Alarm_Insert(ReturnValueString rv)
|
|
{
|
|
string TagID;
|
|
string opName;
|
|
string tagTypeID;
|
|
int TagValue;
|
|
|
|
DateTime alarmStartTime;
|
|
DateTime alarmEndTime;
|
|
int TimeDiff;
|
|
string TagOrderBy;
|
|
string Text1;
|
|
string Text2;
|
|
TagID = rv.TagID;
|
|
tagTypeID = rv.TagTypeID;
|
|
opName = rv.OpName;
|
|
TagValue = Convert.ToInt32(rv.TagValue);
|
|
|
|
alarmStartTime = Convert.ToDateTime(rv.TimeStampBefore);
|
|
alarmEndTime = Convert.ToDateTime(rv.TimeStamp);
|
|
TimeDiff = Convert.ToInt32(rv.TagKeepTime);
|
|
TagOrderBy = rv.TagOrderBy;
|
|
Text1 = rv.ItemName;
|
|
Text2 = rv.ShaftID;
|
|
|
|
Alarm_Insert(TagID, tagTypeID, opName, TagValue,
|
|
alarmStartTime, alarmEndTime, TimeDiff, Text1, Text2, TagOrderBy);
|
|
}
|
|
|
|
public static bool Alarm_Insert(string TagID, string tagTypeID, string opName, int TagValue,
|
|
DateTime alarmStartTime, DateTime alarmEndTime, int TimeDiff,
|
|
string Text1, string Text2, string TagOrderBy)
|
|
{
|
|
|
|
|
|
string produceName = "测量数据工位报警全部_增加数据";
|
|
SqlParameter[] thisParms = new SqlParameter[10];
|
|
thisParms[0] = new System.Data.SqlClient.SqlParameter("@TagID", TagID);
|
|
thisParms[1] = new System.Data.SqlClient.SqlParameter("@TagTypeID", tagTypeID);
|
|
thisParms[2] = new System.Data.SqlClient.SqlParameter("@opName", opName);
|
|
thisParms[3] = new System.Data.SqlClient.SqlParameter("@TagValue", TagValue);
|
|
thisParms[4] = new System.Data.SqlClient.SqlParameter("@alarmStartTime", alarmStartTime);
|
|
thisParms[5] = new System.Data.SqlClient.SqlParameter("@alarmEndTime", alarmEndTime);
|
|
thisParms[6] = new System.Data.SqlClient.SqlParameter("@TimeDiff", TimeDiff);
|
|
thisParms[7] = new System.Data.SqlClient.SqlParameter("@Text1", Text1);
|
|
thisParms[8] = new System.Data.SqlClient.SqlParameter("@Text2", Text2);
|
|
thisParms[9] = new System.Data.SqlClient.SqlParameter("@TagOrderBy", TagOrderBy);
|
|
if (DataAccess.ExecuteStoredProcedure(produceName, ref thisParms))
|
|
{
|
|
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
}
|
|
}
|