public bool Insert(PriceLevelInfo priceLevelInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_PriceLevel](");
sql.Append("[CateID],");
sql.Append("[NickName],");
sql.Append("[StartPrice],");
sql.Append("[EndPrice],");
sql.Append("[OrderID]");
sql.Append(") VALUES(");
sql.Append("@CateID,");
sql.Append("@NickName,");
sql.Append("@StartPrice,");
sql.Append("@EndPrice,");
sql.Append("@OrderID");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CateID",priceLevelInfo.CateID),
dbhelper.CreateParameter("@NickName",priceLevelInfo.NickName),
dbhelper.CreateParameter("@StartPrice",priceLevelInfo.StartPrice),
dbhelper.CreateParameter("@EndPrice",priceLevelInfo.EndPrice),
dbhelper.CreateParameter("@OrderID",priceLevelInfo.OrderID)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
priceLevelInfo.Id=ret;
return true;
}
}
public bool Insert(ProductAttrInfo productAttrInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductAttr](");
sql.Append("[CateID],");
sql.Append("[AttrName]");
sql.Append(") VALUES(");
sql.Append("@CateID,");
sql.Append("@AttrName");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CateID",productAttrInfo.CateID),
dbhelper.CreateParameter("@AttrName",productAttrInfo.AttrName)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
productAttrInfo.AttrID=ret;
return true;
}
}
public bool Insert(ProductPicInfo productPicInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductPic](");
sql.Append("[OrderID],");
sql.Append("[ProductNO],");
sql.Append("[SmallPic],");
sql.Append("[MidPic],");
sql.Append("[BigPic]");
sql.Append(") VALUES(");
sql.Append("@OrderID,");
sql.Append("@ProductNO,");
sql.Append("@SmallPic,");
sql.Append("@MidPic,");
sql.Append("@BigPic");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@OrderID",productPicInfo.OrderID),
dbhelper.CreateParameter("@ProductNO",productPicInfo.ProductNO),
dbhelper.CreateParameter("@SmallPic",productPicInfo.SmallPic),
dbhelper.CreateParameter("@MidPic",productPicInfo.MidPic),
dbhelper.CreateParameter("@BigPic",productPicInfo.BigPic)
};
long ret=(long)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
productPicInfo.Id=ret;
return true;
}
}
public bool Insert(ProductCommentReplyInfo productCommentReplyInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductCommentReply](");
sql.Append("[CommentID],");
sql.Append("[Summary]");
sql.Append(") VALUES(");
sql.Append("@CommentID,");
sql.Append("@Summary");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CommentID",productCommentReplyInfo.CommentID),
dbhelper.CreateParameter("@Summary",productCommentReplyInfo.Summary)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
productCommentReplyInfo.Id=ret;
return true;
}
}
public bool Insert(ProductCommentInfo productCommentInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductComment](");
sql.Append("[ProductNO],");
sql.Append("[Title],");
sql.Append("[Merits],");
sql.Append("[Demerits],");
sql.Append("[Summary],");
sql.Append("[Star],");
sql.Append("[ReplyCount]");
sql.Append(") VALUES(");
sql.Append("@ProductNO,");
sql.Append("@Title,");
sql.Append("@Merits,");
sql.Append("@Demerits,");
sql.Append("@Summary,");
sql.Append("@Star,");
sql.Append("@ReplyCount");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productCommentInfo.ProductNO),
dbhelper.CreateParameter("@Title",productCommentInfo.Title),
dbhelper.CreateParameter("@Merits",productCommentInfo.Merits),
dbhelper.CreateParameter("@Demerits",productCommentInfo.Demerits),
dbhelper.CreateParameter("@Summary",productCommentInfo.Summary),
dbhelper.CreateParameter("@Star",productCommentInfo.Star),
dbhelper.CreateParameter("@ReplyCount",productCommentInfo.ReplyCount)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
productCommentInfo.Id=ret;
return true;
}
}
public bool Insert(BrandInfo brandInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_Brand](");
sql.Append("[CateID],");
sql.Append("[NickName],");
sql.Append("[BrandName],");
sql.Append("[OrderID]");
sql.Append(") VALUES(");
sql.Append("@CateID,");
sql.Append("@NickName,");
sql.Append("@BrandName,");
sql.Append("@OrderID");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CateID",brandInfo.CateID),
dbhelper.CreateParameter("@NickName",brandInfo.NickName),
dbhelper.CreateParameter("@BrandName",brandInfo.BrandName),
dbhelper.CreateParameter("@OrderID",brandInfo.OrderID)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
brandInfo.Id=ret;
return true;
}
}
public bool Insert(CategoryInfo categoryInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_Category](");
sql.Append("[CateName],");
sql.Append("[ParentID],");
sql.Append("[LevelID],");
sql.Append("[OrderID],");
sql.Append("[FullPath],");
sql.Append("[PageUrl]");
sql.Append(") VALUES(");
sql.Append("@CateName,");
sql.Append("@ParentID,");
sql.Append("@LevelID,");
sql.Append("@OrderID,");
sql.Append("@FullPath,");
sql.Append("@PageUrl");
sql.Append(");SELECT @@IDENTITY;");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CateName",categoryInfo.CateName),
dbhelper.CreateParameter("@ParentID",categoryInfo.ParentID),
dbhelper.CreateParameter("@LevelID",categoryInfo.LevelID),
dbhelper.CreateParameter("@OrderID",categoryInfo.OrderID),
dbhelper.CreateParameter("@FullPath",categoryInfo.FullPath),
dbhelper.CreateParameter("@PageUrl",categoryInfo.PageUrl)
};
int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
categoryInfo.Id=ret;
return true;
}
}
