public virtual bool AddOrdersPayment(OrdersPaymentInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Orders_Payment";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Orders_Payment_ID"] = entity.Orders_Payment_ID;
DrAdd["Orders_Payment_OrdersID"] = entity.Orders_Payment_OrdersID;
DrAdd["Orders_Payment_MemberID"] = entity.Orders_Payment_MemberID;
DrAdd["Orders_Payment_PaymentStatus"] = entity.Orders_Payment_PaymentStatus;
DrAdd["Orders_Payment_SysUserID"] = entity.Orders_Payment_SysUserID;
DrAdd["Orders_Payment_DocNo"] = entity.Orders_Payment_DocNo;
DrAdd["Orders_Payment_Name"] = entity.Orders_Payment_Name;
DrAdd["Orders_Payment_ApplyAmount"] = entity.Orders_Payment_ApplyAmount;
DrAdd["Orders_Payment_Amount"] = entity.Orders_Payment_Amount;
DrAdd["Orders_Payment_Status"] = entity.Orders_Payment_Status;
DrAdd["Orders_Payment_Note"] = entity.Orders_Payment_Note;
DrAdd["Orders_Payment_Addtime"] = entity.Orders_Payment_Addtime;
DrAdd["Orders_Payment_Site"] = entity.Orders_Payment_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public virtual bool AddSources(SourcesInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Sources";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Sources_ID"] = entity.Sources_ID;
DrAdd["Sources_Name"] = entity.Sources_Name;
DrAdd["Sources_Code"] = entity.Sources_Code;
DrAdd["Sources_Site"] = entity.Sources_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddContractDividedPayment(ContractDividedPaymentInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Contract_Divided_Payment";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Payment_ID"] = entity.Payment_ID;
DrAdd["Payment_ContractID"] = entity.Payment_ContractID;
DrAdd["Payment_Name"] = entity.Payment_Name;
DrAdd["Payment_Amount"] = entity.Payment_Amount;
DrAdd["Payment_PaymentLine"] = entity.Payment_PaymentLine;
DrAdd["Payment_PaymentStatus"] = entity.Payment_PaymentStatus;
DrAdd["Payment_PaymentTime"] = entity.Payment_PaymentTime;
DrAdd["Payment_Note"] = entity.Payment_Note;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierContractTemplate(SupplierContractTemplateInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_Contract_Template";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Contract_Template_ID"] = entity.Contract_Template_ID;
DrAdd["Contract_Template_Name"] = entity.Contract_Template_Name;
DrAdd["Contract_Template_SupplierID"] = entity.Contract_Template_SupplierID;
DrAdd["Contract_Template_Content"] = entity.Contract_Template_Content;
DrAdd["Contract_Template_Addtime"] = entity.Contract_Template_Addtime;
DrAdd["Contract_Template_Site"] = entity.Contract_Template_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSysState(SysStateInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Sys_State";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Sys_State_ID"] = entity.Sys_State_ID;
DrAdd["Sys_State_CountryCode"] = entity.Sys_State_CountryCode;
DrAdd["Sys_State_Code"] = entity.Sys_State_Code;
DrAdd["Sys_State_CN"] = entity.Sys_State_CN;
DrAdd["Sys_State_IsActive"] = entity.Sys_State_IsActive;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
entity = GetLastSysStateInfo();
entity.Sys_State_Code = Tools.NullStr(entity.Sys_State_ID);
EditSysState(entity);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddStockoutBooking(StockoutBookingInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Stockout_Booking";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Stockout_ID"] = entity.Stockout_ID;
DrAdd["Stockout_Product_Name"] = entity.Stockout_Product_Name;
DrAdd["Stockout_Product_Describe"] = entity.Stockout_Product_Describe;
DrAdd["Stockout_Member_Name"] = entity.Stockout_Member_Name;
DrAdd["Stockout_Member_Tel"] = entity.Stockout_Member_Tel;
DrAdd["Stockout_Member_Email"] = entity.Stockout_Member_Email;
DrAdd["Stockout_IsRead"] = entity.Stockout_IsRead;
DrAdd["Stockout_Addtime"] = entity.Stockout_Addtime;
DrAdd["Stockout_Site"] = entity.Stockout_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddProductPrice(ProductPriceInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Product_Price";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Product_Price_ID"] = entity.Product_Price_ID;
DrAdd["Product_Price_ProcutID"] = entity.Product_Price_ProcutID;
DrAdd["Product_Price_MemberGradeID"] = entity.Product_Price_MemberGradeID;
DrAdd["Product_Price_Price"] = entity.Product_Price_Price;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddLogisticsTender(LogisticsTenderInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Logistics_Tender";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Logistics_Tender_ID"] = entity.Logistics_Tender_ID;
DrAdd["Logistics_Tender_LogisticsID"] = entity.Logistics_Tender_LogisticsID;
DrAdd["Logistics_Tender_SupplierLogisticsID"] = entity.Logistics_Tender_SupplierLogisticsID;
DrAdd["Logistics_Tender_OrderID"] = entity.Logistics_Tender_OrderID;
DrAdd["Logistics_Tender_Price"] = entity.Logistics_Tender_Price;
DrAdd["Logistics_Tender_AddTime"] = entity.Logistics_Tender_AddTime;
DrAdd["Logistics_Tender_IsWin"] = entity.Logistics_Tender_IsWin;
DrAdd["Logistics_Tender_FinishTime"] = entity.Logistics_Tender_FinishTime;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierShopArticle(SupplierShopArticleInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_Shop_Article";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Shop_Article_ID"] = entity.Shop_Article_ID;
DrAdd["Shop_Article_SupplierID"] = entity.Shop_Article_SupplierID;
DrAdd["Shop_Article_Title"] = entity.Shop_Article_Title;
DrAdd["Shop_Article_Content"] = entity.Shop_Article_Content;
DrAdd["Shop_Article_Hits"] = entity.Shop_Article_Hits;
DrAdd["Shop_Article_Addtime"] = entity.Shop_Article_Addtime;
DrAdd["Shop_Article_IsActive"] = entity.Shop_Article_IsActive;
DrAdd["Shop_Article_Site"] = entity.Shop_Article_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddDeliveryTime(DeliveryTimeInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Delivery_Time";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Delivery_Time_ID"] = entity.Delivery_Time_ID;
DrAdd["Delivery_Time_Name"] = entity.Delivery_Time_Name;
DrAdd["Delivery_Time_Sort"] = entity.Delivery_Time_Sort;
DrAdd["Delivery_Time_IsActive"] = entity.Delivery_Time_IsActive;
DrAdd["Delivery_Time_Site"] = entity.Delivery_Time_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierCreditLimitLog(SupplierCreditLimitLogInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_CreditLimit_Log";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["CreditLimit_Log_ID"] = entity.CreditLimit_Log_ID;
DrAdd["CreditLimit_Log_Type"] = entity.CreditLimit_Log_Type;
DrAdd["CreditLimit_Log_SupplierID"] = entity.CreditLimit_Log_SupplierID;
DrAdd["CreditLimit_Log_Amount"] = entity.CreditLimit_Log_Amount;
DrAdd["CreditLimit_Log_AmountRemain"] = entity.CreditLimit_Log_AmountRemain;
DrAdd["CreditLimit_Log_Note"] = entity.CreditLimit_Log_Note;
DrAdd["CreditLimit_Log_Addtime"] = entity.CreditLimit_Log_Addtime;
DrAdd["CreditLimit_Log_PaymentStatus"] = entity.CreditLimit_Log_PaymentStatus;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddMemberCert(MemberCertInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Member_Cert";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Member_Cert_ID"] = entity.Member_Cert_ID;
DrAdd["Member_Cert_Type"] = entity.Member_Cert_Type;
DrAdd["Member_Cert_Name"] = entity.Member_Cert_Name;
DrAdd["Member_Cert_Note"] = entity.Member_Cert_Note;
DrAdd["Member_Cert_Sort"] = entity.Member_Cert_Sort;
DrAdd["Member_Cert_Addtime"] = entity.Member_Cert_Addtime;
DrAdd["Member_Cert_Site"] = entity.Member_Cert_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddLogistics(LogisticsInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Logistics";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Logistics_ID"] = entity.Logistics_ID;
DrAdd["Logistics_NickName"] = entity.Logistics_NickName;
DrAdd["Logistics_Password"] = entity.Logistics_Password;
DrAdd["Logistics_CompanyName"] = entity.Logistics_CompanyName;
DrAdd["Logistics_Name"] = entity.Logistics_Name;
DrAdd["Logistics_Tel"] = entity.Logistics_Tel;
DrAdd["Logistics_Status"] = entity.Logistics_Status;
DrAdd["Logistics_Addtime"] = entity.Logistics_Addtime;
DrAdd["Logistics_Lastlogin_Time"] = entity.Logistics_Lastlogin_Time;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddProductNotify(ProductNotifyInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Product_Notify";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Product_Notify_ID"] = entity.Product_Notify_ID;
DrAdd["Product_Notify_MemberID"] = entity.Product_Notify_MemberID;
DrAdd["Product_Notify_Email"] = entity.Product_Notify_Email;
DrAdd["Product_Notify_ProductID"] = entity.Product_Notify_ProductID;
DrAdd["Product_Notify_IsNotify"] = entity.Product_Notify_IsNotify;
DrAdd["Product_Notify_Addtime"] = entity.Product_Notify_Addtime;
DrAdd["Product_Notify_Site"] = entity.Product_Notify_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddHomeLeftCate(HomeLeftCateInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Home_Left_Cate";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Home_Left_Cate_ID"] = entity.Home_Left_Cate_ID;
DrAdd["Home_Left_Cate_ParentID"] = entity.Home_Left_Cate_ParentID;
DrAdd["Home_Left_Cate_CateID"] = entity.Home_Left_Cate_CateID;
DrAdd["Home_Left_Cate_Name"] = entity.Home_Left_Cate_Name;
DrAdd["Home_Left_Cate_URL"] = entity.Home_Left_Cate_URL;
DrAdd["Home_Left_Cate_Img"] = entity.Home_Left_Cate_Img;
DrAdd["Home_Left_Cate_Sort"] = entity.Home_Left_Cate_Sort;
DrAdd["Home_Left_Cate_Active"] = entity.Home_Left_Cate_Active;
DrAdd["Home_Left_Cate_Site"] = entity.Home_Left_Cate_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierTag(SupplierTagInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_Tag";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Supplier_Tag_ID"] = entity.Supplier_Tag_ID;
DrAdd["Supplier_Tag_Name"] = entity.Supplier_Tag_Name;
DrAdd["Supplier_Tag_Img"] = entity.Supplier_Tag_Img;
DrAdd["Supplier_Tag_Content"] = entity.Supplier_Tag_Content;
DrAdd["Supplier_Tag_Site"] = entity.Supplier_Tag_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierCloseShopApply(SupplierCloseShopApplyInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_CloseShop_Apply";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["CloseShop_Apply_ID"] = entity.CloseShop_Apply_ID;
DrAdd["CloseShop_Apply_SupplierID"] = entity.CloseShop_Apply_SupplierID;
DrAdd["CloseShop_Apply_Note"] = entity.CloseShop_Apply_Note;
DrAdd["CloseShop_Apply_Status"] = entity.CloseShop_Apply_Status;
DrAdd["CloseShop_Apply_AdminNote"] = entity.CloseShop_Apply_AdminNote;
DrAdd["CloseShop_Apply_Addtime"] = entity.CloseShop_Apply_Addtime;
DrAdd["CloseShop_Apply_AdminTime"] = entity.CloseShop_Apply_AdminTime;
DrAdd["CloseShop_Apply_Site"] = entity.CloseShop_Apply_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddKeywordsRanking(KeywordsRankingInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Keywords_Ranking";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["ID"] = entity.ID;
DrAdd["Type"] = entity.Type;
DrAdd["Keyword"] = entity.Keyword;
DrAdd["addtime"] = entity.addtime;
DrAdd["Site"] = entity.Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddMemberAccountOrders(MemberAccountOrdersInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Member_Account_Orders";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Account_Orders_ID"] = entity.Account_Orders_ID;
DrAdd["Account_Orders_MemberID"] = entity.Account_Orders_MemberID;
DrAdd["Account_Orders_SupplierID"] = entity.Account_Orders_SupplierID;
DrAdd["Account_Orders_AccountType"] = entity.Account_Orders_AccountType;
DrAdd["Account_Orders_SN"] = entity.Account_Orders_SN;
DrAdd["Account_Orders_Amount"] = entity.Account_Orders_Amount;
DrAdd["Account_Orders_Status"] = entity.Account_Orders_Status;
DrAdd["Account_Orders_Addtime"] = entity.Account_Orders_Addtime;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierShopGrade(SupplierShopGradeInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_Shop_Grade";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Shop_Grade_ID"] = entity.Shop_Grade_ID;
DrAdd["Shop_Grade_Name"] = entity.Shop_Grade_Name;
DrAdd["Shop_Grade_ProductLimit"] = entity.Shop_Grade_ProductLimit;
DrAdd["Shop_Grade_DefaultCommission"] = entity.Shop_Grade_DefaultCommission;
DrAdd["Shop_Grade_IsActive"] = entity.Shop_Grade_IsActive;
DrAdd["Shop_Grade_Site"] = entity.Shop_Grade_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierSubAccountLog(SupplierSubAccountLogInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_SubAccount_Log";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Log_ID"] = entity.Log_ID;
DrAdd["Log_Supplier_ID"] = entity.Log_Supplier_ID;
DrAdd["Log_SubAccount_ID"] = entity.Log_SubAccount_ID;
DrAdd["Log_SubAccount_Action"] = entity.Log_SubAccount_Action;
DrAdd["Log_SubAccount_Note"] = entity.Log_SubAccount_Note;
DrAdd["Log_Addtime"] = entity.Log_Addtime;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierPriceReportDetail(SupplierPriceReportDetailInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_PriceReport_Detail";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Detail_ID"] = entity.Detail_ID;
DrAdd["Detail_PriceReportID"] = entity.Detail_PriceReportID;
DrAdd["Detail_PurchaseID"] = entity.Detail_PurchaseID;
DrAdd["Detail_PurchaseDetailID"] = entity.Detail_PurchaseDetailID;
DrAdd["Detail_Amount"] = entity.Detail_Amount;
DrAdd["Detail_Price"] = entity.Detail_Price;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddPayWay(PayWayInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Pay_Way";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Pay_Way_Type"] = entity.Pay_Way_Type;
DrAdd["Pay_Way_Name"] = entity.Pay_Way_Name;
DrAdd["Pay_Way_Sort"] = entity.Pay_Way_Sort;
DrAdd["Pay_Way_Status"] = entity.Pay_Way_Status;
DrAdd["Pay_Way_Cod"] = entity.Pay_Way_Cod;
DrAdd["Pay_Way_Img"] = entity.Pay_Way_Img;
DrAdd["Pay_Way_Intro"] = entity.Pay_Way_Intro;
DrAdd["Pay_Way_Site"] = entity.Pay_Way_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public virtual bool AddSysMessage(SysMessageInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Sys_Message";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Message_ID"] = entity.Message_ID;
DrAdd["Message_Type"] = entity.Message_Type;
DrAdd["Message_UserType"] = entity.Message_UserType;
DrAdd["Message_ReceiveID"] = entity.Message_ReceiveID;
DrAdd["Message_SendID"] = entity.Message_SendID;
DrAdd["Message_Content"] = entity.Message_Content;
DrAdd["Message_Addtime"] = entity.Message_Addtime;
DrAdd["Message_Status"] = entity.Message_Status;
DrAdd["Message_Site"] = entity.Message_Site;
DrAdd["Message_IsHidden"] = entity.Message_IsHidden;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddSupplierOnline(SupplierOnlineInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Supplier_Online";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Supplier_Online_ID"] = entity.Supplier_Online_ID;
DrAdd["Supplier_Online_SupplierID"] = entity.Supplier_Online_SupplierID;
DrAdd["Supplier_Online_Type"] = entity.Supplier_Online_Type;
DrAdd["Supplier_Online_Name"] = entity.Supplier_Online_Name;
DrAdd["Supplier_Online_Code"] = entity.Supplier_Online_Code;
DrAdd["Supplier_Online_Sort"] = entity.Supplier_Online_Sort;
DrAdd["Supplier_Online_IsActive"] = entity.Supplier_Online_IsActive;
DrAdd["Supplier_Online_Addtime"] = entity.Supplier_Online_Addtime;
DrAdd["Supplier_Online_Site"] = entity.Supplier_Online_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddRBACUser(RBACUserInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM RBAC_User";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["RBAC_User_GroupID"] = entity.RBAC_User_GroupID;
DrAdd["RBAC_User_Name"] = entity.RBAC_User_Name;
DrAdd["RBAC_User_Password"] = entity.RBAC_User_Password;
DrAdd["RBAC_User_LastLogin"] = entity.RBAC_User_LastLogin;
DrAdd["RBAC_User_LastLoginIP"] = entity.RBAC_User_LastLoginIP;
DrAdd["RBAC_User_Addtime"] = entity.RBAC_User_Addtime;
DrAdd["RBAC_User_Site"] = entity.RBAC_User_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
SaveUserRole(GetLastUserID(entity.RBAC_User_Name), entity.RBACRoleInfos);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddOrdersLog(OrdersLogInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Orders_Log";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Orders_Log_ID"] = entity.Orders_Log_ID;
DrAdd["Orders_Log_OrdersID"] = entity.Orders_Log_OrdersID;
DrAdd["Orders_Log_Addtime"] = entity.Orders_Log_Addtime;
DrAdd["Orders_Log_Operator"] = entity.Orders_Log_Operator;
DrAdd["Orders_Log_Remark"] = entity.Orders_Log_Remark;
DrAdd["Orders_Log_Action"] = entity.Orders_Log_Action;
DrAdd["Orders_Log_Result"] = entity.Orders_Log_Result;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public virtual bool AddRBACUserGroup(RBACUserGroupInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM RBAC_UserGroup";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["RBAC_UserGroup_ID"] = entity.RBAC_UserGroup_ID;
DrAdd["RBAC_UserGroup_Name"] = entity.RBAC_UserGroup_Name;
DrAdd["RBAC_UserGroup_ParentID"] = entity.RBAC_UserGroup_ParentID;
DrAdd["RBAC_UserGroup_Site"] = entity.RBAC_UserGroup_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public virtual bool AddLogisticsLine(LogisticsLineInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Logistics_Line";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Logistics_Line_ID"] = entity.Logistics_Line_ID;
DrAdd["Logistics_Line_Contact"] = entity.Logistics_Line_Contact;
DrAdd["Logistics_Line_CarType"] = entity.Logistics_Line_CarType;
DrAdd["Logistics_Line_Delivery_Address"] = entity.Logistics_Line_Delivery_Address;
DrAdd["Logistics_Line_Receiving_Address"] = entity.Logistics_Line_Receiving_Address;
DrAdd["Logistics_Line_DeliverTime"] = entity.Logistics_Line_DeliverTime;
DrAdd["Logistics_Line_Deliver_Price"] = entity.Logistics_Line_Deliver_Price;
DrAdd["Logistics_Line_Note"] = entity.Logistics_Line_Note;
DrAdd["Logistics_ID"] = entity.Logistics_ID;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool AddProductHistoryPrice(ProductHistoryPriceInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Product_HistoryPrice";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["History_ID"] = entity.History_ID;
DrAdd["History_SysName"] = entity.History_SysName;
DrAdd["History_ProductID"] = entity.History_ProductID;
DrAdd["History_PriceType"] = entity.History_PriceType;
DrAdd["History_Price_Original"] = entity.History_Price_Original;
DrAdd["History_Price_New"] = entity.History_Price_New;
DrAdd["History_Addtime"] = entity.History_Addtime;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
