asp.net三层架构增删改查
发布时间:2020-12-15 21:27:13 所属栏目:asp.Net 来源:网络整理
导读:数据库 ( sysdatabases name span style="color: #0000ff"use span style="color: #000000" bond span style="color: #008080"-- span style="color: #008080"基金类型表(左用) span style="color: #0000ff"if span style="color: #808080"exists (span styl
数据库 ( sysdatabases name <span style="color: #0000ff">use<span style="color: #000000"> bond
<span style="color: #008080">--<span style="color: #008080">基金类型表(左用) <span style="color: #0000ff">if <span style="color: #808080">exists (<span style="color: #0000ff">select <span style="color: #808080">* <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx<span style="color: #ff0000">'<span style="color: #000000">) <span style="color: #0000ff">drop <span style="color: #0000ff">table<span style="color: #000000"> jjlx <span style="color: #0000ff">create <span style="color: #0000ff">table<span style="color: #000000"> jjlx ( id <span style="color: #0000ff">int <span style="color: #0000ff">primary <span style="color: #0000ff">key <span style="color: #ff00ff">identity(<span style="color: #800000; font-weight: bold">1,<span style="color: #800000; font-weight: bold">1),<span style="color: #008080">--<span style="color: #008080">id jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50) <span style="color: #808080">not <span style="color: #0000ff">null <span style="color: #008080">--<span style="color: #008080">基金类型 <span style="color: #000000">) <span style="color: #008080">--<span style="color: #008080">基金类型表增加存储过程 <span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">select <span style="color: #808080"> <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_add<span style="color: #ff0000">'<span style="color: #000000">) <span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_add <span style="color: #0000ff">go <span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_add <span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">) <span style="color: #0000ff">as <span style="color: #0000ff">insert <span style="color: #0000ff">into jjlx <span style="color: #0000ff">values (<span style="color: #008000">@jjlx<span style="color: #000000">) <span style="color: #0000ff">go <span style="color: #008080">--<span style="color: #008080">基金类型表查询存储过程 <span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">select <span style="color: #808080"> <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">p_jjlx<span style="color: #ff0000">'<span style="color: #000000">) <span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> p_jjlx <span style="color: #0000ff">go <span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> p_jjlx <span style="color: #0000ff">as <span style="color: #0000ff">select <span style="color: #808080"> <span style="color: #0000ff">from<span style="color: #000000"> jjlx <span style="color: #0000ff">go <span style="color: #008080">--<span style="color: #008080">基金类型表修改存储过程 <span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">select <span style="color: #808080"> <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_gai<span style="color: #ff0000">'<span style="color: #000000">) <span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_gai <span style="color: #0000ff">go <span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_gai <span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">) <span style="color: #0000ff">as <span style="color: #0000ff">UPDATE jjlx <span style="color: #0000ff">SET jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id <span style="color: #0000ff">go <span style="color: #008080">--<span style="color: #008080">基金类型表删除存储过程 <span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">select <span style="color: #808080">* <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_delete<span style="color: #ff0000">'<span style="color: #000000">) <span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_delete <span style="color: #0000ff">go <span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_delete <span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">) <span style="color: #0000ff">as <span style="color: #0000ff">delete <span style="color: #0000ff">from jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id <span style="color: #808080">and jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx <span style="color: #0000ff">go 链接数据库Web.config Model层managementModel类 <span style="color: #0000ff">namespace<span style="color: #000000"> managementModel
{ <span style="color: #0000ff">public <span style="color: #0000ff">class jjlxs<span style="color: #008000">//<span style="color: #008000">基金类型表 <span style="color: #000000"> { <span style="color: #0000ff">public <span style="color: #0000ff">int id { <span style="color: #0000ff">set; <span style="color: #0000ff">get; }<span style="color: #008000">//<span style="color: #008000">id <span style="color: #0000ff">public <span style="color: #0000ff">string jjlx { <span style="color: #0000ff">set; <span style="color: #0000ff">get; } <span style="color: #008000">//<span style="color: #008000">基金类型 <span style="color: #000000"> } } DAL层添加引用 Model层添加程序集引用 using System.Configuration;managementDAL类 =
sql =
sql = = SqlParameter(
sql = = SqlParameter( SqlParameter(
sql = = SqlParameter(
DBHelper类 conn = ConfigurationManager.ConnectionStrings[
IUD( count = = = ==
DataSet Search(= = =
}
} BLL层添加引用 Model层添加引用 DAL层 =
flag = (stujjlx.jjlx.Length != count = (count > =
flag = (stujjlx.jjlx.Length != &&stujjlx.id!= count = (count > =
flag = (stujjlx.jjlx.Length != && stujjlx.id != count = (count > =
UI 层添加引用 Model层添加引用 BLL层基金类型.aspx <%@ Page Language= AutoEventWireup= CodeBehind= Inherits= %>
<!DOCTYPE html> <html xmlns=<span style="color: #800000">" <span style="color: #800000">http://www.w3.org/1999/xhtml<span style="color: #800000">"><head runat=<span style="color: #800000">"<span style="color: #800000">server<span style="color: #800000">"> <meta http-equiv=<span style="color: #800000">"<span style="color: #800000">Content-Type<span style="color: #800000">" content=<span style="color: #800000">"<span style="color: #800000">text/html; charset=utf-8<span style="color: #800000">"/> |