怎么样把这个方法改成存储过程啊，求大侠帮忙，在在线等

[yezhubaobao]

public void AddressAdd(AddressInfo model,string type,int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Address(");
strSql.Append("Address,City,State,ZipCode,IsMailingAddress,IsPhysicalAddress,Comment)");
strSql.Append(" values (");
strSql.Append("@Address,@City,@State,@ZipCode,@IsMailingAddress,@IsPhysicalAddress,@Comment) ");

if (type.ToLower() == "c")
{
strSql.Append("insert into ChildAddress(");
strSql.Append("ChildId,addId )");
strSql.Append(" values ('");
strSql.Append(id.ToString());
strSql.Append("',@@IDENTITY) ");
}
else if (type.ToLower() == "p")
{
strSql.Append("insert into ParentAddress(");
strSql.Append("ParentId,addId )");
strSql.Append(" values ('");
strSql.Append(id.ToString());
strSql.Append("',@@IDENTITY) ");
}

SqlParameter[] parameters = {
new SqlParameter("@Address", SqlDbType.Char,250),
new SqlParameter("@City", SqlDbType.Char,30),
new SqlParameter("@State", SqlDbType.Char,5),
new SqlParameter("@ZipCode", SqlDbType.Char,10),
new SqlParameter("@IsMailingAddress", SqlDbType.Char,30),
new SqlParameter("@IsPhysicalAddress", SqlDbType.Char,5),
new SqlParameter("@Comment", SqlDbType.Char,100)};
parameters[0].Value = model.Address;
parameters[1].Value = model.City;
parameters[2].Value = model.State;
parameters[3].Value = model.ZipCode;
parameters[4].Value = model.IsMailingAddress;
parameters[5].Value = model.IsPhysicalAddress;
parameters[6].Value = model.Comment;

DbHelperSQL.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}

[bdmh]

很简单，将你的参数改为存储过程的参数即可，比如存储过程中
@Address Varchar(100)
@City Varchar(100)
@ZipCode Varchar(100)

写sql时 就是 exec xxxxx 'aaa','bbb','ccc'

http://www.cnblogs.com/huanlinll/archive/2011/08/02/2119842.html

[yezhubaobao]

你能不能把我的这个整个改一下给我看看，因为我要改好多这样的东西，我不太熟悉，想有一个例子可以给我模仿一下

[wuhailin010]

create proc Proc_table
@Address Varchar(100)
@City Varchar(100)
@ZipCode Varchar(100)
@State Varchar(100)
@IsMailingAddress Varchar(100)
@IsPhysicalAddress Varchar(100)
@Comment Varchar(100)
@type Varchar(10)
@id varchar(50)
as
begin
insert into Address(Address,City,State,ZipCode,IsMailingAddress,IsPhysicalAddress,Comment)
values(
@Address,@City,@State,@ZipCode,@IsMailingAddress,@IsPhysicalAddress,@Comment)
if(lower(@type)='c')
begin
insert into ChildAddress(ChildId,addId )
values (@id,@@IDENTITY)
end
else if(lower(@type)='p')
begin
insert into ParentAddress(ParentId,addId )
values (@id,@@IDENTITY)
end
end
页面传值进去 exec Proc_table model.Address，model.City。。。。。。。

[lvqiuchen]

if exists (select * from sysobjects where name='proc_test')
drop proc proc_test
go
create proc proc_test
@Address nvarchar(50),
@City nvarchar(50),
@State int,
@ZipCode int,
@IsMailingAddress nvarchar(50),
@Comment nvarchar(50)
as
insert into [Address] values(@Address,@City,@State,@ZipCode,@IsMailingAddress,@Comment)
begin
if(@Type='c')then
@
as
insert into ChildAddress ........

是这个流程么

[yezhubaobao]

我也不懂他什么意思，给我好多界面让我把里面色SQL语句全部改成存储过程的，这只是其中一小部分

[yezhubaobao]

[Quote=引用 4 楼 的回复:]

我也不懂他什么意思，给我好多界面让我把里面色SQL语句全部改成存储过程的，这只是其中一小部分

[lvqiuchen]

[Quote=引用 6 楼 的回复:]

[Quote=引用 4 楼 的回复:]

我也不懂他什么意思，给我好多界面让我把里面色SQL语句全部改成存储过程的，这只是其中一小部分
[/Quote]
3楼的更完整.他写得就是你需要的存储过程