public bool Delete(string _productNO)
{
StringBuilder sql = new StringBuilder();
sql.Append("DELETE FROM");
sql.Append(" [Tbl_Product]");
sql.Append(" WHERE");
sql.Append(" [ProductNO]=@ProductNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",_productNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Delete(int _attrID)
{
StringBuilder sql = new StringBuilder();
sql.Append("DELETE FROM");
sql.Append(" [Tbl_ProductAttr]");
sql.Append(" WHERE");
sql.Append(" [AttrID]=@AttrID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@AttrID",_attrID)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(HotKeyWordInfo hotKeyWordInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_HotKeyWord](");
sql.Append("[KeyWord],");
sql.Append("[CateID],");
sql.Append("[OrderID]");
sql.Append(") VALUES(");
sql.Append("@KeyWord,");
sql.Append("@CateID,");
sql.Append("@OrderID");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@KeyWord",hotKeyWordInfo.KeyWord),
dbhelper.CreateParameter("@CateID",hotKeyWordInfo.CateID),
dbhelper.CreateParameter("@OrderID",hotKeyWordInfo.OrderID)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(AutoNumInfo autoNumInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [AutoNum](");
sql.Append("[KeyID],");
sql.Append("[Seed],");
sql.Append("[SeedDate],");
sql.Append("[Prefix],");
sql.Append("[Summary]");
sql.Append(") VALUES(");
sql.Append("@KeyID,");
sql.Append("@Seed,");
sql.Append("@SeedDate,");
sql.Append("@Prefix,");
sql.Append("@Summary");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@KeyID",autoNumInfo.KeyID),
dbhelper.CreateParameter("@Seed",autoNumInfo.Seed),
dbhelper.CreateParameter("@SeedDate",autoNumInfo.SeedDate),
dbhelper.CreateParameter("@Prefix",autoNumInfo.Prefix),
dbhelper.CreateParameter("@Summary",autoNumInfo.Summary)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(AutoNumInfo autoNumInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [AutoNum]");
sql.Append(" SET");
sql.Append(" [Seed]=@Seed,");
sql.Append(" [SeedDate]=@SeedDate,");
sql.Append(" [Prefix]=@Prefix,");
sql.Append(" [Summary]=@Summary");
sql.Append(" WHERE");
sql.Append(" [KeyID]=@KeyID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@KeyID",autoNumInfo.KeyID)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductPicInfo productPicInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductPic]");
sql.Append(" SET");
sql.Append(" [OrderID]=@OrderID,");
sql.Append(" [ProductNO]=@ProductNO,");
sql.Append(" [SmallPic]=@SmallPic,");
sql.Append(" [MidPic]=@MidPic,");
sql.Append(" [BigPic]=@BigPic");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productPicInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(CustomerInfo customerInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_Customer](");
sql.Append("[CustomerNO],");
sql.Append("[Email],");
sql.Append("[Password],");
sql.Append("[NickName],");
sql.Append("[Telephone],");
sql.Append("[Mobile]");
sql.Append(") VALUES(");
sql.Append("@CustomerNO,");
sql.Append("@Email,");
sql.Append("@Password,");
sql.Append("@NickName,");
sql.Append("@Telephone,");
sql.Append("@Mobile");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CustomerNO",customerInfo.CustomerNO),
dbhelper.CreateParameter("@Email",customerInfo.Email),
dbhelper.CreateParameter("@Password",customerInfo.Password),
dbhelper.CreateParameter("@NickName",customerInfo.NickName),
dbhelper.CreateParameter("@Telephone",customerInfo.Telephone),
dbhelper.CreateParameter("@Mobile",customerInfo.Mobile)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductAttrInfo productAttrInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductAttr]");
sql.Append(" SET");
sql.Append(" [CateID]=@CateID,");
sql.Append(" [AttrName]=@AttrName");
sql.Append(" WHERE");
sql.Append(" [AttrID]=@AttrID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@AttrID",productAttrInfo.AttrID)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(BrandInfo brandInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_Brand]");
sql.Append(" SET");
sql.Append(" [CateID]=@CateID,");
sql.Append(" [NickName]=@NickName,");
sql.Append(" [BrandName]=@BrandName,");
sql.Append(" [OrderID]=@OrderID");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",brandInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(ProductAnswerInfo productAnswerInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductAnswer](");
sql.Append("[ID],");
sql.Append("[ProductNO],");
sql.Append("[ServiceType],");
sql.Append("[Ask],");
sql.Append("[Answer],");
sql.Append("[YesCount],");
sql.Append("[NoCount]");
sql.Append(") VALUES(");
sql.Append("@ID,");
sql.Append("@ProductNO,");
sql.Append("@ServiceType,");
sql.Append("@Ask,");
sql.Append("@Answer,");
sql.Append("@YesCount,");
sql.Append("@NoCount");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productAnswerInfo.Id),
dbhelper.CreateParameter("@ProductNO",productAnswerInfo.ProductNO),
dbhelper.CreateParameter("@ServiceType",productAnswerInfo.ServiceType),
dbhelper.CreateParameter("@Ask",productAnswerInfo.Ask),
dbhelper.CreateParameter("@Answer",productAnswerInfo.Answer),
dbhelper.CreateParameter("@YesCount",productAnswerInfo.YesCount),
dbhelper.CreateParameter("@NoCount",productAnswerInfo.NoCount)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductAnswerInfo productAnswerInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductAnswer]");
sql.Append(" SET");
sql.Append(" [ProductNO]=@ProductNO,");
sql.Append(" [ServiceType]=@ServiceType,");
sql.Append(" [Ask]=@Ask,");
sql.Append(" [Answer]=@Answer,");
sql.Append(" [YesCount]=@YesCount,");
sql.Append(" [NoCount]=@NoCount");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productAnswerInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(ProductAttrValueInfo productAttrValueInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductAttrValue](");
sql.Append("[ProID],");
sql.Append("[AttrID],");
sql.Append("[AttrValue]");
sql.Append(") VALUES(");
sql.Append("@ProID,");
sql.Append("@AttrID,");
sql.Append("@AttrValue");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProID",productAttrValueInfo.ProID),
dbhelper.CreateParameter("@AttrID",productAttrValueInfo.AttrID),
dbhelper.CreateParameter("@AttrValue",productAttrValueInfo.AttrValue)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(ProductExInfo productExInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_ProductEx](");
sql.Append("[ProductNO],");
sql.Append("[Intro],");
sql.Append("[Standards],");
sql.Append("[Packing],");
sql.Append("[Service]");
sql.Append(") VALUES(");
sql.Append("@ProductNO,");
sql.Append("@Intro,");
sql.Append("@Standards,");
sql.Append("@Packing,");
sql.Append("@Service");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productExInfo.ProductNO),
dbhelper.CreateParameter("@Intro",productExInfo.Intro),
dbhelper.CreateParameter("@Standards",productExInfo.Standards),
dbhelper.CreateParameter("@Packing",productExInfo.Packing),
dbhelper.CreateParameter("@Service",productExInfo.Service)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductExInfo productExInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductEx]");
sql.Append(" SET");
sql.Append(" [Intro]=@Intro,");
sql.Append(" [Standards]=@Standards,");
sql.Append(" [Packing]=@Packing,");
sql.Append(" [Service]=@Service");
sql.Append(" WHERE");
sql.Append(" [ProductNO]=@ProductNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productExInfo.ProductNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(PriceLevelInfo priceLevelInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_PriceLevel]");
sql.Append(" SET");
sql.Append(" [CateID]=@CateID,");
sql.Append(" [NickName]=@NickName,");
sql.Append(" [StartPrice]=@StartPrice,");
sql.Append(" [EndPrice]=@EndPrice,");
sql.Append(" [OrderID]=@OrderID");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",priceLevelInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductCommentInfo productCommentInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductComment]");
sql.Append(" SET");
sql.Append(" [ProductNO]=@ProductNO,");
sql.Append(" [Title]=@Title,");
sql.Append(" [Merits]=@Merits,");
sql.Append(" [Demerits]=@Demerits,");
sql.Append(" [Summary]=@Summary,");
sql.Append(" [Star]=@Star,");
sql.Append(" [ReplyCount]=@ReplyCount");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productCommentInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductCommentReplyInfo productCommentReplyInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_ProductCommentReply]");
sql.Append(" SET");
sql.Append(" [CommentID]=@CommentID,");
sql.Append(" [Summary]=@Summary");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",productCommentReplyInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(ProductInfo productInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_Product]");
sql.Append(" SET");
sql.Append(" [CateIDPath]=@CateIDPath,");
sql.Append(" [NickName]=@NickName,");
sql.Append(" [ProductName]=@ProductName,");
sql.Append(" [MarketPrice]=@MarketPrice,");
sql.Append(" [InnerPrice]=@InnerPrice,");
sql.Append(" [BrandID]=@BrandID,");
sql.Append(" [BrandName]=@BrandName");
sql.Append(" WHERE");
sql.Append(" [ProductNO]=@ProductNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productInfo.ProductNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(CustomerInfo customerInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_Customer]");
sql.Append(" SET");
sql.Append(" [Email]=@Email,");
sql.Append(" [Password]=@Password,");
sql.Append(" [NickName]=@NickName,");
sql.Append(" [Telephone]=@Telephone,");
sql.Append(" [Mobile]=@Mobile");
sql.Append(" WHERE");
sql.Append(" [CustomerNO]=@CustomerNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@CustomerNO",customerInfo.CustomerNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Insert(ProductInfo productInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_Product](");
sql.Append("[ProductNO],");
sql.Append("[CateIDPath],");
sql.Append("[NickName],");
sql.Append("[ProductName],");
sql.Append("[MarketPrice],");
sql.Append("[InnerPrice],");
sql.Append("[BrandID],");
sql.Append("[BrandName]");
sql.Append(") VALUES(");
sql.Append("@ProductNO,");
sql.Append("@CateIDPath,");
sql.Append("@NickName,");
sql.Append("@ProductName,");
sql.Append("@MarketPrice,");
sql.Append("@InnerPrice,");
sql.Append("@BrandID,");
sql.Append("@BrandName");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@ProductNO",productInfo.ProductNO),
dbhelper.CreateParameter("@CateIDPath",productInfo.CateIDPath),
dbhelper.CreateParameter("@NickName",productInfo.NickName),
dbhelper.CreateParameter("@ProductName",productInfo.ProductName),
dbhelper.CreateParameter("@MarketPrice",productInfo.MarketPrice),
dbhelper.CreateParameter("@InnerPrice",productInfo.InnerPrice),
dbhelper.CreateParameter("@BrandID",productInfo.BrandID),
dbhelper.CreateParameter("@BrandName",productInfo.BrandName)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
public bool Update(CategoryInfo categoryInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_Category]");
sql.Append(" SET");
sql.Append(" [CateName]=@CateName,");
sql.Append(" [ParentID]=@ParentID,");
sql.Append(" [LevelID]=@LevelID,");
sql.Append(" [OrderID]=@OrderID,");
sql.Append(" [FullPath]=@FullPath,");
sql.Append(" [PageUrl]=@PageUrl");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",categoryInfo.Id)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}