public T_Base_Teacher GetTea(String TeaId)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from T_Base_Teacher where TeaId=@TeaId";
cm.Parameters.AddWithValue("@TeaId", TeaId);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
T_Base_Teacher teacher = null;
while (dr.Read())
{
#region 模式转换
teacher = new T_Base_Teacher();
teacher.Id = Convert.ToInt32(dr["Id"]);
teacher.TeaId = Convert.ToString(dr["TeaId"]);
teacher.Name = Convert.ToString(dr["Name"]);
teacher.Sex = Convert.ToInt32(dr["Sex"]);
teacher.PassWord = Convert.ToString(dr["PassWord"]);
teacher.Phone = Convert.ToString(dr["Phone"]);
teacher.IsBZR = Convert.ToInt32(dr["IsBZR"]);
#endregion
}
dr.Close();
co.Close();
return(teacher);
}
public bool Add(T_Base_Teacher teacher)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"];
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "insert into T_Base_Teacher(TeaId,Name,Sex,PassWord,Phone,IsBZR) Values(@TeaId,@Name,@Sex,@PassWord,@Phone,@IsBZR)";
cm.Connection = co;
#region 变量赋值
cm.Parameters.AddWithValue("@TeaId", teacher.TeaId);
cm.Parameters.AddWithValue("@Name", teacher.Name);
cm.Parameters.AddWithValue("@Sex", teacher.Sex);
cm.Parameters.AddWithValue("@PassWord", teacher.PassWord);
cm.Parameters.AddWithValue("@Phone", teacher.Phone);
cm.Parameters.AddWithValue("@IsBZR", teacher.IsBZR);
#endregion
int res = cm.ExecuteNonQuery();
co.Close();
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
//王一情
public string GetCourseTask(int userid, int userlevel)
{
T_Base_Teacher teacher = new T_Base_Teacher();
DALT_Base_Teacher dal_Teacher = new DALT_Base_Teacher();
teacher = dal_Teacher.GetModel(userid);
DALT_Event_CourseTask dal = new DALT_Event_CourseTask();
List <T_Event_CourseTask> list = new List <T_Event_CourseTask>();
if (userlevel != 10 && userlevel != 11)
{
list = dal.GetStuCourseList(userid);
}
else
{
list = dal.GetTeaCourseList("WPeople=" + "'" + teacher.Name + "'");
}
string res = "";
foreach (T_Event_CourseTask item in list)
{
T_Task_Course course = new T_Task_Course();
DALT_Task_Course dal_course = new DALT_Task_Course();
course = dal_course.GetModel(item.CourseId);
string st_date = ((DateTime)item.StartWeek).ToString("yyyy-MM-dd");
string st = st_date + " " + item.StartTime;
string ed = st_date + " " + item.EndTime;
res += "{\"id\":\"" + item.Id
+ "\",\"title\":\"" + course.Name
+ "\",\"type\":\"" + item.Type
+ "\",\"des\":\"" + item.Description
+ "\",\"start\":\"" + st
+ "\",\"end\":\"" + ed + "\"}";
res += ",";
}
return(res);
}
public ActionResult TeacherEdit(int id)
{
//if (!User.Identity.IsAuthenticated)
//{
// return Redirect("/Login/Login/Index");
//}
DALT_Base_Teacher db = new DALT_Base_Teacher();
T_Base_Teacher teacher = db.GetTeacher(id);
ViewBag.item = teacher;
if (teacher == null)
{
return(Content("资料不存在！"));
}
return(View());
}
public void AddSave(T_Base_Teacher teacher)
{
DALT_Base_Teacher dal = new DALT_Base_Teacher();
string pwd = MD5Class.UserMd5(teacher.TeaId);
teacher.PassWord = pwd;
bool res = dal.Add(teacher);
if (res)
{
string tmp = "{\"statusCode\":\"200\",\"message\":\"插入成功\",\"navTabId\":\"TeacherList\",\"rel\":\"TeacherList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
else
{
string tmp = "{\"statusCode\":\"300\",\"message\":\"插入失败\",\"navTabId\":\"TeacherList\",\"rel\":\"TeacherList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
}
public void Reset(int id)
{
DALT_Base_Teacher db = new DALT_Base_Teacher();
T_Base_Teacher teacher = db.GetTeacher(id);
string pwd = MD5Class.UserMd5(teacher.TeaId);
teacher.PassWord = pwd;
bool res = db.Update(teacher);
if (res)
{
string tmp = "{\"statusCode\":\"200\",\"message\":\"重置密码成功\",\"navTabId\":\"teacherList\",\"rel\":\"teacherList\",\"callbackType\":\"\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
else
{
string tmp = "{\"statusCode\":\"300\",\"message\":\"重置密码失败\",\"navTabId\":\"teacherList\",\"rel\":\"teacherList\",\"callbackType\":\"\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
}
public void EditSave(T_Base_Teacher teacher)
{
DALT_Base_Teacher db = new DALT_Base_Teacher();
T_Base_Teacher teacher2 = db.GetTeacher(teacher.Id);
teacher.PassWord = teacher2.PassWord;
bool res = db.Update(teacher);
if (res)
{
string tmp = "{\"statusCode\":\"200\",\"message\":\"修改成功\",\"navTabId\":\"TeacherList\",\"rel\":\"TeacherList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
else
{
string tmp = "{\"statusCode\":\"300\",\"message\":\"修改失败\",\"navTabId\":\"TeacherList\",\"rel\":\"TeacherList\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
Response.Write(tmp);
}
}
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 List <T_Base_Teacher> GetTeacherList(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 T_Base_Teacher where " + where + " and id not in(select top " + (pageIndex - 1) * pageSize + " id from T_Base_Teacher where " + where + ")";
SqlDataReader dr = cm.ExecuteReader();
List <T_Base_Teacher> lst = new List <T_Base_Teacher>();
while (dr.Read())
{
#region 模式转换
T_Base_Teacher teacher = new T_Base_Teacher();
teacher.Id = Convert.ToInt32(dr["Id"]);
teacher.TeaId = Convert.ToString(dr["TeaId"]);
teacher.Name = Convert.ToString(dr["Name"]);
teacher.Sex = Convert.ToInt32(dr["Sex"]);
teacher.PassWord = Convert.ToString(dr["PassWord"]);
teacher.Phone = Convert.ToString(dr["Phone"]);
teacher.IsBZR = Convert.ToInt32(dr["IsBZR"]);
#endregion
lst.Add(teacher);
}
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);
}
//王一情,并且把那个GetCourseTask放到了其他地方
public int AddCourseTask(int type, string des, DateTime start, DateTime end, int taskalert, DateTime start_date, int week_type, int week_number, int userid, int choose_course)
{
T_Base_Teacher teacher = new T_Base_Teacher();
DALT_Base_Teacher dal_teacher = new DALT_Base_Teacher();
//王一情
teacher = dal_teacher.GetModel(userid);
T_Event_CourseTask model = new T_Event_CourseTask();
model.Type = type;
model.IsAlert = taskalert;
model.CourseId = choose_course;
model.Description = des;
model.EndTime = end.ToLongTimeString().ToString();
model.StartTime = start.ToLongTimeString().ToString();
model.StartWeek = start_date;
model.State = 0;
model.WeekNum = week_number;
model.WeekType = week_type;
model.WPeople = teacher.Name;
DALT_Event_CourseTask dal = new DALT_Event_CourseTask();
//循环添加课程日程
int result = 0;
if (model.WeekNum == 1)
{
result = dal.Add(model);
}
//如果有循环的话
else if (model.WeekNum > 1)
{
for (int i = 1; i <= model.WeekNum; i++)
{
//如果不分单双周
if (model.WeekType == 0)
{
result = dal.Add(model);
model.StartWeek = start_date.AddDays(7 * i);
}
//如果单周
else if (model.WeekType == 1)
{
result = dal.Add(model);
model.StartWeek = start_date.AddDays(14 * i);
}
//如果双周
else if (model.WeekType == 2)
{
model.StartWeek = start_date.AddDays(14 * (i - 1) + 7);
result = dal.Add(model);
}
}
}
if (result > 0)
{
return(2);
}
return(0);
}
