protected void btnAttdance_Click(object sender, EventArgs e)//上报
{
StringBuilder strNO = new StringBuilder("未完成作业名单:");
int sum = 0;
foreach (GridViewRow row in this.gvHomeworkDetails.Rows)
{
Control ctl2 = row.FindControl("rdoNO");
TableCellCollection cell = row.Cells;
if ((ctl2 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentHomework", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "未完成", ""))
{
sum++;
strNO.Append(cell[3].Text.ToString() + ";");//添加上姓名
}
}
}
if (strNO.ToString() == "未完成作业名单:")
{
strNO.Append("无");
}
if (AddSQLStringToDAL.UpdateTabTeachers("TabTeacherAttendance", "Count", "已批改作业", "IsAttendance", "已考勤", "TeacherID", Session["UserID"].ToString(), "Course", Session["CurrentCourse"].ToString(), "CurrentWeek", (Convert.ToInt32(Session["CurrentWeek"].ToString()) - 1).ToString(), "Week", Session["Week"].ToString(), "Time", Session["Time"].ToString()))
{
lblHomeWorkMessage.Text = strNO.ToString();
lblResultMessage.Text = "本次作业记录已经上报成功！请返回主页面！";
btnClose.Visible = true;
}
gvHomeworkDetails.Visible = false;
}
protected void Button5_Click(object sender, EventArgs e)//导入系部人数按钮
{
if (TextBox1.Text != "" && TextBox2.Text != "" && TextBox3.Text != "" && TextBox4.Text != "" && TextBox5.Text != "" && TextBox6.Text != "" && TextBox7.Text != "")
{
string[] str = { "会计系", "信息工程系", "经济管理系", "食品工程系", "机械工程系", "商务外语系", "建筑工程系" };
int[] sum = new int[str.Length];
sum[0] = Convert.ToInt32(TextBox1.Text.Trim());
sum[1] = Convert.ToInt32(TextBox2.Text.Trim());
sum[2] = Convert.ToInt32(TextBox3.Text.Trim());
sum[3] = Convert.ToInt32(TextBox4.Text.Trim());
sum[4] = Convert.ToInt32(TextBox5.Text.Trim());
sum[5] = Convert.ToInt32(TextBox6.Text.Trim());
sum[6] = Convert.ToInt32(TextBox7.Text.Trim());
if (AddSQLStringToDAL.DeleteTabTeachers("TabDepartmentSum"))
{
}
for (int i = 0; i < str.Length; i++)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabDepartmentSum", str[i], sum[i].ToString()))
{
label6.Visible = true;
label6.Text = "各系人数设置完毕！";
}
}
}
else
{
label6.Visible = true;
label6.Text = "部分系部人数未设置，请全部设置！";
}
}
private void InsertCoursesSimpleMap(List <string> strDistinctTeacherID)
{
for (int i = 0; i < strDistinctTeacherID.Count; i++)
{
List <string> strDD = new List <string>();
strDD = AddSQLStringToDAL.GetDistinctStrings("TabAllCourses", "TimeAndArea", "TeacherID", strDistinctTeacherID[i].ToString());//获取TimeAndArea
for (int k = 0; k < strDD.Count; k++)
{
List <string> strResult = new List <string>();
strResult = SplitString.GetSplitCountAndDetails(strDD[k]);
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabAllCourses where TeacherID = '" + strDistinctTeacherID[i].ToString() + "' and TimeAndArea = '" + strDD[k].ToString() + "'");
for (int j = 0; j < (strResult.Count / 4); j++)
{
string WeekRange = SplitString.GetWithoutWeek(strResult[j * 4 + 0].ToString());//如果想用空格隔开，只是在最后加一个空格（以，作为例子试的）
string Week = strResult[j * 4 + 1].ToString();
string Time = strResult[j * 4 + 2].ToString();
string Area = strResult[j * 4 + 3].ToString();
string Course = dt.Rows[0]["Course"].ToString().Trim();
if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherCourseSimpleMap", strDistinctTeacherID[i].ToString(), dt.Rows[0]["TeacherName"].ToString(), Course, WeekRange, Week, Time, strDD[k].ToString(), dt.Rows[0]["Class"].ToString(), dt.Rows.Count.ToString(), dt.Rows[0]["TeacherDepartment"].ToString(), dt.Rows[0]["StudentDepartment"].ToString(), Area))
{
}
}
dt.Clear();
}
}
}
private void GetTeacherCourseSimpleMap()
{
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabTeacherCourseSimpleMap");
foreach (DataRow dr in dt.Rows)
{
string[] strT = dr["WeekRange"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < strT.Length; i++)
{
string WeekNumber = "";
string TeacherDepartment = dr["TeacherDepartment"].ToString();
string TeacherID = dr["TeacherID"].ToString();
string TeacherName = dr["TeacherName"].ToString();
string Week = dr["Week"].ToString();
switch (Week)
{
case "星期一":
WeekNumber = "1";
break;
case "星期二":
WeekNumber = "2";
break;
case "星期三":
WeekNumber = "3";
break;
case "星期四":
WeekNumber = "4";
break;
case "星期五":
WeekNumber = "5";
break;
case "星期六":
WeekNumber = "6";
break;
default:
WeekNumber = "7";
break;
}
string Time = dr["Time"].ToString();
string Course = dr["Course"].ToString();
string Area = dr["Area"].ToString();
if (strT[i].Length == 1)
{
strT[i] = "0" + strT[i];
}
if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherAttendance", WeekNumber, TeacherDepartment, TeacherID, TeacherName, strT[i].ToString(), Week, Time, Course, Area, "未考勤", "", dr["WithoutWeek"].ToString(), "", ""))
{
}
}
lblMessage7.Text = "数据处理完毕！";
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (chkToLeader.Checked == false && chkToSecretary.Checked == false && chkToTeacher.Checked == false)
{
lblMessage.Text = "请选中要发布通知的对象！";
}
else
{
if (txtxMessage.Text == "")
{
lblMessage.Text = "通知不能为空！";
}
else
{
List <string> strSum = new List <string>();
List <string> strID1 = new List <string>();
List <string> strID2 = new List <string>();
List <string> strID3 = new List <string>();
List <string> strID4 = new List <string>();
if (chkToLeader.Checked)//找出校领导ID
{
strID1 = AddSQLStringToDAL.GetDistinctStrings("TabTeachers", "UserID", "Role", 2);
}
if (chkToSecretary.Checked)//找出辅导员ID
{
strID2 = AddSQLStringToDAL.GetDistinctStrings("TabTeachers", "UserID", "Role", 3);
}
if (chkToTeacher.Checked)//找出所有有课教师的ID
{
strID3 = AddSQLStringToDAL.GetDistinctStrings("Tabteachers", "UserID");
}
//将这三个找出来的全部放到strSum里
strSum.AddRange(strID1);
strSum.AddRange(strID2);
strSum.AddRange(strID3);
//因为有课的教师也可能是辅导员或者校领导，所以移除相同的ID
for (int i = 0; i < strSum.Count; i++)
{
for (int j = 0; j < strSum.Count; j++)
{
if (i != j)
{
if (strSum[i] == strSum[j])
{
strSum.RemoveAt(j);
}
}
}
}
if (strSum.Count > 0)
{
for (int i = 0; i < strSum.Count; i++)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabMessage", System.DateTime.Now.ToString(), txtxMessage.Text.ToString(), strSum[i].ToString(), "false", "", ""))
{
}
}
lblMessage.Text = "消息发送成功！";
txtxMessage.Text = "";
}
}
}
}
protected void btnAttdance_Click(object sender, EventArgs e)//将非正常学生名单录入数据库
{
StringBuilder strLate = new StringBuilder("迟到名单:");
StringBuilder strAbsence = new StringBuilder("旷课名单:");
StringBuilder strEarly = new StringBuilder("早退名单:");
StringBuilder strLeave = new StringBuilder("请假名单:");
int sum = 0;
foreach (GridViewRow row in this.gvAttendanceDetails.Rows)
{
Control ctl2 = row.FindControl("rdoLate");
Control ctl3 = row.FindControl("rdoAbsence");
Control ctl4 = row.FindControl("rdoEarly");
Control ctl5 = row.FindControl("rdoLeave");
TableCellCollection cell = row.Cells;
if ((ctl2 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "迟到", ""))
{
sum++;
strLate.Append(cell[3].Text.ToString() + ";");
}
}
if ((ctl3 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "旷课", ""))
{
sum++;
strAbsence.Append(cell[3].Text.ToString() + ";");
}
}
if ((ctl4 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "早退", ""))
{
sum++;
strEarly.Append(cell[3].Text.ToString() + ";");
}
}
if ((ctl5 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "请假", ""))
{
sum++;
strLeave.Append(cell[3].Text.ToString() + ";");
}
}
}
if (strLate.ToString() == "迟到名单:")
{
strLate.Append("无");
}
if (strAbsence.ToString() == "旷课名单:")
{
strAbsence.Append("无");
}
if (strEarly.ToString() == "早退名单:")
{
strEarly.Append("无");
}
if (strLeave.ToString() == "请假名单:")
{
strLeave.Append("无");
}
if (AddSQLStringToDAL.UpdateTabTeachers("TabTeacherAttendance", "IsAttendance", "已考勤", "Count", Session["Homework"].ToString(), "TeacherID", Session["UserID"].ToString(), "Course", Session["CurrentCourse"].ToString(), "CurrentWeek", Session["CurrentWeek"].ToString(), "Week", Session["Week"].ToString(), "Time", Session["Time"].ToString()))
{
lblAttendanceMessage.Text = strAbsence.ToString();
lblLateMessage.Text = strLate.ToString();
lblEarlyMessage.Text = strEarly.ToString();
lblLeaveMessage.Text = strLeave.ToString();
strLate.Remove(0, strLate.Length);
strAbsence.Remove(0, strAbsence.Length);
strEarly.Remove(0, strEarly.Length);
strLeave.Remove(0, strLeave.Length);
SetControlsVisibleFalse();
lblResultMessage.Text = "本次考勤记录已经上报成功！本次课您" + Session["Homework"].ToString() + ",请返回主页面！";
btnClose.Visible = true;
}
}