示例#1
0
        private static int InsertUpdateDelete(Supplier_ContractInfo supplier_ContractInfo, DataProviderAction action)
        {
            int rs = DataProvider.Instance().InsertUpdateDelete(
                action,
                StoredProcedureName.InsertUpdateDelete_Supplier_Contract,
                "@" + TableSupplier_Contract.ID,
                supplier_ContractInfo.ID, supplier_ContractInfo.Supplier_Contract_Name, supplier_ContractInfo.Ordered_Date, supplier_ContractInfo.SupplierID, supplier_ContractInfo.ItemID, supplier_ContractInfo.Purchase_Quantity_Bulbs, supplier_ContractInfo.Price_EUR, supplier_ContractInfo.Shipped_Quantity_Bulbs, supplier_ContractInfo.Note, supplier_ContractInfo.Comment, supplier_ContractInfo.Schedule, supplier_ContractInfo.ETD, supplier_ContractInfo.ETA, supplier_ContractInfo.Loading_Date, supplier_ContractInfo.ETD_CMA_SCHEDULE, supplier_ContractInfo.ETA_CMA_SCHEDULE, supplier_ContractInfo.ETD_ONE_SCHEDULE, supplier_ContractInfo.ETA_ONE_SCHEDULE, supplier_ContractInfo.InformationID, supplier_ContractInfo.OrderID,
                (int)action);

            if (rs > 0 && Cache)
            {
                DataCache.RemoveCache(Key);
            }
            return(rs);
        }
示例#2
0
 public static int Delete(Supplier_ContractInfo supplier_ContractInfo)
 {
     return(InsertUpdateDelete(supplier_ContractInfo, DataProviderAction.Delete));
 }