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; } }