📄 grd_mis_1.cs
字号:
//加学术报告人员名单表(JoinReportStu)
//DataTable共有３个字段 JoinReportStuID,ReportName,StuName
//返回结果按JoinReportStuID降叙排列
DataTable dt = new DataTable();
string sqlString = "SELECT JoinReportStuID,ReportName,StuName FROM StudentInfo,ReportInfo,JoinReportStu WHERE StudentInfo.StuID=JoinReportStu.StuID AND JoinReportStu.ReportID=ReportInfo.ReportID ORDER BY JoinReportStuID DESC ";
//多表链接查询SQL语句
/*********************************************************
* SELECT JoinReportStuID,ReportName,StuName *
* FROM StudentInfo,ReportInfo,JoinReportStu *
* WHERE StudentInfo.StuID=JoinReportStu.StuID *
* AND JoinReportStu.ReportID=ReportInfo.ReportID *
* ORDER BY JoinReportStuID DESC *
***********************************************************/
try
{
dt = Query.ProcessSql(sqlString,"GradMIS_Data");
}
catch //(PlException exp)
{
return null;
}
return dt;
}
public static DataTable GetData_ActivityJioner()
{
//列出所有有效的参见活动的学生的名单
//返回的DataTable需要３张表连接，学生信息表(StudentInfo)，
//活动信息表(ActivityInfo)，加活动人员名单表(JoinActivStu)
//DataTable共有３个字段 JoinActivStuID,ActivityName,StuName
//返回结果按JoinActivStuID降叙排列
DataTable dt = new DataTable();
string sqlString = "SELECT JoinActivStuID,ActivityName,StuName FROM StudentInfo,ActivityInfo,JoinActivStu WHERE StudentInfo.StuID = JoinActivStu.StuID AND JoinActivStu.ActivityID = ActivityInfo.ActivityID ORDER BY JoinActivStuID DESC";
//多表链接查询SQL语句
/*
* SELECT JoinActivStuID,ActivityName,StuName
* FROM StudentInfo,ActivityInfo,JoinActivStu
* WHERE StudentInfo.StuID = JoinActivStu.StuID
* AND JoinActivStu.ActivityID = ActivityInfo.ActivityID
* ORDER BY JoinActivStuID DESC
*/
try
{
dt = Query.ProcessSql(sqlString, "GradMIS_Data");
return dt;
}
catch //(PlException exp)
{
return null;
}
}
public static DataRow GetData_OneReport(int id)
{
//返回数据库学术报告信息表的ReportID＝id的一条记录
//不存在返回null
try
{
//ReportInfoEntity reportInfo = new ReportInfoEntity();
RetrieveCriteria rc = new RetrieveCriteria(typeof(ReportInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(ReportInfoEntity.__REPORTID, id);
DataTable dt = rc.AsDataTable();
return dt.Rows[0];
}
/*try
{
if (!reportInfo.Retrieve())
return null;
else
return dt.Rows[0];
}*/
catch //(PlException exp)
{
return null;
}
}
public static DataRow GetData_OneActivity(int id)
{
//返回数据库学生活动信息表中ActivityID＝id的一列
try
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ActivityInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(ActivityInfoEntity.__ACTIVITYID, id);
DataTable dt = rc.AsDataTable();
return dt.Rows[0];
}
/*try
{
if (!activityInfo.Retrieve())
return null;
else
return dt.Rows[0];
}*/
catch //(PlException exp)
{
return null;
}
}
public static DataTable GetData_Activity()
{
//返回数据库学生活动信息表的所有信息
//返回时按ID降序排列
//失败返回NULL
try
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ActivityInfoEntity));
Condition c = rc.GetNewCondition();
rc.OrderBy(ActivityInfoEntity.__ACTIVITYID, false);
DataTable dt = rc.AsDataTable();
return dt;
}
catch //(PlException exp)
{
return null;
}
}
public static DataTable GetData_ExcellInfo()
{
//返回ExcellInfo表中所有有效数据
//返回时按ID降序排列
//失败返回NULL
try
{
ExcellInfoEntity excellInfo = new ExcellInfoEntity();
RetrieveCriteria rc = new RetrieveCriteria(typeof(ExcellInfoEntity));
Condition c = rc.GetNewCondition();
rc.OrderBy(ExcellInfoEntity.__EXCELLENCEINFOID, false);
DataTable dt = rc.AsDataTable();
return dt;
}
/*try
{
if (!excellInfo.Retrieve())
return null;
else
return dt;
}*/
catch //(PlException exp)
{
return null;
}
}
public static DataRow GetData_ExcellInfo(int id)
{
//返回ExcellInfo表中ExcellenceInfoID=id数据
//返回时按ID降序排列
//失败返回NULL
//ExcellInfoEntity excellInfo = new ExcellInfoEntity();
try
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ExcellInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(ExcellInfoEntity.__EXCELLENCEINFOID, id);
rc.OrderBy(ExcellInfoEntity.__EXCELLENCEINFOID, false);
DataTable dt = rc.AsDataTable();
return dt.Rows[0];
}
/*try
{
if (!excellInfo.Retrieve())
return null;
else
return dt.Rows[0];
}*/
catch //(PlException exp)
{
return null;
}
}
public static DataTable GetData_ExcellApply(int id)
{
//返回ExcellApp表,StudentInfo表和ExcellInfo表 的连接查询中 ExcellenceInfoID ＝id的信息
//返回的datatable中应包含StuName,ExcellenceID,ExcellenceInfoID，ExcellenceName，ExceIsChecked
DataTable dt = new DataTable();
string sqlString = "SELECT StuName,ExcellenceID,ExcellInfo.ExcellenceInfoID,ExcellenceName,IsChecked FROM ExcellApp,ExcellInfo,StudentInfo WHERE StudentInfo.StuID = ExcellApp.StuID AND ExcellApp.ExcellenceInfoID = ExcellInfo.ExcellenceInfoID AND ExcellInfo.ExcellenceInfoID = " +id.ToString();
//多表查询SQL语句TO_CHAR()
/*************************************************************************************
* SELECT StuName,ExcellenceID,ExcellInfo.ExcellenceInfoID,ExcellenceName,IsChecked *
* FROM ExcellApp,ExcellInfo,StudentInfo *
* WHERE StudentInfo.StuID = ExcellApp.StuID *
* AND ExcellApp.ExcellenceInfoID = ExcellInfo.ExcellenceInfoID *
* AND ExcellenceInfoID = " +id.ToString() *
***************************************************************************************/
try
{
dt = Query.ProcessSql(sqlString, "GradMIS_Data");
return dt;
}
catch //(PlException exp)
{
return null;
}
}
public static DataRow GetData_OneExcelApp(int id)
{
//返回ExcellApp表,StudentInfo表和ExcellInfo表 的连接查询中 ExcellenceID ＝id的信息
//返回的datatable中应包含StuName，ExcellenceName,Enable和ExcellApp表的全部信息
DataTable dt = new DataTable();
string sqlString = "SELECT StuName,ExcellenceName,Enable,ExcellenceID,ExcellApp.StuID,ExcellApp.ExcellenceInfoID,ExcellenceResume,GetExcellDate,IsChecked,ExcellApp.FileName,ExcellApp.Remark FROM ExcellApp,ExcellInfo,StudentInfo WHERE StudentInfo.StuID = ExcellApp.StuID AND ExcellApp.ExcellenceInfoID = ExcellInfo.ExcellenceInfoID AND ExcellenceID = " + id.ToString();
try
{
dt = Query.ProcessSql(sqlString, "GradMIS_Data");
return dt.Rows[0];
}
catch //(PlException exp)
{
return null;
}
}
/// <summary>
/// //////////////////////////////////////////////
/// //////////////////////////////////////////////
/// /////////////////////////////////////////////
/// </summary>
/// <returns></returns>
public static DataTable GetData_ScholarInfo()
{
//返回ScholarInfo表中所有有效数据
//返回的信息中应包含
//失败返回NULL
DataTable dt;// = new DataTable();
string sqlString = "SELECT * FROM ScholarInfo ORDER BY ScholarshipInfoID DESC";
try
{
dt = Query.ProcessSql(sqlString, "GradMIS_Data");
}
catch //(PlException exp)
{
return null;
}
return dt;
}
public static DataRow GetData_ScholarInfo(int id)
{
//返回ScholarInfo表ScholarshipInfoID=id的数据
//失败返回NULL
//ScholarInfoEntity scholarInfo = new ScholarInfoEntity();
try
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ScholarInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(ScholarInfoEntity.__SCHOLARSHIPINFOID, id);
rc.OrderBy(ScholarInfoEntity.__SCHOLARSHIPINFOID, false);
DataTable dt = rc.AsDataTable();
return dt.Rows[0];
}
/*
try
{
if (!scholarInfo.Retrieve())
return null;
else
return dt.Rows[0];
}*/
catch //(PlException exp)
{
return null;
}
}
public static DataTable GetData_ScholarApply(int id)
{
//返回ScholarApp,ScholarInfo和StudentInfo三表联合中ScholarshipInfoID＝id的信息表
//返回的datatable中应包含StuName，Enable，ScholarshipName和ScholarApp表中所有信息
//失败返回NULL
DataTable dt = new DataTable();
string sqlString = "SELECT StuName,Enable,ScholarshipName,ScholarshipAppID,ScholarApp.ScholarshipInfoID,ScholarApp.StuID,ScholarshipResume,IsChecked,GetScholarDate,ScholarApp.FileName,ScholarApp.Remark FROM ScholarApp,ScholarInfo,StudentInfo WHERE StudentInfo.StuID = ScholarApp.StuID AND ScholarApp.ScholarshipInfoID = ScholarInfo.ScholarshipInfoID AND ScholarInfo.ScholarshipInfoID = " + id.ToString();
/************************************************************************************************
*SELECT StuName,Enable,ScholarshipName,ScholarshipAppID,ScholarApp.ScholarshipInfoID, *
* ScholarApp.StuID,ScholarshipResume,IsChecked,GetScholarDate,ScholarApp.FileName, *
* ScholarApp.Remark *
*FROM ScholarApp,ScholarInfo,StudentInfo *
*WHERE StudentInfo.StuID = ScholarApp.StuID *
* AND ScholarApp.ScholarshipInfoID = ScholarInfo.ScholarshipInfoID *
* AND ScholarInfo.ScholarshipInfoID = " + id.ToString() *
*************************************************************************************************/
try
{
dt = Query.ProcessSql(sqlString, "GradMIS_Data");
}
catch //(PlException exp)
{
return null;
}
return dt;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -