小工具知识网

当前位置: 首页 > 行业知识 > ASP.Net实现玩具管理(三层架构,两项数据相乘)

行业知识

ASP.Net实现玩具管理(三层架构,两项数据相乘)

2026-11-18 19:33:14 来源:互联网转载

���录

演示功能:

点击启动生成页面

步骤:

1、建文件

​编辑

2、添加引用关系

3、根据数据库中的列写Models下的XueshengModels类

4、DAL下的DBHelper(对数据库进行操作)

5、DAL数据访问层下的service文件

6、BLL业务逻辑层下调用DAL的文件

8、这个地方可以进行计算得出小计的数字

9、ui表现层主界面前端部分

10、ui表现层主界面后端部分


演示功能:

点击启动生成页面

步骤:

1、建文件

下图是三层架构列表,Models里面有模拟数据库中列的类,DAL中有DBHelper和service,BLL中有BllManager文件用于ui界面直接调用

建照片文件图片,数据夹用于展示库存地址 

2、添加引用关系

DAL引用Models文件,BLL引用DAL和Models文件,主文件WebApplication1引用Bll和Models

3、根据数据库中的列写Models下的XueshengModels类

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace Models{  public   class GoodsModel    {        private string goodsID;        public string GoodsID        {            get { return goodsID; }            set { goodsID = value; }        }      private string goodsName;      public string GoodsName      {          get { return goodsName; }          set { goodsName = value; }      }      private  string goodsPic;      public  string GoodsPic      {          get { return goodsPic; }          set { goodsPic = value; }      }      private  string goodsPrice;      public  string GoodsPrice      {          get { return goodsPrice; }          set { goodsPrice = value; }      }      private string goodsStock;      public string GoodsStock      {          get { return goodsStock; }          set { goodsStock = value; }      }      private string xiaoji;      public string Xiaoji      {          get { return xiaoji; }          set { xiaoji = value; }      }      private string zongji;        public string Zongji{  get { return zongji; }  set { zongji = value; }}}}

4、DAL下的DBHelper(对数据库进行操作)

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace DAL{ public    class DBHelper    {     public static string connstr = "server=.;database=GoodsDB;uid=sa;pwd=123123";     public static SqlConnection conn = null;     public static void connect() {         if (conn==null)         {             conn = new SqlConnection(connstr);         }         conn.Close();         conn.Open();          }     public static bool NoQuery(string sql) {         connect();         SqlCommand cmd = new SqlCommand(sql,conn);       int ret=  cmd.ExecuteNonQuery();       conn.Close();       return ret > 0;     }     public static SqlDataReader Read(string sql)     {         connect();         SqlCommand cmd = new SqlCommand(sql, conn);         return cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);     }    }}

5、DAL数据访问层下的service文件

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace DAL{  public   class GoodsService    {      public static List ChaXun()      {       SqlDataReader read=   DBHelper.Read("select * from Goods");          List list = new List();          int zong = 0;          while (read.Read())          {              Models.GoodsModel model = new Models.GoodsModel();              model.GoodsID = read["GoodsID"].ToString();              model.GoodsName = read["GoodsName"].ToString();              model.GoodsPic = read["GoodsPic"].ToString();              model.GoodsPrice = read["GoodsPrice"].ToString();              model.GoodsStock = read["GoodsStock"].ToString();              model.Xiaoji = (int.Parse(read["GoodsStock"].ToString()) * int.Parse(read["GoodsPrice"].ToString())).ToString();                                         zong  += int.Parse(read["GoodsStock"].ToString()) * int.Parse(read["GoodsPrice"].ToString());               model.Zongji = zong.ToString();              list.Add(model);          }          return list;      }      public static List MoCha(string name)      {          string sql = string.Format("select * from Goods where GoodsName like '%{0}%'",name);          SqlDataReader read = DBHelper.Read(sql);          List list = new List();          int zong = 0;          while (read.Read())          {              Models.GoodsModel model = new Models.GoodsModel();              model.GoodsID = read["GoodsID"].ToString();              model.GoodsName = read["GoodsName"].ToString();              model.GoodsPic = read["GoodsPic"].ToString();              model.GoodsPrice = read["GoodsPrice"].ToString();              model.GoodsStock = read["GoodsStock"].ToString();              model.Xiaoji = (int.Parse(read["GoodsStock"].ToString()) * int.Parse(read["GoodsPrice"].ToString())).ToString();              zong += int.Parse(read["GoodsStock"].ToString()) * int.Parse(read["GoodsPrice"].ToString());              model.Zongji = zong.ToString();              list.Add(model);          }          return list;      }    }}

6、BLL业务逻辑层下调用DAL的文件

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace BLL{ public   class GoodsManger    {     public static List ChaXun() {         return DAL.GoodsService.ChaXun();     }     public static List MoCha(string name) {         return DAL.GoodsService.MoCha(name);     }    }}

8、这个地方可以进行计算得出小计的数字

9、ui表现层主界面前端部分

                    商品名称:                                             
ID 商品名 图片 价格 库存 小计 操作
删除

10、ui表现层主界面后端部分

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;namespace WebApplication1{    public partial class WebForm1 : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                Repeater1.DataSource=BLL.GoodsManger.ChaXun();                Repeater1.DataBind();            }        }        protected void Button1_Click(object sender, EventArgs e)        {            Repeater1.DataSource = BLL.GoodsManger.MoCha(TextBox1.Text.ToString());            Repeater1.DataBind();        }        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)        {        }    }}

上一篇:河北银行APP下载攻略,简单掌握下载步骤

下一篇:揭秘阿里NTP,网络时间协议深度解析!