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