-
大小: 1.09MB文件類型: .rar金幣: 2下載: 0 次發布日期: 2023-10-30
- 語言: C#
- 標簽:
資源簡介
C#開發的庫存管理系統。庫存管理信息系統是一種典型的信息管理系統(MIS),其開發主要包括后臺的數據庫的建立、維護以及前端的應用程序開發兩個方面的內容。庫存管理信息系統研究的內容涉及庫存管理的全過程,包括入庫、出庫、訂貨,庫存查詢,系統維護,報表輸出,幫助等。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?System.Windows.Forms;
namespace?WMIM
{
????class?ConnectDB
????{
????????public?static?string?connectionString?=?“Data?Source=PC-200908281418;database?=WMIM;Integrated?Security?=?true“;
????????public?static?SqlConnection?conn;
????????public?static?string?Login_ID?=?““;?//定義全局變量,記錄當前登錄的用戶編號
????????public?static?string?Login_Name?=?““;??//定義全局變量,記錄當前登錄的用戶名
????????public?static?string?tag=“0“;
????????public?static?SqlConnection?getCon()?
????????{
????????????conn?=?new?SqlConnection(connectionString);
????????????conn.Open();
????????????return?conn;
????????}
????????public?void?con_close()?
????????{
????????????if?(conn.State?==?ConnectionState.Open)?
????????????{
????????????????conn.Close();
????????????????conn.Dispose();
????????????}
????????}
????????public?SqlDataReader?get_dr(string?cmdText)?
????????{
????????????getCon();
????????????SqlCommand?cmd?=?conn.CreateCommand();
????????????cmd.CommandText?=?cmdText;
????????????SqlDataReader?dr?=?cmd.ExecuteReader();
????????????return?dr;
????????}
????????public?void?get_update(string?cmdText)?
????????{
????????????getCon();
????????????SqlCommand?cmd?=new??SqlCommand(cmdTextconn);
????????????cmd.ExecuteNonQuery();
????????????cmd.Dispose();
????????????con_close();
????????}
????????public?DataSet?getDateSet(string?cmdTextstring?tableName)?
????????{
????????????getCon();
????????????SqlDataAdapter?sdr?=?new?SqlDataAdapter(cmdTextconn);
????????????DataSet?ds?=?new?DataSet();
????????????sdr.Fill(dstableName);
????????????con_close();
????????????return?ds;
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????1395200??2010-01-12?23:29??WMIM\bin\Debug\bar\2010-1-12232919.bak
?????文件?????335872??2010-01-14?22:37??WMIM\bin\Debug\WMIM.exe
?????文件?????353792??2010-01-14?22:37??WMIM\bin\Debug\WMIM.pdb
?????文件???????5632??2005-12-08?14:51??WMIM\bin\Debug\WMIM.vshost.exe
?????文件???????1821??2010-01-13?10:24??WMIM\ConnectDB.cs
?????文件???????4842??2010-01-12?18:33??WMIM\CrystalReport1.cs
?????文件??????16384??2009-12-07?13:32??WMIM\CrystalReport1.rpt
?????文件???????9527??2010-01-12?18:33??WMIM\CrystalReport2.cs
?????文件??????16384??2009-12-13?10:46??WMIM\CrystalReport2.rpt
?????文件???????7528??2010-01-12?18:33??WMIM\CrystalReportNew.cs
?????文件??????16384??2009-12-13?11:29??WMIM\CrystalReportNew.rpt
?????文件??????50737??2010-01-12?18:33??WMIM\DataSet1.Designer.cs
?????文件????????381??2009-12-13?10:32??WMIM\DataSet1.xsc
?????文件???????5857??2009-12-13?10:32??WMIM\DataSet1.xsd
?????文件????????854??2009-12-13?10:32??WMIM\DataSet1.xss
?????文件??????39997??2010-01-12?18:33??WMIM\DataSet2.Designer.cs
?????文件????????381??2009-12-13?10:32??WMIM\DataSet2.xsc
?????文件???????4188??2009-12-13?10:35??WMIM\DataSet2.xsd
?????文件????????853??2009-12-13?10:35??WMIM\DataSet2.xss
?????文件???????2338??2010-01-13?22:11??WMIM\F_ABCmaterial.cs
?????文件???????6399??2010-01-13?22:11??WMIM\F_ABCmaterial.Designer.cs
?????文件???????5814??2010-01-13?22:11??WMIM\F_ABCmaterial.resx
?????文件???????5357??2010-01-11?22:27??WMIM\F_browseDB.cs
?????文件??????18875??2010-01-11?22:27??WMIM\F_browseDB.Designer.cs
?????文件??????11216??2010-01-11?22:27??WMIM\F_browseDB.resx
?????文件???????5782??2010-01-13?18:00??WMIM\F_browsePickingList.cs
?????文件??????18841??2010-01-13?18:00??WMIM\F_browsePickingList.Designer.cs
?????文件??????11216??2010-01-13?18:00??WMIM\F_browsePickingList.resx
?????文件????????442??2009-12-07?09:37??WMIM\F_Creport.cs
?????文件???????2544??2009-12-07?09:37??WMIM\F_Creport.Designer.cs
............此處省略116個文件信息
評論
共有 條評論