//学生查看自己的请假信息
public static async Task <LeaveItemEntity> ViewLeave(int student_id)
{
LeaveItemEntity leave = new LeaveItemEntity();
leave.total = 0;
leave.leaveItem = new List <LeaveEntity>();
var query = "SELECT leave_id,student_id,work_id,content,leave_time,proof,status,request_time,leave_duration FROM leave_information WHERE student_id=@student_id";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@student_id", student_id);
using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
LeaveEntity temp = new LeaveEntity();
temp.leave_id = reader.GetInt32("leave_id");
temp.student_id = reader.GetInt32("student_id");
temp.work_id = reader.GetInt32("work_id");
temp.content = reader.GetString("content");
temp.leave_time = reader.GetString("leave_time");
temp.proof = reader.GetString("proof");
temp.status = reader.GetInt32("status");
temp.leave_duration = reader.GetDecimal("leave_duration");
temp.request_time = reader.GetDateTime("request_time");
leave.total++;
leave.leaveItem.Add(temp);
}
return(leave);
}
///<summery>
/// (非学生用户)查看所有请假申请
/// 这里不查询student.name和work.name
/// dumei 08.24
///</summery>
public static async Task <LeaveItemEntity> ProViewLeaves(int provider_id)
{
var leave_apps = new LeaveItemEntity();
leave_apps.total = 0;
leave_apps.leaveItem = new List <LeaveEntity>();
var query = @"SELECT leave_id,user_id,work_id,
content,proof,status,leave_duration,
request_time,leave_day,leave_start,leave_end
FROM leave_information NATURAL JOIN work
WHERE teacher_id=@id ORDER BY status ASC";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@id", provider_id);
using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
var temp = new LeaveEntity()
{
leave_id = reader.GetInt32("leave_id"),
student_id = reader.GetInt32("user_id"),
work_id = reader.GetInt32("work_id"),
content = reader.GetString("content"),
//leave_time=reader.GetString("leave_time"),
proof = reader.GetString("proof"),
status = reader.GetInt32("status"),
leave_duration = reader.GetDouble("leave_duration"),
request_time = reader.GetDateTime("request_time"),
leave_day = reader.GetString("leave_day"),
leave_start = reader.GetString("leave_start"),
leave_end = reader.GetString("leave_end")
};
leave_apps.total++;
leave_apps.leaveItem.Add(temp);
}
return(leave_apps);
}
