public static DataSet SelectAllStudentFile()
{
Sql.SqlSelectAllStudentFile qs = new StudentFile.Sql.SqlSelectAllStudentFile();
Ops.OpStudentFileQuery op = new StudentFile.Ops.OpStudentFileQuery(qs);
op.Do();
return(op.Ds);
}
public static DataSet SelectStudentArchivesContent(String ID)
{
Sql.SqlSelectStudentArchivesContent qs = new StudentFile.Sql.SqlSelectStudentArchivesContent();
qs.GetID(ID);
Ops.OpStudentFileQuery op = new StudentFile.Ops.OpStudentFileQuery(qs);
op.Do();
return(op.Ds);
}
public static DataSet SelectSingleStudentFileInfo(String ID)
{
Sql.SqlSelectSingleStudentFileInfo qs = new StudentFile.Sql.SqlSelectSingleStudentFileInfo();
qs.GetID(ID);
Ops.OpStudentFileQuery op = new StudentFile.Ops.OpStudentFileQuery(qs);
op.Do();
return(op.Ds);
}
public static DataSet SelectStudentFileQuery(String ID, String strName)
{
Sql.SqlSelectStudentFileQuery qs = new StudentFile.Sql.SqlSelectStudentFileQuery();
qs.GetConditon(ID, strName);
Ops.OpStudentFileQuery op = new StudentFile.Ops.OpStudentFileQuery(qs);
op.Do();
return(op.Ds);
}
public static bool CheckStudentTable(String ID)
{
Sql.SqlSelectStudentSingleInStudent qs = new StudentFile.Sql.SqlSelectStudentSingleInStudent();
qs.GetID(ID);
Ops.OpStudentFileQuery op = new StudentFile.Ops.OpStudentFileQuery(qs);
op.Do();
if (op.Ds.Tables[0].Rows.Count == 0)
{
return(false);
}
return(true);
}