资源简介
购物网.zip
代码片段和文件信息
using System;
using System.Data;
using System.Data.SqlClient;
using Sqldbconn;
namespace Entity
{
///
/// 管理员后台管理
///
public class Admin
{
private sqldbconn dbconn;
private int adminid;
private string admin;
private string adminname;
private string adminpassword;
#region 属性器
public int Adminid
{
get
{
return adminid;
}
set
{
adminid = value;
}
}
public string Adminstr
{
get
{
return admin;
}
set
{
admin = value;
}
}
public string Adminname
{
get
{
return adminname;
}
set
{
adminname = value;
}
}
public string Adminpassword
{
get
{
return adminpassword;
}
set
{
adminpassword = value;
}
}
#endregion
public Admin()
{
dbconn = new sqldbconn();
}
public SqlDataReader admin_denlu()
{
SqlParameter [] para = new SqlParameter[2];
para[0] = new SqlParameter(“@adminname“SqlDbType.VarChar20);
para[0].Value = adminname;
para[1] = new SqlParameter(“@adminpassword“SqlDbType.VarChar40);
para[1].Value = adminpassword;
return dbconn.getread(“select * from administrator where adminname=‘“+ adminname + “‘ and adminpassword=‘“+ adminpassword + “‘“ para);
}
public DataSet admin_select()
{
return dbconn.getdataset(“select * from administrator“ null);
}
public int admin_add()
{
SqlParameter [] para = new SqlParameter[4];
para[0] = new SqlParameter(“@adminname“SqlDbType.VarChar20);
para[0].Value = adminname;
para[1] = new SqlParameter(“@adminpassword“SqlDbType.VarChar40);
para[1].Value = adminpassword;
para[2] = new SqlParameter(“@admin“SqlDbType.VarChar20);
para[2].Value = admin;
para[3] = new SqlParameter(“@returnvalue“SqlDbType.Int);
para[3].Direction = ParameterDirection.ReturnValue;
dbconn.updata(“insert into administrator values(@adminname@adminpassword)“ para);
return (int)para[3].Value;
}
public int admin_update()
{
SqlParameter [] para = new SqlParameter[2];
para[0] = new SqlParameter(“@adminname“SqlDbType.VarChar20);
para[0].Value = admin;
para[1] = new SqlParameter(“@adminpassword“SqlDbType.VarChar40);
para[1].Value = adminpassword;
return dbconn.updata(“update administrator set adminpassword=@adminpassword where adminname=@adminname“ para);
}
public int admin_del()
{
SqlParameter [] para = new SqlParameter[3];
para[0] = new SqlParameter(“@adminid“SqlDbType.Int);
para[0].Value = adminid;
para[1] = new SqlParameter(“@admin“SqlDbType.VarChar20);
para[1].Value = admin;
para[2] = new SqlParameter(“@adminname“SqlDbType.VarChar20);
para[2].Value = adminname;
return dbconn.updata(“delete from administrator where adminid=@adminid“ para);
}
}
}
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2018-10-20 18:32 购物网\
目录 0 2018-10-20 18:32 购物网\DB\
文件 5242880 2018-01-14 17:11 购物网\DB\Shopping.mdf
文件 2097152 2018-01-14 17:11 购物网\DB\Shopping_log.ldf
文件 123211 2018-01-16 15:21 购物网\DB\USI848ZZ%GK))H(}2O1XLMF.png
文件 91044 2018-01-16 15:20 购物网\DB\购物网.pdm
目录 0 2018-10-20 18:32 购物网\购物网\
目录 0 2018-10-20 18:32 购物网\购物网\.vs\
目录 0 2018-10-20 18:32 购物网\购物网\.vs\config\
文件 85901 2018-09-29 19:01 购物网\购物网\.vs\config\applicationhost.config
目录 0 2018-10-20 18:32 购物网\购物网\.vs\购物网\
目录 0 2018-10-20 18:32 购物网\购物网\.vs\购物网\v14\
文件 160768 2018-09-29 19:03 购物网\购物网\.vs\购物网\v14\.suo
目录 0 2018-10-20 18:32 购物网\购物网\DB\
文件 5242880 2018-01-14 17:11 购物网\购物网\DB\Shopping.mdf
文件 2097152 2018-01-14 17:11 购物网\购物网\DB\Shopping_log.ldf
目录 0 2018-10-20 18:32 购物网\购物网\Entity\
文件 2962 2018-01-14 13:37 购物网\购物网\Entity\Admin.cs
目录 0 2018-10-20 18:32 购物网\购物网\Entity\bin\
目录 0 2018-10-20 18:32 购物网\购物网\Entity\bin\Debug\
文件 36864 2018-09-29 19:02 购物网\购物网\Entity\bin\Debug\Entity.dll
文件 73216 2018-09-29 19:02 购物网\购物网\Entity\bin\Debug\Entity.pdb
文件 16384 2018-09-29 19:02 购物网\购物网\Entity\bin\Debug\Sqldbconn.dll
文件 13824 2018-09-29 19:02 购物网\购物网\Entity\bin\Debug\Sqldbconn.pdb
目录 0 2018-10-20 18:32 购物网\购物网\Entity\bin\Release\
文件 32768 2018-01-19 18:10 购物网\购物网\Entity\bin\Release\Entity.dll
文件 16384 2018-01-19 18:10 购物网\购物网\Entity\bin\Release\Sqldbconn.dll
文件 3835 2018-01-14 14:07 购物网\购物网\Entity\Dingdan.cs
文件 4805 2018-01-12 21:07 购物网\购物网\Entity\Entity.csproj
文件 2141 2018-01-01 16:25 购物网\购物网\Entity\Entity.csproj.user
文件 3254 2018-01-14 14:28 购物网\购物网\Entity\gongyingshang.cs
............此处省略1178个文件信息
相关资源
- 机器人学基础[蔡自兴编著]2015年版.
- 算法.zip
- 学习正则表达式.zip
- jrebel配置及破解.zip
- nRF52832开发指南上下两册.rar
- 定量遥感.pdf
- VJC5.0简体中文版.rar
- UnityAsset-EasyMovieTextureVideoTexturev3.20[A
- 百度poi数据,百度全国数据2018年.zi
- 《最优化理论与算法第2版》高清中文
- 普林斯顿微积分读本(图灵数学·统计
- ManageEngine.Eventlog.Analyzer.v6.0.0.6010.rar
- 《TMS320C54×DSP原理及应用第2版》_130
- 普林斯顿微积分读本修订版.rar
- 教学课件ppt.rar
- 计算机组成原理学习指导与习题解析
- 1.7z
- David_A._Patterson_John_L._Hennessy_Computer_O
- ComputerOrganizationandDesign5th.pdf
- 姚静版.pdf
- Fencesv3.0.9中文破解版-安装指示.zip
- pengcaiyun_10345612.zip
- 微擎weliam_merchant.rar
- full-bcq.bin
- anyconnectlinux644.4.01054predeployk9.tar.gz
- 电脑常见问题与故障1000例.rar
- ads.7z
- flight-system.zip
- 微擎禾匠仿二更视频1.7.1.zip
- zw_STM32嵌入式微控制器快速上手.zip
评论
共有 条评论