protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string courseId = Request.QueryString["courseId"];
string sql = "select * from CourseInfo inner join VideoInfo on CourseInfo.courseId = VideoInfo.CourseId where CourseInfo.courseId=" + courseId;
SqlDataReader sdr = DataOperate.GetRow(sql);
sdr.Read();
video.Src = sdr["VideoPath"].ToString();
currentVideo.Text = sdr["VideoId"].ToString();
maininfo_top.Text = sdr["intro"].ToString();
maininfo_bottom.Text = sdr["target"].ToString();
QABindData(sdr["VideoId"].ToString());
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd = new SqlCommand("select * from VideoInfo where CourseId=" + courseId, con);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
someIntro.Visible = true;
questionList.Visible = false;
resdata.Visible = false;
introPart.ForeColor = System.Drawing.Color.DodgerBlue;
RBindData();
}
}
public static string CurrentTime(float currentTime, string videoPath)
{
string courseId = "";
string stuId = "";
if (HttpContext.Current.Session != null && HttpContext.Current.Session["courseId"] != null && HttpContext.Current.Session["userId"] != null)
{
courseId = HttpContext.Current.Session["courseId"].ToString();
stuId = HttpContext.Current.Session["userId"].ToString();
}
SqlConnection con = DataOperate.CreateCon();
string sql1 = "select * from VideoInfo where CourseId=" + courseId + " and VideoPath='" + videoPath + "'";
SqlDataReader sdr1 = DataOperate.GetRow(sql1);
sdr1.Read();
string videoId = sdr1["VideoId"].ToString();
string sql2 = "select count(*) from LearnRecord where stuId='" + stuId + "' and videoId=" + videoId;
string sql3 = "";
string updatedAt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (DataOperate.SeleSQL(sql2) == 0)
{
sql3 = "insert into LearnRecord(stuId,courseId,videoId,currentTime,updatedAt) values('" + stuId + "','" + courseId + "'," + videoId + "," + currentTime + ",'" + updatedAt + "')";
}
else
{
sql3 = "update LearnRecord set currentTime = " + currentTime + ",updatedAt = '" + updatedAt + "' where stuId='" + stuId + "' and videoId=" + videoId;
}
DataOperate.ExecSQL(sql3);
return("success");
}
protected void Infosave_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = DataOperate.CreateCon();
coverimg.SaveAs(Server.MapPath("~/upload/image/") + Path.GetFileName(coverimg.FileName));
string coverName = Path.GetFileName(coverimg.FileName);
string coverLink = "~/upload/image/" + Path.GetFileName(coverimg.FileName);
string teacherName = Session["userName"].ToString();
string openDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string sql = "insert into CourseInfo(courseId,courseName,courseType,teacher,cover,intro,target,part,courseLevel,openDate) values('" + courseid.Text + "','" + coursename.Text + "','" + coursetype.SelectedValue + "','" + teacherName + "','" + coverLink + "','" + intro.Text + "','" + target.Text + "','" + part.Text + "','" + courselevel.SelectedValue + "','" + openDate + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
courseid.Text = "";
coursename.Text = "";
part.Text = "";
target.Text = "";
intro.Text = "";
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('成功新设课程')</script>");
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('新设课程失败')</script>");
}
}
protected void find_Click(object sender, EventArgs e)
{
string mail = txtMail.Text;
SqlConnection con = DataOperate.CreateCon();
con.Open();
string sql1 = "select count(*) from TeacherInfo where TeachId = '" + mail + "'";
string sql2 = "select count(*) from StudentInfo where StuId = '" + mail + "'";
SqlCommand cmd1 = new SqlCommand(sql1, con);
SqlCommand cmd2 = new SqlCommand(sql2, con);
Session["mail"] = mail;
if ((Convert.ToInt32(cmd1.ExecuteScalar()) > 0) || (Convert.ToInt32(cmd2.ExecuteScalar()) > 0))
{
firstImg.Visible = false;
secondImg.Visible = true;
thirdImg.Visible = false;
first.Visible = false;
second.Visible = true;
third.Visible = false;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('该邮箱未被注册')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = "select * from TeacherInfo where TeachId ='" + Session["userId"].ToString() + "'";
SqlDataReader sdr = DataOperate.GetRow(sql);
sdr.Read();
user.Text = Session["userName"].ToString();
person.ImageUrl = sdr["TeachPic"].ToString();
img.ImageUrl = sdr["TeachPic"].ToString();
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select * from CourseInfo where teacher ='" + user.Text + "'";
SqlDataReader reader = null;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
reader = cmd.ExecuteReader();
videocourse.DataSource = reader;
videocourse.DataTextField = "courseName";
videocourse.DataValueField = "courseId";
videocourse.DataBind();
}
}
protected void LBindData()
{
string courseId = Request.QueryString["courseId"];
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd = new SqlCommand("select * from VideoInfo where CourseId=" + courseId, con);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void DropDownListBind()
{
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con;
string teacher = Session["userName"].ToString();
cmd1.CommandText = "select * from CourseInfo where teacher ='" + teacher + "'";
SqlDataReader reader1 = null;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
reader1 = cmd1.ExecuteReader();
CourseName.DataSource = reader1;
CourseName.DataTextField = "courseName";
CourseName.DataValueField = "courseId";
CourseName.DataBind();
if (con.State == ConnectionState.Open)
{
con.Close();
}
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandText = "select * from VideoInfo where CourseId ='" + CourseName.SelectedValue + "'";
SqlDataReader reader2 = null;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
reader2 = cmd2.ExecuteReader();
VideoName.DataSource = reader2;
VideoName.DataTextField = "videoName";
VideoName.DataValueField = "videoId";
VideoName.DataBind();
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
protected void change_Click(object sender, EventArgs e)
{
string newpass = newone.Text.ToString();
string sql1 = "update TeacherInfo set TeachPassword ='******' where TeachId='" + Session["Mail"].ToString() + "'";
string sql2 = "update StudentInfo set StuPassword ='******' where StuId='" + Session["Mail"].ToString() + "'";
SqlConnection con = DataOperate.CreateCon();
con.Open();
SqlCommand cmd1 = new SqlCommand(sql1, con);
SqlCommand cmd2 = new SqlCommand(sql2, con);
if (cmd1.ExecuteNonQuery() > 0 || cmd2.ExecuteNonQuery() > 0)
{
ClientScript.RegisterStartupScript(Page.GetType(), "true", "<script>alert('密码重置成功 请重新登录');window.location.href='Index.aspx'</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('密码重置失败')</script>");
}
}
protected void outerDataList_ItemCommand(object source, DataListCommandEventArgs e)
{
((TextBox)e.Item.FindControl("AddAnswer")).Visible = true;
((Button)e.Item.FindControl("Submit")).Visible = true;
if (e.CommandName == "submit")
{
int questionId = Convert.ToInt32(e.CommandArgument);
((TextBox)e.Item.FindControl("AddAnswer")).Visible = false;
((Button)e.Item.FindControl("Submit")).Visible = false;
string answerContent = ((TextBox)e.Item.FindControl("AddAnswer")).Text;
string answerBy = Session["userName"].ToString();
string answerTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
SqlConnection con = DataOperate.CreateCon();
string sql = "insert into AnswerInfo(AnswerContent,AnswerBy,QuesId,AnswerTime) values('" + answerContent + "','" + answerBy + "'," + questionId + ",'" + answerTime + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
QABindData(getVideoIdByQuestionId(questionId));
}
}
protected void filesave_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = DataOperate.CreateCon();
filepath.SaveAs(Server.MapPath("~/upload/file/") + Path.GetFileName(filepath.FileName));
string fileLink = "~/upload/file/" + Path.GetFileName(filepath.FileName);
string upTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string sql = "insert into FileInfo values('" + filename.Text + "','" + fileLink + "','" + filevideo.SelectedValue + "','" + remark.Text + "','" + upTime + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
filename.Text = "";
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('文件上传成功')</script>");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('文件上传失败')</script>");
}
}
public static string ToRegister(string userId, string Pwd, string entryType, string mailCode)
{
string MailCode = mailCode;
string str = HttpContext.Current.Session["code"].ToString();
string sql = "";
if (str == MailCode)
{
if ("teacher" == entryType)
{
sql = "insert into TeacherInfo(TeachId,TeachPassword) values(@userId,@userPwd)";
}
else
{
sql = "insert into StudentInfo(StuId,StuPassword) values(@userId,@userPwd)";
}
SqlConnection con = DataOperate.CreateCon();
con.Open();
SqlCommand com = new SqlCommand(sql, con);
com = new SqlCommand(sql, con);
com.Parameters.Add(new SqlParameter("@userId", SqlDbType.VarChar, 50));
com.Parameters["@userId"].Value = userId;
com.Parameters.Add(new SqlParameter("@userPwd", SqlDbType.VarChar, 50));
com.Parameters["@userPwd"].Value = Pwd;
if (com.ExecuteNonQuery() > 0)
{
HttpContext.Current.Session["userId"] = userId;
return("success");
}
else
{
return("fail"); //提示注册失败ToRegister
}
}
else
{
return("wrong code");
}
}
private void QABindData(string videoId)
{
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd = new SqlCommand("PROC_QA", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlParameter param = new SqlParameter("@videoId", SqlDbType.VarChar);
param.Direction = ParameterDirection.Input;
param.Value = videoId;
cmd.Parameters.Add(param);
DataSet ds = new DataSet();
ad.Fill(ds);
ds.Relations.Add(new DataRelation("QA_Relation", ds.Tables[0].Columns["quesId"],
ds.Tables[1].Columns["quesId"], false));
outerDataList.DataSource = ds;
outerDataList.DataBind();
}
protected void CourseName_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = DataOperate.CreateCon();
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandText = "select * from VideoInfo where CourseId ='" + CourseName.SelectedValue + "'";
SqlDataReader reader2 = null;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
reader2 = cmd2.ExecuteReader();
VideoName.DataSource = reader2;
VideoName.DataTextField = "videoName";
VideoName.DataValueField = "videoId";
VideoName.DataBind();
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
protected void videosave_Click(object sender, EventArgs e)
{
string videoName = videoname.Text;
SqlConnection con = DataOperate.CreateCon();
videopath.SaveAs(Server.MapPath("~/upload/video/") + Path.GetFileName(videopath.FileName));
string videoLink = "~/upload/video/" + Path.GetFileName(videopath.FileName);
string[] sqlT = new string[2];
int i = 0;
sqlT[i++] = "insert into VideoInfo values('" + videoName + "','" + videoLink + "','" + videocourse.SelectedValue + "')";
sqlT[i] = "update CourseInfo set part = part+1 where courseId='" + videocourse.SelectedValue + "'";
if (DataOperate.ExecTransaction(sqlT))
{
videoname.Text = "";
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('视频上传成功')</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('视频上传失败')</script>");
}
}
public static string SendEmail(string email, string userType)
{
string sql = "";
if (userType == "student")
{
sql = "select count(*) from StudentInfo where StuId=@userId";
}
else
{
sql = "select count(*) from TeacherInfo where TeachId=@userId";
}
SqlConnection con = DataOperate.CreateCon();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(new SqlParameter("@userId", SqlDbType.VarChar, 50));
cmd.Parameters["@userId"].Value = email;
if (Convert.ToInt32(cmd.ExecuteScalar()) == 0)
{
String to = email;
Random random = new Random(Guid.NewGuid().GetHashCode());
int code = random.Next(100000, 1000000);
string content = "您正在使用邮箱安全验证服务，您本次操作的验证码是：" + code;
string strSmtpServer = ConfigurationManager.AppSettings["STR_SMTP_SERVER"];
string strFrom = ConfigurationManager.AppSettings["STR_SMTP_FROM"];
string strFromPass = ConfigurationManager.AppSettings["STR_SMTP_PASSWORD"];
SendEmail(strSmtpServer, strFrom, strFromPass, to, "激活邮箱", content);
HttpContext.Current.Session["code"] = code;
return("success");
}
return("user existed");
}
public static string Login(string userId, string Pwd, string entryType)
{
HttpContext.Current.Session["entryType"] = entryType;
string cs = entryType;
string sql;
if (cs == "教师")
{
sql = "select * from TeacherInfo where TeachId=@userId and TeachPassword=@Pwd ";
}
else
{
sql = "select * from StudentInfo where StuId=@userId and StuPassword=@Pwd ";
}
SqlConnection con = DataOperate.CreateCon();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(new SqlParameter("userId", SqlDbType.VarChar, 50));
cmd.Parameters["userId"].Value = userId;
cmd.Parameters.Add(new SqlParameter("Pwd", SqlDbType.VarChar, 50));
cmd.Parameters["Pwd"].Value = Pwd;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
HttpContext.Current.Session["userId"] = userId;
HttpContext.Current.Session["userName"] = cs == "教师" ? sdr["TeachName"].ToString() : sdr["StuName"].ToString();
HttpContext.Current.Session["userType"] = cs;
return("success");
}
return("fail");
}