库存管理系统软件设计源代码.docx
- 文档编号:6713531
- 上传时间:2023-01-09
- 格式:DOCX
- 页数:81
- 大小:28.42KB
库存管理系统软件设计源代码.docx
《库存管理系统软件设计源代码.docx》由会员分享,可在线阅读,更多相关《库存管理系统软件设计源代码.docx(81页珍藏版)》请在冰豆网上搜索。
库存管理系统软件设计源代码
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
namespaceS.DAL
{
publicclassAdminServer
{
publicstaticAdminGetAdminByName(stringname)
{
stringsql=string.Format("select*fromadminwherename='{0}'",name);
Admina=null;
DataTabledt=Web.DBHelper.GetTable(sql,"admin");
foreach(DataRowrowindt.Rows)
{
a=newAdmin();
a.Id=(int)row["id"];
a.Name=(string)row["name"];
a.Pass=(string)row["pass"];
}
returna;
}
///
///添加
///
///
///
publicstaticboolAdd(stringlogin)
{
stringsql=string.Format("insertintoAdminvalues('{0}','{0}')",login);
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///删除
///
///
///
publicstaticboolDel(intid)
{
stringsql="deletefromAdminwhereid="+id;
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///获取所有用户信息
///
///
publicstaticDataTableGet()
{
stringsql="select*fromadmin";
returnWeb.DBHelper.GetTable(sql,"admin");
}
///
///修改密码
///
///
///
///
publicstaticboolEditPass(stringpass,intid)
{
stringsql=string.Format("updateAdminsetpass='{0}'whereid={1}",pass,id);
returnWeb.DBHelper.ExecuteSql(sql);
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
namespaceS.DAL
{
publicclassChuServer
{
///
///装箱
///
///
///
staticChuGet(DataRowrow)
{
Chuc=newChu();
c.Buy=(string)row["buy"];
c.Id=(int)row["id"];
c.Num=(int)row["num"];
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"];
returnc;
}
///
///获取所有出库记录
///
///
///
///
publicstaticList
{
stringsql=string.Format("select*fromchu_Viewwherechutype={0}{1}orderbyiddesc",chuType,key);
List
DataTabledt=Web.DBHelper.GetTable(sql,startindex,pagesize,"chu");
foreach(DataRowrowindt.Rows)
cs.Add(Get(row));
returncs;
}
///
///查询出库的数量
///
///
///
///
publicstaticintGetCount(stringkey,intchuType)
{
stringsql=string.Format("selectcount(*)fromchu_Viewwherechutype={0}{1}'",chuType,key);
returnConvert.ToInt32(Web.DBHelper.GetScalar(sql));
}
///
///添加出库记录
///
///
///
publicstaticboolAdd(Chuc)
{
stringsql=string.Format("insertintochuvalues('{0}',{1},{2},{3},{4},'{5}',{6})",c.Buy,c.People.Id,c.Thing.Id,c.Num,c.Price,DateTime.Now,c.ChuType);
returnWeb.DBHelper.ExecuteSql(sql);
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
usingWeb;
namespaceS.DAL
{
publicclassExitServer
{
///
///添加退货入库记录
///
///
///
///
///
publicstaticboolAdd(Exite)
{
stringsql=string.Format("insert[Exit]values({0},{1},getdate(),'{2}',{3})",
e.Thing.Id,e.Num,e.Because,e.People.Id);
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///封装
///
///
///
staticExitGet(DataRowrow)
{
Exite=newExit();
e.Because=(string)row["Because"];
e.Id=(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"]);
returne;
}
///
///获取所有退款入库记录
///
///
///
///
///
publicstaticList
{
stringsql=string.Format("select*fromExit_Viewwherenamelike'%{0}%'orderbyiddesc",key);
DataTabledt=Web.DBHelper.GetTable(sql,startindex,pagesize,"Exit");
List
foreach(DataRowrowindt.Rows)
e.Add(Get(row));
returne;
}
///
///获取所有退款入库的数量
///
///
///
publicstaticintGetCount(stringkey)
{
stringsql=string.Format("selectcount(*)fromExit_Viewwherenamelike'%{0}%'",key);
returnConvert.ToInt32(Web.DBHelper.GetScalar(sql));
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
namespaceS.DAL
{
publicclassJinServer
{
///
///添加进货
///
///
///
publicstaticboolAdd(Jinj)
{
stringsql=string.Format("insertintojinvalues({0},{1},{2},{3},'{4}',{5},'{6}')",j.Mfg.Id,j.People.Id,j.Thing.Id,j.Num,DateTime.Now,j.Price,j.CaiGou);
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///封装
///
///
///
staticJinGet(DataRowrow)
{
Jinj=newJin();
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.GetByID((int)row["thing_ID"]);
j.Intime=(DateTime)row["intime"];
j.Price=(double)row["price"];
j.CaiGou=(string)row["CaiGou"];
returnj;
}
///
///获取所有进货记录
///
///
///
///
///
publicstaticList
{
stringsql=string.Format("select*fromjin_View{0}orderbyiddesc",key);
List
DataTabledt=Web.DBHelper.GetTable(sql,"jin");
foreach(DataRowrowindt.Rows)
js.Add(Get(row));
returnjs;
}
///
///获取数量
///
///
///
publicstaticintGetCount(stringkey)
{
stringsql=string.Format("selectcount(*)fromjin_View{0}",key);
returnConvert.ToInt32(Web.DBHelper.GetScalar(sql));
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
namespaceS.DAL
{
publicclassMFGServer
{
///
///封装
///
///
///
staticMFGGet(DataRowrow)
{
MFGm=newMFG();
m.Address=(string)row["address"];
m.Id=(int)row["id"];
m.Name=(string)row["name"];
m.People=(string)row["people"];
m.Tel=(string)row["tel"];
returnm;
}
///
///获取所有厂商
///
///
publicstaticList
{
stringsql="select*fromMFG";
List
DataTabledt=Web.DBHelper.GetTable(sql,"mfg");
foreach(DataRowrowindt.Rows)
ms.Add(Get(row));
returnms;
}
///
///获取明细
///
///
///
publicstaticMFGGetByID(intid)
{
stringsql=string.Format("select*fromMFGwhereid={0}",id);
DataTabledt=Web.DBHelper.GetTable(sql,"mfg");
if(dt.Rows.Count>0)
returnGet(dt.Rows[0]);
returnnull;
}
///
///修改
///
///
///
publicstaticboolEdit(MFGm)
{
stringsql=string.Format("updatemfgsetaddress='{0}',name='{1}',people='{2}',tel='{3}'whereid={4}",
m.Address,m.Name,m.People,m.Tel,m.Id);
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///添加厂商
///
///
///
publicstaticboolAdd(MFGm)
{
stringsql=string.Format("insertintomfgvalues('{0}','{1}','{2}','{3}')",m.Name,m.People,m.Tel,m.Address);
returnWeb.DBHelper.ExecuteSql(sql);
}
///
///删除厂商
///
///
///
publicstaticboolDel(intid)
{
stringsql=string.Format("deletefrommfgwhereid={0}",id);
returnWeb.DBHelper.ExecuteSql(sql);
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingS.Model;
namespaceS.DAL
{
publicclassPeopleServer
{
///
///封装
///
///
///
staticPeopleGet(DataRowrow)
{
Peoplep=newPeople();
p.Address=(string)row["address"];
p.Age=(int)row["age"];
p.Id=(int)row["id"];
p.Tel=(string)row["tel"];
p.Name=(string)row["name"];
returnp;
}
///
///获取所有人员
///
///
publicstaticList
{
stringsql="select*frompeople";
List
DataTabledt=Web.DBHelper.GetTable(sql,"people");
foreach(DataRowrowindt.Rows)
ps.Add(Get(row));
returnps;
}
///
///
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 库存 管理 系统软件 设计 源代码
![提示](https://static.bdocx.com/images/bang_tan.gif)