form1.cs

一个基于像素的字符分割。适合于数字

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace HttpMessageBoard
{
    public partial class Form1 : Form
    {
        string szConnectString = "Data Source=58.61.38.117;Initial Catalog=DeployDB;Persist Security Info=True;User ID=51SoleDeploySys;Password=51sole3812554";
        //string szConnectString = "Data Source=(local);Initial Catalog=DeployDB;Persist Security Info=True;User ID=sa;Password=sa";
        string szId = "";
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            cbIsScript.SelectedIndex = 0;
            cbOperation.SelectedIndex = 0;
            cbSplitCh.SelectedIndex = 0;
        }

        private void ExecuteSp(int act)
        {
            SqlConnection conn = new SqlConnection(szConnectString);
            try
            {
                string szEndTag = "";
                szEndTag = txtEndTag.Text.Trim();
                if (szEndTag.Length > 1)
                {
                    MessageBox.Show("结束标记符只能是一个字符", "ExecuteSp");
                    return;
                }
                if (txtOrigUrl.Text == "")
                {
                    MessageBox.Show("留言管理地址不能为空", "ExecuteSp");
                    return;
                }
                if (txtUrl.Text == "")
                {
                    MessageBox.Show("留言信息地址不能为空", "ExecuteSp");
                    return;
                }
                if (txtFindKey.Text == "")
                {
                    MessageBox.Show("查找关键字不能为空", "ExecuteSp");
                    return;
                }
                conn.Open();
                SqlCommand cmd = new SqlCommand("sp_httpmessageboard", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                
                cmd.Parameters.Add("@ID",SqlDbType.Int).Value=(act==0?Convert.DBNull:act);
                cmd.Parameters.Add("@WebId", SqlDbType.Int).Value = Int32.Parse(txtWebId.Text);
                cmd.Parameters.Add("@OrigUrl", SqlDbType.VarChar).Value = txtOrigUrl.Text;
                cmd.Parameters.Add("@Url", SqlDbType.VarChar).Value = txtUrl.Text;
                cmd.Parameters.Add("@QueryKey", SqlDbType.VarChar).Value = (txtQueryKey.Text==""?Convert.DBNull:txtQueryKey.Text);
                cmd.Parameters.Add("@FindKey", SqlDbType.VarChar).Value = txtFindKey.Text;
                cmd.Parameters.Add("@EndTag", SqlDbType.VarChar).Value = (szEndTag == "" ? " " : szEndTag);
                cmd.Parameters.Add("@IsScript", SqlDbType.Int).Value = cbIsScript.SelectedIndex;
                cmd.Parameters.Add("@ReGroup", SqlDbType.Int).Value = (cbReGroup.Checked?1:0);
                cmd.Parameters.Add("@SplitCh", SqlDbType.VarChar).Value = cbSplitCh.Text;
                cmd.Parameters.Add("@Operation", SqlDbType.Int).Value = cbOperation.SelectedIndex;
                cmd.Parameters.Add("@ret", SqlDbType.Int, sizeof(int)).Direction = ParameterDirection.ReturnValue;
                cmd.ExecuteNonQuery();
                conn.Close();
                int nRet = Int32.Parse(cmd.Parameters["@ret"].Value.ToString());
                if (nRet == 0)
                {
                    MessageBox.Show("操作成功", "ExecuteSp");
                }
                else
                {
                    if (nRet == -21 || nRet == -22)
                    {
                        MessageBox.Show("记录已存在,添加失败", "ExecuteSp");
                    }
                    else
                    {
                        MessageBox.Show("操作失败", "ExecuteSp");
                    }
                }
            }
            catch (Exception e)
            {
                if (conn.State.ToString().ToLower() == "open")
                {
                    conn.Close();
                }
                MessageBox.Show(e.ToString(), "ExecuteSp");
            }
        }
        private void butAdd_Click(object sender, EventArgs e)
        {
            if (txtWebId.Text == "")
            {
                MessageBox.Show("WebID不能为空", "添加");
                return;
            }
            ExecuteSp(0);
        }
        private void butUpdate_Click(object sender, EventArgs e)
        {
            if (szId != "")
            {
                if (txtWebId.Text == "")
                {
                    return;
                }
                ExecuteSp(Int32.Parse(szId));
            }
        }
        private void butLoad_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(szConnectString);
            try
            {
                if (txtWebId.Text != "")
                {
                    SqlCommand cmd = new SqlCommand();
                    SqlDataReader dr;
                    conn.Open();
                    cmd.Connection = conn;
                    cmd.CommandText = "select ID,WebId,OrigUrl,Url,QueryKey,FindKey,EndTag,IsScript,ReGroup,SplitCh,Operation from HttpMessageBoard where WebId=" + txtWebId.Text;
                    dr = cmd.ExecuteReader();
                    if (dr.HasRows)
                    {
                        while (dr.Read())
                        {
                            szId = dr["ID"].ToString();
                            txtOrigUrl.Text = dr["OrigUrl"].ToString();
                            txtUrl.Text = dr["Url"].ToString();
                            txtQueryKey.Text = dr["QueryKey"].ToString();
                            txtEndTag.Text = dr["EndTag"].ToString();
                            txtFindKey.Text = dr["FindKey"].ToString();
                            cbIsScript.SelectedIndex = Int32.Parse(dr["IsScript"].ToString());
                            cbSplitCh.Text = dr["SplitCh"].ToString();
                            cbOperation.SelectedIndex = Int32.Parse(dr["Operation"].ToString());
                        }
                        txtRecordId.Text = szId;
                    }
                    dr.Close();
                    conn.Close();
                }
            }
            catch (Exception ex)
            {
                if (conn.State.ToString().ToLower() == "open")
                {
                    conn.Close();
                }
                MessageBox.Show(e.ToString(), "ExecuteSp");
            }
        }
        private void butDel_Click(object sender, EventArgs e)
        {            
            SqlConnection conn = new SqlConnection(szConnectString);
            try
            {
                if (szId != "")
                {
                    DialogResult rest;
                    rest=MessageBox.Show("确定要删除该数据吗?", "删除提示", MessageBoxButtons.YesNo);
                    if (rest==DialogResult.No)
                    {
                        return;
                    }
                    SqlCommand cmd = new SqlCommand();                    
                    conn.Open();
                    cmd.Connection = conn;
                    cmd.CommandText = "delete from HttpMessageBoard where ID=" + szId;
                    int nRet = cmd.ExecuteNonQuery();
                    if (nRet > 0)
                    {
                        MessageBox.Show("删除成功", "删除");
                    }
                    else
                    {
                        MessageBox.Show("删除失败", "删除");
                    }
                    conn.Close();
                }
            }
            catch (Exception ex)
            {
                if (conn.State.ToString().ToLower() == "open")
                {
                    conn.Close();
                }
                MessageBox.Show(e.ToString(), "ExecuteSp");
            }
        }
    }
}