資源簡介
信用社對其信貸客戶情況進行詳細的管理,對客戶的借貸的情況進行詳細記錄,應實現以下功能:
(1).客戶信息錄入:將新增加的客戶按要求的指標將其錄入數據庫中。
(2).查詢功能:實現按客戶的編號、名稱等指標進行客戶情況的查詢。
(3).修改功能:當客戶的某個或者某些指標錄入錯誤時,能對其進行修改。
(4).刪除功能:當某些客戶消除其賬號時,應能刪除客戶記錄。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?Loans
{
????public?partial?class?Apply?:?Form
????{
????????public?Apply()
????????{
????????????InitializeComponent();
????????}
????????private?void?label4_Click(object?sender?EventArgs?e)
????????{
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????try
????????????{
????????????????if?(textBox1.Text.Trim()?==?““?||?comboBox1.Text.Trim()?==?““?||?textBox2.Text.Trim()?==?““?||?textBox3.Text.Trim()?==?““?||?textBox4.Text.Trim()?==?““?||?textBox5.Text.Trim()?==?““?||?textBox6.Text.Trim()?==?““)
????????????????{
????????????????????MessageBox.Show(“信息未填完!!!“?“提示“);
????????????????}
????????????????else
????????????????{
????????????string?strcon?=?@“Data?source=(local);Initial?Catalog=LOAN;Integrated?Security=True“;
????????????string?sql?=?“insert?into?Man(D_nameD_sexD_birthD_idD_addrD_phoneD_work)?values(‘“?+?textBox1.Text.Trim()?+?“‘‘“?+?comboBox1.Text.Trim()?+?“‘‘“?+?textBox2.Text.Trim()?+?“‘‘“?+?textBox3.Text.Trim()?+?“‘‘“?+?textBox4.Text.Trim()?+?“‘‘“?+?textBox5.Text.Trim()?+?“‘‘“?+?textBox6.Text.Trim()?+?“‘)“;
??
????????????SqlConnection?conn?=?new?SqlConnection(strcon);
????????????SqlCommand?cmd?=?new?SqlCommand(sqlconn);
???????????
????????????????cmd.Connection.Open();
????????????????cmd.ExecuteNonQuery();
????????????????MessageBox.Show(“申請成功!!!“?“提示“);
????????????????this.Hide();
????????????????new?Hetong().Show();
????????????}
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(ex.Message);
????????????}
????????????finally
????????????{
??????????
????????????}??????
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????textBox1.Text?=?““;
????????????textBox2.Text?=?““;
????????????textBox3.Text?=?““;
????????????textBox4.Text?=?““;
????????????textBox5.Text?=?““;
????????????textBox6.Text?=?““;
????????????new?Menu().Show();
????????????this.Hide();
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-01-10?11:00??貸款\
?????目錄???????????0??2013-01-10?11:00??貸款\Loans\
?????目錄???????????0??2013-01-10?11:00??貸款\Loans\Loans\
?????文件?????????857??2012-06-11?20:02??貸款\Loans\Loans.sln
?????文件???????36352??2012-06-21?19:50??貸款\Loans\Loans.suo
?????文件?????????379??2012-06-12?14:39??貸款\Loans\Loans\app.config
?????文件????????2302??2012-06-21?19:43??貸款\Loans\Loans\Apply.cs
?????文件???????10478??2012-06-21?19:43??貸款\Loans\Loans\Apply.Designer.cs
?????文件????????5817??2012-06-21?19:43??貸款\Loans\Loans\Apply.resx
?????目錄???????????0??2013-01-10?11:00??貸款\Loans\Loans\bin\
?????目錄???????????0??2013-01-10?11:00??貸款\Loans\Loans\bin\Debug\
?????文件??????827904??2012-06-21?19:45??貸款\Loans\Loans\bin\Debug\Loans.exe
?????文件?????????379??2012-06-12?14:39??貸款\Loans\Loans\bin\Debug\Loans.exe.config
?????文件??????538112??2012-06-21?19:45??貸款\Loans\Loans\bin\Debug\Loans.pdb
?????文件???????11600??2012-06-21?19:41??貸款\Loans\Loans\bin\Debug\Loans.vshost.exe
?????文件?????????379??2012-06-12?14:39??貸款\Loans\Loans\bin\Debug\Loans.vshost.exe.config
?????文件?????????490??2010-03-17?22:39??貸款\Loans\Loans\bin\Debug\Loans.vshost.exe.manifest
?????目錄???????????0??2012-06-11?20:18??貸款\Loans\Loans\bin\Release\
?????文件????????4994??2012-06-21?19:43??貸款\Loans\Loans\Del.cs
?????文件????????5649??2012-06-21?19:43??貸款\Loans\Loans\Del.Designer.cs
?????文件????????5817??2012-06-21?19:43??貸款\Loans\Loans\Del.resx
?????文件????????2776??2012-06-21?19:43??貸款\Loans\Loans\Denglu.cs
?????文件????????6048??2012-06-21?19:43??貸款\Loans\Loans\Denglu.Designer.cs
?????文件????????5817??2012-06-21?19:43??貸款\Loans\Loans\Denglu.resx
?????文件????????2547??2012-06-21?19:43??貸款\Loans\Loans\Hetong.cs
?????文件???????17622??2012-06-21?19:43??貸款\Loans\Loans\Hetong.Designer.cs
?????文件????????6426??2012-06-21?19:43??貸款\Loans\Loans\Hetong.resx
?????文件??????127416??2012-06-13?12:28??貸款\Loans\Loans\LOANDataSet.Designer.cs
?????文件???????????3??2012-06-13?12:28??貸款\Loans\Loans\LOANDataSet.xsc
?????文件???????28397??2012-06-13?12:28??貸款\Loans\Loans\LOANDataSet.xsd
?????文件???????????3??2012-06-13?12:28??貸款\Loans\Loans\LOANDataSet.xss
............此處省略76個文件信息
- 上一篇:計算機專業頂崗實習報告
- 下一篇:GPS動態精密單點定位
評論
共有 條評論