public static ContractAmpere GetAmpere(string contract)
        {
            Regex reg         = new Regex(@"[^0-9]");
            var   contractNum = Int32.Parse(reg.Replace(contract, "").ToString());

            reg = new Regex(@"[^A-Z]");
            var unitStr = reg.Replace(contract, "").ToString();

            var sql = @"
SELECT TOP 1 * FROM ContractAmpere
WHERE Ampere = (

SELECT MIN(Ampere) FROM ContractAmpere
WHERE Contract >= " + contractNum + @" AND
      Unit = '" + unitStr + "')";

            var db     = ContractAmpere.GetDatabase();
            var result = db.ExecuteQuery <ContractAmpere>(sql);

            if (result.Count > 0)
            {
                return(result[0]);
            }
            else
            {
                return(null);
            }
        }
        public static string GetHinban(decimal ampere)
        {
            var sql = @"
SELECT Hinban FROM ContractAmpere
WHERE Ampere = (

SELECT MIN(Ampere) FROM ContractAmpere
WHERE Ampere >= " + ampere + ")";

            var db = ContractAmpere.GetDatabase();

            return(db.ExecuteScalar(sql).ToString());
        }
        public static ContractAmpere GetExtensionAmpere(string ampere)
        {
            Regex reg       = new Regex(@"[^0-9]");
            var   ampereNum = Int32.Parse(reg.Replace(ampere, "").ToString());

            var sql = @"
SELECT TOP 1 * FROM ContractAmpere
WHERE Ampere = (

SELECT MIN(Ampere) FROM ContractAmpere
WHERE Ampere > " + ampereNum + ")";

            var db     = ContractAmpere.GetDatabase();
            var result = db.ExecuteQuery <ContractAmpere>(sql);

            if (result.Count > 0)
            {
                return(result[0]);
            }
            else
            {
                return(null);
            }
        }