public List <T_Base_Student> GetStuListByView(string where, int startIndex, int endIndex)
{
DataSet ds = GetListByPageByView(where, "id", startIndex, endIndex);
List <T_Base_Student> lst = new List <T_Base_Student>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
//lst.Add(DataRowToModel(dr));
T_Base_Student student = new T_Base_Student();
student = GetModel((int)dr["Id"]);
T_Base_Class cla = new T_Base_Class();
cla.Name = Convert.ToString(dr["className"]);
student.Class = cla;
lst.Add(student);
}
return(lst);
}
public bool Add(T_Base_Class cla)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "insert into T_Base_Class(TeaId,Name) Values(@TeaId,@Name)";
cm.Connection = co;
#region 变量赋值
cm.Parameters.AddWithValue("@TeaId", cla.TeaId);
cm.Parameters.AddWithValue("@Name", cla.Name);
#endregion
int res = cm.ExecuteNonQuery();
co.Close();
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
public void AddSave(T_Base_Class cla)
{
DALT_Base_Class dal = new DALT_Base_Class();
cla.TeaId = Convert.ToInt32(Request.Form["Teacher.Id"]);
bool res = dal.Add(cla);
if (res)
{
string tmp = "{\"statusCode\":\"200\",\"message\":\"插入成功\",\"navTabId\":\"ClassList\",\"rel\":\"ClassList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
else
{
string tmp = "{\"statusCode\":\"300\",\"message\":\"插入失败\",\"navTabId\":\"ClassList\",\"rel\":\"ClassList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
}
public ActionResult ClassEdit(int id)
{
//if (!User.Identity.IsAuthenticated)
//{
// return Redirect("/Login/Login/Index");
//}
DALT_Base_Class db = new DALT_Base_Class();
T_Base_Class cla = db.GetClass(id);
ViewBag.item = cla;
if (cla == null)
{
return(Content("资料不存在！"));
}
return(View());
}
public List <T_Base_Student> GetStudentList(int pageSize, int pageIndex, string where)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "select top " + pageSize + " * from V_Class_Student where " + where + " and id not in(select top " + (pageIndex - 1) * pageSize + " id from V_Class_Student where " + where + ")";
SqlDataReader dr = cm.ExecuteReader();
List <T_Base_Student> lst = new List <T_Base_Student>();
while (dr.Read())
{
#region 模式转换
T_Base_Student student = new T_Base_Student();
T_Base_Class cla = new T_Base_Class();
student.Id = Convert.ToInt32(dr["Id"]);
student.StuId = Convert.ToString(dr["StuId"]);
student.Name = Convert.ToString(dr["Name"]);
student.Sex = Convert.ToInt32(dr["Sex"]);
student.PassWord = Convert.ToString(dr["PassWord"]);
student.Phone = Convert.ToString(dr["Phone"]);
student.IsBGB = Convert.ToInt32(dr["IsBGB"]);
student.IsKDB = Convert.ToInt32(dr["IsKDB"]);
student.ClassId = Convert.ToInt32(dr["ClassId"]);
cla.Name = Convert.ToString(dr["className"]);
student.Class = cla;
#endregion
lst.Add(student);
}
co.Close();
dr.Close();
return(lst);
}
public T_Base_Student GetStudent(int Id)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from V_Class_Student where Id=@Id";
cm.Parameters.AddWithValue("@Id", Id);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
T_Base_Student student = null;
T_Base_Class cla = null;
while (dr.Read())
{
#region 模式转换
student = new T_Base_Student();
cla = new T_Base_Class();
cla.Name = Convert.ToString(dr["className"]);
student.Id = Convert.ToInt32(dr["Id"]);
student.StuId = Convert.ToString(dr["StuId"]);
student.Name = Convert.ToString(dr["Name"]);
student.Sex = Convert.ToInt32(dr["Sex"]);
student.PassWord = Convert.ToString(dr["PassWord"]);
student.Phone = Convert.ToString(dr["Phone"]);
student.IsBGB = Convert.ToInt32(dr["IsBGB"]);
student.IsKDB = Convert.ToInt32(dr["IsKDB"]);
student.ClassId = Convert.ToInt32(dr["ClassId"]);
student.Class = cla;
#endregion
}
dr.Close();
co.Close();
return(student);
}
public List <T_Base_Class> GetClassList(int pageSize, int pageIndex, string where)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "select top " + pageSize + " * from V_Class_Teacher where " + where + " and id not in(select top " + (pageIndex - 1) * pageSize + " id from V_Class_Teacher where " + where + ")";
SqlDataReader dr = cm.ExecuteReader();
List <T_Base_Class> lst = new List <T_Base_Class>();
while (dr.Read())
{
#region 模式转换
T_Base_Class cla = new T_Base_Class();
T_Base_Teacher teacher = new T_Base_Teacher();
cla.Id = Convert.ToInt32(dr["classId"]);
cla.Name = Convert.ToString(dr["className"]);
cla.TeaId = Convert.ToInt32(dr["Id"]);
teacher.Name = Convert.ToString(dr["Name"]);
cla.Teacher = teacher;
#endregion
lst.Add(cla);
}
co.Close();
dr.Close();
return(lst);
}
public T_Base_Class GetClass(int Id)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from V_Class_Teacher where classId=@Id";
cm.Parameters.AddWithValue("@Id", Id);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
T_Base_Teacher teacher = null;
T_Base_Class cla = null;
while (dr.Read())
{
#region 模式转换
cla = new T_Base_Class();
teacher = new T_Base_Teacher();
cla.Id = Convert.ToInt32(dr["classId"]);
cla.Name = Convert.ToString(dr["className"]);
cla.TeaId = Convert.ToInt32(dr["Id"]);
teacher.Name = Convert.ToString(dr["Name"]);
cla.Teacher = teacher;
#endregion
}
dr.Close();
co.Close();
return(cla);
}
public JsonResult LoginCheck(string Name, string password, string checkres)
{
string pwd = MD5Class.UserMd5(password);
if (checkres == "学生")
{
DAL.DALT_Base_Student dal = new DAL.DALT_Base_Student();
Model.T_Base_Student student = dal.GetStu(Name);
if (ifExist(Name, pwd, checkres))
{
Session["UserName"] = student.Name;
Session["UserId"] = student.Id;
Session["ClassId"] = student.ClassId;
Session["UserLevel"] = 0;
if (student.IsBGB == 1 && student.IsKDB == 1)
{
Session["UserLevel"] = 3;
}
else if (student.IsBGB == 1)
{
Session["UserLevel"] = 2;
}
else if (student.IsKDB == 1)
{
Session["UserLevel"] = 1;
}
return(Json(new { code = 11, message = "登录成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { code = 3, message = "用户名或密码错误" }, JsonRequestBehavior.AllowGet));
}
}
else if (checkres == "老师")
{
DAL.DALT_Base_Teacher dal = new DAL.DALT_Base_Teacher();
Model.T_Base_Teacher teacher = dal.GetTea(Name);
DAL.DALT_Base_Class dal2 = new DAL.DALT_Base_Class();
Model.T_Base_Class cla = new T_Base_Class();
if (teacher.IsBZR == 1)
{
cla = dal2.FindCla(teacher.Id);
Session["ClassId"] = cla.Id;
}
else
{
Session["ClassId"] = 0;
}
if (ifExist(Name, pwd, checkres))
{
Session["UserName"] = teacher.Name;
Session["UserId"] = teacher.Id;
Session["UserLevel"] = 10;
if (teacher.IsBZR == 1)
{
Session["UserLevel"] = 11;
}
return(Json(new { code = 12, message = "登录成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { code = 3, message = "用户名或密码错误" }, JsonRequestBehavior.AllowGet));
}
}
else
{
DAL.DALT_Base_Admin dal = new DAL.DALT_Base_Admin();
Model.T_Base_Admin admin = dal.GetAdmin(Name);
if (ifExist(Name, pwd, checkres))
{
Session["UserId"] = admin.Id;
Session["Name"] = admin.LoginName;
return(Json(new { code = 13, message = "登录成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { code = 3, message = "用户名或密码错误" }, JsonRequestBehavior.AllowGet));
}
}
}
