protected DBase db; //数据库连接
public CommonAdapter(DBase datab, string tb_Name)
{
db = datab;
tableName = tb_Name;
odda = new OleDbDataAdapter();
InitAdapter();
}
public static CommonAdapter CreateAdapter(DBase db, string tableName)
{
CommonAdapter adapter = null;
switch (tableName)
{
case "StudentUser":
//adapter = new UserAdapter(db,"StudentUser");
break;
}
return(adapter);
}
//构造函数
public OrderDetailAdapter(DBase db)
: base(db, "OrderDetail")
{
}
private ArrayList CourseList; //保存课程列表
//构造函数
public CourseControl(DBase db)
: base(db, "Course")
{
CourseList = new ArrayList();
}
//构造函数
public StudentUserControl(DBase db)
: base(db, "StudentUser")
{
StudentUserList = new ArrayList();
}
public OrdersAdapter(DBase db)
: base(db, "Orders")
{
}
//构造函数
public SystemUserControl(DBase db)
: base(db, "SystemUser")
{
}
//构造函数
public TeacherUserControl(DBase db)
: base(db, "TeacherUser")
{
TeacherUserList = new ArrayList();
}
//构造函数
public GoodsAdapter(DBase db)
: base(db, "Goods")
{
}
//构造函数
public StudentControl(DBase db)
: base(db, "Student")
{
StudentList = new ArrayList();
}
public PurchaseDetailAdapter(DBase db)
: base(db, "PurchaseDetail")
{
}
public SysUserAdapter(DBase db)
: base(db, "SysUser")
{
}
public PurchaseAdapter(DBase db)
: base(db, "Purchase")
{
}
public SupplierAdapter(DBase db)
: base(db, "Supplier")
{
}
public CustomerAdapter(DBase db)
: base(db, "Customer")
{
}
public PayAdapter(DBase db)
: base(db, "Pay")
{
}
protected OleDbConnection conn; //数据库连接
//构造函数
public DBTable(DBase datab, string tb_Name)
{
db = datab;
tableName = tb_Name;
conn = datab.getConnection();
}