using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace AinB
{
internal class Meth
{
//校验输入字符
public bool NotNull(string Str)
{
bool bl = false;
Str = Str.Trim();
if (Str.Length == 0 || Str == "")
{
bl = true;
MessageBox.Show("用户未输入信息!");
}
else if (Str.Substring(0, 3) == "[)>")
{
if (Str.Substring(5, 2) != "LU" || Str.Substring(5, 2) != "Lu" || Str.Substring(5, 2) != "lU" || Str.Substring(5, 2) != "lu")
{
bl = true; MessageBox.Show("输入的SN不正确!请确认!");
}
}
else if (Str.Substring(0, 1) == "H")
{
if (Str.Length != 15)
{
bl = true; MessageBox.Show("输入的MO不正确!请确认!");
}
}
else if (Str.Substring(0, 4) == "0000")
{
if (Str.Length != 14)
{
bl = true; MessageBox.Show("输入的MO不正确!请确认!");
}
}
else { bl= false; MessageBox.Show("输入特殊或非法字符!"); }
return bl;
}
//连接数据库方法,入参为区域,SN或MO
public DataTable MacInfo(string ST, string SN)
{
string SQL = $"exec PROC_MOorSN '{SN}'";
DataTable macInfo = new DataTable();
macInfo = null;
SqlConnection conn;
if (ST == "ST")
{
conn = new SqlConnection("Data Source=192.168.XX.XX;User ID=SA;Password=PWD;Initial Catalog=UD_LEO");
}
SqlCommand cmd = new SqlCommand(SQL, conn);
SqlDataReader dr=cmd.ExecuteReader();
conn.Open();
if(conn.State== System.Data.ConnectionState.Closed) { MessageBox.Show($"{ST}产区连接失败,请检查网络链接!"); }
if (dr.Read()) { }else { MessageBox.Show($"输入的{SN}在产区{ST}找不到记录,请检查!"); }
conn.Close();
SqlDataAdapter ada = new SqlDataAdapter(SQL, conn);
ada.Fill(macInfo);
//if (macInfo != null) { return macInfo; } else { MessageBox.Show($"输入的{SN}在产区{ST}找不到记录,请检查!"); }
return macInfo;
}
//校验变量是否为数组和字母组成
public bool Str_Int(string User, int MaxLen, int MinLen)
{
bool Result = false;
string pattern = @"^[a-zA-Z0-9]*$";
if (User.Length > MinLen && User.Length < MaxLen)
{
if (System.Text.RegularExpressions.Regex.IsMatch(User, pattern))
{
Result = true;
//Debug.WriteLine();
//MessageBox.Show("格式正确!");
}
else
{
Result = false;// Debug.WriteLine("格式错误!");
//MessageBox.Show("格式错误!");
}
}
else
{
Result = false;
//Debug.WriteLine("格式长度非法!");
// MessageBox.Show("格式长度非法!");
}
return Result;
}
}
}