1.DAL数据访问层
DAL数据访问层的MainInfoDALcs中添加DeleteMainInfoDAL()方法:根据id删除数据。
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteMainInfoDAL(int id)
{
string sqlStr = @"delete from [dbo].[HKSJ_Main] where ID=@id";
return SqlHelper.ExectuNoQurey(sqlStr, CommandType.Text, new SqlParameter("@id", SqlDbType.Int) { Value = id });
}
2.BLL业务逻辑处理层
BLL业务逻辑处理层的MainInfoBLL.cs中添加DeleteMainInfoBLL()方法,用于调用DAL层的DeleteMainInfoDal()方法进行业务逻辑处理。
/// <summary>
/// 删除BLL
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteMainInfoBLL(int id)
{
return mainInfoDAL.DeleteMainInfoDAL(id);
}
3.UI展示层
(1)添加DeleteNews.ashx一般处理程序。
(2)编辑DeleteNews.ashx中的ProcessRequest方法数据展示:
<%@ WebHandler Language="C#" Class="DeleteNews" %>
using System;
using System.Web;
public class DeleteNews : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
int id = int.Parse(context.Request["id"] ?? "0");
BLL.MainInfoBLL mainInfoBLL = new BLL.MainInfoBLL();
mainInfoBLL.DeleteMainInfoBLL(id);
context.Response.Redirect("MainList.ashx");
}
public bool IsReusable
{
get
{
return false;
}
}
}