/// <summary> /// ����Ա��ӿγ���Ϣ /// </summary> /// <param name="mStudent">����ӵĿγ̶����Լ���ÿγ���ص���ʦ</param> /// <returns>����Ƿ�ɹ����ɹ���true,ʧ����false</returns> public bool AddCourse(CourseInfo mCourse, List<string> teachers) { SqlParameter[] parms1 = { new SqlParameter("@name",mCourse.Name), new SqlParameter("@startDate",mCourse.StartDate), new SqlParameter("@endDate",mCourse.EndDate) }; bool isSuccess = false; int affectedRows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_AddCourse", parms1); SqlParameter[] params2 = { new SqlParameter("@courseName", mCourse.Name), new SqlParameter("@teacherName", SqlDbType.NVarChar) }; SqlConnection conn = new SqlConnection(SQLHelper.ConnectionStringSTEduSys); conn.Open(); SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { foreach (string strTeacher in teachers) { params2[1].Value = strTeacher; SQLHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "SP_AddTeacherCourse", params2); } trans.Commit(); isSuccess = true; } catch (Exception e) { trans.Rollback(); throw new ApplicationException(e.Message); } finally { conn.Close(); } if (affectedRows > 0 && isSuccess) { isSuccess = true; } return isSuccess; }
protected void ValidateInfo_Server(object sender, EventArgs e) { tbStartDate.Enabled = true; tbEndDate.Enabled = true; tbTeacher1.Enabled = true; tbTeacher2.Enabled = true; bool isValidated = true; List<string> teachers = new List<string>(); if (tbCourseName.Text == "" || tbCourseName.Text.Length > 50) { isValidated = false; } if (tbTeacher1.Text == tbTeacher2.Text) { isValidated = false; } else if (tbTeacher1.Text == "" && tbTeacher2.Text == "") { isValidated = false; } else { if (tbTeacher1.Text != "") { teachers.Add(tbTeacher1.Text); } if (tbTeacher2.Text != "") { teachers.Add(tbTeacher2.Text); } } if (tbStartDate.Text == "" || tbEndDate.Text == "") { isValidated = false; } else if (DateTime.Parse(tbStartDate.Text) >= DateTime.Parse(tbEndDate.Text)) { isValidated = false; } if (new Search().GetCourseInfoByName(tbCourseName.Text).ID > 0) { isValidated = false; tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('该课程已存在,请更换');window.location.href='" + Request.RawUrl + "';</script>"); return; } if (isValidated) { CourseInfo course = new CourseInfo(tbCourseName.Text, DateTime.Parse(tbStartDate.Text), DateTime.Parse(tbEndDate.Text)); Admin admin = new Admin(); if (admin.AddCourse(course, teachers)) { FilesCreate(tbCourseName.Text); // 为新加的课程创建文件夹及文件 tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('添加成功');window.location.href='./Course_Manage.aspx';</script>"); } else { tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('服务器繁忙,请稍后再试');window.location.href='" + Request.RawUrl + "';</script>"); } } else { tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('请按流程输入合理数据');window.location.href='" + Request.RawUrl + "';</script>"); } }
/// <summary> /// ����Ա�Ŀγ̵���Ϣ /// </summary> /// <param name="mStudent">�γ̵Ķ����Լ���γ����������ʦ��Ϣ</param> /// <returns>���Ƿ�ɹ����ɹ���true,ʧ����false</returns> //public delegate void Init(SqlDataReader Dr, string dir); ////�����ļ�ɾ�����߳� //public void init(SqlDataReader dr, string dir) //{ // while (dr.Read()) // { // //��ҵ���� // string Path = dir + @"/SiteFile/annex/"; // if (Directory.Exists(Path)) // { // DirectoryInfo dinfo = new DirectoryInfo(Path); // FileInfo[] files = dinfo.GetFiles(); // foreach (FileInfo file in files) // { // string filename = file.Name; // string[] sArray = filename.Split('&'); // if (sArray[0] == dr[0].ToString()) // { // try // { // file.Delete(); // } // catch { } // break; // } // } // } // //ѧ����ҵ // try // { // File.Delete(dr[1].ToString()); // } // catch { } // } // dr.Close(); //} public bool EditCourse(CourseInfo mCourse, List<string> teachers, string dir) { SqlParameter[] params1 = { new SqlParameter("@id",mCourse.ID), new SqlParameter("@name",mCourse.Name), new SqlParameter("@startDate",mCourse.StartDate), new SqlParameter("@endDate",mCourse.EndDate) }; SqlParameter[] params2 = { new SqlParameter("@id", mCourse.ID), new SqlParameter("@name", SqlDbType.NVarChar) }; SqlParameter[] params3 = { new SqlParameter("@id", mCourse.ID) }; bool isSuccess = false; SqlConnection conn = new SqlConnection(SQLHelper.ConnectionStringSTEduSys); conn.Open(); SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { //���¿γ���Ϣ SQLHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "SP_EditCourseInfoByID", params1); //������ʦ��γ̶�Ӧ��Ϣ foreach (string strTeacher in teachers) { params2[1].Value = strTeacher; SQLHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "SP_UpdateTeacher_Course", params2); } //����֮ǰ���ο���ʦ���ڲ��ٽ̴˿γ̣���ɾ������ÿγ��йص�������Ϣ //ɾ���ļ����ᵼ�����ݿ������ʱ���ʷ��� //SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_GetFileURLAboutTeacher", params3); //Init optionDelgate = new Init(init); //optionDelgate.BeginInvoke(dr, dir, null, null); //ɾ�����ݿ������Ϣ SQLHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "SP_ClearAllAboutTeacher", params3); trans.Commit(); isSuccess = true; } catch (Exception e) { trans.Rollback(); throw new ApplicationException(e.Message); } finally { conn.Close(); } return isSuccess; }
protected void ValidateInfo_Server(object sender, EventArgs e) { tbStartDate.Enabled = true; tbEndDate.Enabled = true; tbTeacher1.Enabled = true; tbTeacher2.Enabled = true; bool isValidated = true; List<string> teachers = new List<string>(); if (tbCourseName.Text == "" || tbCourseName.Text.Length > 50) { isValidated = false; } if (tbTeacher1.Text == tbTeacher2.Text) { isValidated = false; } else if (tbTeacher1.Text == "" && tbTeacher2.Text == "") { isValidated = false; } else { if (tbTeacher1.Text != "") { teachers.Add(tbTeacher1.Text); } if (tbTeacher2.Text != "") { teachers.Add(tbTeacher2.Text); } } if (tbStartDate.Text == "" || tbEndDate.Text == "") { isValidated = false; } else if (DateTime.Parse(tbStartDate.Text) >= DateTime.Parse(tbEndDate.Text)) { isValidated = false; } if (tbCourseName.Text != oldCourseName.Value && new Search().GetCourseInfoByName(tbCourseName.Text).ID > 0) { isValidated = false; tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('该课程已存在,请更换');window.location.href='" + Request.RawUrl + "';</script>"); return; } if (isValidated) { CourseInfo course = new CourseInfo(tbCourseName.Text, DateTime.Parse(tbStartDate.Text), DateTime.Parse(tbEndDate.Text)); try { course.ID = Int32.Parse(Request.QueryString["courseID"].ToString()); } catch (FormatException fe) { Response.Redirect("./Course_Manage.aspx"); return; } tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Admin admin = new Admin(); if (admin.EditCourse(course, teachers, Server.MapPath("~/"))) { try { Directory.Move(Server.MapPath("~/Text/") + oldCourseName.Value, Server.MapPath("~/Text/") + course.Name); Directory.Move(Server.MapPath("~/CommandFiles/") + oldCourseName.Value, Server.MapPath("~/CommandFiles/") + course.Name); } catch { } Response.Write("<script>alert('修改成功');window.location.href='./Course_Manage.aspx';</script>"); } else { Response.Write("<script>alert('服务器繁忙,请稍后再试');window.location.href='" + Request.RawUrl + "';</script>"); } } else { tbStartDate.Enabled = false; tbEndDate.Enabled = false; tbTeacher1.Enabled = false; tbTeacher2.Enabled = false; Response.Write("<script>alert('请按流程输入合理数据');window.location.href='" + Request.RawUrl + "';</script>"); } }
public void Add(CourseInfo pCourseInfo) { _arrayInternal.Add(pCourseInfo); }
/// <summary> /// ����Ա��ӿγ���Ϣ /// </summary> /// <param name="mStudent">����ӵĿγ̶����Լ���ÿγ����������ʦ</param> /// <returns>����Ƿ�ɹ����ɹ���true,ʧ����false</returns> public bool AddCourse(CourseInfo mCourse, List<string> teachers) { return dal.AddCourse(mCourse, teachers); }
/// <summary> /// ����Ա�Ŀγ������Ϣ /// </summary> /// <param name="mStudent">�γ̵Ķ����Լ���ÿγ����������ʦ</param> /// <returns>���Ƿ�ɹ����ɹ���true,ʧ����false</returns> public bool EditCourse(CourseInfo mCourse, List<string> teachers, string dir) { return dal.EditCourse(mCourse, teachers, dir); }
/// <summary> /// ���ݿγ�����ѯ�γ���Ϣ /// </summary> /// <returns>���ؿγ̶���</returns> public CourseInfo GetCourseInfoByName(string name) { CourseInfo course = new CourseInfo(); string queryCourse = "select ID,name,startDate,endDate from Course where name = '"+name+"'"; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnStringSTEduSys"].ConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand(queryCourse, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { course.ID = Int32.Parse(reader[0].ToString()); course.Name = reader[1].ToString(); course.StartDate = DateTime.Parse(reader[2].ToString()); course.EndDate = DateTime.Parse(reader[3].ToString()); } // call close when done reading. ���� reader.Close(); } return course; }