示例#1
0
        static void Add_CustomerMaster_Records()
        {
            CUSTOMER_DATA[] data = new CUSTOMER_DATA[4];
            data[0] = new CUSTOMER_DATA("1000", "92867", "CA", "1", "Bryan Williams", "2999 Regency", "Orange");
            data[1] = new CUSTOMER_DATA("1001", "61434", "CT", "1", "Michael Jordan", "13 Main", "Harford");
            data[2] = new CUSTOMER_DATA("1002", "73677", "GA", "1", "Joshua Brown", "4356 Cambridge", "Atlanta");
            data[3] = new CUSTOMER_DATA("1003", "10034", "MO", "1", "Keyon Dooling", "19771 Park Avenue", "Columbia");
            int nRecords = data.Length;

            Delete_Records(recordCustMast);

            Console.WriteLine("\tAdd records in table CustomerMaster...");

            try
            {
                // start a transaction
                MySession.Begin();

                for (int i = 0; i < nRecords; i++)
                {
                    recordCustMast.Clear();

                    // populate record buffer with data
                    recordCustMast.SetFieldAsString(0, data[i].number);
                    recordCustMast.SetFieldAsString(1, data[i].zipcode);
                    recordCustMast.SetFieldAsString(2, data[i].state);
                    recordCustMast.SetFieldAsString(3, data[i].rating);
                    recordCustMast.SetFieldAsString(4, data[i].name);
                    recordCustMast.SetFieldAsString(5, data[i].address);
                    recordCustMast.SetFieldAsString(6, data[i].city);

                    // add record
                    recordCustMast.Write();
                }

                // commit transaction
                MySession.Commit();
            }
            catch (CTException E)
            {
                Handle_Exception(E);
            }
        }