[高等教育]毕业设计附件封面

1、 毕 业 设 计 附 件 一程序清单专业 学生姓名王子悦班级u计算机081学号0811503126指导教师安晶adminbll.csusing system;using system.collections.generic;using system.linq;using system.web;using productstocksystem.model;using productstocksystem.dao;namespace productstocksystem.bll / /adminbll 的摘要说明:管理员信息处理的业务层 / public class adminbll /*保存业务

2、逻辑错误信息*/ private string errmessage; public string geterrmessage() return this.errmessage; public adminbll() this.errmessage = ; /*验证用户登录信息*/ public bool checklogin(admin admin) /*建立数据访问层对象*/ admindao admindao = new admindao(); /*首先验证用户名是否存在*/ if (!admindao.existusername(admin.getusername() this.errm

3、essage = 对不起，用户名不存在!; return false; /*如果用户名存在再验证密码输入是否正确*/ if (!admindao.checkuser(admin) this.errmessage = 对不起，密码错误!; return false; return true; /*修改密码*/ public bool changepassword(string username, string password) admindao admindao = new admindao(); return admindao.changepassword(username, passwor

4、d); admindao.csusing system;using system.collections.generic;using system.linq;using system.web;using system.data;using productstocksystem.db;using productstocksystem.model;namespace productstocksystem.dao / /admindao 的摘要说明: 管理员信息处理数据层 / public class admindao /*保存业务逻辑错误信息*/ private string errmessage

5、; public void seterrmessage(string errmessage) this.errmessage = errmessage; public string geterrmessage() return this.errmessage; public admindao() this.errmessage = ; public bool adduser(string username, string password) if (username = ) this.errmessage = 用户名不能为空!; return false; if (password = ) t

6、his.errmessage = 密码不能为空!; return false; string querysql = select * from admin where username= + sqlstring.getquotedstring(username); database db = new database(); dataset ds = db.getdataset(querysql); if (ds.tables0.rows.count 0) this.errmessage = 用户名已经存在!; return false; string insertstring = insert

7、 into admin (username,password) values (; insertstring += sqlstring.getquotedstring(username) + , + sqlstring.getquotedstring(password) + ); if (db.insertorupdate(insertstring) 0; /*根据用户名查询用户信息*/ public static admin getadmininfo(string username) admin admin = null; string querysql = select * from ad

8、min where username= + sqlstring.getquotedstring(username); database db = new database(); system.data.dataset ds = db.getdataset(querysql); if (ds.tables0.rows.count 0) system.data.datarow dr = ds.tables0.rows0; admin = new admin(); admin.setusername(username); admin.setpassword(drpassword.tostring()

9、; admin.setclassmanageflag(convert.toint32(drclass_manage_flag); admin.setproductmanageflag(convert.toint32(drproduct_manage_flag); admin.setproductinflag(convert.toint32(drproductin_flag); admin.setproductoutflag(convert.toint32(drproductout_flag); admin.setstockflag(convert.toint32(drstock_flag);

10、admin.setqueryflag(convert.toint32(drrecord_query_flag); admin.setsupplyermanageflag(convert.toint32(drsupplyer_manage_flag); admin.setcustomermanageflag(convert.toint32(drcustomer_manage_flag); admin.setusermanageflag(convert.toint32(druser_manage_flag); return admin; /*设置用户权限*/ public bool updatef

11、lag(admin admin) string updatestring = update admin set class_manage_flag=; updatestring += admin.getclassmanageflag() + ,product_manage_flag=; updatestring += admin.getproductmanageflag() + ,productin_flag=; updatestring += admin.getproductinflag() + ,productout_flag=; updatestring += admin.getprod

12、uctoutflag() + ,stock_flag=; updatestring += admin.getstockflag() + ,record_query_flag=; updatestring += admin.getqueryflag() + ,supplyer_manage_flag=; updatestring += admin.getsupplyermanageflag() + ,customer_manage_flag=; updatestring += admin.getcustomermanageflag() + ,user_manage_flag=; updatest

13、ring += admin.getusermanageflag() + where username= + sqlstring.getquotedstring(admin.getusername(); database db = new database(); return db.insertorupdate(updatestring) 0; customerdao.csusing system;using system.data;using system.configuration;using system.web;using system.web.security;using system

14、.web.ui;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using productstocksystem.model;using productstocksystem.db;/ / customerdao 的摘要说明:客户信息管理处理业务逻辑层/ public class customerdao /*保存业务处理的错误信息*/ private string errmessage; public string geterrme

15、ssage() return this.errmessage; public customerdao() this.errmessage = ; /*添加客户信息*/ public bool addcustomer(customer customer) /*验证客户名称不能为空*/ if (customer.getcustomername() = ) this.errmessage = 对不起，客户名称输入不能为空!; return false; /*验证客户名称是否已经存在*/ string querysql = select * from t_customer where customer

16、_name= + sqlstring.getquotedstring(customer.getcustomername(); database db = new database(); dataset ds = db.getdataset(querysql); if (ds.tables0.rows.count 0) this.errmessage = 对不起，该客户名称已经存在!; return false; /*执行客户信息的添加操作*/ string insertstring = insert into t_customer (customer_name,person_name,tele

17、phone,address) values (; insertstring += sqlstring.getquotedstring(customer.getcustomername() + ,; insertstring += sqlstring.getquotedstring(customer.getpersonname() + ,; insertstring += sqlstring.getquotedstring(customer.gettelephone() + ,; insertstring += sqlstring.getquotedstring(customer.getaddr

18、ess() + ); if (db.insertorupdate(insertstring) 0) datarow dr = ds.tables0.rows0; customer = new customer(); customer.setcustomerid(customerid); customer.setcustomername(drcustomer_name.tostring(); customer.setpersonname(drperson_name.tostring(); customer.settelephone(drtelephone.tostring(); customer

19、.setaddress(draddress.tostring(); return customer; /*删除客户信息*/ public bool deletecustomer(int customerid) /*查询是否还存在该客户的出库信息*/ string querysql = select * from t_product_out where customer_id= + customerid; database db = new database(); dataset ds = db.getdataset(querysql); if (ds.tables0.rows.count 0)

20、 this.errmessage = 还存在该客户的出库信息！无法删除!; return false; /*执行客户信息的删除*/ string deletestring = delete from t_customer where customer_id= + customerid; if (db.insertorupdate(deletestring) 0) this.errmessage = 客户信息删除失败!; return false; return true; productclassdao.csusing system;using system.data;using system

21、.configuration;using system.web;using system.web.security;using system.web.ui;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using productstocksystem.db;using productstocksystem.model;using system.collections;namespace productstocksystem.dao

22、 / / productclassdao 的摘要说明:图书类别信息处理数据层 / public class productclassdao private string errmessage; public string geterrmessage() return this.errmessage; public productclassdao() this.errmessage = ; /*添加图书类别信息*/ public bool addproductclass(productclass productclass) if (productclass.getclassname() = )

23、this.errmessage = 请输入图书类别名称!; return false; database db = new database(); string query_sql = select * from t_class where class_name = + sqlstring.getquotedstring(productclass.getclassname(); system.data.dataset ds = db.getdataset(query_sql); if (ds.tables0.rows.count 0) this.errmessage = 你输入的图书类别名称已

24、经存在!; return false; string sql = insert into t_class (class_name) values ( + sqlstring.getquotedstring(productclass.getclassname() + ); return db.insertorupdate(sql) 0; /*根据图书类别编号取得图书类别信息*/ public static productclass getproductclass(int classid) productclass productclass = null; string querystring =

25、 select * from t_class where class_id= + classid; database db = new database(); dataset classds = db.getdataset(querystring); if (classds.tables0.rows.count 0) datarow dr = classds.tables0.rows0; productclass = new productclass(); productclass.setclassid(classid); productclass.setclassname(drclass_n

26、ame.tostring(); return productclass; /*更新图书类别信息*/ public bool updateproductclass(productclass productclass) if (productclass.getclassname() = ) this.errmessage = 请输入图书类别名称!; return false; database db = new database(); string query_sql = select * from t_class where class_id + productclass.getclassid(

27、) + and class_name = + sqlstring.getquotedstring(productclass.getclassname(); system.data.dataset ds = db.getdataset(query_sql); if (ds.tables0.rows.count 0) this.errmessage = 你输入的图书类别名称已经存在!; return false; string sql = update t_class set class_name= + sqlstring.getquotedstring(productclass.getclass

28、name() + where class_id= + productclass.getclassid(); return db.insertorupdate(sql) 0; /*删除某个图书类别*/ public bool deleteproductclass(int classid) /*首先查询该图书类别下是否还存在图书信息*/ string querysql = select * from t_product where class_id= + classid; database db = new database(); dataset ds = db.getdataset(querys

29、ql); if (ds.tables0.rows.count 0) this.errmessage = 对不起，还存在该类别的图书信息!; return false; /*如果该类别下已经没有图书信息了就开始执行删除操作*/ string deletestring = delete from t_class where class_id= + classid; if (db.insertorupdate(deletestring) 0) this.errmessage = 删除图书类别信息发生了错误!; return false; return true; /*查询所有的图书类别*/ publ

30、ic arraylist queryallproductclass() arraylist classlist = new arraylist(); string querystring = select * from t_class; database db = new database(); dataset classds = db.getdataset(querystring); for (int i = 0; i classds.tables0.rows.count; i+) datarow dr = classds.tables0.rowsi; productclass produc

31、tclass = new productclass(); productclass.setclassid(convert.toint32(drclass_id); productclass.setclassname(drclass_name.tostring(); classlist.add(productclass); return classlist; productdao.csusing system;using system.data;using system.configuration;using system.web;using system.web.security;using

32、system.web.ui;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using productstocksystem.model;using productstocksystem.db;using system.collections;namespace productstocksystem.dao / / productdao 的摘要说明:图书信息管理处理的业务逻辑层 / public class productdao /

33、*保存业务逻辑错误信息*/ private string errmessage; public string geterrmessage() return this.errmessage; public productdao() this.errmessage = ; /*添加图书信息*/ public bool addproduct(product product) /*验证图书名称不能为空*/ if (product.getproductname() = ) this.errmessage = 请输入图书名称!; return false; /*查询该图书名称是否存在*/ string q

34、uerysql = select * from t_product where product_name= + sqlstring.getquotedstring(product.getproductname(); database db = new database(); dataset ds = db.getdataset(querysql); if (ds.tables0.rows.count 0) this.errmessage = 图书名称已经存在!; return false; /*开始执行图书信息的添加*/ string insertstring = insert into t_

35、product (class_id,product_name,model,spec,address,unit,price) values (; insertstring += product.getclassid() + ,; insertstring += sqlstring.getquotedstring(product.getproductname() + ,; insertstring += sqlstring.getquotedstring(product.getmodel() + ,; insertstring += sqlstring.getquotedstring(produc

36、t.getspec() + ,; insertstring += sqlstring.getquotedstring(product.getaddress() + ,; insertstring += sqlstring.getquotedstring(product.getunit() + ,; insertstring += product.getprice() +); if (db.insertorupdate(insertstring) 0) this.errmessage = 添加图书信息失败!; return false; /*查询刚才添加的图书的编号，更新它的库存为0*/ querysql = select max(product_id) as product_id from t_product; ds = db.getdataset(querysql); datarow dr = ds.tables0.rows0; int productid = convert.toint32(drproduct_id); insertstring = insert into t_stock (product_id,stock_count) values (; insertstring += productid + ,0); /*设置图书的库存