886 lines
32 KiB
C#
886 lines
32 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Text.RegularExpressions;
|
|||
|
|
using System.Windows.Forms;
|
|||
|
|
using System.Reflection;
|
|||
|
|
using DevExpress.XtraBars;
|
|||
|
|
using DevExpress.XtraEditors;
|
|||
|
|
using System.Collections;
|
|||
|
|
using System.IO;
|
|||
|
|
|
|||
|
|
namespace WMS.Common
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 静态方法处理类
|
|||
|
|
/// 主要一些公共方法处理
|
|||
|
|
/// </summary>
|
|||
|
|
public class SystemCommon
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据当前年获取字符串
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="year"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static string GetNowYear (string year)
|
|||
|
|
{
|
|||
|
|
string CodeYear = "";
|
|||
|
|
if(int.Parse(year) <=2009)
|
|||
|
|
{
|
|||
|
|
CodeYear = year;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
Dictionary<string, char> systemData = new Dictionary<string, char>();
|
|||
|
|
int a = 2010;
|
|||
|
|
for (char c = 'A'; c <= 'Z'; c++)
|
|||
|
|
{
|
|||
|
|
systemData.Add(a.ToString(),c);
|
|||
|
|
a++;
|
|||
|
|
if(a>=2031)
|
|||
|
|
{
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
int i = 1;
|
|||
|
|
for(int j=2031;j<2039;j++ )
|
|||
|
|
{
|
|||
|
|
systemData.Add(j.ToString(), Convert.ToChar(i));
|
|||
|
|
i++;
|
|||
|
|
}
|
|||
|
|
return systemData[year].ToString();
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取月份
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="month"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
|
|||
|
|
public static string GetNowMonth(string month)
|
|||
|
|
{
|
|||
|
|
string noInt = "1";
|
|||
|
|
if(int.Parse(month)>10)
|
|||
|
|
{
|
|||
|
|
if(noInt=="10")
|
|||
|
|
{
|
|||
|
|
noInt = "A";
|
|||
|
|
}
|
|||
|
|
if(month=="11")
|
|||
|
|
{
|
|||
|
|
noInt = "B";
|
|||
|
|
}
|
|||
|
|
if (month == "12")
|
|||
|
|
{
|
|||
|
|
noInt = "C";
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return noInt;
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
private const int MAX_NUMBER = 10000;
|
|||
|
|
|
|||
|
|
//#region 单件模式实例化类 返回当前子类
|
|||
|
|
///// <summary>
|
|||
|
|
/////实例话窗体类。返回一个窗体类
|
|||
|
|
///// </summary>
|
|||
|
|
///// <param name="nameForm"></param>
|
|||
|
|
///// <returns></returns>
|
|||
|
|
//public object Instance(string nameForm, string className, string FormId, ref int FrmIndex, string strAppPath)
|
|||
|
|
//{
|
|||
|
|
// DevExpress.XtraTab.XtraTabControl tab_list = ((DevExpress.XtraTab.XtraTabControl)(Application.OpenForms[FormId].Controls["FunRibbon"]));
|
|||
|
|
// object objType = new object();
|
|||
|
|
// for (int i = 0; i < tab_list.TabPages.Count; i++)
|
|||
|
|
// {
|
|||
|
|
// if (className == tab_list.TabPages[i].Name.ToString())
|
|||
|
|
// {
|
|||
|
|
// FrmIndex = i;
|
|||
|
|
// return tab_list.TabPages[i];
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
|
|||
|
|
// objType = (Form)System.Reflection.Assembly.LoadFile(strAppPath + "\\" + nameForm + ".dll").GetType(nameForm + "." + className).GetConstructor(System.Type.EmptyTypes).Invoke(null);
|
|||
|
|
// return objType;
|
|||
|
|
//}
|
|||
|
|
//#endregion
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 写文件
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="fileName"></param>
|
|||
|
|
/// <param name="str"></param>
|
|||
|
|
public static void WriteFile(string fileName,string str) {
|
|||
|
|
//检测目录是否存在，不存在则创建
|
|||
|
|
string directory = fileName.Substring(0,fileName.LastIndexOf("\\"));
|
|||
|
|
if (!Directory.Exists(directory))
|
|||
|
|
{
|
|||
|
|
DirectoryInfo info = Directory.CreateDirectory(directory);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
//创建一个文件（如果有进行覆盖），并且返回一个文件流（进行写入的）。
|
|||
|
|
FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write);
|
|||
|
|
|
|||
|
|
//写入一个字符串
|
|||
|
|
//讲一个字符串转换成字节数组（并且指名了编码方式和操作系统的方式是一样的）。
|
|||
|
|
byte[] bytes = System.Text.Encoding.Default.GetBytes(str);
|
|||
|
|
//将byte数组写入文件流。
|
|||
|
|
fs.Write(bytes, 0, bytes.Length);
|
|||
|
|
//关闭流
|
|||
|
|
fs.Flush();
|
|||
|
|
fs.Close();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 字符串格式化 1,2,3----'1','2','3'
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="str"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static string StringFormat(string str)
|
|||
|
|
{
|
|||
|
|
string strValue = "";
|
|||
|
|
string[] arr = str.Split(',');
|
|||
|
|
for (int i = 0; i < arr.Length; i++)
|
|||
|
|
{
|
|||
|
|
strValue = strValue + "'" + arr[i] + "',";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (strValue != "")
|
|||
|
|
strValue = strValue.Substring(0, strValue.Length - 1);
|
|||
|
|
|
|||
|
|
return strValue;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 控制窗体控件是否可用
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="FormId">窗体ID</param>
|
|||
|
|
/// <param name="ControlId">控件ID</param>
|
|||
|
|
/// <param name="Enabled">True</param>
|
|||
|
|
/// <param name="dtFun">功能菜单结果集</param>
|
|||
|
|
/// <param name="Menu_Id">菜单ID</param>
|
|||
|
|
/// <param name="FunName">功能名称</param>
|
|||
|
|
public static void FunControlEnabled(string FormId, bool Enabled
|
|||
|
|
, DataTable dtFun, string Menu_Id, string FunName)
|
|||
|
|
{
|
|||
|
|
DataRow[] dr = dtFun.Select("MENU_ID = '" + Menu_Id + "'");
|
|||
|
|
for (int i = 0; i < dr.Length; i++)
|
|||
|
|
{
|
|||
|
|
string[] arr = FunName.Split(':');
|
|||
|
|
for (int j = 0; j < arr.Length; j++)
|
|||
|
|
{
|
|||
|
|
if (dr[i]["FUN_NAME"].ToString().Trim() == arr[j].Trim())
|
|||
|
|
{
|
|||
|
|
ControlEnabled("FrmSysFrame", dr[i]["FUN_ID"].ToString(), Enabled);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 控制窗体控件是否可用
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="FormId">窗体ID</param>
|
|||
|
|
/// <param name="ControlId">控件ID</param>
|
|||
|
|
/// <param name="Enabled">True</param>
|
|||
|
|
public static void ControlEnabled(string FormId, string ControlId, bool Enabled)
|
|||
|
|
{
|
|||
|
|
DevExpress.XtraBars.Ribbon.RibbonControl FunRibbon = ((DevExpress.XtraBars.Ribbon.RibbonControl)(Application.OpenForms[FormId].Controls["FunRibbon"]));
|
|||
|
|
for (int i = 0; i < FunRibbon.Pages.Count; i++)
|
|||
|
|
{
|
|||
|
|
for (int j = 0; j < FunRibbon.Pages[i].Groups.Count; j++)
|
|||
|
|
{
|
|||
|
|
for (int k = 0; k < FunRibbon.Pages[i].Groups[j].ItemLinks.Count; k++)
|
|||
|
|
{
|
|||
|
|
for (int h = 0; h < FunRibbon.Pages[i].Groups[j].ItemLinks[k].Links.Count; h++)
|
|||
|
|
{
|
|||
|
|
BarButtonItem btn = ((DevExpress.XtraBars.BarButtonItemLink)(FunRibbon.Pages[i].Groups[j].ItemLinks[k].Links[h])).Item;
|
|||
|
|
if (btn.Name == ControlId)
|
|||
|
|
{
|
|||
|
|
btn.Enabled = Enabled;
|
|||
|
|
return;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 弹出错误提示信息，标题为“错误”
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="errorInfoString">错误信息</param>
|
|||
|
|
public static void ShowErrorMessageBox(string errorInfoString)
|
|||
|
|
{
|
|||
|
|
XtraMessageBox.Show(errorInfoString, "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
|
|||
|
|
// MessageBox.Show(errorInfoString, "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 弹出提示信息，标题为“提示”
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="errorInfoString">提示信息</param>
|
|||
|
|
public static void ShowInfoMessageBox(string infoString)
|
|||
|
|
{
|
|||
|
|
XtraMessageBox.Show(infoString, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|||
|
|
//MessageBox.Show(infoString, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 弹出返回是与否信息，标题为“确认” OKCancel
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="errorInfoString">提示信息</param>
|
|||
|
|
public static DialogResult ShowMessageBoxResult(string infoString)
|
|||
|
|
{
|
|||
|
|
return XtraMessageBox.Show(infoString, "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button2);
|
|||
|
|
//MessageBox.Show(infoString, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 弹出返回是否以及取消信息，标题为“确认”
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="errorInfoString">提示信息</param>
|
|||
|
|
public static DialogResult ShowMessageBoxResultCancel(string infoString)
|
|||
|
|
{
|
|||
|
|
return XtraMessageBox.Show(infoString, "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button2);
|
|||
|
|
//MessageBox.Show(infoString, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 判断当前输入是否为正整数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="input">Input</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static bool IsPositiveInteger(string input)
|
|||
|
|
{
|
|||
|
|
return Regex.IsMatch(input, @"^\d{1,9}$");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
/*
|
|||
|
|
/// <summary>
|
|||
|
|
/// 判断当前输入是否为整数（可以为负数）
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="input">Input</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static bool IsInteger(string input)
|
|||
|
|
{
|
|||
|
|
return Regex.IsMatch(input, @"^-?\d{1,9}$");
|
|||
|
|
}*/
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 判断当前输入是否为正整数或正浮点数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="input">Input</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static bool IsPositiveFloat(string input)
|
|||
|
|
{
|
|||
|
|
return Regex.IsMatch(input, @"^(0|[1-9]\d{0,8})(.\d{0,4})?$");
|
|||
|
|
// 可以是 1.00
|
|||
|
|
// @"^(\+|-)?(0|[1-9]\d*)(.\d*)?$" ： 任意实数
|
|||
|
|
// @"^(0|[1-9]\d*)(.\d*[1-9])?$" ： 不可以是1.00
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#region 判断当前输入是否为正确的出版年月（格式：yyyy.MM）
|
|||
|
|
/// <summary>
|
|||
|
|
/// 判断当前输入是否为正确的出版年月（格式：yyyy.MM）
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="input">Input</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static bool IsRightPublishDate(string input)
|
|||
|
|
{
|
|||
|
|
return Regex.IsMatch(input, @"^[1-9]\d{3}.(0[1-9]|1[0-2])$");
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 合并相同结构的两个DataTable
|
|||
|
|
/// <summary>
|
|||
|
|
/// 合并相同结构的两个DataTable
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="originalDt">原DataTable</param>
|
|||
|
|
/// <param name="aimDt">目的DataTable</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static System.Data.DataTable DataTableAdd(System.Data.DataTable originalDt, System.Data.DataTable aimDt)
|
|||
|
|
{
|
|||
|
|
foreach (DataRow dr in originalDt.Rows)
|
|||
|
|
{
|
|||
|
|
aimDt.ImportRow(dr);
|
|||
|
|
}
|
|||
|
|
aimDt.AcceptChanges();
|
|||
|
|
return aimDt;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 将10位ISBN转换为13位ISBN
|
|||
|
|
/// <summary>
|
|||
|
|
/// 将10位ISBN转换为13位ISBN
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="inputValue">10位ISBN</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static string ConvertIsbn(string inputValue)
|
|||
|
|
{
|
|||
|
|
string outValue = inputValue.Trim().Replace("X", "x");
|
|||
|
|
if (!Regex.IsMatch(outValue, @"^[7]\d{8}([x]|\d{1})$"))
|
|||
|
|
{
|
|||
|
|
return inputValue;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
int flag1;
|
|||
|
|
if (outValue.EndsWith("x"))
|
|||
|
|
{
|
|||
|
|
flag1 = 10;
|
|||
|
|
}
|
|||
|
|
else if (outValue.EndsWith("0"))
|
|||
|
|
{
|
|||
|
|
flag1 = 11;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
flag1 = int.Parse(outValue.Substring(9, 1));
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
char[] valueChar = outValue.Substring(0, 9).ToCharArray();
|
|||
|
|
int flag2 = 0;
|
|||
|
|
int i = 0;
|
|||
|
|
foreach (char a in valueChar)
|
|||
|
|
{
|
|||
|
|
i++;
|
|||
|
|
flag2 += int.Parse(a.ToString()) * (11 - i);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (flag1 != (11 - (flag2 % 11)))
|
|||
|
|
{
|
|||
|
|
return inputValue;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
//重算校验码
|
|||
|
|
int bit1 = 0;
|
|||
|
|
int bit2 = 0;
|
|||
|
|
outValue = "978" + outValue.Substring(0, 9);
|
|||
|
|
valueChar = outValue.ToCharArray();
|
|||
|
|
i = 0;
|
|||
|
|
foreach (char a in valueChar)
|
|||
|
|
{
|
|||
|
|
if ((i % 2) == 0)
|
|||
|
|
{
|
|||
|
|
//奇数位
|
|||
|
|
bit2 += int.Parse(a.ToString());
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
//偶数位
|
|||
|
|
bit1 += int.Parse(a.ToString());
|
|||
|
|
}
|
|||
|
|
i++;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
int bit = bit1 * 3 + bit2;
|
|||
|
|
bit = 10 - (bit % 10);
|
|||
|
|
if (bit == 10)
|
|||
|
|
{
|
|||
|
|
bit = 0;
|
|||
|
|
}
|
|||
|
|
outValue += bit;
|
|||
|
|
return outValue;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 判断输入的数字是否大于MAX_NUMBER
|
|||
|
|
public static bool IsMoreThanMaxNumber(int number)
|
|||
|
|
{
|
|||
|
|
return number > MAX_NUMBER;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region DataTable 分页
|
|||
|
|
public static System.Data.DataTable GetDataTableFT(int from, int length, System.Data.DataTable dt, out bool flag)
|
|||
|
|
{
|
|||
|
|
flag = false;
|
|||
|
|
|
|||
|
|
DataTable newdt = new DataTable();
|
|||
|
|
newdt = dt.Clone();
|
|||
|
|
if (from < dt.Rows.Count)
|
|||
|
|
{
|
|||
|
|
int i;
|
|||
|
|
for (i = from; i < from + length; i++)
|
|||
|
|
{
|
|||
|
|
if (i < dt.Rows.Count)
|
|||
|
|
{
|
|||
|
|
newdt.ImportRow(dt.Rows[i]);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
flag = true;
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
if (i == dt.Rows.Count)
|
|||
|
|
{
|
|||
|
|
flag = true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return newdt;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 校验isbn是否正确 1-12位的数值，其中偶数、奇数各自相加，根据偶数、奇数的和
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 校验isbn是否正确 1-12位的数值，其中偶数、奇数各自相加，根据偶数、奇数的和
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="as_isbn"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static bool of_checkisbn(string as_isbn)
|
|||
|
|
{
|
|||
|
|
// 判断校验位是否正确
|
|||
|
|
string ls_temp_isbn = as_isbn.Trim();
|
|||
|
|
if (ls_temp_isbn.Trim().Length != 13 || ls_temp_isbn.Trim().Substring(0, 3) != "978")
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
int li_sum_js = 0; // 奇数和
|
|||
|
|
int li_sum_os = 0; // 偶数和
|
|||
|
|
int li_avg_ys = 0; // 余数
|
|||
|
|
int li_bit_isbn = 0; // UNIT的isbn
|
|||
|
|
int li_bit_check = 0; // 检测位
|
|||
|
|
for (int i = 1; i <= 12; i++)
|
|||
|
|
{
|
|||
|
|
li_bit_isbn = int.Parse(ls_temp_isbn.Substring(i - 1, 1));
|
|||
|
|
if (i % 2 == 0)
|
|||
|
|
{
|
|||
|
|
li_sum_os = li_sum_os + li_bit_isbn; // 偶数位相加
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
li_sum_js = li_sum_js + li_bit_isbn; // 奇数位相加
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
li_avg_ys = (li_sum_js + li_sum_os * 3) % 10;
|
|||
|
|
|
|||
|
|
li_bit_check = 10 - li_avg_ys; // 用10 - 所求余数，得到校验位
|
|||
|
|
if (li_bit_check == 10) { li_bit_check = 0; } // 如果等于10的话则视为0
|
|||
|
|
string ls_bit_right = ls_temp_isbn.Substring(12, 1); // 取最后一位
|
|||
|
|
|
|||
|
|
if (li_bit_check.ToString() != ls_bit_right)
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// MisCtrlTextBox回车验证
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="e"></param>
|
|||
|
|
/// <param name="textBox"></param>
|
|||
|
|
public static void TextBoxKeyDown(TextBox textBox)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
if (GetValResult(textBox))
|
|||
|
|
{
|
|||
|
|
SendKeys.Send("{TAB}");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// MisCtrlTextBox 离开验证
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="textBox"></param>
|
|||
|
|
public static void TextBoxLeave(TextBox textBox)
|
|||
|
|
{
|
|||
|
|
GetValResult(textBox);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private static bool GetValResult(TextBox textBox)
|
|||
|
|
{
|
|||
|
|
if (textBox.Text.Length != 0 && textBox.Text.Length > textBox.Text.Length)
|
|||
|
|
{
|
|||
|
|
ShowErrorMessageBox("文本长度不能大于" + textBox.Text.Length.ToString() + "！");
|
|||
|
|
//MessageBox.Show("文本长度不能大于" + textBox.StrLen.ToString() + "！");
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
string msg = "";
|
|||
|
|
//if (!Check(textBox.Text, ref msg))
|
|||
|
|
//{
|
|||
|
|
// ShowErrorMessageBox(textBox.Text.ToString() + "输入错误！");
|
|||
|
|
// textBox.Text = "";
|
|||
|
|
// textBox.Focus();
|
|||
|
|
// return false;
|
|||
|
|
//}
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#region 正则验证
|
|||
|
|
//string pattern;
|
|||
|
|
public static bool Check(TextBox textBox, ref string msg)
|
|||
|
|
{
|
|||
|
|
string pattern;
|
|||
|
|
switch (textBox.Text.ToString())
|
|||
|
|
{
|
|||
|
|
//case "无://无
|
|||
|
|
// return true;
|
|||
|
|
// break;
|
|||
|
|
case "整数"://整数
|
|||
|
|
msg = "整数";
|
|||
|
|
pattern = @"^-?[1-9]\d*$";
|
|||
|
|
break;
|
|||
|
|
case "正整数"://正整数
|
|||
|
|
msg = "正整数";
|
|||
|
|
pattern = "^[0-9]*[1-9][0-9]*$";
|
|||
|
|
break;
|
|||
|
|
case "负整数"://负整数
|
|||
|
|
msg = "负整数";
|
|||
|
|
pattern = "^-[0-9]*[1-9][0-9]*$";
|
|||
|
|
break;
|
|||
|
|
case "数字"://数字
|
|||
|
|
msg = "数字";
|
|||
|
|
pattern = "^([+-]?)\\d*\\.?\\d+$";
|
|||
|
|
break;
|
|||
|
|
case "电话"://电话
|
|||
|
|
msg = "电话";
|
|||
|
|
//在做项目时常常用到判断电话号码的正则表达式，写了一个，可验证如下27种格式：
|
|||
|
|
//110
|
|||
|
|
//8888888
|
|||
|
|
//88888888
|
|||
|
|
//8888888-123
|
|||
|
|
//88888888-23435
|
|||
|
|
//0871-8888888-123
|
|||
|
|
//023-88888888-23435
|
|||
|
|
//86-0871-8888888-123
|
|||
|
|
//8888888_123
|
|||
|
|
//88888888_23435
|
|||
|
|
//0871_8888888_123
|
|||
|
|
//023_88888888_23435
|
|||
|
|
//86_0871_8888888_123
|
|||
|
|
//8888888－123
|
|||
|
|
//88888888－23435
|
|||
|
|
//0871－8888888－123
|
|||
|
|
//023－88888888－23435
|
|||
|
|
//86－0871－8888888－123
|
|||
|
|
//8888888—123
|
|||
|
|
//88888888—23435
|
|||
|
|
//0871—8888888—123
|
|||
|
|
//023—88888888—23435
|
|||
|
|
//86—0871—8888888—123
|
|||
|
|
//13588888888
|
|||
|
|
//15988888888
|
|||
|
|
//013588888888
|
|||
|
|
//015988888888
|
|||
|
|
//(0315)7663551
|
|||
|
|
pattern = @"((^(\d{2,4}[-_－—]?)?\d{3,8}([-_－—]?\d{3,8})?([-_－—]?\d{1,7})?$)|(^0?1[35]\d{9}$)z)|(^(\([0-9]+\))?[0-9]{7,8}$)";
|
|||
|
|
break;
|
|||
|
|
case "正数"://正数（正整数+ 0）
|
|||
|
|
msg = "正数（正整数+ 0）";
|
|||
|
|
pattern = @"^\d+$";
|
|||
|
|
break;
|
|||
|
|
case "负数"://负数（负整数+ 0）
|
|||
|
|
msg = "负数（负整数+ 0）";
|
|||
|
|
pattern = @"^((-\d+)|(0+))$";
|
|||
|
|
break;
|
|||
|
|
case "浮点数"://浮点数
|
|||
|
|
msg = "浮点数";
|
|||
|
|
pattern = @"^(-?\d+)(\.\d+)?$";
|
|||
|
|
break;
|
|||
|
|
case "正浮点数"://正浮点数
|
|||
|
|
msg = "正浮点数";
|
|||
|
|
pattern = @"^(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$";
|
|||
|
|
break;
|
|||
|
|
case "负浮点数"://负浮点数
|
|||
|
|
msg = "负浮点数";
|
|||
|
|
pattern = @"^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$";
|
|||
|
|
break;
|
|||
|
|
case "浮点数2"://浮点数
|
|||
|
|
msg = "浮点数";
|
|||
|
|
pattern = "^-?([1-9]\\d*.\\d*|0.\\d*[1-9]\\d*|0?.0+|0)$";
|
|||
|
|
break;
|
|||
|
|
case "非负浮点数"://非负浮点数（正浮点数+ 0）
|
|||
|
|
msg = "非负浮点数（正浮点数+ 0）";
|
|||
|
|
pattern = @"^\d+(\.\d+)?$";
|
|||
|
|
break;
|
|||
|
|
case "非正浮点数"://非正浮点数（负浮点数+ 0）
|
|||
|
|
msg = "非正浮点数（负浮点数+ 0）";
|
|||
|
|
pattern = @"^((-\d+(\.\d+)?)|(0+(\.0+)?))$";
|
|||
|
|
break;
|
|||
|
|
case "邮件"://邮件 //正确
|
|||
|
|
msg = "邮件";
|
|||
|
|
pattern = @"^[\w-]+(\.[\w-]+)*@[\w-]+(\.[\w-]+)+$";
|
|||
|
|
break;
|
|||
|
|
case "颜色"://颜色
|
|||
|
|
msg = "颜色";
|
|||
|
|
pattern = "^[a-fA-F0-9]{6}$";
|
|||
|
|
break;
|
|||
|
|
case "url"://url(http格式的)
|
|||
|
|
msg = "url(http格式的)";
|
|||
|
|
pattern = @"http://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?";
|
|||
|
|
break;
|
|||
|
|
case "中文"://仅中文
|
|||
|
|
msg = "中文";
|
|||
|
|
pattern = @"[\u4e00-\u9fa5]";
|
|||
|
|
break;
|
|||
|
|
case "ACSII字符"://仅ACSII字符
|
|||
|
|
msg = "ACSII字符";
|
|||
|
|
pattern = "^[\\x00-\\xFF]+$";
|
|||
|
|
break;
|
|||
|
|
case "邮编"://邮编
|
|||
|
|
msg = "邮编";
|
|||
|
|
pattern = "^\\d{6}$";
|
|||
|
|
break;
|
|||
|
|
case "手机"://手机
|
|||
|
|
msg = "手机";
|
|||
|
|
pattern = "^[1]+[3,5,8,4]+\\d{9}";
|
|||
|
|
break;
|
|||
|
|
case "IP地址"://ip地址
|
|||
|
|
msg = "IP地址";
|
|||
|
|
pattern = @"^(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9])\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[0-9])$";
|
|||
|
|
break;
|
|||
|
|
case "非空"://非空
|
|||
|
|
msg = "非空";
|
|||
|
|
pattern = "^\\S+$";
|
|||
|
|
break;
|
|||
|
|
case "图片"://图片
|
|||
|
|
msg = "图片";
|
|||
|
|
pattern = @"(.*)\.(jpg|gif|png|bmp)$";
|
|||
|
|
break;
|
|||
|
|
case "压缩文件"://压缩文件
|
|||
|
|
msg = "压缩文件";
|
|||
|
|
pattern = "(.*)\\.(rar|zip|7zip|tgz)$";
|
|||
|
|
break;
|
|||
|
|
case "日期"://日期
|
|||
|
|
msg = "日期";
|
|||
|
|
//这个日期正则表达式支持
|
|||
|
|
//YYYY-MM-DD
|
|||
|
|
//YYYY/MM/DD
|
|||
|
|
//YYYY_MM_DD
|
|||
|
|
//YYYY.MM.DD的形式
|
|||
|
|
pattern = @"((^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(10|12|0?[13578])([-\/\._])(3[01]|[12][0-9]|0?[1-9])$)|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(11|0?[469])([-\/\._])(30|[12][0-9]|0?[1-9])$)|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(0?2)([-\/\._])(2[0-8]|1[0-9]|0?[1-9])$)|(^([2468][048]00)([-\/\._])(0?2)([-\/\._])(29)$)|(^([3579][26]00)([-\/\._])(0?2)([-\/\._])(29)$)|(^([1][89][0][48])([-\/\._])(0?2)([-\/\._])(29)$)|(^([2-9][0-9][0][48])([-\/\._])(0?2)([-\/\._])(29)$)|(^([1][89][2468][048])([-\/\._])(0?2)([-\/\._])(29)$)|(^([2-9][0-9][2468][048])([-\/\._])(0?2)([-\/\._])(29)$)|(^([1][89][13579][26])([-\/\._])(0?2)([-\/\._])(29)$)|(^([2-9][0-9][13579][26])([-\/\._])(0?2)([-\/\._])(29)$))";
|
|||
|
|
break;
|
|||
|
|
case "QQ号码"://QQ号码
|
|||
|
|
msg = "QQ号码";
|
|||
|
|
pattern = "[1-9][0-9]{4,}";
|
|||
|
|
break;
|
|||
|
|
|
|||
|
|
case "用户名"://用来用户注册。匹配由数字、个英文字母或者下划线组成的字符串
|
|||
|
|
msg = "用户名匹配由数字、个英文字母或者下划线组成的字符串";
|
|||
|
|
pattern = "^(?!\\d)[a-zA-Z0-9_\\u4e00-\\u9fa5]+$";
|
|||
|
|
break;
|
|||
|
|
case "字母"://字母
|
|||
|
|
msg = "字母";
|
|||
|
|
pattern = "^[A-Za-z]+$";
|
|||
|
|
break;
|
|||
|
|
case "大写字母"://大写字母
|
|||
|
|
msg = "大写字母";
|
|||
|
|
pattern = "^[A-Z]+$";
|
|||
|
|
break;
|
|||
|
|
case "小写字母"://小写字母
|
|||
|
|
msg = "小写字母";
|
|||
|
|
pattern = "^[a-z]+$";
|
|||
|
|
break;
|
|||
|
|
case "身份证"://身份证
|
|||
|
|
msg = "身份证";
|
|||
|
|
//pattern = @"^[1-9]([0-9]{16}|[0-9]{13})[xX0-9]$";
|
|||
|
|
pattern = "(^\\d{18}$)|(^\\d{15}$)";
|
|||
|
|
break;
|
|||
|
|
default:
|
|||
|
|
pattern = string.Empty;
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
return Regex.IsMatch(textBox.Text, pattern);
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
//public static void GridColumnWidth(DevExpress.XtraGrid.Views.Grid.GridView gridView)
|
|||
|
|
//{
|
|||
|
|
|
|||
|
|
// for (int i = 0; i < gridView.Columns.Count; i++)
|
|||
|
|
// {
|
|||
|
|
// gridView.Columns[i].BestFit();
|
|||
|
|
// }
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 提取字符串中的数字字符串
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="str"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static string GetNumber(ref string str)
|
|||
|
|
{
|
|||
|
|
string returnStr = string.Empty;
|
|||
|
|
returnStr = Regex.Replace(str, "[a-z,A-Z]", "", RegexOptions.IgnoreCase);
|
|||
|
|
str = Regex.Replace(str, "[0-9]", "", RegexOptions.IgnoreCase);
|
|||
|
|
return returnStr;
|
|||
|
|
//string returnStr = string.Empty;
|
|||
|
|
//for (int i = 0; i < str.Length; i++)
|
|||
|
|
//{
|
|||
|
|
|
|||
|
|
// if (Char.IsNumber(str, i) == true)
|
|||
|
|
// {
|
|||
|
|
// string sdfsdfsd = str.Substring(i, 1);
|
|||
|
|
// returnStr += str.Substring(i, 1);
|
|||
|
|
// }
|
|||
|
|
// else
|
|||
|
|
// {
|
|||
|
|
|
|||
|
|
// string sss = str.Substring(i, 1);
|
|||
|
|
// if (str.Substring(i, 1) == "A" || str.Substring(i, 1) == " ")
|
|||
|
|
// {
|
|||
|
|
// returnStr += str.Substring(i, 1);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
|
|||
|
|
//}
|
|||
|
|
//return returnStr;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public class ConvertHelper<T> where T :class, new()
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 利用反射和泛型
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="dt"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static List<T> ConvertToList(DataTable dt)
|
|||
|
|
{
|
|||
|
|
// 定义集合
|
|||
|
|
List<T> ts = new List<T>();
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
// 获得此模型的类型
|
|||
|
|
Type type = typeof(T);
|
|||
|
|
//定义一个临时变量
|
|||
|
|
string tempName = string.Empty;
|
|||
|
|
///列的属性Status是否改变
|
|||
|
|
bool typeChange = false;
|
|||
|
|
DataTable resutTable = dt.Clone();
|
|||
|
|
foreach (DataColumn clmn in resutTable.Columns)
|
|||
|
|
{
|
|||
|
|
PropertyInfo[] propertys = type.GetProperties();
|
|||
|
|
//遍历该对象的所有属性
|
|||
|
|
foreach (PropertyInfo pi in propertys)
|
|||
|
|
{
|
|||
|
|
if (pi.Name.ToUpper() == clmn.ColumnName.ToUpper())
|
|||
|
|
{
|
|||
|
|
if (pi.PropertyType != clmn.DataType)
|
|||
|
|
{
|
|||
|
|
clmn.DataType = pi.PropertyType;
|
|||
|
|
typeChange = true;
|
|||
|
|
continue;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (typeChange)
|
|||
|
|
{
|
|||
|
|
foreach (DataRow dr in dt.Rows)
|
|||
|
|
{
|
|||
|
|
DataRow row = resutTable.NewRow();
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
foreach (DataColumn clm in dt.Columns)
|
|||
|
|
{
|
|||
|
|
row[clm.ColumnName] = dr[clm.ColumnName];
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
resutTable.Rows.Add(row);
|
|||
|
|
resutTable.AcceptChanges();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
resutTable = dt.Copy();
|
|||
|
|
}
|
|||
|
|
//遍历DataTable中所有的数据行
|
|||
|
|
foreach (DataRow dr in resutTable.Rows)
|
|||
|
|
{
|
|||
|
|
T t = new T();
|
|||
|
|
// 获得此模型的公共属性
|
|||
|
|
PropertyInfo[] propertys = t.GetType().GetProperties();
|
|||
|
|
//遍历该对象的所有属性
|
|||
|
|
foreach (PropertyInfo pi in propertys)
|
|||
|
|
{
|
|||
|
|
tempName = pi.Name;//将属性名称赋值给临时变量
|
|||
|
|
//检查DataTable是否包含此列（列名==对象的属性名）
|
|||
|
|
if (dt.Columns.Contains(tempName))
|
|||
|
|
{
|
|||
|
|
Type v = pi.PropertyType;
|
|||
|
|
|
|||
|
|
// 判断此属性是否有Setter
|
|||
|
|
if (!pi.CanWrite) continue;//该属性不可写，直接跳出
|
|||
|
|
//取值
|
|||
|
|
object value = dr[tempName];
|
|||
|
|
if (v != dr[tempName].GetType())
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
//如果非空，则赋给对象的属性
|
|||
|
|
if (value != DBNull.Value)
|
|||
|
|
|
|||
|
|
pi.SetValue(t, value, null);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//对象添加到泛型集合中
|
|||
|
|
ts.Add(t);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return ts;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 将集合类转换成DataTable
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="list">集合</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static DataTable ToDataTable(IList<T> list)
|
|||
|
|
{
|
|||
|
|
DataTable result = new DataTable();
|
|||
|
|
if (list.Count > 0)
|
|||
|
|
{
|
|||
|
|
PropertyInfo[] propertys = list[0].GetType().GetProperties();
|
|||
|
|
foreach (PropertyInfo pi in propertys)
|
|||
|
|
{
|
|||
|
|
result.Columns.Add(pi.Name, pi.PropertyType);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
for (int i = 0; i < list.Count; i++)
|
|||
|
|
{
|
|||
|
|
ArrayList tempList = new ArrayList();
|
|||
|
|
foreach (PropertyInfo pi in propertys)
|
|||
|
|
{
|
|||
|
|
object obj = pi.GetValue(list[i], null);
|
|||
|
|
tempList.Add(obj);
|
|||
|
|
}
|
|||
|
|
object[] array = tempList.ToArray();
|
|||
|
|
result.LoadDataRow(array, true);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|