public EditTerm()
{
InitializeComponent();
//查询当前学期
jdm = new JszxDataManager();
tm = jdm.GetCurrentTerm();
SetTermContent();
}
private void StartInportBtn_Click_1(object sender, RoutedEventArgs e)
{
string table = this.ExcelTable.Text.Trim();
string sql = string.Format("select * from [{0}]", table);
SwitchTip.Text = "查询依赖信息";
//try
//{
DataTable dt = SqlExcel.ExcuteSelect(this.ExcleFile.Text.Trim(), sql);
int rowsCount = dt.Rows.Count;
SwitchTip.Text = "共"+rowsCount+"条记录";
SwitchProgressBar.Value = 10;
JszxDataManager jszxDataManager = new JszxDataManager();
//获取当前学期id
SwitchTip.Text = "获取当前学期";
SwitchProgressBar.Value = 40;
int termID = jszxDataManager.GetCurrentTerm().TermID;
//获取实验室列表
SwitchTip.Text = "获取实验室列表";
SwitchProgressBar.Value = 70;
List<labs_tb> labs = jszxDataManager.GetLabs_tbList();
#region 开始导入
SwitchProgressBar.Value = 100;
SwitchTip.Text = "获取实验室列表";
SwitchProgressBar.Maximum = rowsCount;
SwitchProgressBar.Value = 0;
using (TransactionScope scope = new TransactionScope())
{
for (int i = 0; i < rowsCount; i++)
{
SwitchTip.Text = "导入第" + (i + 1).ToString() + "条记录";
#region 保存课程信息
courses_tb course = new courses_tb();
//格式化第i行
DataRow dr = FormatDataRow(dt, i);
course.CrsName = dr["课程名称"].ToString();
//crsTeacher 教师姓名
course.CrsTeacher = dr["任课教师"].ToString();
//crsClass 上课班级
course.CrsClasses = dr["班级"].ToString();
//crsHour上机学时
course.CrsHour = Convert.ToInt32(dr["上机学时"]);
//crsTimes 上机次数
course.CrsTimes = Convert.ToInt32(dr["上机次数"]);
//crsNum 上机人数
course.CrsNum = Convert.ToInt32(dr["人数"]);
//crsConf 实验环境配置要求
course.CrsConf = dr["对软硬件环境的要求"].ToString();
//备注
course.CrsRemark = dr["备注"].ToString();
jszxDataManager.jszxEntity.courses_tb.Add(course);
jszxDataManager.jszxEntity.SaveChanges();
int courseID = course.CrsID;
#endregion
#region 保存课程安排
#region 处理实验室
//获取该条记录对应的实验室，根据每条记录的上机地点是否包含该实验室关键字确定是否包含实验室
string lab = dr["上机地点"].ToString();
List<int> courseLabs = new List<int>();
foreach (var drlab in labs)
{
if (lab.Contains(drlab.LabKeyWord))
{
courseLabs.Add(drlab.LabID);
}
}
if (courseLabs.Count == 0)
{
//此条记录没有对应的实验室，继续循环下一条
continue;
}
#endregion
#region 处理周次
string weekStr = dr["周"].ToString();
int isDouble = 0;
if (weekStr.Contains("双"))
{
isDouble = 2;
}
else if (weekStr.Contains("单"))
{
isDouble = 1;
}
List<int> weeks = GetListOfStr(weekStr, isDouble);
#endregion
#region 处理工作日
string weekdayStr = dr["星期"].ToString();
List<int> weekdays = GetListOfStr(weekdayStr, 0);
#endregion
#region 处理节次
string classStr = dr["节"].ToString();
List<int> classes = GetListOfStr(classStr, 0);
#endregion
#region 循环导入
//schtb.
foreach (int wk in weeks)
{
//周
foreach (int wkd in weekdays)
{
//工作日
foreach (int lb in courseLabs)
{
//实验室
foreach (int cls in classes)
{
schedule_tb schtb = new schedule_tb();
schtb.ScdCrs = courseID;
schtb.ScdTerm = termID;
schtb.ScdWeek = (sbyte)wk;
schtb.ScdWeekDay = (sbyte)wkd;
schtb.ScdLab = lb;
//节次
schtb.ScdClass = cls;
//保存至数据库
jszxDataManager.jszxEntity.schedule_tb.Add(schtb);
jszxDataManager.jszxEntity.SaveChanges();
}
}
}
}
#endregion
#endregion
SwitchProgressBar.Value = i + 1;
}
scope.Complete();
}
#endregion
SwitchTip.Text = "导入完成,正在保存数据";
SwitchProgressBar.IsIndeterminate = true;
//}
//catch (Exception ex)
//{
// MessageBox.Show("出现错误：\n"+ex.Message);
//}
}
/// <summary>
/// 保存实验记录
/// </summary>
/// <param name="exp">实验记录信息，不包含实验学期，和实验节次</param>
/// <param name="selectedClass">实验记录节次的列表</param>
public void SaveExpRecord(Exprecord exp, List<int> selectedClass)
{
using(JszxDataManager jszxDataManager=new JszxDataManager()){
int tm = jszxDataManager.GetCurrentTerm().TermID;
exp.ExpTerm = tm;
foreach(int cls in selectedClass){
exp.ExpCls =(sbyte)cls;
exprecords_tb exptb = null;
//判断当前课是否填写过
exptb = jszxDataManager.GetExpRecords(tm, (int)exp.ExpLabID, (int)exp.ExpWeek, (int)exp.ExpWeekDay, (int)exp.ExpCls).FirstOrDefault();
if (exptb == null)
{
exptb = new exprecords_tb();
}
exptb.CourseName = exp.CourseName;
exptb.ExpClasses = exp.ExpClasses;
exptb.ExpCls = exp.ExpCls;
exptb.ExpDate = exp.ExpDate;
exptb.ExpLab = exp.ExpLab;
exptb.ExpLabID = exp.ExpLabID;
exptb.ExpName = exp.ExpName;
exptb.ExpTerm = exp.ExpTerm;
exptb.ExpWeek = exp.ExpWeek;
exptb.ExpWeekDay = exp.ExpWeekDay;
exptb.Groups = exp.Groups;
exptb.InstrumentStatus = exp.InstrumentStatus;
exptb.PerGroup = exp.PerGroup;
exptb.PostTime = exp.PostTime;
exptb.Problems = exp.Problems;
exptb.Realizer = exp.Realizer;
exptb.Shoulder = exp.Shoulder;
exptb.StudentName = exp.StudentName;
exptb.StudentStatus = exp.StudentStatus;
exptb.TeacherName = exp.TeacherName;
exptb.TeacherNumber = exp.TeacherNumber;
jszxDataManager.SaveExpRecord(exptb);
}
}
}
/// <summary>
/// 获取指定学期
/// </summary>
/// <returns>指定学期</returns>
public Term GetPurposeTerm(int id)
{
using (JszxDataManager jszxDateManage = new JszxDataManager())
{
terms_tb tmtb = jszxDateManage.GetCurrentTerm(id);
Term tm = new Term();
if (tmtb != null)
{
tm.TermID = tmtb.TermID;
tm.TermIndex = tmtb.TermIndex;
tm.TermIsUse = tmtb.TermIsUse;
tm.TermStartDay = tmtb.TermStartDay;
tm.TermWeeks = tmtb.TermWeeks;
tm.TermYear = tmtb.TermYear;
}
return tm;
}
}
