//查找
public DataTable Search(int num, CourseBuild CourseBuild)
{
string sql = "select Building_Id as 教学楼,Department as 系院,Garde as 年级, Name as 教室,Week as 周节,Weekday as 星期,Section 节次,Teacher as 任课老师,Course as 课程名称,Class as 班级, Year as 学年,Term as 学期,reason as 说明 from CourseBuild where";
switch (num)
{
case 1: //根据系别
sql += " Department= '" + CourseBuild.Department + "'";
break;
case 2: //根据系别和教室
sql += " Department= '" + CourseBuild.Department + "' and Name='" + CourseBuild.Name + "'";
break;
case 3: //根据老师
sql += " Teacher='" + CourseBuild.Teacher + "'";
break;
case 4: //根据年级
sql += " Garde='" + CourseBuild.Garde + "'";
break;
case 5: //根据年级和班级
sql += " Garde='" + CourseBuild.Garde + "' and Class='" + CourseBuild.Class + "'";
break;
}
return(sqldb.FillDt(sql));
// return dt;
}
/// <summary>
/// 查找是否存在课程冲突
/// </summary>
/// <param name="top">选择课程的上限</param>
/// <param name="down">所选课程的下限</param>
/// <param name="model">model类</param>
/// <returns></returns>
public bool SelectSection(string top, string down, CourseBuild model)
{
int key = 2;
int k = 0;
int TOP = Convert.ToInt32(top);
int DOWN = Convert.ToInt32(down);
string st = null;
string[] array = null;
dal.GetControl(model);
dt = dal.dtShow(key);
for (int j = 0; j < dt.Rows.Count; j++)
{
st = dt.Rows[j][0].ToString(); //得到节次
array = st.Split(','); //把节次中的','删除
int s = array.Length;
if (TOP <= Convert.ToInt32(array[0]) && DOWN >= Convert.ToInt32(array[s - 1])) //top=1,down=4, 3,4
{
k = 1;
break;
}
}
if (k == 1) //存在课程冲突
{
return(false);
}
else
{
return(true);
}
}
//生成word表格
public void ToWord(CourseBuild model, string mm, string pe)
{
int key = 3;
dal.GetControl(model); //传值
dt = dal.dtShow(key); //得到记录;
dt.Rows[0][10] = mm;
dt.Rows[0][11] = pe;
ToWord toword = new ToWord();
toword.CourseTable1(dt, "申请表", "申请表");
}
/// <summary>
/// 插入申请的课程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertApply(CourseBuild model)
{
dal.GetControl(model);
if (dal.InsertApply())
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 传递控件的值
/// </summary>
/// <param name="model"></param>
public void GetControl(CourseBuild model)
{
//SqlParameter[] paras = { new SqlParameter("@B_ID", model.Building_Id), new SqlParameter("@CM", model.Name), new SqlParameter("@WK", model.Week), new SqlParameter("@WY", model.Weekday)};
B_ID = model.Building_Id;
CM = model.Name;
WK = model.Week;
WY = model.Weekday;
Term = model.Term;
Year = model.Year;
Course = model.Course;
Garde = model.Garde;
Department = model.Department;
Class = model.Class;
Teacher = model.Teacher;
Reason = model.reason;
Section = model.Section;
}
/// <summary>
/// 将add添加的信息转化为实体类并放入list中
/// </summary>
/// <param name="CourseSum"></param>
/// <returns></returns>
List <CourseBuild> Convert(List <string> CourseSum)
{
foreach (string item in CourseSum)
{
CourseBuild CourseBuildNow = new CourseBuild();
string[] Sum = item.Split('|');
CourseBuildNow.Building_Id = Sum[1];
CourseBuildNow.Department = Sum[0];
CourseBuildNow.Garde = Sum[6];
CourseBuildNow.Name = Sum[2];
CourseBuildNow.Week = Sum[5];
CourseBuildNow.Weekday = Sum[8];
CourseBuildNow.Section = Sum[9];
CourseBuildNow.Teacher = Sum[4];
CourseBuildNow.Course = Sum[3];
CourseBuildNow.Class = Sum[7];
CourseBuildNow.Year = Sum[10];
CourseBuildNow.Term = Sum[11];
CourseBuild.Add(CourseBuildNow);
}
return(CourseBuild);
}
public DataTable Search(int num, CourseBuild courseBuild)//查找
{
return(recordDAL.Search(num, courseBuild));
}
/// <summary>
/// 传递控件的值
/// </summary>
/// <param name="b_id">教学楼ID</param>
/// <param name="cm">教室</param>
/// <param name="wk">几周</param>
/// <param name="wy">周几</param>
public void ControlValue(CourseBuild model)
{
dal.GetControl(model);
}
