We_Message/MqttMsgServer/Model/Client.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ConsoleHttp.Model;

namespace MqttMsgServer.Model
{
    [Table("Clients")]
    public class ClientInfos:CreatorEntity<string>
    {
        public const int ClientNameMaxLength = 32;
        public const int RunningNoMaxLength = 50;
        public const int PasswordMaxLength = 150;
        public const int SystemDescMaxLength = 500;

        [MaxLength(ClientNameMaxLength)]
        public string ClientName { get; set; }

        [MaxLength(PasswordMaxLength)]
        public string Password { get; set; }
        [MaxLength(SystemDescMaxLength)]
        public string SystemDesc { get; set; }

        public int Hours { get; set; } = 24;

        [MaxLength(RunningNoMaxLength)]
        public string RunningNo { get; set; }
        [MaxLength(RunningNoMaxLength)]
        public string RunningNoEx { get; set; }
        [MaxLength(RunningNoMaxLength)]
        public string RunningNoEx2 { get; set; }

        public int ClientState { get; set; }

        public string InsertSql()
        {
            return
                $"insert INTO Clients(Id,ClientName,Password,RunningNo,RunningNoEx,RunningNoEx2,Hours,ClientState,SystemDesc,CreatorDate,CreatorUserId) values('{Id}','{ClientName}','{Password}','{RunningNo}','{RunningNoEx}','{RunningNoEx2}',{Hours},{ClientState},'{SystemDesc}','{CreatorDate}',{CreatorUserId})";
        }
        public string UpdateSql()
        {
            return
                $"update Clients set ClientName='{ClientName}',Password='{Password}',RunningNo='{RunningNo}',RunningNoEx='{RunningNoEx}',RunningNoEx2='{RunningNoEx2}',Hours={Hours},ClientState={ClientState},SystemDesc='{SystemDesc}' where Id='{Id}'";
        }

        public string DeleteSql()
        {
            return $"Delete from Clients where Id='{Id}'";
        }
    }
}