-
大小: 2.41MB文件類(lèi)型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-09-28
- 語(yǔ)言: 其他
- 標(biāo)簽:
資源簡(jiǎn)介
一個(gè)詳細(xì)完整的房屋中介系統(tǒng),包括代碼,文檔,數(shù)據(jù)表,適合剛接觸數(shù)據(jù)庫(kù)開(kāi)發(fā),以及寫(xiě)文檔說(shuō)明的人

代碼片段和文件信息
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?=?“取消查詢(xún)“;
????????????????this.groupBox2.Enabled?=?true;
????????????}
????????????else
????????????{
????????????????this.button2.Text?=?“開(kāi)始查詢(xún)“;
????????????????this.groupBox2.Enabled?=?false;
????????????}
????????????this.groupBox2.Text?=“查詢(xún)信息“;
????????}
????????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?‘業(yè)務(wù)編號(hào)‘Pay_Moeny?‘手續(xù)費(fèi)‘“);
????????????sb.Append(“?house_ID?‘房屋編號(hào)‘Pay_date?‘收費(fèi)日期‘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
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件????????400??2006-11-02?12:37??房屋中介系統(tǒng)\houseAgency\houseAgency\app.config
?????文件?????585728??2006-12-02?10:05??房屋中介系統(tǒng)\houseAgency\houseAgency\bin\Debug\houseAgency.exe
?????文件????????400??2006-11-02?12:37??房屋中介系統(tǒng)\houseAgency\houseAgency\bin\Debug\houseAgency.exe.config
?????文件?????622080??2006-12-02?10:05??房屋中介系統(tǒng)\houseAgency\houseAgency\bin\Debug\houseAgency.pdb
?????文件???????5632??2005-11-11?22:25??房屋中介系統(tǒng)\houseAgency\houseAgency\bin\Debug\houseAgency.vshost.exe
?????文件????????400??2006-11-02?12:37??房屋中介系統(tǒng)\houseAgency\houseAgency\bin\Debug\houseAgency.vshost.exe.config
?????文件????1638400??2006-12-21?20:12??房屋中介系統(tǒng)\houseAgency\houseAgency\databa
?????文件????1048576??2006-12-21?20:12??房屋中介系統(tǒng)\houseAgency\houseAgency\databa
?????文件????????464??2006-12-02?10:05??房屋中介系統(tǒng)\houseAgency\houseAgency\databa
?????文件???????3692??2006-12-01?10:08??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBackMoney.cs
?????文件???????6364??2006-11-09?13:09??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBackMoney.Designer.cs
?????文件???????5814??2006-11-09?13:09??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBackMoney.resx
?????文件???????3670??2006-12-01?10:35??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBargin.cs
?????文件???????8107??2006-11-10?14:22??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBargin.Designer.cs
?????文件???????5814??2006-11-10?14:22??房屋中介系統(tǒng)\houseAgency\houseAgency\frmBargin.resx
?????文件???????1942??2006-12-02?09:46??房屋中介系統(tǒng)\houseAgency\houseAgency\frmChangYouSelfPwd.cs
?????文件???????6800??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmChangYouSelfPwd.Designer.cs
?????文件???????6008??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmChangYouSelfPwd.resx
?????文件???????5739??2006-12-01?09:37??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmpleeyAll.cs
?????文件??????13969??2006-11-08?11:17??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmpleeyAll.Designer.cs
?????文件??????10144??2006-11-13?15:46??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmpleeyAll.resx
?????文件???????4553??2006-12-01?09:14??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmploeey.cs
?????文件??????15065??2006-11-08?11:46??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmploeey.Designer.cs
?????文件???????5814??2006-11-08?11:46??房屋中介系統(tǒng)\houseAgency\houseAgency\frmEmploeey.resx
?????文件???????5932??2006-12-01?16:56??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFavor.cs
?????文件??????15811??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFavor.Designer.cs
?????文件??????14813??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFavor.resx
?????文件???????5635??2006-12-01?16:56??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFitment.cs
?????文件??????15825??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFitment.Designer.cs
?????文件??????14640??2006-11-14?11:16??房屋中介系統(tǒng)\houseAgency\houseAgency\frmFitment.resx
............此處省略155個(gè)文件信息
評(píng)論
共有 條評(píng)論