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