資源簡介
包括了人員檔案的管理、物料檔案管理、簡單物料進倉/出倉信息管理、多物料進出倉信息管理、用戶登錄與權限設計、統計程序設計與報表打印等多個功能模塊
代碼片段和文件信息
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;
namespace?DBManagment
{
????class?SqlOperation
????{
????????public?SqlConnection?conn() //定義連接方法,返回的是連接對象
????????{
????????????//數據庫連字符串
????????????//string?con?=?@“data?source=.\sqlexpress;initial?catalog=sam;integrated?security=sspi;“;
????????????string?con?=?@“Data?Source=.\MYSQL;Initial?Catalog=sam;Integrated?Security=True“;
????????????SqlConnection?conn?=?new?SqlConnection(con); //創建連接對象
????????????return?conn; //返回連接對象
????????}
????????public?bool?OPSQL(string?SQLcmd) //定義返回值類型為bool的OPSQL類//SQL數據庫單條記錄的增刪改操作
????????{
????????????SqlConnection?con?=?conn(); //SQL數據庫單條記錄的增刪改操作
????????????con.Open(); //打開連接
????????????SqlCommand?cmd?=?new?SqlCommand(SQLcmd?con); //獲得傳來的SQL命令
????????????bool?succ?=?true; //操作是否成功的標志
???
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????11326??2017-06-08?18:55??all\all.csproj
?????文件????????363??2017-06-08?12:59??all\all.csproj.user
?????文件????????686??2017-06-08?13:31??all\app.config
?????文件?????243712??2018-01-26?16:30??all\bin\Debug\all.exe
?????文件????????686??2017-06-08?13:31??all\bin\Debug\all.exe.config
?????文件?????331264??2018-01-26?16:30??all\bin\Debug\all.pdb
?????文件??????11600??2018-01-26?17:08??all\bin\Debug\all.vshost.exe
?????文件????????686??2017-06-08?13:31??all\bin\Debug\all.vshost.exe.config
?????文件????????490??2017-09-29?21:43??all\bin\Debug\all.vshost.exe.manifest
?????文件???????3067??2017-06-06?22:11??all\DBClass.cs
?????文件???????4399??2018-01-26?17:08??all\obj\x86\Debug\all.csproj.FileListAbsolute.txt
?????文件???????1903??2017-06-16?23:02??all\obj\x86\Debug\all.csproj.GenerateResource.Cache
?????文件??????98920??2017-11-06?14:54??all\obj\x86\Debug\all.csprojResolveAssemblyReference.cache
?????文件?????243712??2018-01-26?16:30??all\obj\x86\Debug\all.exe
?????文件?????331264??2018-01-26?16:30??all\obj\x86\Debug\all.pdb
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.Properties.Resources.resources
?????文件???????2707??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_AuthorizeManagement.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_GoodsCountSearch.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_GoodsManagement.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_GoodsStatistics.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_InoutOrder.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_Login.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_Main.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_MultiInout.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_MultiInoutRecordSearch.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_SimpleInout.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_SimpleInoutRecordSearch.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_StaffManagement.resources
?????文件????????180??2017-11-06?14:54??all\obj\x86\Debug\all.UI.wg212_WarehouseLedger.resources
?????文件?????108812??2017-06-17?10:54??all\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
............此處省略83個文件信息
- 上一篇:C#讀取股票日線數據(同花順版)
- 下一篇:C#利用access數據庫做的登陸界面
評論
共有 條評論