mainsearchform.cs

aTm机 daima认真阅读您的文件包然后写出其具体功能(至少要20个字)。尽量不要让站长把时间都花费在为您修正说明上。压缩包解压时不能有密码。

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 Bank
{
    public partial class MainSearchform : Form
    {
        public MainSearchform()
        {
            InitializeComponent();
        }

        private void MainSearchbtnReturn_Click(object sender, EventArgs e)
        {
                this.Close();  
        }

        private void MainSearchbtnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                MainSearchlvSearch.Items.Clear();   
                string str = MainSearchrboStateTrue.Checked ? "'True'":"'False'";
                string sql = "select * from users where free =" + str;
                if (MainSearchtxtMinMoney.Text.Trim() != "")
                {
                    sql = sql + " and money >= " + this.MainSearchtxtMinMoney.Text;
                }
                if (MainSearchtxtMaxMoney.Text.Trim() != "")
                {
                    sql = sql + " and money <= " + this.MainSearchtxtMaxMoney.Text;
                }
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                DBHelper.connection.Close();
                DBHelper.connection.Open();
                //MessageBox.Show(sql);
                SqlDataReader dataReader = command.ExecuteReader();
                Mainform mainform = new Mainform();
                /*
                 验证部分
                */
                while (dataReader.Read())
                {
                    ListViewItem listviewitem = new ListViewItem(dataReader["id"].ToString());
                    listviewitem.Name = dataReader["id"].ToString();
                    listviewitem.SubItems.AddRange(new string[] { dataReader[1].ToString(), dataReader[2].ToString(), dataReader[3].ToString() });
                    MainSearchlvSearch.Items.Add(listviewitem);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据库出错了！\n\n" + ex, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
            }
            finally
            {
                DBHelper.connection.Close();
                
            }

        }

    }
}