C#房屋中介系统及说明表

房屋中介系统和房屋中介系统使用说明表,不错的哦!

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;
using houseAgency.mothedCls;
namespace houseAgency
{
    public partial class frmMoneyRemark : Form
    {
        ClsCon con = new ClsCon（）;

        public int PintCount = 0;
        public frmMoneyRemark（）
        {
            InitializeComponent（）;
            con.ConDatabase（）;
        }

        private void frmMoneyRemark_Load（object sender EventArgs e）
        {
            
            this.load（）;
        
        }

        private void button2_Click（object sender EventArgs e）
        {
            PintCount += 1;
            if （PintCount % 2 == 0）
            {
                this.button2.Text = “取消查询“;
                this.groupBox2.Enabled = true;
            }
            else
            {
                this.button2.Text = “开始查询“;
                this.groupBox2.Enabled = false;
            }
            this.groupBox2.Text =“查询信息“;
        }

        private void load（）
        {
            SqlDataAdapter da = new SqlDataAdapter（“select employee_idemployee_name from tb_employee“ con.conn）;
            DataTable dt = new DataTable（）;
            con.conn.Open（）;
            da.Fill（dt）;
            this.comboBox1.DataSource = dt.DefaultView;
            comboBox1.DisplayMember = “employee_name“;
            comboBox1.ValueMember = “employee_id“;
        }

        private void comboBox1_SelectedValueChanged（object sender EventArgs e）
        {
            string strid = this.comboBox1.SelectedValue.ToString（）;
            this.dataGridView1.DataSource = this.dtsorce（striddate（））.DefaultView;
        }

        private DataTable dtsorce（string stridstring date）
        {
         
            StringBuilder sb = new StringBuilder（）;
            sb.Append（“select moeny_ID ‘业务编号‘Pay_Moeny ‘手续费‘“）;
            sb.Append（“ house_ID ‘房屋编号‘Pay_date ‘收费日期‘lend_Name ‘甲方姓名‘lend_Phone ‘甲方电话‘“）;
            sb.Append（“ want_Name ‘乙方姓名‘want_Phone ‘乙方电话‘“）;
            sb.Append（“ from tb_MoneyAndInfo where emp_ID=‘“ + strid + “‘ and “）;
            sb.Append（“ Pay_date like ‘%“ + date + “%‘ “）;

            SqlDataAdapter da = new SqlDataAdapter（sb.ToString（） con.conn）;
            DataTable dt = new DataTable（）;
            da.Fill（dt）;
            return dt; 
        }

        private string date（）
        {
            string date = this.dateTimePicker1.Text.Replace（‘年‘ ‘-‘）.Replace（‘月‘ ‘-‘）.Replace（‘日‘ ‘ ‘）;
            string dateNew = string.Empty;
            char[] C ={ ‘-‘ };
            string []dateinfo=date.Split（C）;
            if （dateinfo[1].Trim（）.ToString（）.Length <= 1）
            {
                dateNew += dateinfo[0].ToString（） + “-0“ + dateinfo[1].ToString（）;
            }
            else
            {
                d

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        400  2006-11-02 12:37  房屋中介系统\houseAgency\houseAgency\app.config

     文件     585728  2006-12-02 10:05  房屋中介系统\houseAgency\houseAgency\bin\Debug\houseAgency.exe

     文件        400  2006-11-02 12:37  房屋中介系统\houseAgency\houseAgency\bin\Debug\houseAgency.exe.config

     文件     622080  2006-12-02 10:05  房屋中介系统\houseAgency\houseAgency\bin\Debug\houseAgency.pdb

     文件       5632  2005-11-11 22:25  房屋中介系统\houseAgency\houseAgency\bin\Debug\houseAgency.vshost.exe

     文件        400  2006-11-02 12:37  房屋中介系统\houseAgency\houseAgency\bin\Debug\houseAgency.vshost.exe.config

     文件    1638400  2006-12-21 20:12  房屋中介系统\houseAgency\houseAgency\database\db_showHouse_Data.MDF

     文件    1048576  2006-12-21 20:12  房屋中介系统\houseAgency\houseAgency\database\db_showHouse_Log.LDF

     文件        464  2006-12-02 10:05  房屋中介系统\houseAgency\houseAgency\database\杀死进程的存储过程.sql

     文件       3692  2006-12-01 10:08  房屋中介系统\houseAgency\houseAgency\frmBackMoney.cs

     文件       6364  2006-11-09 13:09  房屋中介系统\houseAgency\houseAgency\frmBackMoney.Designer.cs

     文件       5814  2006-11-09 13:09  房屋中介系统\houseAgency\houseAgency\frmBackMoney.resx

     文件       3670  2006-12-01 10:35  房屋中介系统\houseAgency\houseAgency\frmBargin.cs

     文件       8107  2006-11-10 14:22  房屋中介系统\houseAgency\houseAgency\frmBargin.Designer.cs

     文件       5814  2006-11-10 14:22  房屋中介系统\houseAgency\houseAgency\frmBargin.resx

     文件       1942  2006-12-02 09:46  房屋中介系统\houseAgency\houseAgency\frmChangYouSelfPwd.cs

     文件       6800  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmChangYouSelfPwd.Designer.cs

     文件       6008  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmChangYouSelfPwd.resx

     文件       5739  2006-12-01 09:37  房屋中介系统\houseAgency\houseAgency\frmEmpleeyAll.cs

     文件      13969  2006-11-08 11:17  房屋中介系统\houseAgency\houseAgency\frmEmpleeyAll.Designer.cs

     文件      10144  2006-11-13 15:46  房屋中介系统\houseAgency\houseAgency\frmEmpleeyAll.resx

     文件       4553  2006-12-01 09:14  房屋中介系统\houseAgency\houseAgency\frmEmploeey.cs

     文件      15065  2006-11-08 11:46  房屋中介系统\houseAgency\houseAgency\frmEmploeey.Designer.cs

     文件       5814  2006-11-08 11:46  房屋中介系统\houseAgency\houseAgency\frmEmploeey.resx

     文件       5932  2006-12-01 16:56  房屋中介系统\houseAgency\houseAgency\frmFavor.cs

     文件      15811  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmFavor.Designer.cs

     文件      14813  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmFavor.resx

     文件       5635  2006-12-01 16:56  房屋中介系统\houseAgency\houseAgency\frmFitment.cs

     文件      15825  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmFitment.Designer.cs

     文件      14640  2006-11-14 11:16  房屋中介系统\houseAgency\houseAgency\frmFitment.resx

............此处省略155个文件信息