|
数据库
( 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
connectionString= />
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">
}
}
（编辑：安卓应用网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
