public virtual int DelMemberSubAccountLog(int ID)
{
string SqlAdd = "DELETE FROM Member_SubAccount_Log WHERE ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierShopGrade(int ID)
{
string SqlAdd = "DELETE FROM Supplier_Shop_Grade WHERE Shop_Grade_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelCategory(int Cate_ID)
{
string SqlAdd = "DELETE FROM Category WHERE Cate_ID = " + Cate_ID;
try
{
return(SQLHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierLogistics(int ID)
{
string SqlAdd = "DELETE FROM Supplier_Logistics WHERE Supplier_Logistics_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelPaymentInformation(int ID)
{
string SqlAdd = "DELETE FROM Payment_Information WHERE Payment_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelBrand(int Brand_ID)
{
string SqlAdd = "DELETE FROM brand WHERE Brand_ID = " + Brand_ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelDeliveryTime(int ID)
{
string SqlAdd = "DELETE FROM Delivery_Time WHERE Delivery_Time_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSysInterfaceLog(int ID)
{
string SqlAdd = "DELETE FROM Sys_Interface_Log WHERE Log_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelOrdersBackApply(int ID)
{
string SqlAdd = "DELETE FROM Orders_BackApply WHERE Orders_BackApply_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelShoppingAsk(int ID)
{
string SqlAdd = "DELETE FROM Shopping_Ask WHERE Ask_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelConfig(int ID)
{
string SqlAdd = "DELETE FROM Sys_Config WHERE Sys_Config_ID = " + ID;
try {
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex) {
throw ex;
//TraceError.Log(ex);
//return 0;
}
}
public virtual int DelZhongXin(int ID)
{
string SqlAdd = "DELETE FROM ZhongXin WHERE ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierPayBackApply(int ID)
{
string SqlAdd = "DELETE FROM Supplier_PayBack_Apply WHERE Supplier_PayBack_Apply_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelRBACResourceGroup(int ID)
{
string SqlAdd = "DELETE FROM RBAC_ResourceGroup WHERE RBAC_ResourceGroup_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelProductNotify(int ID)
{
string SqlAdd = "DELETE FROM Product_Notify WHERE Product_Notify_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelBidUpRequireQuick(int ID)
{
string SqlAdd = "DELETE FROM Bid_Up_Require_Quick WHERE Bid_Up_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelContractTemplate(int ID)
{
string SqlAdd = "DELETE FROM Contract_Template WHERE Contract_Template_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelRBACPrivilege(string ID)
{
string SqlAdd = "DELETE FROM RBAC_Privilege WHERE RBAC_Privilege_ID = '" + ID + "'";
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelMemberCertType(int ID)
{
string SqlAdd = "DELETE FROM Member_Cert_Type WHERE Member_Cert_Type_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierPurchaseCategory(int ID)
{
string SqlAdd = "DELETE FROM Supplier_Purchase_Category WHERE Cate_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierCreditLimitLog(int ID)
{
string SqlAdd = "DELETE FROM Supplier_CreditLimit_Log WHERE CreditLimit_Log_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierAgentProtocal(int ID)
{
string SqlAdd = "DELETE FROM Supplier_Agent_Protocal WHERE Protocal_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelLogisticsTender(int ID)
{
string SqlAdd = "DELETE FROM Logistics_Tender WHERE Logistics_Tender_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelOrdersInvoice(int ID)
{
string SqlAdd = "DELETE FROM Orders_Invoice WHERE Invoice_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelKeywordsRanking(int ID)
{
string SqlAdd = "DELETE FROM Keywords_Ranking WHERE ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelProductHistoryPrice(int ID)
{
string SqlAdd = "DELETE FROM Product_HistoryPrice WHERE History_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSupplierPriceReport(int ID)
{
string SqlAdd = "DELETE FROM Supplier_PriceReport WHERE PriceReport_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelMemberConsumption(int ID)
{
string SqlAdd = "DELETE FROM Member_Consumption WHERE Consump_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelSysCity(int ID)
{
string SqlAdd = "DELETE FROM Sys_City WHERE Sys_City_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int DelOrdersAccompanyingGoods(int ID)
{
string SqlAdd = "DELETE FROM Orders_Accompanying_Goods WHERE Goods_ID = " + ID;
try
{
return(DBHelper.ExecuteNonQuery(SqlAdd));
}
catch (Exception ex)
{
throw ex;
}
}