53 lines
1.6 KiB
C#
53 lines
1.6 KiB
C#
using Global;
|
|
using njc = Newtonsoft.Json.JsonConvert;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
//using wfmt = System.Windows.Forms.MessageBox;
|
|
using System.IO;
|
|
using System.Text;
|
|
using static DtWebApiDT.DataAccess;
|
|
//using static SqlManage.ExecSql;
|
|
using Newtonsoft.Json;
|
|
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
namespace DTTest
|
|
{
|
|
/// <summary>
|
|
/// 对于数据库的操作
|
|
/// </summary>
|
|
public partial class SqlOperation
|
|
{
|
|
/// <summary>
|
|
/// 项目的操作
|
|
/// </summary>
|
|
public class SqlSignal
|
|
{
|
|
/// <summary>
|
|
/// 查看所有项目
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static DataTable SelectProjectAll()
|
|
{
|
|
string sql = $"SELECT [CurrentProject],[ProjectName],[OperationTime],[ProjectCode] FROM [ProjectList]" +
|
|
$" ORDER BY [OperationTime] DESC";
|
|
ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);
|
|
return ds.Tables[0];
|
|
}
|
|
|
|
public static bool UpdateSignalsResources(string resourceCode, List<string> signalIdList)
|
|
{
|
|
var sqls = "";
|
|
foreach (var signalId in signalIdList)
|
|
{
|
|
var sql = "UPDATE SignalViewer SET Resources = '" + resourceCode + "' WHERE DeviceCode = '" + signalId + "';\n";
|
|
sqls += sql;
|
|
}
|
|
return ExecuteNonQuery(sqls, PP.ConnectionStr, out string errorMessage);
|
|
}
|
|
}
|
|
}
|
|
}
|