public ActionResult UpdateTeacher(string tid, string property, string value)
{
try
{
if (!string.IsNullOrEmpty(value.Trim()))
{
string updateteachers = string.Format("update teachers set {0}='{1}' where tid='{2}'", property, value, tid);
DBHelper.ExecuteNonQuery(updateteachers, CommandType.Text, null);
if (property == "indentify" && value == "1")
{
CheckClassModel c = new CheckClassModel();
c.Tid = tid;
c.DayNumber = 0;
c.WeekNumber = 0;
c.total = 0;
DBHelper.Insert <CheckClassModel>(c);
}
}
return(Json(new mkjson("更新成功", 0)));
}
catch (Exception) { return(Json(new mkjson("更新失败", 1))); }
////}
//return null;
}
/// <summary>
/// 教师信息导入
/// 密码默认123
/// 邮箱,教研室,职称为空
/// </summary>
/// <param name="filename">文件名</param>
/// <param name="college">学院</param>
public void ReadTeacherTable(string filename, string college)
{
Common com = new Common();
Excel_dt = new DataTable();
HSSFWorkbook hssfworkbook;
using (FileStream file = new FileStream(filename, FileMode.Open, FileAccess.Read))
{
hssfworkbook = new HSSFWorkbook(file);
}
ISheet sheet = hssfworkbook.GetSheetAt(0);
System.Collections.IEnumerator rows = sheet.GetRowEnumerator();
IRow headerRow = sheet.GetRow(0);
int cellCount = headerRow.LastCellNum;
for (int j = 0; j < cellCount; j++)
{
Excel_dt.Columns.Add(j.ToString());
}
for (int i = 4; i <= sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
if (row != null)
{
DataRow dataRow = Excel_dt.NewRow();
for (int j = 0; j < cellCount; j++)
{
if (row.GetCell(j) != null)
{
dataRow[j] = row.GetCell(j).ToString();
}
}
Excel_dt.Rows.Add(dataRow);
}
else
{
break;
}
}
for (int i = 0; i < Excel_dt.Rows.Count; i++)
{
if (Excel_dt.Rows[i][0].ToString().Length != 0 && Excel_dt.Rows[i][1].ToString().Length == 11)
{
string tname = Excel_dt.Rows[i][0].ToString();
TeachersModel m = new TeachersModel();
m.Tid = collegeid(college) + com.Get16binary(tname);
m.TeacherName = Excel_dt.Rows[i][0].ToString();
m.Phone = Excel_dt.Rows[i][1].ToString();
if (Excel_dt.Rows[i][2].ToString() != null && Excel_dt.Rows[i][2].ToString() == "1")
{
m.Indentify = 1;
CheckClassModel c = new CheckClassModel();
c.Tid = collegeid(college) + com.Get16binary(tname);
c.DayNumber = 0;
c.WeekNumber = 0;
c.total = 0;
//checkclasslist.Add(c);
DBHelper.Insert <CheckClassModel>(c);
}
else
{
m.Indentify = 0;
}
m.Islimit = 1;
m.Password = "******";
m.TeacherRoom = " ";
m.Title = " ";
m.Email = " ";
m.College = college;
DBHelper.Insert <TeachersModel>(m);
//teacherlist.Add(m);
}
}
DBHelper.BulkInsert <TeachersModel>(teacherlist);
DBHelper.BulkInsert <CheckClassModel>(checkclasslist);
}
