结合MVC.NET相关知识实现在线卖酒销售项目(三)

结合项目二内容本章内容运用到ASP.NET里面”Web用户控件“与“水印”功能

一、结合第二章内容已经实现产品详细，本章内容主要运用“ASP.NETWeb用户控件”来实现”查找产品“，

首先“BraSys”项目里面新建一个文件夹名叫“FindControl”，在“FindControl文件夹”添加新项，选择“Web用户控件”名为“BraControl.ascx”

如图所示：

二、添加完成后，在“设计”拖进“TextBox控件”和“LinkButton控件”分别来时实现客户”输入“和“提交”功能并添加适合样式

如图所示：

代码示例：

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="BraControl.ascx.cs" Inherits="FindControl_BraControl" %>
<style type="text/css">
    span 
    {
        margin-left:40%;
        line-height:30px;
        font-weight:bold;
        
    }
</style>
<span>请输入关键字<asp:TextBox Width="150px" Height="20px" ID="txtKey" runat="server"></asp:TextBox></span>
<asp:LinkButton ID="lkbFind" runat="server" Font-Bold="True" Font-Strikeout="False" Font-Underline="False">查 找</asp:LinkButton>

View Code

三、完成后，来到“BraClothList.aspx窗体”找到合适位置，把““BraControl.ascx”Web用户控件”拖进去

如图所示：

四、拖进后，添加一个“Web窗体”主要实现”查找到产品“，改名为“BraFind.aspx”,选择“母版”，

拖进一个“DataList控件”编辑前台代码，接着也拖进“BraControl.ascxWeb用户控件”

1、如图所示（DataList前台代码）：

2、如图所示（Web用户控件）

代码示例

<%@ Page Title="" Language="C#" MasterPageFile="~/BrasServer/Bratheme.master" AutoEventWireup="true" CodeFile="BraFind.aspx.cs" Inherits="BrasServer_BraFind" %>

<%@ Register Src="~/FindControl/BraControl.ascx" TagPrefix="uc1" TagName="BraControl" %>


<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<style type="text/css">
    .DataListdiv 
    {
        margin-left:20%;
    }
</style>
<fieldset>
    <legend>产品查找</legend>
    <div>
        <uc1:BraControl runat="server" ID="BraControl" />
    </div>

    <div class="DataListdiv">
        <asp:DataList ID="BraProductList" runat="server">
            <ItemTemplate>
             <table style="width:100%;height:180px;">                       
                <tr>
                    <td rowspan="5">
                        <asp:Image ID="Image1" runat="server" Width="165px" Height="175px" BorderWidth="5" ImageUrl='<%#Eval("ImgSrc","~/{0}") %>'/>
                    </td>
                    <td>
                        <a href='BarDetail.aspx?ProductId=<%#Eval("ProductId") %>' class="a1">
                            <%#Eval("ProductName") %></a>
                    </td>
                </tr>
                <tr>
                    <td class="a3">价格：<%#Eval("Price","{0:F1}") %></td>                        
                </tr>
                <tr>
                    <td class="a3">日期：<%#Eval("PublishDate","{0:yyyy-MM-dd}") %>></td>
                </tr>
                <tr>
                    <td style="width:270px">
                        <span class="a2">
                        <a href='ShowCart.aspx?ProductId=<%#Eval("ProductId") %>'>
                        <img  src="../images/btn_new.jpg" style="height:32px;width:100px;" />添加购物车</a>
                    </span>
                    </td>
                </tr>
                <tr>
                    <td colspan="3" style="border-bottom:2px solid red;height:5px;">&nbsp;</td>
                </tr>                       
                </table>
             </ItemTemplate>
        </asp:DataList>
    </div>
</fieldset>
</asp:Content>

View Code

五、运用数据库写出“通过关键字查询数据”方法，通过”三层架构“调用

1、如图所示（SQL方法语句）

代码示例：

--通过关键字来查找数据

create proc Xyy_BarProductByKey
@Key varchar(200)
as
begin
select ProductId,ProductName,Price,PublishDate,ImgSrc from Bars
where ProductName like '%'+@Key+'%'
end

View Code

2、如图所示：（数据访问层）

代码示例：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DBUtility;
using Models;
using System.Data.SqlClient;
namespace DAL
{
    public class BarsService
    {
        //日期排序
        public List<Bars> Xyy_BarGetpageList(string key, int startindex, int endidenx, string orderkey)
        {
            List<Bars> lst = new List<Bars>();
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@Key",key),
                new SqlParameter("@StartIdenx",startindex),
                new SqlParameter("@EndIdenx",endidenx),
                new SqlParameter("@OrderKey",orderkey)
            };
            using (SqlDataReader dr = SqlHelper.ExecuteReader("Xyy_BarGetpageList", param))
            {
                while (dr.Read())
                {
                    lst.Add(new Bars
                    {
                        ProductId = Convert.ToInt32(dr["ProductId"]),
                        ProductName = Convert.ToString(dr["ProductName"]),
                        Price = Convert.ToInt32(dr["Price"]),
                        PublishDate = dr["PublishDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["PublishDate"]),
                        ImgSrc = dr["ImgSrc"].ToString()
                    });
                }
            }
            return lst;
        }
        //分类选中
        public int XYY_Bars_Count_Key(string cateid)
        {
            SqlParameter[] param = new SqlParameter[] 
           {
               new SqlParameter("@categoryid",cateid)
           };
            object obj = SqlHelper.ExecuteScalar("XYY_Product_Count_Key", param);
            if (obj != null)
            {
                return Convert.ToInt32(obj);
            }
            else
            {
                return 0;
            }
        }
        //获取产品详细
        public Bars Xyy_ProductGetModel(string productId)
        {
            SqlParameter[] param = new SqlParameter[] 
            {
                new SqlParameter("@ProductId",productId)
            };
            Bars models = null;
            using (SqlDataReader dr = SqlHelper.ExecuteReader("Xyy_ProductGetModel", param))
            {
                if (dr.Read())
                {
                    models = new Bars();
                    models.ProductId = Convert.ToInt32(dr["ProductId"]);
                    models.ProductName = Convert.ToString(dr["ProductName"]);
                    models.Brand = Convert.ToString(dr["Brand"]);
                    models.CategoryId = dr["CategoryId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["CategoryId"]);
                    models.Price = Convert.ToInt32(dr["Price"]);
                    models.nContent = Convert.ToString(dr["nContent"]);
                    models.ImgSrc = Convert.ToString(dr["ImgSrc"]);
                    models.PublishDate = dr["PublishDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["PublishDate"]);
                    models.Area = Convert.ToString(dr["Area"]);
                    models.Fresh = Convert.ToString(dr["Fresh"]);
                    models.CliclTime = Convert.ToInt32(dr["CliclTime"]);
                    models.Vis = Convert.ToBoolean(dr["Vis"]);
                }
            }
            return models;
        }
        //通过关键字查找数据
        public List<Bars> Xyy_BraProductByKey(string Key)
        {
            List<Bars> lst = new List<Bars>();
            SqlParameter[] param = new SqlParameter[] 
            {
                new SqlParameter("@Key",Key)
            };
            Bars model = null;
            using (SqlDataReader dr = SqlHelper.ExecuteReader("Xyy_BarProductByKey", param))
            {
                while(dr.Read())
                {
                    model = new Bars();
                    model.ProductId = Convert.ToInt32(dr["ProductId"]);
                    model.ProductName = Convert.ToString(dr["ProductName"]);
                    model.Price = Convert.ToInt32(dr["Price"]);
                    model.PublishDate = dr["PublishDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["PublishDate"]);
                    model.ImgSrc = Convert.ToString(dr["ImgSrc"]);
                    lst.Add(model);
                }
            }
            return lst;
        }
    }
}

View Code

3、如图所示（逻辑层）

代码示例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Models;
using DAL;
namespace BLL
{
    public class BarManager
    {
        BarsService dal = new BarsService();
           //日期
        public List<Bars> Xyy_BarGetpageList(string key, int startindex, int endidenx, string orderkey)
        {
            return dal.Xyy_BarGetpageList(key, startindex, endidenx, orderkey);
        }
         //分类选中
        public int XYY_Bars_Count_Key(string cateid)
        {
            return dal.XYY_Bars_Count_Key(cateid);
        }
          //获取产品详细
        public Bars Xyy_ProductGetModel(string productId)
        {
            return dal.Xyy_ProductGetModel(productId);
        }
        //通过关键字查找数据
        public List<Bars> Xyy_BraProductByKey(string Key)
        {
            return dal.Xyy_BraProductByKey(Key);
        }
    }
}

View Code

六、在调用“表示层”时，先在”BraControl.ascxWed用户控件“编辑"委托事件"

如图所示：

代码示例：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class FindControl_BraControl : System.Web.UI.UserControl
{
    //定义委托
    public delegate void LkbCllick(string key);
    public event LkbCllick OnLkbClick;
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    //定义属性
    public string Text 
    {
        get { return txtKey.Text; }
        set { txtKey.Text = value; }
    }
    //查找事件
    protected void lkbFind_Click(object sender, EventArgs e)
    {
        if (OnLkbClick != null)
        {
            string key = txtKey.Text;
            OnLkbClick(key);
        }
    }
}

View Code

七、在“BraClothList.aspx窗体”和“BraFind.aspx窗体”调用”触发事件“

1、如图所示（BraClothList.aspx窗体）：

代码示例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using Models;
using BLL;
public partial class BrasServer_BraClothList : System.Web.UI.Page
{
    CategoriesManager cll = new CategoriesManager();
    BarManager bll = new BarManager();
    private int pageSize = 4;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //初始化
            pageIndex = 0;
            OrderKey = "Price";
            LoadCates();
            //设置第一行选中
            lbCates.SelectedIndex = 1;
            lbCates_SelectedIndexChanged(null, null);
        }
        //注册用户控件事件
        BraControl.OnLkbClick += new FindControl_BraControl.LkbCllick(Lkb_Click);
    }
    //触发事件
    private void Lkb_Click(string key) 
    {
        Response.Redirect("~/BrasServer/BraFind.aspx?Key=" + key);     
    }
    //种类
    private void LoadCates()
    { 
        lbCates.DataValueField = "CateId";
        lbCates.DataTextField = "Name";
        lbCates.DataSource = cll.Xyy_Categories_GetList();
        lbCates.DataBind();
    }
    //加载数据
    private void LoadData()
    {
        string key = "";
        if (lbCates.SelectedValue != "0")
        {
            key = " where CategoryId=" + lbCates.SelectedValue + " and Vis=1";
        }
        repClothList.DataSource = bll.Xyy_BarGetpageList(key, pageSize * pageIndex + 1, pageSize * (pageIndex + 1), OrderKey);
        repClothList.DataBind();
        if (repClothList.Items.Count > 0)
        {
            //显示分页
            lblPage.Text = ViewState["msg"].ToString() + ",当前第：" +
                (pageIndex + 1).ToString() + "页";
        }
        else
        {
            lblPage.Text = ViewState["msg"].ToString() + ",当前第0页";
        }
        SetButtonState();
    }
    //设置按钮状态
    private void SetButtonState()
    {
        //设置所有按钮有效
        lkbprev.Enabled = true;
        lkbNext.Enabled = true;
        //设置无效按钮
        if (pageIndex == 0)
        {
            lkbprev.Enabled = false;
        }
        if (pageIndex + 1 == PageCount || PageCount == 0)
        {
            lkbNext.Enabled = false;
        }
    }
    //页面索引
    private int pageIndex
    {
        get {return (int)ViewState["pageindex"]; }
        set { ViewState["pageindex"] = value; }
    }
    //排序索引
    private string OrderKey
    {
        get { return ViewState["order"].ToString(); }
        set { ViewState["order"] = value; }
    }
    //总页数
    private int PageCount
    {
        get { return (int)ViewState["pagecount"]; }
        set { ViewState["pagecount"] = value; }
    }
    //分类选中事件
    protected void lbCates_SelectedIndexChanged(object sender, EventArgs e)
    {
        pageIndex = 0;
        int count = bll.XYY_Bars_Count_Key(lbCates.SelectedValue);
        PageCount = (int)Math.Ceiling(count * 1.0 / pageSize); //总页数
        ViewState["msg"] = "总有：" + count.ToString() + 
            "记录，共有：" + PageCount.ToString() + "页";
        LoadData();
    }
    //上一页
    protected void lkbprev_Click(object sender, EventArgs e)
    {
        pageIndex--;
        LoadData();
    }
    //下一页
    protected void lkbNext_Click(object sender, EventArgs e)
    {
        pageIndex++;
        LoadData();
    }
}

View Code

2、如图所示（BraFind.aspx窗体）

代码示例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using Models;
using BLL;
public partial class ClothesFind : System.Web.UI.Page
{
    ProductManager bll = new ProductManager();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadData();
            if (Request.QueryString["Key"] != null)
            {
                FindControl.Text = Request.QueryString["Key"];
            }    
        }
        //注册用户控件事件
        FindControl.OnLkbClick += new Controls_FindControl.LkbCllick(Lkb_Click);
    }
    //触发事件
    private void Lkb_Click(string key)
    {
        ProductList.DataSource = bll.GetListByKey(key);
        ProductList.DataBind();
    }
    //加载数据
    private void LoadData()
    {
        string Key = "";
        if (Request.QueryString["Key"] != null) 
             Key=Request.QueryString["Key"];
            ProductList.DataSource = bll.GetListByKey(Key);
            ProductList.DataBind();
            
        
    }
}

View Code

3、如图所示（绑定按钮事件）

八、完成”Web用户控件“功能后，实现“水印”，在“BraSys”项目添加一个文件名为"Handles",

在"Handles"添加"一般处理程序"名为"ImgHandler.ashx"

如图所示：

九、在”ImgHandler.ashx“一般处理程序编辑”水印“方法

如图所示：

代码示例;

<%@ WebHandler Language="C#" Class="ImgHandler" %>

using System;
using System.Web;

using System.Drawing;
using Models;
using BLL;
using System.Drawing.Drawing2D;
public class ImgHandler : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
        //获取产品Id
        string id = context.Request.QueryString["Id"];
        Bars bs = new BarManager().Xyy_ProductGetModel(id);
        context.Response.ContentType = "image/jpeg";
        //转成物理路径
        string path = context.Server.MapPath("~/" + bs.ImgSrc);
        //把图片路径转成图片对象
        Image img = Image.FromFile(path);
        //导入画板
        Graphics g = Graphics.FromImage(img);
        Matrix matrix = new Matrix();
        //旋转45度
        matrix.Rotate(45);
       
        g.Transform = matrix;
        g.DrawLine(Pens.Blue, 0, 0, 0, 0);
        //定义刷子
        SolidBrush brusb = new SolidBrush(Color.Red);
        //在画布上写入文字
        g.DrawString("羊羊羊",new Font("宋体",50f),brusb,150,-10);
        //输出
        img.Save(context.Response.OutputStream,
            System.Drawing.Imaging.ImageFormat.Jpeg);
        context.Response.End();
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}

View Code

十、来“BrasServer/BraFind.aspx”窗体前台代码绑定图片路径，注释点之前的

如图所示：

代码示例

<%@ Page Title="" Language="C#" MasterPageFile="~/BrasServer/Bratheme.master" AutoEventWireup="true" CodeFile="BraFind.aspx.cs" Inherits="BrasServer_BraFind" %>

<%@ Register Src="~/FindControl/BraControl.ascx" TagPrefix="uc1" TagName="BraControl" %>


<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
&nbsp;<style type="text/css">
    .DataListdiv 
    {
        margin-left:20%;
    }
</style><fieldset>
    <legend>产品查找</legend>
    <div>
        <uc1:BraControl runat="server" ID="BraControl" />
    </div>

    <div class="DataListdiv">
        <asp:DataList ID="BraProductList" runat="server" RepeatColumns="2">
            <ItemTemplate>
                <table style="width: 100%;">
                    <tr>
                        <td rowspan="5">
                          <%--  <asp:Image ID="Image1" runat="server" Width="165px" Height="175px" BorderWidth="5" ImageUrl='<%#Eval("ImgSrc","~/{0}") %>' />--%>
                              <asp:Image ID="Image1" runat="server" Width="165px" Height="175px" BorderWidth="5" 
                                  ImageUrl='<%#Eval("ProductId","~/Handles/ImgHandler.ashx?Id={0}") %>' />
                        </td>

                        <td style="text-align:center">
                            <a href='BarDetail.aspx?ProductId=<%#Eval("ProductId") %>' class="a1">
                                <%#Eval("ProductName") %></a>
                        </td>
                    </tr>
                    <tr>
                        <td class="a3">价格：<%#Eval("Price","{0:F1}") %></td>
                    </tr>
                    <tr>
                        <td class="a3">日期：<%#Eval("PublishDate","{0:yyyy-MM-dd}") %>></td>
                    </tr>
                    <tr>
                        <td style="width: 270px">
                            <span class="a2">
                                <a href='ShowCart.aspx?ProductId=<%#Eval("ProductId") %>'>
                                    <img src="../images/btn_new.jpg" style="height: 32px; width: 100px;" />添加购物车</a>
                            </span>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="3" style="border-bottom: 2px solid red; height: 5px;">&nbsp;</td>
                    </tr>
                </table>
            </ItemTemplate>
        </asp:DataList>
    </div>
</fieldset>
</asp:Content>

View Code

十一、最后编辑“Web.config”文件就可以了

如图所示：

代码示例：

<?xml version="1.0" encoding="utf-8"?>

<!--
  有关如何配置 ASP.NET 应用程序的详细信息，请访问
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
    </system.web>
  <!--印刷-->
  <system.webServer>
    <handlers>
      <add name="Handles" verb="*" path="ImgSrc/*.jpg" type="ImgConver"/>
    </handlers>
  </system.webServer>
  
<connectionStrings>
    <add name="ConnectString" connectionString="Data Source=.;Initial Catalog=BarsSys;User ID=sa;Pwd=sa;"/>
</connectionStrings>
</configuration>

View Code

运行效果：

posted @ 2017-02-09 14:14 羊羊君阅读(238) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

xuyangyang

结合MVC.NET相关知识实现在线卖酒销售项目(三)

结合项目二内容本章内容运用到ASP.NET里面”Web用户控件“与“水印”功能

公告

xuyangyang

结合MVC.NET相关知识实现在线卖酒销售项目(三)

结合项目二内容 本章内容运用到ASP.NET里面”Web用户控件“与“水印”功能

公告

结合项目二内容本章内容运用到ASP.NET里面”Web用户控件“与“水印”功能