資源簡介
使用C# + sql server 2008 實現,包含完整代碼以及數據庫,還有使用說明文檔

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?PMS.PMSClass;
namespace?PMS
{
????public?partial?class?frmAddDep?:?Form
????{
????????public?frmAddDep()
????????{
????????????InitializeComponent();
????????}
????????DBOperate?operate?=?new?DBOperate();//創建數據操作對象
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????this.Close();//關閉窗體
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????if?(txtDepName.Text.Trim()?==?““)
????????????{
????????????????MessageBox.Show(“請輸入部門名稱“?“提示“//彈出消息對話框
????????????????????MessageBoxButtons.OK?MessageBoxIcon.Information);
????????????????return;//退出事件
????????????}
????????????else
????????????{
????????????????string?str=//創建SQL字符串
????????????????????“select?count(*)?from?tb_department?where?DepName=‘“+txtDepName.Text.Trim()+“‘“;
????????????????int?i=operate.HumanNum(str);//得到記錄數量
????????????????if?(i?>?0)
????????????????{
????????????????????MessageBox.Show(“該部門已經存在“?“提示“//彈出消息對話框
????????????????????????MessageBoxButtons.OK?MessageBoxIcon.Information);
????????????????????return;//退出事件
????????????????}
????????????????else
????????????????{
????????????????????string?Addsql?=//創建SQL字符串
????????????????????????“insert?into?tb_department(DepName)?values(‘“?+?txtDepName.Text.Trim()?+?“‘)“;
????????????????????if?(operate.OperateData(Addsql)?>?0)
????????????????????{
????????????????????????MessageBox.Show(“添加成功“?“提示“//彈出消息對話框
????????????????????????????MessageBoxButtons.OK?MessageBoxIcon.Information);
????????????????????}
????????????????}
????????????}
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-04-27?19:06??03\
?????目錄???????????0??2015-05-16?23:56??03\PMS\
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\Backup\
?????文件?????1864192??2010-08-11?13:44??03\PMS\PMS\Backup\PMS.bak
?????文件???????????1??2010-08-12?13:06??03\PMS\PMS\ClassDiagram1.cd
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\CrystalReport\
?????文件????????5246??2012-12-27?09:37??03\PMS\PMS\CrystalReport\UserCheck.cs
?????文件???????16384??2010-08-14?14:41??03\PMS\PMS\CrystalReport\UserCheck.rpt
?????文件????????5238??2012-12-27?09:37??03\PMS\PMS\CrystalReport\UserInfo.cs
?????文件???????16384??2010-08-11?10:45??03\PMS\PMS\CrystalReport\UserInfo.rpt
?????文件????????5230??2012-12-27?09:37??03\PMS\PMS\CrystalReport\UserPay.cs
?????文件???????16384??2008-04-11?15:54??03\PMS\PMS\CrystalReport\UserPay.rpt
?????文件????????5246??2012-12-27?09:37??03\PMS\PMS\CrystalReport\UserPrize.cs
?????文件???????16384??2010-08-11?10:29??03\PMS\PMS\CrystalReport\UserPrize.rpt
?????文件????????5270??2012-12-27?09:37??03\PMS\PMS\CrystalReport\UserRedeploy.cs
?????文件???????16384??2010-08-11?14:41??03\PMS\PMS\CrystalReport\UserRedeploy.rpt
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\Databa
?????文件?????3407872??2015-06-10?13:33??03\PMS\PMS\Databa
?????文件?????1048576??2015-06-10?13:33??03\PMS\PMS\Databa
?????文件???????20575??2015-05-16?23:40??03\PMS\PMS\PMS.csproj
?????文件?????????957??2012-12-27?09:37??03\PMS\PMS\PMS.csproj.user
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\PMSClass\
?????文件?????????547??2015-05-16?23:59??03\PMS\PMS\PMSClass\DBConnection.cs
?????文件???????10126??2010-08-15?09:44??03\PMS\PMS\PMSClass\DBOperate.cs
?????目錄???????????0??2015-04-27?19:06??03\PMS\PMS\PMSImage\
?????文件???????22534??2008-04-03?16:41??03\PMS\PMS\PMSImage\default.jpg
?????文件????????2862??2008-04-03?11:11??03\PMS\PMS\PMSImage\house.ico
?????文件???????31177??2008-04-18?14:43??03\PMS\PMS\PMSImage\login.jpg
?????文件??????104793??2008-04-18?14:21??03\PMS\PMS\PMSImage\main1.jpg
?????文件????????2862??2008-04-03?11:11??03\PMS\PMS\PMSImage\people.ico
............此處省略185個文件信息
- 上一篇:基于asp.net的酒店網站
- 下一篇:超市庫存管理系統 C#源代碼
評論
共有 條評論