• 大小: 2.41MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-09-28
  • 语言: 其他
  • 标签:

资源简介

一个详细完整的房屋中介系统,包括代码,文档,数据表,适合刚接触数据库开发,以及写文档说明的人

资源截图

代码片段和文件信息

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个文件信息

评论

共有 条评论

相关资源