庫存管理系統(tǒng)軟件設(shè)計(jì)源代碼_第1頁
庫存管理系統(tǒng)軟件設(shè)計(jì)源代碼_第2頁
庫存管理系統(tǒng)軟件設(shè)計(jì)源代碼_第3頁
庫存管理系統(tǒng)軟件設(shè)計(jì)源代碼_第4頁
庫存管理系統(tǒng)軟件設(shè)計(jì)源代碼_第5頁
已閱讀5頁，還剩82頁未讀， 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡介

1、using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;namespace S.DAL public class AdminServer public static Admin GetAdminByName(string name) string sql = string.Format("select * from admin where name='0'",name)

2、; Admin a = null; DataTable dt = Web.DBHelper.GetTable(sql, "admin"); foreach (DataRow row in dt.Rows) a = new Admin(); a.Id = (int)row"id" a.Name = (string)row"name" a.Pass = (string)row"pass" return a; / <summary> / 添加 / </summary> / <param na

3、me="login"></param> / <returns></returns> public static bool Add(string login) string sql = string.Format("insert into Admin values('0','0')", login); return Web.DBHelper.ExecuteSql(sql); / <summary> / 刪除 / </summary> / <param n

4、ame="id"></param> / <returns></returns> public static bool Del(int id) string sql = "delete from Admin where id=" + id; return Web.DBHelper.ExecuteSql(sql); / <summary> / 獲取所有用戶信息 / </summary> / <returns></returns> public static DataTa

5、ble Get() string sql = "select * from admin" return Web.DBHelper.GetTable(sql, "admin"); / <summary> / 修改密碼 / </summary> / <param name="pass"></param> / <param name="id"></param> / <returns></returns> public stat

6、ic bool EditPass(string pass, int id) string sql = string.Format("update Admin set pass='0' where id=1", pass, id); return Web.DBHelper.ExecuteSql(sql); using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;names

7、pace S.DAL public class ChuServer / <summary> / 裝箱 / </summary> / <param name="row"></param> / <returns></returns> static Chu Get(DataRow row) Chu c = new Chu(); c.Buy = (string)row"buy" c.Id = (int)row"id" c.Num = (int)row"num&q

8、uot; c.People = PeopleServer.GetByID(int)row"people_ID"); c.Price = (double)row"price" c.Thing = ThingServer.GetByID(int)row"thing_ID"); c.Intime = (DateTime)row"intime" return c; / <summary> / 獲取所有出庫記錄 / </summary> / <param name="key"

9、></param> / <param name="chuType"></param> / <returns></returns> public static List<Chu> Get(string key,int chuType,int startindex,int pagesize) string sql = string.Format("select * from chu_View where chutype=0 1 order by id desc",chuType,k

10、ey); List<Chu> cs = new List<Chu>(); DataTable dt = Web.DBHelper.GetTable(sql, startindex, pagesize, "chu"); foreach (DataRow row in dt.Rows) cs.Add(Get(row); return cs; / <summary> / 查詢出庫的數(shù)量 / </summary> / <param name="key"></param> / <para

11、m name="chuType"></param> / <returns></returns> public static int GetCount(string key, int chuType) string sql = string.Format("select count(*) from chu_View where chutype=0 1'", chuType, key); return Convert.ToInt32(Web.DBHelper.GetScalar(sql); / <sum

12、mary> / 添加出庫記錄 / </summary> / <param name="c"></param> / <returns></returns> public static bool Add(Chu c) string sql = string.Format("insert into chu values('0',1,2,3,4,'5',6)", c.Buy, c.People.Id, c.Thing.Id, c.Num, c.Price, Date

13、Time.Now,c.ChuType); return Web.DBHelper.ExecuteSql(sql); using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;using Web;namespace S.DAL public class ExitServer / <summary> / 添加退貨入庫記錄 / </summary> / <param name=&qu

14、ot;e"></param> / <param name="thingID"></param> / <param name="peopeleID"></param> / <returns></returns> public static bool Add(Exit e) string sql = string.Format("insert Exit values(0,1,getdate(),'2',3)", e.Thin

15、g.Id, e.Num, e.Because, e.People.Id); return Web.DBHelper.ExecuteSql(sql); / <summary> / 封裝 / </summary> / <param name="row"></param> / <returns></returns> static Exit Get(DataRow row) Exit e = new Exit(); e.Because = (string)row"Because" e.Id

16、= (int)row"ID" e.InTime = (DateTime)row"InTIme" e.Num = (int)row"Num" e.People = PeopleServer.GetByID(int)row"People_ID"); e.Thing = ThingServer.GetByID(int)row"Thing_ID"); return e; / <summary> / 獲取所有退款入庫記錄 / </summary> / <param name=

17、"startindex"></param> / <param name="pagesize"></param> / <param name="key"></param> / <returns></returns> public static List<Exit> Get(int startindex, int pagesize, string key) string sql = string.Format("select *

18、 from Exit_View where name like '%0%' order by id desc", key); DataTable dt = Web.DBHelper.GetTable(sql, startindex, pagesize, "Exit"); List<Exit> e = new List<Exit>(); foreach (DataRow row in dt.Rows) e.Add(Get(row); return e; / <summary> / 獲取所有退款入庫的數(shù)量 / <

19、;/summary> / <param name="key"></param> / <returns></returns> public static int GetCount(string key) string sql = string.Format("select count(*) from Exit_View where name like '%0%'", key); return Convert.ToInt32(Web.DBHelper.GetScalar(sql); usi

20、ng System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;namespace S.DAL public class JinServer / <summary> / 添加進(jìn)貨 / </summary> / <param name="j"></param> / <returns></returns> public static

21、 bool Add(Jin j) string sql = string.Format("insert into jin values(0,1,2,3,'4',5,'6')", j.Mfg.Id, j.People.Id, j.Thing.Id, j.Num,DateTime.Now,j.Price,j.CaiGou); return Web.DBHelper.ExecuteSql(sql); / <summary> / 封裝 / </summary> / <param name="row"&

22、gt;</param> / <returns></returns> static Jin Get(DataRow row) Jin j = new Jin(); j.Id = (int)row"id" j.Mfg = MFGServer.GetByID(int)row"mfg_ID"); j.Num = (int)row"num" j.People = PeopleServer.GetByID(int)row"people_ID"); j.Thing = ThingServer.

23、GetByID(int)row"thing_ID"); j.Intime = (DateTime)row"intime" j.Price = (double)row"price" j.CaiGou = (string)row"CaiGou" return j; / <summary> / 獲取所有進(jìn)貨記錄 / </summary> / <param name="key"></param> / <param name="startin

24、dex"></param> / <param name="pagesize"></param> / <returns></returns> public static List<Jin> Get(string key,int startindex,int pagesize) string sql = string.Format("select * from jin_View 0 order by id desc",key); List<Jin> js =

25、new List<Jin>(); DataTable dt = Web.DBHelper.GetTable(sql, "jin"); foreach (DataRow row in dt.Rows) js.Add(Get(row); return js; / <summary> / 獲取數(shù)量 / </summary> / <param name="key"></param> / <returns></returns> public static int GetCount(

26、string key) string sql = string.Format("select count(*) from jin_View 0", key); return Convert.ToInt32(Web.DBHelper.GetScalar(sql); using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;namespace S.DAL public class MFGSe

27、rver / <summary> / 封裝 / </summary> / <param name="row"></param> / <returns></returns> static MFG Get(DataRow row) MFG m = new MFG(); m.Address = (string)row"address" m.Id = (int)row"id" m.Name = (string)row"name" m.People =

28、(string)row"people" m.Tel = (string)row"tel" return m; / <summary> / 獲取所有廠商 / </summary> / <returns></returns> public static List<MFG> Get() string sql = "select * from MFG" List<MFG> ms = new List<MFG>(); DataTable dt = Web.DBH

29、elper.GetTable(sql, "mfg"); foreach (DataRow row in dt.Rows) ms.Add(Get(row); return ms; / <summary> / 獲取明細(xì) / </summary> / <param name="id"></param> / <returns></returns> public static MFG GetByID(int id) string sql = string.Format("select

30、 * from MFG where id=0",id); DataTable dt = Web.DBHelper.GetTable(sql, "mfg"); if (dt.Rows.Count > 0) return Get(dt.Rows0); return null; / <summary> / 修改 / </summary> / <param name="m"></param> / <returns></returns> public static bool E

31、dit(MFG m) string sql = string.Format("update mfg set address='0',name='1',people='2',tel='3' where id=4", m.Address,m.Name,m.People,m.Tel,m.Id); return Web.DBHelper.ExecuteSql(sql); / <summary> / 添加廠商 / </summary> / <param name="m"&

32、gt;</param> / <returns></returns> public static bool Add(MFG m) string sql = string.Format("insert into mfg values('0','1','2','3')", m.Name, m.People, m.Tel, m.Address); return Web.DBHelper.ExecuteSql(sql); / <summary> / 刪除廠商 / </

33、summary> / <param name="id"></param> / <returns></returns> public static bool Del(int id) string sql = string.Format("delete from mfg where id=0",id); return Web.DBHelper.ExecuteSql(sql); using System;using System.Collections.Generic;using System.Text;u

34、sing System.Data;using System.Data.SqlClient;using S.Model;namespace S.DAL public class PeopleServer / <summary> / 封裝 / </summary> / <param name="row"></param> / <returns></returns> static People Get(DataRow row) People p = new People(); p.Address = (str

35、ing)row"address" p.Age = (int)row"age" p.Id = (int)row"id" p.Tel = (string)row"tel" p.Name = (string)row"name" return p; / <summary> / 獲取所有人員 / </summary> / <returns></returns> public static List<People> Get() string sql

36、 = "select * from people" List<People> ps = new List<People>(); DataTable dt = Web.DBHelper.GetTable(sql, "people"); foreach (DataRow row in dt.Rows) ps.Add(Get(row); return ps; / <summary> / 添加人員 / </summary> / <param name="p"></param&g

37、t; / <returns></returns> public static bool Add(People p) string sql = string.Format("insert into people values('0',1,'2','3')", p.Name, p.Age, p.Tel, p.Address); return Web.DBHelper.ExecuteSql(sql); / <summary> / 修改人員信息 / </summary> / <pa

38、ram name="p"></param> / <returns></returns> public static bool Edit(People p) string sql = string.Format("update people set name='0',age=1,tel='2',address='3' where id=4", p.Name, p.Age, p.Tel, p.Address, p.Id); return Web.DBHelper.Exe

39、cuteSql(sql); / <summary> / 刪除人員 / </summary> / <param name="id"></param> / <returns></returns> public static bool Del(int id) string sql = string.Format("delete from people where id=0",id); return Web.DBHelper.ExecuteSql(sql); / <summary>

40、; / 獲取明細(xì) / </summary> / <param name="id"></param> / <returns></returns> public static People GetByID(int id) string sql = string.Format("select * from people where id=0",id); DataTable dt = Web.DBHelper.GetTable(sql, "people"); if (dt.Rows.

41、Count > 0) return Get(dt.Rows0); return null; using System;using System.Collections.Generic;using System.Text;using S.Model;using System.Data;namespace S.DAL public class StockServer / <summary> / 添加庫存物品 / </summary> / <param name="thingID"></param> / <param n

42、ame="wearhouseID"></param> / <returns></returns> public static bool Add(int thingID, int wearhouseID) string sql = string.Format("insert Stocks values(0,1,0)", thingID, wearhouseID); return Web.DBHelper.ExecuteSql(sql); / <summary> / 修改庫存數(shù)量 / </summa

43、ry> / <param name="thingID"></param> / <param name="wareHouseID"></param> / <param name="num"></param> / <param name="str"></param> / <returns></returns> public static bool EditNum(int thingID, int

44、 wareHouseID, int num, string str) string sql = string.Format("update Stocks set Num=Num01 where Thing_ID=2 and WareHouse_ID=3", str, num, thingID, wareHouseID); return Web.DBHelper.ExecuteSql(sql); / <summary> / 修改庫存數(shù)量 / </summary> / <param name="thingID"></

45、param> / <param name="wareHouseID"></param> / <param name="num"></param> / <param name="str"></param> / <returns></returns> public static bool EditNum(int thingID, int wareHouseID, int num) string sql = string.Format(&q

46、uot;update Stocks set Num=0 where Thing_ID=1 and WareHouse_ID=2", num, thingID, wareHouseID); return Web.DBHelper.ExecuteSql(sql); / <summary> / 封裝 / </summary> / <param name="row"></param> / <returns></returns> static Stocks Get(DataRow row) Stocks

47、 s = new Stocks(); s.Num = (int)row"Num" s.Thing = ThingServer.GetByID(int)row"Thing_ID"); s.Ware = WareHouseServer.GetByID(int)row"WareHouse_ID"); return s; / <summary> / 獲取所有獲存 / </summary> / <param name="wareHouseID">倉庫編號(hào)</param> / &

48、lt;param name="key">and開</param> / <returns></returns> public static List<Stocks> Get(int wareHouseID, string key) string sql = string.Format("select * from Stock_View where WareHouse_ID=0 1", wareHouseID, key); DataTable dt=Web.DBHelper.GetTable(sql,&q

49、uot;Stocks"); List<Stocks> ss=new List<Stocks> (); foreach (DataRow row in dt.Rows) ss.Add(Get(row); return ss; / <summary> / 獲取數(shù)量 / </summary> / <param name="wareHouseID"></param> / <param name="thingID"></param> / <returns

50、></returns> public static Stocks Get(int wareHouseID, int thingID) string sql = string.Format("select * from Stocks where WareHouse_ID=0 and Thing_ID=1", wareHouseID, thingID); DataTable dt = Web.DBHelper.GetTable(sql, "Stocks"); if (dt.Rows.Count > 0) return Get(dt.Rows0); return null; using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using S.Model;namespace S.DAL public class ThingServer / <summary> / 封裝 / </summary>

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論