91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 5.96MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2023-08-16
  • 語言: C#
  • 標簽: CRMC#??

資源簡介

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.OOxml.dll
?????文件??????431466??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.OOxml.xml
?????文件???????84480??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.Openxml4Net.dll
?????文件??????153211??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.Openxml4Net.xml
?????文件?????1866240??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.OpenxmlFormats.dll
?????文件?????2133648??2015-01-14?17:00??CRM\CRM\bin\Debug\NPOI.xml
?????文件?????2752512??2015-01-28?15:04??CRM\CRM\bin\Debug\sql.accdb
?????目錄???????????0??2014-05-26?14:11??CRM\CRM\bin\Release\
............此處省略59個文件信息

評論

共有 條評論

相關資源