/// <summary>
/// 保存一天的CSV文件
/// </summary>
/// <param name="Door">门号</param>
/// <param name="Way">路径</param>
public static void PaeserveInfo(int Door, string Way)
{
string BeginTime = Convert.ToString(DateTime.Now.AddDays(0).ToString("yyyy-MM-dd 00:00:00"));
string EndTime = Convert.ToString(DateTime.Now.AddDays(0).ToString("yyyy-MM-dd 23:59:59"));
try
{
string sql = string.Format(@"select * from [dbo.tb_MachineStatus] where [Door] like '%{0}%'and [WriteTime] >= '{1}' and [WriteTime] <= '{2}'", Door, BeginTime, EndTime);
DataTable dt = SqlServerHelp.Query(sql).Tables[0];
//DataTable dt = new DataTable();
// dt = SqlServerHelp.Query(sql).Tables[0];
dt.Columns["id"].ColumnName = "ID";
dt.Columns["WriteTime"].ColumnName = "采集时间";
dt.Columns["Door"].ColumnName = "门号";
dt.Columns["UpperLimitOfTemperature"].ColumnName = "上限温度";
dt.Columns["LowerTemperatureLimit"].ColumnName = "下限温度";
dt.Columns["SetValueMonitoringTemperature"].ColumnName = "设定温度";
dt.Columns["MonitoringTemperature"].ColumnName = "监控温度";
dt.Columns["RunTime"].ColumnName = "运行时间";
dt.Columns["SetTime"].ColumnName = "设定时间";
Common.CSVHelper.SaveCSV(dt, Way);//保存CSV文件
}
catch (Exception ex) { }
}
/// <summary>
/// 修改MES校验接口配置
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static int UploadCheckoutMES(List <string> list)
{
String Sql = string.Format(@"Update [dbo.tb_MES] set ElectricCore_WSDL='{0}', ElectricCore_TimeOut='{1}', ElectricCore_User='******',
ElectricCore_Password='******' ,ElectricCore_site='{4}'", list[0], list[1], list[2], list[3], list[4]);
int conn = SqlServerHelp.ExecuteSql(Sql);
return(conn);
}
/// <summary>
/// 修改系统配置
/// </summary>
/// <param name="COM">端口号</param>
/// <param name="RefreshTime">刷新时间</param>
/// <param name="SetCSV">CSV保存路径</param>
/// <returns></returns>
public static int SysetInfo(List <string> List)
{
string Setsql = string.Format(@"Update tb_syset set Prefix='{0}', Plc_ip='{1}', ComAddress='{2}',
Renovate='{3}' ,[CSV_log]='{4}',Cancellation='{5}'", List[0], List[1], List[2], List[3], List[4], List[5]);
int conn = SqlServerHelp.ExecuteSql(Setsql);
return(conn);
}
/// <summary>
/// 报警日志错误查询
/// </summary>
/// <param name="LineNumber"></param>
/// <param name="timeBegin"></param>
/// <param name="timeEnd"></param>
/// <returns></returns>
public static DataTable InquiryError(string LineNumber, string timeBegin, string timeEnd)
{
string sql = string.Format(@"select top {0}*from dbo.[dbo.tb_Error] where [ErrorTime] >= '{1}' and [ErrorTime] <= '{2}'", LineNumber, timeBegin, timeEnd);
//sql查询语句，注意查询命令不能加 % 号
//语法and [SyTime] >= '{2}' and [SyTime] <= '{3}'"
connError = SqlServerHelp.Query(sql).Tables[0];
return(connError);
}
// string Prefix, string Plc_ip, string COM, string RefreshTime, string SetCSV
/// <summary>
/// 修改炉子资源号配置
/// </summary>
/// <param name="List"></param>
public static int ResourceNumberSet(List <string> List)
{
string Setsql = string.Format(@"Update [dbo.tb_MES] set ResourceNumberOne='{0}', ResourceNumberTwo='{1}', ResourceNumberThree='{2}',
ResourceNumberFour='{3}' ,ResourceNumberFive='{4}', ResourceNumberSix='{5}' ,ResourceNumberSeven='{6}' ,ResourceNumberEight='{7}'",
List[0], List[1], List[2], List[3], List[4], List[5], List[6], List[7]);
int conn = SqlServerHelp.ExecuteSql(Setsql);
return(conn);
}
/// <summary>
/// 查询采集温度
/// </summary>
/// <param name="Door">门号</param>
/// <param name="LineNumber">查询行数</param>
/// <param name="timeBegin">查询开始时间</param>
/// <param name="timeEnd">查询停止时间</param>
/// <returns></returns>
public static DataTable Inquiry(string Door, string LineNumber, string timeBegin, string timeEnd)
{
string sql = string.Format(@"select top {0}*from dbo.[dbo.tb_MachineStatus]
where [Door] like '%{1}%'and [WriteTime] >= '{2}'
and [WriteTime] <= '{3}'", LineNumber, Door, timeBegin, timeEnd);
//sql查询语句，注意查询命令不能加 % 号
//语法and [SyTime] >= '{2}' and [SyTime] <= '{3}'"
conn = SqlServerHelp.Query(sql).Tables[0];
return(conn);
}
/// <summary>
/// 修改MES收数接口配置
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static int UploadChargeNumberMES(List <string> list)
{
String Sql = string.Format(@"Update [dbo.tb_MES] set ChargeNumber_WSDL='{0}', ChargeNumber_TimeOut='{1}', ChargeNumber_User='******',
ChargeNumber_Password='******',ChargeNumber_site='{4}', ChargeNumber_Operation='{5}',ChargeNumber_OperationRevision='{6}',
ChargeNumber_ActivityId='{7}',ChargeNumber_IsDispositionRequired='{8}',ChargeNumber_DcGroup='{9}',
ChargeNumber_DcGroupRevision='{10}'", list[0], list[1], list[2], list[3], list[4],
list[5], list[6], list[7], list[8], list[9], list[10]);
int conn = SqlServerHelp.ExecuteSql(Sql);
return(conn);
}
/// <summary>
/// 采集到的温度写入数据库
/// </summary>
/// <param name="stove">机器号</param>
/// <param name="storey">机器层数</param>
/// <param name="RunStatus">机器运行状态</param>
/// <param name="data">机器温度集合</param>
/// <param name="id">数据库id</param>
public static void UpdateInfo(int stove, int storey, string RunStatus, List <double> data, int id)
{
string str = "";
for (int i = 0; i < data.Count; i++)
{
str += "0" + data[i] + ",";
}
string sql = string.Format(@"update dbo_Rur set stove='{0}',storey='{1}',RunStatus='{2}',temperature='{3}',UpdateTime='{4}' where id='{5}' ",
stove, storey, RunStatus, str, DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), id);
SqlServerHelp.ExecuteSql(sql);
}
/// <summary>
/// 查询MES系统配置
/// </summary>
/// <returns></returns>
public static DataSet GetSysConfigMES()
{
string sql = string.Format(@"select * from [dbo.tb_MES] ");
return(SqlServerHelp.DtQuery(sql));
}
/// <summary>
/// 查询系统配置
/// </summary>
/// <returns></returns>
public static DataSet GetSysConfig()
{
string sql = string.Format(@"select * from tb_SySet ");
return(SqlServerHelp.DtQuery(sql));
}