using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using Dapper;

using MySql.Data.MySqlClient;

using System.Security.Permissions;

​

​

public class Program

{

    public static void Main()

    {

        var year = "2020";

​

        Console.WriteLine(year.Trim(Convert.ToChar("2")).Trim(Convert.ToChar("0")));

    }

}

​

​

public class Dept

{

    /// <summary>

    /// DpetNo

    /// </summary>

    public int DeptNo { get; set; }

    /// <summary>

    /// DName

    /// </summary>

    public string DName { get; set; }

    /// <summary>

    /// Location

    /// </summary>

    public string Location { get; set; }

​

 }

​

​

public class DeptService

{

    private readonly MySqlConnection _conn;

​

        private string _connectionString = "Server=192.168.10.8;Database=cmdev;Uid=root;Pwd=mayday00066;";

        public DeptService()

        {

​

            _conn = new MySqlConnection(_connectionString);

        }

        public IEnumerable<Dept> GetDept()

        {

            var sql = "SELECT DeptNo,DName,Location FROM Dept";

            var result = this._conn.Query<Dept>(sql).ToList();

            return result;

        }

​

        public Dept GetDeptByDeptNo(int deptNo)

        {

            var sql = "SELECT DeptNo,DName,Location FROM Dept WHERE DeptNo = @DeptNo";

            var result = this._conn.Query<Dept>(sql, new { DeptNo = deptNo }).FirstOrDefault();

            return result;

        }

}