コード例 #1
0
        protected override object FillRecord(object[] fields)
        {
            CustomersVerticalBar record = new CustomersVerticalBar();

            record.CustomerID   = (string)fields[0];
            record.CompanyName  = (string)fields[1];
            record.ContactName  = (string)fields[2];
            record.ContactTitle = (string)fields[3];
            record.Address      = (string)fields[4];
            record.City         = (string)fields[5];
            record.Country      = (string)fields[6];

            return(record);
        }
コード例 #2
0
		protected override object FillRecord(object[] fields)
		{
			CustomersVerticalBar record = new CustomersVerticalBar();

			record.CustomerID = (string) fields[0];
			record.CompanyName = (string) fields[1];
			record.ContactName = (string) fields[2];
			record.ContactTitle = (string) fields[3];
			record.Address = (string) fields[4];
			record.City = (string) fields[5];
			record.Country = (string) fields[6];

			return record;
		}
コード例 #3
0
        public override object ValuesToRecord(object[] values)
        {
            CustomersVerticalBar res = new CustomersVerticalBar();

            res.CustomerID   = values[0].ToString();
            res.CompanyName  = values[1].ToString();
            res.ContactName  = values[2].ToString();
            res.ContactTitle = values[3].ToString();
            res.Address      = values[4].ToString();
            res.City         = values[5].ToString();
            res.Country      = values[6].ToString();

            return(res);
        }
コード例 #4
0
		public override object ValuesToRecord(object[] values)
		{
            CustomersVerticalBar res = new CustomersVerticalBar();
			
			res.CustomerID = values[0].ToString();
			res.CompanyName = values[1].ToString();
			res.ContactName = values[2].ToString();
			res.ContactTitle = values[3].ToString();
			res.Address = values[4].ToString();
			res.City = values[5].ToString();
			res.Country = values[6].ToString();

			return res;

		}
コード例 #5
0
        protected override string GetInsertSql(object record)
        {
            CustomersVerticalBar obj = (CustomersVerticalBar)record;

            return(String.Format("INSERT INTO CustomersTemp (Address, City, CompanyName, ContactName, ContactTitle, Country, CustomerID) " +
                                 " VALUES ( \"{0}\" , \"{1}\" , \"{2}\" , \"{3}\" , \"{4}\" , \"{5}\" , \"{6}\"  ); ",
                                 obj.Address,
                                 obj.City,
                                 obj.CompanyName,
                                 obj.ContactName,
                                 obj.ContactTitle,
                                 obj.Country,
                                 obj.CustomerID
                                 ));
        }
コード例 #6
0
        public override object[] RecordToValues(object record)
        {
            CustomersVerticalBar rec = (CustomersVerticalBar)record;

            object[] values = new object[7];

            values[0] = rec.CustomerID;
            values[1] = rec.CompanyName;
            values[2] = rec.ContactName;
            values[3] = rec.ContactTitle;
            values[4] = rec.Address;
            values[5] = rec.City;
            values[6] = rec.Country;

            return(values);
        }
コード例 #7
0
        public bool IsEqualRecord(object record)
        {
            CustomersVerticalBar rec = (CustomersVerticalBar)record;

            return(this.CustomerID == rec.CustomerID);
        }