winoperationclass.cs

订阅报刊的企业员工用户希望通过企业的系统更方便、快捷地订阅报刊

using System;
using System.Collections.Generic;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.IO;
using System.Security.Cryptography;
using System.Text.RegularExpressions;

namespace 报刊管理.类
{
    class WinOperationClass
    {
        public WinOperationClass()
        {

        }

        SqlBaseClass SqlExecute = new SqlBaseClass();   //声明数据库操作类对象

        #region  数据绑定ComboBox控件
        /// <summary>
        /// 数据绑定ComboBox控件
        /// </summary>
        /// <param name="sqlcmd">要查询的SQL语句</param>
        /// <param name="cbxname">绑定的ComboBox控件的名称</param>
        /// <param name="bindmember">要绑定的数据表中的字段</param>
        public void BindComboBox(string sqlcmd, ComboBox cbxname, string bindmember)
        {
            cbxname.BeginUpdate();
            cbxname.DataSource = SqlExecute.GetDS(sqlcmd).Tables[0];
            cbxname.DisplayMember = bindmember;
            cbxname.ValueMember = bindmember;
            cbxname.EndUpdate();
        }
        #endregion

        #region  数据绑定ToolStripComboBox控件
        /// <summary>
        /// 数据绑定ToolStripComboBox控件
        /// </summary>
        /// <param name="sqlcmd">要查询的SQL语句</param>
        /// <param name="cbxname">绑定的ToolStripComboBox控件的名称</param>
        /// <param name="bindmember">要绑定的数据表中的字段</param>
        public void BindToolStripComboBox(string sqlcmd, ToolStripComboBox cbxname, string bindmember)
        {
            cbxname.BeginUpdate();
            cbxname.ComboBox.DataSource= SqlExecute.GetDS(sqlcmd).Tables[0];
            cbxname.ComboBox.DisplayMember = bindmember;
            cbxname.ComboBox.ValueMember = bindmember;
            cbxname.EndUpdate();
        }
        #endregion

        #region  验证输入字符串为数字
        /// <summary>
        /// 验证输入字符串为数字
        /// </summary>
        /// <param name="IPnum">输入字符</param>
        /// <returns>返回一个bool类型的值</returns>
        public bool validateNum(string IPnum)
        {
            return Regex.IsMatch(IPnum, "^[0-9]*$");
        }
        #endregion

        #region  验证输入字符串为E-mail地址
        /// <summary>
        /// 验证输入字符串为E-mail地址
        /// </summary>
        /// <param name="IPemail">输入字符串</param>
        /// <returns>返回一个bool类型的值</returns>
        public bool validateEmail(string IPemail)
        {
            return Regex.IsMatch(IPemail, @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
        }
        #endregion
    }
}