資源簡介
完整的C#實例源代碼系列（內附詳細說明文檔）之：房屋中介系統適合C#和SQL2005入門者練習。 內附數據庫安裝錄像(FLASH格式)應網友要求，因為原來發布的資源點數過高，不適合CSDN新人下載，而CSDN又無法修改資源的點數，故該系列共8套系統全部免費再次發布，如下：財務憑證管理系統房屋中介系統高校教師檔案管理系統固定資產管理系統庫存管理系統企業客戶資源管理系統商品進銷存報表系統網上商城購物系統所有這8套系統都可以在我的資源里找到。
代碼片段和文件信息
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\databa
?????文件????1048576??2006-12-21?20:12??房屋中介系統\houseAgency\houseAgency\databa
?????文件????????464??2006-12-02?10:05??房屋中介系統\houseAgency\houseAgency\databa
?????文件???????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
............此處省略157個文件信息
評論
共有 條評論
川公網安備 51152502000135號