62,040
社区成员
发帖
与我相关
我的任务
分享
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PRO_AddProduct]
@S_sort int,
@S_sort2 int,
@S_title nvarchar(50),
@S_title_color nvarchar(50),
@S_price money,
@S_space nvarchar(50),
@S_Pic nvarchar(50),
@S_link nvarchar(200),
@S_content ntext,
@S_tu int,
@S_addtime datetime
AS
Begin
Insert into S_product (
S_sort,
S_sort2,
S_title,
S_title_color,
S_price,
S_space,
S_pic,
S_link,
S_content,
S_tu,
S_addtime)
values (
@S_sort,
@S_sort2,
@S_title,
@S_title_color,
@S_price,
@S_space,
@S_Pic,
@S_link,
@S_content,
@S_tu,
@s_addtime)
End
//添加产品
/// <summary>
/// 添加产品数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public int AddProduct(Model.S_product getproduct,string sql)
{
return (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, sql, new SqlParameter("@S_title",getproduct.Sttile),
new SqlParameter("@S_title_color",getproduct.Sttile),
new SqlParameter("@S_sort",getproduct.Ssort),
new SqlParameter("@S_sort2",getproduct.Ssort2),
new SqlParameter("@S_price",getproduct.Sprice),
new SqlParameter("@S_space",getproduct.Sspace),
new SqlParameter("@S_pic",getproduct.Spic),
new SqlParameter("@S_link",getproduct.Slink),
new SqlParameter("@S_content",getproduct.Scontent),
new SqlParameter("@S_tu",getproduct.Stu),
new SqlParameter("@S_addtime",getproduct.Saddtime)
);
}