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 SqlSystemUser
        {
            /// <summary>
            /// 查看所有项目
            /// </summary>
            /// <returns></returns>
            public static DataTable Select_SystemUser(string userName,string userPassword)
            {
                string sql = 
                    $" SELECT TOP 1 [UserID],[UserName],[UserPassword],[Jurisdiction],[ProjectList],[OperationTime] FROM [SystemUser]" +
                    $" WHERE [UserName] = '{userName}' AND [UserPassword] = '{userPassword}'";
                ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);
                return ds.Tables[0];
            }

            public static DataTable Select_SystemUserTable()
            {
                string sql =
                    $" SELECT [UserID],[UserName],[UserPassword],[Jurisdiction],[ProjectList],[OperationTime] FROM [SystemUser]";
                ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);
                return ds.Tables[0];
            }




        }


    }
}