public CourseScore SelectById(CourseScore model)
{
//修改
string sql = "select * from course_score where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("id", model.id)
};
DataTable table = SqliteHelper.Select(sql, ps);
//修改
List <CourseScore> list = new List <CourseScore>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new CourseScore()
{
id = Convert.ToInt32(row["id"]),
student_id = Convert.ToInt32(row["student_id"]),
course_id = Convert.ToInt32(row["course_id"]),
score = Convert.ToDouble(row["score"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
//修改
CourseScore model2 = list[0];
return(model2);
}
public Student SelectById(Student model)
{
string sql = "select * from student where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("id", model.id)
};
//执行查询，获取数据
DataTable table = SqliteHelper.Select(sql, ps);
//构造数据集合
List <Student> list = new List <Student>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
list.Add(new Student()
{
id = Convert.ToInt32(row["id"]),
student_id = Convert.ToInt32(row["student_id"]),
password = row["password"].ToString(),
name = row["name"].ToString(),
sex = Convert.ToInt32(row["sex"]),
student_class = row["student_class"].ToString(),
age = Convert.ToInt32(row["age"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
Student model2 = list[0];
return(model2);
}
public List <Student> SelectAll()
{
//执行查询，获取数据
DataTable table = SqliteHelper.Select("SELECT * FROM student where deleted=0");
//构造数据集合
List <Student> list = new List <Student>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
list.Add(new Student()
{
id = Convert.ToInt32(row["id"]),
student_id = Convert.ToInt32(row["student_id"]),
password = row["password"].ToString(),
name = row["name"].ToString(),
sex = Convert.ToInt32(row["sex"]),
student_class = row["student_class"].ToString(),
age = Convert.ToInt32(row["age"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public Course SelectById(Course model)
{
string sql = "select * from course where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("id", model.id)
};
//执行查询，获取数据
DataTable table = SqliteHelper.Select(sql, ps);
//构造数据集合
List <Course> list = new List <Course>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
list.Add(new Course()
{
id = Convert.ToInt32(row["id"]),
name = row["name"].ToString(),
credit = Convert.ToDouble(row["credit"]),
teacher = row["teacher"].ToString(),
time = Convert.ToInt32(row["time"]),
place = row["place"].ToString(),
capacity = Convert.ToInt32(row["capacity"]),
type = Convert.ToInt32(row["type"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
Course model2 = list[0];
return(model2);
}
public List <Course> SelectAll()
{
//执行查询，获取数据
DataTable table = SqliteHelper.Select("SELECT * FROM course where deleted=0");
//构造数据集合
List <Course> list = new List <Course>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
list.Add(new Course()
{
id = Convert.ToInt32(row["id"]),
name = row["name"].ToString(),
credit = Convert.ToDouble(row["credit"]),
teacher = row["teacher"].ToString(),
time = Convert.ToInt32(row["time"]),
place = row["place"].ToString(),
capacity = Convert.ToInt32(row["capacity"]),
type = Convert.ToInt32(row["type"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public CreditClass SelectById(CreditClass model)
{
//修改
string sql = "select * from credit_class where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("id", model.id)
};
DataTable table = SqliteHelper.Select(sql, ps);
//修改
List <CreditClass> list = new List <CreditClass>();
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new CreditClass()
{
id = Convert.ToInt32(row["id"]),
student_class = row["student_class"].ToString(),
credit_limit = Convert.ToDouble(row["credit_limit"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
//修改
CreditClass model2 = list[0];
return(model2);
}
public Admin SelectById(Admin model)
{
//修改
string sql = "select * from admin where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("id", model.id)
};
DataTable table = SqliteHelper.Select(sql, ps);
//修改
List <Admin> list = new List <Admin>();
//遍历数据表，将数据转存到集合中
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new Admin()
{
id = Convert.ToInt32(row["Id"]),
admin_name = row["admin_name"].ToString(),
password = row["password"].ToString(),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
//修改
Admin model2 = list[0];
return(model2);
}
public List <Admin> Login(Admin ai)
{
string sql = "select * from admin";
SQLiteParameter[] ps = new SQLiteParameter[2];
if (ai != null)
{
sql += " where admin_name=@admin_name and password=@password and deleted=0";
ps[0] = new SQLiteParameter("@admin_name", ai.admin_name);
ps[1] = new SQLiteParameter("@password", Md5Helper.GetMd5(ai.password));
}
DataTable table = SqliteHelper.Select(sql, ps);
List <Admin> list = new List <Admin>();
foreach (DataRow row in table.Rows)
{
list.Add(new Admin()
{
id = Convert.ToInt32(row["Id"]),
admin_name = row["admin_name"].ToString(),
password = row["password"].ToString(),
add_time = Convert.ToDateTime(row["add_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public List <Admin> SelectAll()
{
//修改
DataTable table = SqliteHelper.Select("select * from admin where deleted=0");
//修改
List <Admin> list = new List <Admin>();
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new Admin()
{
id = Convert.ToInt32(row["id"]),
admin_name = row["admin_name"].ToString(),
password = row["password"].ToString(),
add_time = Convert.ToDateTime(row["add_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public List <TeacherCourse> SelectAll()
{
//修改
DataTable table = SqliteHelper.Select("SELECT * FROM teacher_course where deleted=0");
//修改
List <TeacherCourse> list = new List <TeacherCourse>();
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new TeacherCourse()
{
id = Convert.ToInt32(row["id"]),
teacher_id = Convert.ToInt32(row["teacher_id"]),
course_id = Convert.ToInt32(row["course_id"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public List <CreditClass> SelectAll()
{
//修改
DataTable table = SqliteHelper.Select("SELECT * FROM credit_class where deleted=0");
//修改
List <CreditClass> list = new List <CreditClass>();
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new CreditClass()
{
id = Convert.ToInt32(row["id"]),
student_class = row["student_class"].ToString(),
credit_limit = Convert.ToDouble(row["credit_limit"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
public List <CourseScore> SelectAll()
{
//修改
DataTable table = SqliteHelper.Select("SELECT * FROM course_score where deleted=0");
//修改
List <CourseScore> list = new List <CourseScore>();
foreach (DataRow row in table.Rows)
{
//修改
list.Add(new CourseScore()
{
id = Convert.ToInt32(row["id"]),
student_id = Convert.ToInt32(row["student_id"]),
course_id = Convert.ToInt32(row["course_id"]),
score = Convert.ToDouble(row["score"]),
add_time = Convert.ToDateTime(row["add_time"]),
update_time = Convert.ToDateTime(row["update_time"]),
deleted = Convert.ToInt32(row["deleted"])
});
}
return(list);
}
