protected void AddSalary_Submit(object sender, EventArgs e)
{
DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry();
DalOperationAboutTeacher dalt = new DalOperationAboutTeacher();
DalOperationAboutCourses dalc = new DalOperationAboutCourses();
string teacherNo = this.TeacherId.Value;
string termTag = this.SalaryTermTag.SelectedValue;
string salaryMonth = this.SalaryMonth.Value;
int teacherType = int.Parse(this.teacherType.Value.Trim());
int salaryEntryStatus = 0;
List<SalaryEntry> salaryEntries = dal.GetSalaryEntrys(teacherNo, termTag, salaryMonth, teacherType, salaryEntryStatus);
if (salaryEntries != null && salaryEntries.Count != 0)
{
Javascript.Alert("本月已为该教师添加过薪酬信息，请核对信息后再次录入!", Page);
}
else {
SalaryEntry salaryEntry = new SalaryEntry();
TeachersList teacher = new TeachersList
{
teacherNo = teacherNo
};
Courses course = new Courses
{
courseNo = this.CourseId.Value
};
salaryEntry.teacher = teacher;
salaryEntry.course = course;
salaryEntry.atCourseType = atCourseType.Value;
salaryEntry.termTag = termTag;
salaryEntry.salaryMonth = salaryMonth;
salaryEntry.teacherCostWithTax = float.Parse(this.TeacherSalaryCostWithTax.Text);
salaryEntry.teacherCostWithoutTax = float.Parse(this.TeacherSalaryCostWithoutTax.Text);
salaryEntry.teacherTotalCost = float.Parse(this.TeacherTotalCost.Text);
salaryEntry.SetSalaryInItemValueList(this.InSalaryItemValueList.Value, false);
salaryEntry.SetSalaryOutItemValueList(this.OutSalaryItemValueList.Value, false);
salaryEntry.memo = this.SalaryEntryMemo.Text.Trim();
salaryEntry.teacherType = teacherType;
dal.AddSalaryEntry(salaryEntry);
Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=5", Page);
}
}
protected void TeacherSalaryQA_Click(object sender, EventArgs e)
{
SalaryQA salaryQa = new SalaryQA();
salaryQa.qaContent = this.newTeacherSalaryQA.Text.Trim();
salaryQa.salaryId = int.Parse(this.hf_SalaryId.Value.Trim());
salaryQa.salaryType = int.Parse(this.hf_SalaryType.Value.Trim());
TeachersList teacher = new TeachersList();
UserCookiesInfo userCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
teacher.teacherNo = userCookiesInfo.userNo;
salaryQa.teacher = teacher;
DalOperationAboutSalaryQA dalqa = new DalOperationAboutSalaryQA();
dalqa.AddSalaryQA(salaryQa);
Javascript.JavaScriptLocationHref("/Teacher/TeacherSalaryQA.aspx?salaryType=" + salaryQa.salaryType + "&salaryId=" + salaryQa.salaryId, Page);
}
/// <summary>
///将Excel表的信息数据保存到数据库
/// </summary>
/// <param name="dt">文件名称</param>
/// <param name="tableType">表类型</param>
/// <returns>删除是否成功</returns>
public int DataTabletoDBTables(DataTable dt,string tableType)
{
if (tableType.Equals("学生信息"))
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StudentsList student = new StudentsList();
student.studentNo = dt.Rows[i][1].ToString().Trim();
student.studentName = dt.Rows[i][2].ToString().Trim();
student.studentSpeciality = dt.Rows[i][3].ToString().Trim();
student.classNo = dt.Rows[i][4].ToString().Trim();
student.mobileNo = dt.Rows[i][5].ToString().Trim();
student.emailAddress = dt.Rows[i][6].ToString().Trim();
student.remark = dt.Rows[i][7].ToString().Trim();
student.studentUserPwd = student.studentNo;//密码默认与学号相同
this.AddStudent(student);
}
return dt.Rows.Count;
}
}
else if (tableType.Equals("教师信息"))
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TeachersList teacher = new TeachersList();
teacher.teacherNo = dt.Rows[i][1].ToString().Trim();
teacher.teacherName = dt.Rows[i][2].ToString().Trim();
teacher.emailAddress = dt.Rows[i][3].ToString().Trim();
teacher.officeAddress = dt.Rows[i][4].ToString().Trim();
teacher.remark = dt.Rows[i][5].ToString().Trim();
teacher.teacherUserPwd = teacher.teacherNo;//密码默认与教师编号相同
this.AddTeacher(teacher);
}
return dt.Rows.Count;
}
}
else if (tableType.Equals("助教信息"))
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AssistantsList assistant = new AssistantsList();
assistant.assistantNo = dt.Rows[i][1].ToString().Trim();
assistant.assistantName = dt.Rows[i][2].ToString().Trim();
assistant.emailAddress = dt.Rows[i][3].ToString().Trim();
assistant.officeAddress = dt.Rows[i][4].ToString().Trim();
assistant.remark = dt.Rows[i][5].ToString().Trim();
assistant.assistantUserPwd = assistant.assistantNo;//密码默认与助教编号相同
this.AddAssistant(assistant);
}
return dt.Rows.Count;
}
}
else if (tableType.Equals("课程信息"))
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Courses course = new Courses();
course.courseNo = dt.Rows[i][1].ToString().Trim();
course.courseName= dt.Rows[i][2].ToString().Trim();
course.period =dt.Rows[i][3].ToString().Trim();
course.credit=float.Parse( dt.Rows[i][4].ToString().Trim());
course.courseSpeciality= dt.Rows[i][5].ToString();
course.termTag =dt.Rows[i][6].ToString().Trim();//学期标识
new DalOperationAboutCourses().AddCourse(course);
}
return dt.Rows.Count;
}
}
else if (tableType.Equals("考试安排"))
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ExamArrangeList examTime = new ExamArrangeList();
examTime.courseName= dt.Rows[i][1].ToString().Trim();
examTime.examArrangeTime =DateTime.Parse(dt.Rows[i][2].ToString().Trim());
examTime.examArrageAddress = dt.Rows[i][3].ToString().Trim();
examTime.remark =dt.Rows[i][4].ToString().Trim();
examTime.teacherName = dt.Rows[i][5].ToString();
examTime.courseNo= dt.Rows[i][6].ToString().Trim();
this.AddExamArrange(examTime);
}
return dt.Rows.Count;
}
}
return 0;
}
/// <summary>
/// 查询教师信息,通过教师编号teacherNo
/// </summary>
/// <param name="teacherNo">教师编号</param>
/// <returns>教师信息</returns>
public TeachersList FindTeacherByNo(string teacherNo)
{
TeachersList teacher = null;
string cmdstring = "SELECT [teacherNo] ,[teacherName] ,[teacherUserPwd],[emailAddress] ,[officeAddress] ,[remark] FROM [USTA].[dbo].[usta_TeachersList] WHERE teacherNo=@teacherNo";
SqlParameter[] parameters = {
new SqlParameter("@teacherNo", SqlDbType.NVarChar,50)
};
parameters[0].Value = teacherNo;
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, cmdstring, parameters);
if (dr.Read())
{
teacher = new TeachersList
{
teacherUserPwd = dr["teacherUserPwd"].ToString().Trim(),
teacherNo = dr["teacherNo"].ToString().Trim(),
teacherName = dr["teacherName"].ToString().Trim(),
emailAddress = dr["emailAddress"].ToString().Trim(),
officeAddress = dr["officeAddress"].ToString().Trim(),
remark = dr["remark"].ToString().Trim()
};
}
dr.Close();
conn.Close();
return teacher;
}
//-----------------------------------------------------------------
/// <summary>
/// 增加教师信息
/// </summary>
/// <param name="teacher">教师信息</param>
public void AddTeacher(TeachersList teacher)
{
try
{
string sql = "INSERT INTO usta_TeachersList VALUES(@teacherNo,@teacherUserPwd,@teacherName,@emailAddress, @officeAddress,@remark,@type)";
SqlParameter[] parameters = {
new SqlParameter("@teacherNo", SqlDbType.NVarChar,50),
new SqlParameter("@teacherUserPwd", SqlDbType.NChar,32),
new SqlParameter("@teacherName", SqlDbType.NChar,10),
new SqlParameter("@emailAddress", SqlDbType.NChar,50),
new SqlParameter("@officeAddress", SqlDbType.NChar,50),
new SqlParameter("@remark", SqlDbType.NVarChar,500),
new SqlParameter("@type", SqlDbType.Int,4)};
parameters[0].Value = teacher.teacherNo;
parameters[1].Value = CommonUtility.EncodeUsingMD5(teacher.teacherUserPwd);
parameters[2].Value = teacher.teacherName;
parameters[3].Value = teacher.emailAddress;
parameters[4].Value = teacher.officeAddress;
parameters[5].Value = teacher.remark;
parameters[6].Value = teacher.type;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 修改教师信息
/// </summary>
/// <param name="teacher">教师信息</param>
public void UpdateTeacherByTeacher(TeachersList teacher)
{
try
{
string sql = "UPDATE usta_TeachersList SET teacherUserPwd=@teacherUserPwd,officeAddress=@officeAddress,emailAddress=@emailAddress,remark=@remark,teacherName= @teacherName WHERE teacherNo=@teacherNo AND type='1'";
SqlParameter[] parameters = {
new SqlParameter("@teacherNo", SqlDbType.NVarChar,50),
new SqlParameter("@teacherUserPwd", SqlDbType.NChar,32),
new SqlParameter("@teacherName", SqlDbType.NVarChar,50),
new SqlParameter("@emailAddress", SqlDbType.NChar,50),
new SqlParameter("@officeAddress", SqlDbType.NChar,50),
new SqlParameter("@remark", SqlDbType.NVarChar,500)};
parameters[0].Value = teacher.teacherNo;
parameters[1].Value =teacher.teacherUserPwd;
parameters[2].Value = teacher.teacherName;
parameters[3].Value = teacher.emailAddress;
parameters[4].Value = teacher.officeAddress;
parameters[5].Value = teacher.remark;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
protected void btn_TeacherSalary_Click(object sender, EventArgs e)
{
DalOperationAboutTeacherSalary teacherSalaryDal = new DalOperationAboutTeacherSalary();
if (this.btn_TeacherSalary.Text == "添加")
{
string teacherNo = this.teacherNo.Value;
string termTag = this.TeacherSalary_TermTag.SelectedValue;
int teacherType = int.Parse(this.teacherType.Value.Trim());
List<TeacherSalary> teacherSalaries = teacherSalaryDal.GetTeacherSalarys(teacherNo, teacherType, termTag, 0);
if (teacherSalaries != null && teacherSalaries.Count != 0)
{
Javascript.Alert("本学期已为该教师添加过薪酬预算，请核对信息后再次录入！", Page);
}
else {
TeachersList teacherList = new TeachersList
{
teacherNo = this.teacherNo.Value
};
TeacherSalary salary = new TeacherSalary();
salary.teacher = teacherList;
if (Course_TR.Visible)
{
string atCourseType = this.atCourseType.Value;
Courses course = new Courses
{
courseNo = this.CourseId_hf.Value
};
salary.course = course;
salary.atCourseType = int.Parse(atCourseType);
salary.teachPeriod = int.Parse(this.teachPeriod.Text.Trim());
if (this.experPeriod.Text == null || this.experPeriod.Text.Trim().Length == 0)
{
salary.experPeriod = 0;
}
else
{
salary.experPeriod = int.Parse(this.experPeriod.Text.Trim());
}
}
if (BuildInSalaryItemValueList(salary)) {
salary.teacherType = int.Parse(this.teacherType.Value.Trim());
salary.termTag = TeacherSalary_TermTag.SelectedValue;
salary.memo = teacherSalary_Memo.Text.Trim();
using (TransactionScope scope = new TransactionScope())
{
try
{
teacherSalaryDal.AddTeacherSalary(salary);
AddSalaryEntryDefault(salary);
scope.Complete();
Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=3", Page);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
Javascript.GoHistory(-1, "添加薪酬预算和月发放薪酬记录失败！", Page);
}
}
}
}
}
}
private List<SalaryQA> BuildSalaryQA(SqlDataReader reader, List<SalaryQA> salaryQAs)
{
SalaryQA salaryQA;
while (reader.Read())
{
salaryQA = new SalaryQA();
salaryQA.salaryQaId = int.Parse(reader["salaryqaId"].ToString().Trim());
TeachersList teacher = new TeachersList();
teacher.teacherNo = reader["userId"].ToString().Trim();
teacher.teacherName = reader["teacherName"].ToString().Trim();
salaryQA.teacher = teacher;
salaryQA.salaryId = int.Parse(reader["salaryId"].ToString().Trim());
salaryQA.qaContent = reader["qaContent"].ToString().Trim();
salaryQA.salaryType = int.Parse(reader["salaryType"].ToString().Trim());
salaryQA.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim());
salaryQAs.Add(salaryQA);
}
return salaryQAs;
}
/// <summary>
/// 根据工作薄的名称判断进行对应实体类数据的封装
/// </summary>
/// <param name="sheetName">工作薄名称</param>
/// <param name="list">具体实体类项目的集合</param>
/// <returns>返回封装后的实体类数据</returns>
public static object ReturnModelDataJudgeBySheetName(string sheetName, List<string> list)
{
object modelClassCorrelationSheet = null;
switch (sheetName)
{
case "Sheet1":
modelClassCorrelationSheet =
new TeachersList
{
teacherNo = list[0],
teacherName = list[1],
emailAddress = list[2],
officeAddress = list[3],
remark = list[4],
teacherUserPwd = list[5]
};
break;
case "Sheet2":
modelClassCorrelationSheet = new AssistantsList
{
assistantNo = list[0],
assistantName = list[1],
emailAddress = list[2],
officeAddress = list[3],
remark = list[4],
assistantUserPwd = list[5]
};
break;
case "Sheet3":
modelClassCorrelationSheet = new StudentsList
{
studentNo = list[0],
studentName = list[1],
studentSpeciality = list[2],
classNo = list[3],
mobileNo = list[4],
emailAddress = list[5],
remark = list[6],
studentUserPwd = list[7]
};
break;
case "Sheet4":
modelClassCorrelationSheet = new TermTags
{
termTag = list[0]
};
break;
case "Sheet5":
modelClassCorrelationSheet = new Courses
{
courseNo = list[0],
courseName = list[1],
period = list[2],
credit = float.Parse(list[3]),
courseSpeciality = list[4],
termTag = list[5],
preCourse = string.Empty,
referenceBooks = string.Empty,
attachmentIds = string.Empty
};
break;
case "Sheet6":
modelClassCorrelationSheet = new CoursesTeachersCorrelation
{
teacherNo = list[0],
courseNo = list[1]
};
break;
case "Sheet7":
modelClassCorrelationSheet = new CoursesAssistantsCorrelation
{
assistantNo = list[0],
courseNo = list[1]
};
break;
case "Sheet8":
modelClassCorrelationSheet = new CoursesStudentsCorrelation
{
studentNo = list[0],
courseNo = list[1]
};
break;
default:
break;
}
return modelClassCorrelationSheet;
}
