コード例 #1
0
        private static int InsertUpdateDelete(Customer_ContractInfo customer_ContractInfo, DataProviderAction action)
        {
            int rs = DataProvider.Instance().InsertUpdateDelete(
                action,
                StoredProcedureName.InsertUpdateDelete_Customer_Contract,
                "@" + TableCustomer_Contract.ID,
                customer_ContractInfo.ID, customer_ContractInfo.Customer_Contract, customer_ContractInfo.Effective_Date, customer_ContractInfo.In_Charge, customer_ContractInfo.CustomerID, customer_ContractInfo.ItemID, customer_ContractInfo.Required_Supplier, customer_ContractInfo.Order_QTY_Bulbs, customer_ContractInfo.Price_VND, customer_ContractInfo.Seeding_Date_Lunar, customer_ContractInfo.Seeding_Date_Gregorian, customer_ContractInfo.Estimated_Arrival_Date, customer_ContractInfo.Note, customer_ContractInfo.ContID, customer_ContractInfo.Date_Arrived, customer_ContractInfo.Deposit, customer_ContractInfo.Date_1, customer_ContractInfo.Delivery_1, customer_ContractInfo.Date_2, customer_ContractInfo.Delivery_2, customer_ContractInfo.Date_3, customer_ContractInfo.Delivery_3, customer_ContractInfo.Date_4, customer_ContractInfo.Delivery_4, customer_ContractInfo.Date_5, customer_ContractInfo.Delivery_5, customer_ContractInfo.InformationID, customer_ContractInfo.OrderID,
                (int)action);

            if (rs > 0 && Cache)
            {
                DataCache.RemoveCache(Key);
            }
            return(rs);
        }
コード例 #2
0
 public static int Delete(Customer_ContractInfo customer_ContractInfo)
 {
     return(InsertUpdateDelete(customer_ContractInfo, DataProviderAction.Delete));
 }