public Base_NhomSanPham()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("NhomSanPhamID", "NhomSanPhamID")
                            ,
                            new DataColumnMapping("TenNhomSanPham", "TenNhomSanPham")
                            ,
                            new DataColumnMapping("MoTaNhomSanPham", "MoTaNhomSanPham")
                            ,
                            new DataColumnMapping("NhomChaID", "NhomChaID")
                            ,
                            new DataColumnMapping("Show", "Show")
                            ,
                            new DataColumnMapping("SapXep", "SapXep")
                            ,
                            new DataColumnMapping("Bak1", "Bak1")
                            ,
                            new DataColumnMapping("Bak2", "Bak2")
                            ,
                            new DataColumnMapping("Bak3", "Bak3")
                            ,
                            new DataColumnMapping("Bak4", "Bak4")
                            ,
                            new DataColumnMapping("Bak5", "Bak5")
                            ,
                            new DataColumnMapping("KhuVucShow", "KhuVucShow")
                        };
     dtTblMapping = new DataTableMapping("Table", "NhomSanPham", dtColMapping);
 }

 public Base_DauGia()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("DauGiaID", "DauGiaID")
                            ,
                            new DataColumnMapping("SanPhamID", "SanPhamID")
                            ,
                            new DataColumnMapping("GiaBanNgay", "GiaBanNgay")
                            ,
                            new DataColumnMapping("GiaKhoiDiem", "GiaKhoiDiem")
                            ,
                            new DataColumnMapping("BuocGia", "BuocGia")
                            ,
                            new DataColumnMapping("BatDau", "BatDau")
                            ,
                            new DataColumnMapping("KetThuc", "KetThuc")
                            ,
                            new DataColumnMapping("TraGiaID", "TraGiaID")
                            ,
                            new DataColumnMapping("Bak1", "Bak1")
                            ,
                            new DataColumnMapping("Bak2", "Bak2")
                            ,
                            new DataColumnMapping("Bak3", "Bak3")
                            ,
                            new DataColumnMapping("Bak4", "Bak4")
                        };
     dtTblMapping = new DataTableMapping("Table", "DauGia", dtColMapping);
 }

 public Base_QuangCao()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("QuangCaoID", "QuangCaoID")
                            ,
                            new DataColumnMapping("DuongDan", "DuongDan")
                            ,
                            new DataColumnMapping("NoiDungQuangCao", "NoiDungQuangCao")
                            ,
                            new DataColumnMapping("DuongDanAnh", "DuongDanAnh")
                            ,
                            new DataColumnMapping("NguoiDungID", "NguoiDungID")
                            ,
                            new DataColumnMapping("GhiChu", "GhiChu")
                            ,
                            new DataColumnMapping("LoaiAnh", "LoaiAnh")
                            ,
                            new DataColumnMapping("SapXep", "SapXep")
                            ,
                            new DataColumnMapping("Bak1", "Bak1")
                            ,
                            new DataColumnMapping("Bak2", "Bak2")
                            ,
                            new DataColumnMapping("Bak3", "Bak3")
                            ,
                            new DataColumnMapping("Bak4", "Bak4")
                        };
     dtTblMapping = new DataTableMapping("Table", "QuangCao", dtColMapping);
 }

 public static DataTableMapping CreateDataTableMapping(string sourceTable, string dataSetTable, DataColumnMappingCollection dataColumnMappings)
 {
     DataTableMapping dataTableMapping = new DataTableMapping(sourceTable, dataSetTable);
     foreach (DataColumnMapping dataColumnMapping in dataColumnMappings)
         dataTableMapping.ColumnMappings.Add(dataColumnMapping);
     return dataTableMapping;
 }

 public Base_HoiDapSanPham()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("HoiDapID", "HoiDapID")
                            ,
                            new DataColumnMapping("SanPhamID", "SanPhamID")
                            ,
                            new DataColumnMapping("NguoiDungID", "NguoiDungID")
                            ,
                            new DataColumnMapping("NguoiHoi", "NguoiHoi")
                            ,
                            new DataColumnMapping("CauHoi", "CauHoi")
                            ,
                            new DataColumnMapping("TraLoi", "TraLoi")
                            ,
                            new DataColumnMapping("NgayHoi", "NgayHoi")
                            ,
                            new DataColumnMapping("NgayTraLoi", "NgayTraLoi")
                            ,
                            new DataColumnMapping("bak", "bak")
                            ,
                            new DataColumnMapping("bak1", "bak1")
                            ,
                            new DataColumnMapping("ChiTietCauHoi", "ChiTietCauHoi")
                        };
     dtTblMapping = new DataTableMapping("Table", "HoiDapSanPham", dtColMapping);
 }

 protected override RowUpdatingEventArgs CreateRowUpdatingEvent(
 DataRow dataRow,
 IDbCommand command,
 StatementType statementType,
 DataTableMapping tableMapping)
 {
     return null;
 }

		public FbRowUpdatedEventArgs(
			DataRow				row, 
			IDbCommand			command, 
			StatementType		statementType, 
			DataTableMapping		tableMapping)
			: base(row, command, statementType, tableMapping) 
		{
		}

		RowUpdatedEventArgs (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) 
		{
			this.dataRow = dataRow;
			this.command = command;
			this.statementType = statementType;
			this.tableMapping = tableMapping;
			this.status = UpdateStatus.Continue;
		}

		protected override RowUpdatedEventArgs CreateRowUpdatedEvent(
			DataRow dataRow,
			IDbCommand command,
			StatementType statementType,
			DataTableMapping tableMapping)
		{
			return new NpgsqlRowUpdatedEventArgs(dataRow, command, statementType, tableMapping);
		}

		/// <summary>
		/// 获取映射表
		/// </summary>
		public DataTableMapping GetTableMapping(DataTable dt)
		{
			if (TableMapping.ColumnMappings.Count == 0 && dt.Columns.Count > 0)
			{
				TableMapping = Apq.Data.DataTable.CreateDefaultTableMapping(dt);
			}

			return TableMapping;
		}

		protected RowUpdatedEventArgs (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping) 
		{
			this.dataRow = dataRow;
			this.command = command;
			this.statementType = statementType;
			this.tableMapping = tableMapping;
			this.errors = null;
			this.status = UpdateStatus.Continue;
			this.recordsAffected = 0; // FIXME
		}

		public void GetReady()
		{
			tabs=new DataTableMapping[5];
			tabs[0]=new DataTableMapping("sourceCustomers", "dataSetCustomers");
			tabs[1]=new DataTableMapping("sourceEmployees", "dataSetEmployees");
			tabs[2]=new DataTableMapping("sourceBooks", "dataSetBooks");
			tabs[3]=new DataTableMapping("sourceStore", "dataSetStore");
			tabs[4]=new DataTableMapping("sourceInventory", "dataSetInventory");
			tableMapCollection=new DataTableMappingCollection();
		}

		/// <summary>
		/// 生成默认映射表
		/// </summary>
		/// <param name="dt">表</param>
		/// <returns></returns>
		public static DataTableMapping CreateDefaultTableMapping(System.Data.DataTable dt)
		{
			DataTableMapping rtn = new DataTableMapping();
			rtn.SourceTable = rtn.DataSetTable = dt.TableName;
			foreach (DataColumn dc in dt.Columns)
			{
				rtn.ColumnMappings.Add(dc.ColumnName, dc.ColumnName);
			}
			return rtn;
		}

 public Base_CauHinhHeThong()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("Khoa", "Khoa")
                            ,
                            new DataColumnMapping("NoiDung", "NoiDung")
                        };
     dtTblMapping = new DataTableMapping("Table", "CauHinhHeThong", dtColMapping);
 }

 public Base_DongSanPham()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("DongSanPhamID", "DongSanPhamID")
                            ,
                            new DataColumnMapping("TenDongSanPham", "TenDongSanPham")
                        };
     dtTblMapping = new DataTableMapping("Table", "DongSanPham", dtColMapping);
 }

 public Base_CuaHangNhomSanPham()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("CuaHangNhomSanPhamID", "CuaHangNhomSanPhamID")
                            ,
                            new DataColumnMapping("CuaHangID", "CuaHangID")
                            ,
                            new DataColumnMapping("NhomSanPhamID", "NhomSanPhamID")
                        };
     dtTblMapping = new DataTableMapping("Table", "CuaHangNhomSanPham", dtColMapping);
 }

 public Base_LichSuTruyCap()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("LichSuTruyCapID", "LichSuTruyCapID")
                            ,
                            new DataColumnMapping("LuotTruyCap", "LuotTruyCap")
                            ,
                            new DataColumnMapping("CuaHangID", "CuaHangID")
                        };
     dtTblMapping = new DataTableMapping("Table", "LichSuTruyCap", dtColMapping);
 }

        protected override RowUpdatedEventArgs CreateRowUpdatedEvent(
            DataRow dataRow,
            IDbCommand command,
            StatementType statementType,
            DataTableMapping tableMapping
        )
        {
            NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, "CreateRowUpdatedEvent");
            return new NpgsqlRowUpdatedEventArgs(dataRow, command, statementType, tableMapping);



        }

        public Base_LoaiCuaHang()
        {
            dtColMapping = new DataColumnMapping[]{

                new DataColumnMapping("LoaiCuaHangID","LoaiCuaHangID")
                    ,

                new DataColumnMapping("TenLoaiCuaHang","TenLoaiCuaHang")
                    ,

                new DataColumnMapping("Mota","Mota")
                    };
            dtTblMapping = new DataTableMapping("Table", "LoaiCuaHang", dtColMapping);
        }

 public Base_ThuocTinhSanPham()
 {
     dtColMapping = new DataColumnMapping[]
                        {
                            new DataColumnMapping("ThuocTinhSanPhamID", "ThuocTinhSanPhamID")
                            ,
                            new DataColumnMapping("SanPhamID", "SanPhamID")
                            ,
                            new DataColumnMapping("ThuocTinhID", "ThuocTinhID")
                            ,
                            new DataColumnMapping("SanPhamMauID", "SanPhamMauID")
                        };
     dtTblMapping = new DataTableMapping("Table", "ThuocTinhSanPham", dtColMapping);
 }