/// <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);
}
// 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>
/// 修改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);
}
