action.cs

一些常用的方法

using System;
using System.IO;
using System.Net;
using System.Data;
using System.Text;
using System.Drawing;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Security.Cryptography;
using System.Text.RegularExpressions;

/// <summary>
/// 小六专用类库
/// </summary> 

namespace Action
{
    //返回一些固定的提示
    public class ImmobilityString
    {
        public static string Caption = "PMS";
    }
    // 执行一些与SQL相关的操作
    public class SQLExecute
    {
        //SQL数据库连接语句
        //private static string StrSqlConnection = "SERVER=222.77.182.153,4133;Initial Catalog=HC;uid=HC;pwd=HC;";
        private static string StrSqlConnection = "SERVER=(local);Initial Catalog=PMS;Integrated Security=True";
        /// <summary>
        /// SQL数据连接。
        /// </summary>
        /// <param name="Sql">传入SQL语句。</param>
        /// <returns>返回DataSet数据集。</returns>
        public static DataSet ConnectSql(string Sql)
        {
            SqlConnection SqlConn = new SqlConnection(StrSqlConnection);
            DataSet DS = new DataSet();
            SqlDataAdapter SqlDA = new SqlDataAdapter(Sql, SqlConn);
            SqlDA.Fill(DS);
            return DS;
        }
        /// <summary>
        /// 直接执行SQL语句。
        /// </summary>
        /// <param name="Sql">传入SQL语句。</param>
        public void ExecutionSql(string Sql)
        {
            SqlConnection SqlConn = new SqlConnection(StrSqlConnection);
            SqlCommand SqlComm = new SqlCommand(Sql, SqlConn);
            SqlConn.Open();
            SqlComm.ExecuteReader();
            SqlConn.Close();
        }
    }
    // 执行一些与字符串处理相关的操作
    public class ManageChar
    {
        /// <summary>
        /// 过滤一些和SQL语句关键句相冲突的字符串。
        /// </summary>
        /// <param name="CharString">传入一个要过滤的字符串。</param>
        /// <returns>返回过滤后的值。</returns>
        public static string FilteringChar(string CharString)
        {
            CharString = Regex.Replace(CharString, @"insert", string.Empty);
            CharString = Regex.Replace(CharString, @"update", string.Empty);
            CharString = Regex.Replace(CharString, @"delete", string.Empty);
            CharString = Regex.Replace(CharString, @"select", string.Empty);
            CharString = Regex.Replace(CharString, @"and", string.Empty);
            CharString = Regex.Replace(CharString, @"or", string.Empty);
            CharString = Regex.Replace(CharString, @";", string.Empty);
            CharString = Regex.Replace(CharString, @"'", string.Empty);
            CharString = Regex.Replace(CharString, @"&", string.Empty);
            CharString = Regex.Replace(CharString, @"%20", string.Empty);
            CharString = Regex.Replace(CharString, @"--", string.Empty);
            CharString = Regex.Replace(CharString, @"==", string.Empty);
            CharString = Regex.Replace(CharString, @" <", string.Empty);
            CharString = Regex.Replace(CharString, @">", string.Empty);
            CharString = Regex.Replace(CharString, @"%", string.Empty);
            return CharString;
        }
        /// <summary>
        /// 检测用户输入的为数字。
        /// </summary>
        /// <param name="MessAge">传入要返回的消息。</param>
        /// <param name="e">带入一个e。</param>
        public void ValidateNumber(string MessAge, KeyPressEventArgs e)
        {
            if ((e.KeyChar < 48 || e.KeyChar > 57) && e.KeyChar != 8)
            {
                e.Handled = true;
                MessageBox.Show(MessAge, ImmobilityString.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
    //显示时间
    public class GetDateTime
    {
        /// <summary>
        /// 获取系统日期。
        /// </summary>
        /// <returns>系统日期。</returns>
        private static string Time()
        {
            string Year = DateTime.Now.Year.ToString();//年
            string Month = DateTime.Now.Month.ToString();//月
            string Day = DateTime.Now.Day.ToString();//日
            string StrWeek = DateTime.Today.DayOfWeek.ToString().ToLower();//星期
            switch (StrWeek)
            {
                case "monday":
                    StrWeek = "星期一";
                    break;
                case "tuesday":
                    StrWeek = "星期二";
                    break;
                case "wednesday":
                    StrWeek = "星期三";
                    break;
                case "thursday":
                    StrWeek = "星期四";
                    break;
                case "friday":
                    StrWeek = "星期五";
                    break;
                case "saturday":
                    StrWeek = "星期六";
                    break;
                case "sunday":
                    StrWeek = "星期日";
                    break;
            }
            return Year + "年" + Month + "月" + Day + "日" + StrWeek;
        }
    }
    //查询某项数据，绑定控件
    public class ControlBind
    {
        /// <summary>
        /// 数据绑定ListBox控件。
        /// </summary>
        /// <param name="ListBoxTxt">绑定到ListBox的SQL语句。</param>
        /// <param name="LBname">绑定ListBox的控件名。</param>
        /// <param name="bindmember">绑定到ListBox的列表名。</param>
        public void BindListBox(string ListBoxTxt, ListBox LBname, string bindmember)
        {
            LBname.BeginUpdate();
            LBname.DataSource = SQLExecute.ConnectSql(ListBoxTxt).Tables[0];
            LBname.DisplayMember = bindmember;
            LBname.ValueMember = bindmember;
            LBname.EndUpdate();
        }
        /// <summary>
        /// 数据绑定comboBox控件。
        /// </summary>
        /// <param name="CmdTxt">绑定到ComboBox的SQL语句。</param>
        /// <param name="CBname">绑定ComboBox的控件名。</param>
        /// <param name="bindmember">绑定到ComboBox的列表名。</param>
        public void BindComboBox(string CmdTxt, ComboBox CBname, string bindmember)
        {
            CBname.BeginUpdate();
            CBname.DataSource = SQLExecute.ConnectSql(CmdTxt).Tables[0];
            CBname.DisplayMember = bindmember;
            CBname.ValueMember = bindmember;
            CBname.EndUpdate();
        }
        /// <summary>
        /// 数据绑定ListView控件。
        /// </summary>
        /// <param name="StrSql">绑定到ListView的SQL语句。</param>
        /// <param name="LVName">绑定ListView的控件名。</param>
        /// <param name="Lie">绑定到ListView的列表名数组。</param>
        /// <param name="M">错误时，返回的消息。</param>
        public void BindListView(string StrSql,ListView LVName, string[] Lie,string M)
        {
            try
            {
                LVName.Items.Clear();
                DataSet DS = Action.SQLExecute.ConnectSql(StrSql);
                for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
                {
                    ListViewItem LWI = new ListViewItem(DS.Tables[0].Rows[i][Lie[0].ToString ()].ToString().Trim());
                    for (int j = 1; j < Lie.Length; j++)
                    {
                        LWI.SubItems.Add(DS.Tables[0].Rows[i][Lie[j].ToString()].ToString().Trim());
                    }
                    LVName.Items.Add(LWI);
                }
            }
            catch
            {
                MessageBox.Show(M, ImmobilityString.Caption );
            }
        }