/// <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;
}