資源簡介
C#+Access實現小型CRM系統。
有興趣可以看看

代碼片段和文件信息
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?System.Data.OleDb;
namespace?CRM
{
????public?partial?class?AddUser?:?Form
????{
????????public?AddUser()
????????{
????????????InitializeComponent();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????if?(GetUserByNumber(this.TxtNumber.Text))
????????????{
????????????????MessageBox.Show(“已存在此用戶信息“);
????????????????return;
????????????}
????????????if?(Add(t8.Text?t2.Text?t1.Text?t7.Text?t3.Text?t6.Text?t5.Text?t4.Text?DateTime.Now.ToString()?radioButton1.Checked???“男“?:?“女“?this.TxtNumber.Text)?>?0)
????????????{
????????????????MessageBox.Show(“添加成功!“);
????????????????this.Close();
????????????}
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????if?(GetUserByNumber(this.TxtNumber.Text))
????????????{
????????????????MessageBox.Show(“已存在此用戶信息“);
????????????????return;
????????????}
????????????if?(Add(t8.Text?t2.Text?t1.Text?t7.Text?t3.Text?t6.Text?t5.Text?t4.Text?DateTime.Now.ToString()?radioButton1.Checked???“男“?:?“女“?this.TxtNumber.Text)?>?0)
????????????{
????????????????MessageBox.Show(“添加成功!“);
????????????????for?(int?i?=?0;?i?????????????????{
????????????????????if?(this.Controls[i].GetType()?==?t3.GetType())
????????????????????{
????????????????????????Controls[i].Text?=?““;
????????????????????}
????????????????}
????????????}
????????}
????????///?
????????///?增加一條數據
????????///?
????????public?int?Add(string?bz?string?company?string?Uname?string?Email?string?zhiwu?string?Phone?string?Mobile?string?birthday?string?AddTime?string?sex?string?number)
????????{
????????????int?obj?=?0;
????????????if?(Uname?==?““)
????????????{
????????????????MessageBox.Show(“客戶名稱不能為空!“);
????????????}
????????????else
????????????{
????????????????StringBuilder?strSql?=?new?StringBuilder();
????????????????strSql.Append(“insert?into?Users(“);
????????????????strSql.Append(“bzcompanyUnameEmailzhiwuPhoneMobilebirthdayAddTimesexnumbers“);
????????????????strSql.Append(“)?values?(“);
????????????????strSql.Append(“@bz@company@Uname@Email@zhiwu@Phone@Mobile@birthday@AddTime@sex@number“);
????????????????strSql.Append(“)?“);
????????????????OleDbParameter[]?parameters?=?{
?????????????????????
????????????new?OleDbParameter(“@bz“?OleDbType?.VarChar255)?????????????
????????????????????????new?OleDbParameter(“@company“?OleDbType.VarChar255)?????????????
????????????????????????new?OleDbParameter(“@Uname“?OleDbType.VarChar255)?????????????
????????????????????????new?OleDbParameter(“@Email“?OleDbType.VarChar255)?????????????
????????????????????????new?OleDbParameter(“@zhiwu“?OleDbT
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-01-14?10:15??CRM\
?????目錄???????????0??2015-01-28?15:07??CRM\CRM\
?????文件?????????851??2014-05-21?18:12??CRM\CRM.sln
?????文件???????34816??2014-09-20?12:54??CRM\CRM.suo
?????文件???????60928??2015-01-29?09:03??CRM\CRM.v11.suo
?????文件????????6302??2015-01-28?15:05??CRM\CRM\AddUser.cs
?????文件???????13684??2014-09-20?12:51??CRM\CRM\AddUser.Designer.cs
?????文件????????5817??2014-09-20?12:51??CRM\CRM\AddUser.resx
?????文件?????????431??2015-01-14?17:29??CRM\CRM\app.config
?????目錄???????????0??2015-01-28?15:14??CRM\CRM\bin\
?????目錄???????????0??2015-01-28?15:13??CRM\CRM\bin\Debug\
?????文件?????1969990??2015-01-28?15:14??CRM\CRM\bin\Debug.zip
?????文件????????1603??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.application
?????文件??????104448??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.exe
?????文件?????????431??2015-01-14?17:29??CRM\CRM\bin\Debug\CRM.exe.config
?????文件???????10230??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.exe.manifest
?????文件??????194048??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.pdb
?????文件????????1603??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.vshost.application
?????文件???????21472??2015-01-28?17:59??CRM\CRM\bin\Debug\CRM.vshost.exe
?????文件?????????431??2015-01-14?17:29??CRM\CRM\bin\Debug\CRM.vshost.exe.config
?????文件???????10230??2015-01-28?15:07??CRM\CRM\bin\Debug\CRM.vshost.exe.manifest
?????文件??????200704??2015-01-14?17:00??CRM\CRM\bin\Debug\ICSharpCode.SharpZipLib.dll
?????文件?????1599488??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.dll
?????文件??????395776??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.OOxm
?????文件??????431466??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.OOxm
?????文件???????84480??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.Openxm
?????文件??????153211??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.Openxm
?????文件?????1866240??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.Openxm
?????文件?????2133648??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.xm
?????文件?????2752512??2015-01-28?15:04??CRM\CRM\bin\Debug\sql.accdb
?????目錄???????????0??2014-05-26?14:11??CRM\CRM\bin\Release\
............此處省略59個文件信息
- 上一篇:超市進銷存銷售管理系統源碼
- 下一篇:C#文件資源管理器——仿我的電腦
評論
共有 條評論