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(); } }
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>"); } }
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 link_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; string videoName = btn.CommandArgument.ToString(); string sql = "select * from VideoInfo where VideoName=" + "'" + videoName + "'"; SqlDataReader sdr1 = DataOperate.GetRow(sql); sdr1.Read(); video.Src = sdr1["VideoPath"].ToString(); currentVideo.Text = sdr1["VideoId"].ToString(); Label lb = (Label)btn.FindControl("title"); lb.Style["color"] = "red"; string stuId = Session["userId"].ToString(); string videoId = sdr1["VideoId"].ToString(); string courseId = Session["courseId"].ToString(); string updatedAt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string timeSql = "select count(*) from LearnRecord where stuId='" + stuId + "' and videoId=" + videoId; if (DataOperate.SeleSQL(timeSql) == 0) { string insertSql = "insert into LearnRecord(stuId,courseId,videoId,updatedAt) values('" + stuId + "','" + courseId + "'," + videoId + ",'" + updatedAt + "')"; DataOperate.ExecSQL(insertSql); } string selectSql = "select * from LearnRecord where stuId='" + stuId + "' and videoId=" + videoId; SqlDataReader sdr2 = DataOperate.GetRow(selectSql); sdr2.Read(); getTime.Text = sdr2["currentTime"].ToString(); QABindData(videoId); NBindData(); RBindData(); }
protected void join_Click(object sender, EventArgs e) { string courseId = Request.QueryString["id"]; string stuId = Session["userId"].ToString(); string sql = "select * from CourseInfo where courseId =" + courseId; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); string SC_sql = "select count(*) from SCInfo where StuId='" + stuId + "' and CourseId='" + courseId + "' "; if (DataOperate.SeleSQL(SC_sql) == 0) { string[] sqlT = new string[2]; int i = 0; sqlT[i++] = "update CourseInfo set orderNum=orderNum+1 where courseId='" + courseId + "'"; sqlT[i] = "insert into SCInfo values('" + stuId + "','" + courseId + "')"; if (DataOperate.ExecTransaction(sqlT)) { BindData(); Response.Redirect("StuCourseDetails.aspx?tip=new&courseId=" + courseId); } else { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('加入课程失败!')</script>"); } } else { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('您已加入过此课程!');location.href='StuCourseDetails.aspx?tip=again&courseId=" + courseId + "';</script>"); } }
protected void select_Click(object sender, EventArgs e) { string sql = ""; int item = selectcourse.SelectedIndex; switch (item) { case 0: sql = "select * from CourseInfo inner join CourseType on CourseInfo.courseType = CourseType.courseTypeId where CourseInfo.teacher='" + Session["userName"].ToString() + "'"; break; case 1: sql = "select * from CourseInfo inner join CourseType on CourseInfo.courseType = CourseType.courseTypeId where CourseInfo.teacher='" + Session["userName"].ToString() + "' and courseId like " + selectkey.Value; break; case 2: sql = "select * from CourseInfo inner join CourseType on CourseInfo.courseType = CourseType.courseTypeId where CourseInfo.teacher='" + Session["userName"].ToString() + "' and courseName like '" + selectkey.Value + "'"; break; case 3: sql = "select * from CourseInfo inner join CourseType on CourseInfo.courseType = CourseType.courseTypeId where CourseInfo.teacher='" + Session["userName"].ToString() + "' and courseTypeName like '" + selectkey.Value + "'"; break; } gvopened.DataSource = DataOperate.GetDataset(sql, "CourseInfo"); gvopened.DataKeyNames = new string[] { "courseId" }; gvopened.DataBind(); }
protected void btn_push_Click(object sender, EventArgs e) { string videoPath = video.Src; string courseId = Request.QueryString["courseId"].ToString(); string sql1 = "select * from VideoInfo where CourseId=" + courseId + " and VideoPath='" + videoPath + "'"; SqlDataReader sdr = DataOperate.GetRow(sql1); sdr.Read(); string videoId = sdr["VideoId"].ToString(); string sqlName = "select * from StudentInfo where StuId='" + Session["userId"] + "'"; SqlDataReader sdr1 = DataOperate.GetRow(sqlName); sdr1.Read(); string quesBy = sdr1["StuName"].ToString(); string quesContent = questContent.InnerText; string quesTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string sql2 = "insert into QuesInfo values('" + videoId + "','" + quesBy + "','" + quesContent + "','" + quesTime + " ')"; if (DataOperate.ExecSQL(sql2)) { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('发布成功!')</script>"); questContent.InnerText = ""; } QABindData(videoId); }
protected void Page_Load(object sender, EventArgs e) { string practiceId = Request.QueryString["practiceId"]; string singleSql = "select * from SingleChoice where practiceId=" + practiceId; singleList.DataSource = DataOperate.GetDataset(singleSql, "SingleChoice"); singleList.DataKeyField = "practiceId"; singleList.DataBind(); string judgeSql = "select * from JudgeQuestion where practiceId=" + practiceId; judgeList.DataSource = DataOperate.GetDataset(judgeSql, "JudgeQuestion"); judgeList.DataKeyField = "practiceId"; judgeList.DataBind(); Session["practiceId"] = practiceId; string sql = "select * from PracticeInfo where practiceId=" + practiceId; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); Name.Text = sdr["practiceName"].ToString(); string resultSql = "select * from AnswerResult inner join PracticeInfo on AnswerResult.practiceId = PracticeInfo.practiceId inner join StudentInfo on AnswerResult.stuId = StudentInfo.StuId where AnswerResult.practiceId=" + practiceId; gvResult.DataSource = DataOperate.GetDataset(resultSql, "AnswerResult"); gvResult.DataKeyNames = new string[] { "answerId" }; gvResult.DataBind(); }
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 init_Date() { string stuId = Session["userId"].ToString(); DateTime now = DateTime.Now; int Year = now.Year - 50; string sql = "select * from StudentInfo where StuId='" + stuId + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); for (int i = 0; i < 50; i++) { string value = (Year + i).ToString(); year.Items.Add(new ListItem(value, value)); } for (int i = 1; i <= 12; i++) { string value = i.ToString(); month.Items.Add(new ListItem(value, value)); } for (int i = 1; i <= 31; i++) { string value = i.ToString(); day.Items.Add(new ListItem(value, value)); } }
protected void BindInfo() { string sqlinit = "select * from CourseInfo inner join CourseType on CourseInfo.courseType = CourseType.courseTypeId where CourseInfo.teacher='" + Session["userName"].ToString() + "'"; gvopened.DataSource = DataOperate.GetDataset(sqlinit, "CourseInfo"); gvopened.DataKeyNames = new string[] { "courseId" }; gvopened.DataBind(); }
private string getVideoIdByQuestionId(int questionId) { string sql = "select * from QuesInfo where QuesId=" + questionId; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); return(sdr["VideoId"].ToString()); }
protected void Page_Load(object sender, EventArgs e) { string courseId = Request.QueryString["courseId"]; string sql = "select * from VideoInfo where CourseId =" + courseId; DataList1.DataSource = DataOperate.GetDataset(sql, "VideoInfo"); DataList1.DataKeyField = "VideoId"; DataList1.DataBind(); }
protected void User_Info() { string stuId = Session["userId"].ToString(); string sql = "select * from StudentInfo where StuId='" + stuId + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); StuId.Text = sdr["StuId"].ToString(); }
protected void User_Info() { string teachId = Session["userId"].ToString(); string sql = "select * from TeacherInfo where TeachId='" + teachId + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); TeachId.Text = sdr["TeachId"].ToString(); }
protected void TeacherBind() { string sql = "select * from TeacherInfo inner join TeacherTypeInfo on TeacherInfo.TeachTypeId = TeacherTypeInfo.TypeId"; DataSet data = DataOperate.GetDataset(sql, "TeacherInfo"); TeacherData.DataSource = data; TeacherData.DataKeyField = "TeachId"; TeacherData.DataBind(); }
protected void BindInfo() { string teachName = Session["userName"].ToString(); string sql = "select * from PracticeInfo inner join VideoInfo on PracticeInfo.videoId = VideoInfo.VideoId inner join CourseInfo on CourseInfo.courseId = VideoInfo.CourseId where CourseInfo.teacher = " + "'" + teachName + "'"; WorkList.DataSource = DataOperate.GetDataset(sql, "PracticeInfo"); WorkList.DataKeyNames = new string[] { "practiceId" }; WorkList.DataBind(); }
protected void Course_Info() { string StuId = Session["userId"].ToString(); string sql = "select * from CourseInfo inner join SCInfo on CourseInfo.courseId = SCInfo.CourseId inner join StudentInfo on StudentInfo.StuId = SCInfo.StuId where SCInfo.StuId='" + StuId + "'"; CourseInfo.DataSource = DataOperate.GetDataset(sql, "CourseInfo"); CourseInfo.DataKeyField = "courseId"; CourseInfo.DataBind(); }
protected void Practice_Todo() { string userId = Session["userId"].ToString(); string sql = "select * from PracticeInfo inner join SCInfo on PracticeInfo.courseId = SCInfo.CourseId inner join CourseInfo on CourseInfo.courseId = SCInfo.CourseId inner join VideoInfo on VideoInfo.VideoId = PracticeInfo.videoId where PracticeInfo.practiceId not in (select practiceId from AnswerResult where stuId = '" + userId + "') and SCInfo.StuId = '" + userId + "'"; TodoList.DataSource = DataOperate.GetDataset(sql, "PracticeInfo"); TodoList.DataKeyNames = new string[] { "practiceId" }; TodoList.DataBind(); }
protected void init_Info() { string StuId = Session["userId"].ToString(); string sql = "select * from StudentInfo inner join StudentTypeInfo on StudentInfo.StuTypeId = StudentTypeInfo.TypeId where StudentInfo.StuId='" + StuId + "'"; headerDataList.DataSource = DataOperate.GetDataset(sql, "StudentInfo"); headerDataList.DataKeyField = "StuId"; headerDataList.DataBind(); }
protected void Note_Info() { string stuId = Session["userId"].ToString(); string sql = "select * from NoteInfo inner join VideoInfo on NoteInfo.videoId = VideoInfo.videoId inner join CourseInfo on CourseInfo.courseId = VideoInfo.CourseId where stuId='" + stuId + "'"; NoteInfo.DataSource = DataOperate.GetDataset(sql, "NoteInfo"); NoteInfo.DataKeyField = "NoteId"; NoteInfo.DataBind(); }
protected void init_Info() { 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(); }
protected void CourseBind() { string teachId = Request.QueryString["id"]; string sql = "select * from CourseInfo inner join TeacherInfo on CourseInfo.teacher = TeacherInfo.TeachName where TeachId='" + teachId + "'"; DataSet data = DataOperate.GetDataset(sql, "CourseInfo"); CourseData.DataSource = data; CourseData.DataKeyField = "courseId"; CourseData.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string sql1 = "select * from TeacherInfo where TeachId ='" + Session["userId"].ToString() + "'"; SqlDataReader sdr = DataOperate.GetRow(sql1); sdr.Read(); user.Text = Session["userName"].ToString(); person.ImageUrl = sdr["TeachPic"].ToString(); img.ImageUrl = sdr["TeachPic"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { string sql = "select * from StudentInfo where StuId ='" + Session["userId"].ToString() + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); user.Text = sdr["StuName"].ToString(); userImg.ImageUrl = sdr["StuPic"].ToString(); TeacherBind(); }
protected void save_Click(object sender, EventArgs e) { save.Enabled = false; update.Enabled = true; string userId = Session["userId"].ToString(); string Name = txtName.Text; string Sex = ""; if (Female.Checked) { Sex = Female.Text; } else { Sex = Male.Text; } string Year = year.SelectedValue; string Month = month.SelectedValue; string Day = day.SelectedValue; string Type = TeachType.SelectedValue; string Major = TeachMajor.SelectedValue; string City = txtCity.Text; string Unit = txtUnit.Text; string Intro = txtIntro.Text; string Phone = txtPhone.Text; string filepath = "~/upload/image/"; //文件路径 string serverPath = Server.MapPath(filepath); //判断服务器目录是否存在 if (System.IO.Directory.Exists(serverPath) == false)//如果不存在就创建文件夹 { System.IO.Directory.CreateDirectory(serverPath); } UploadPic.SaveAs(serverPath + Path.GetFileName(UploadPic.FileName)); string picName = Path.GetFileName(UploadPic.FileName); string picLink = filepath + Path.GetFileName(UploadPic.FileName); string[] sqlT = new string[2]; int i = 0; sqlT[i++] = "update TeacherInfo set TeachName='" + Name + "', TeachSex='" + Sex + "',BirthYear='" + Year + "', BirthMonth='" + Month + "',BirthDay='" + Day + "',TeachTypeId='" + Type + "',TeachCity='" + City + "',TeachUnit='" + Unit + "', TeachPhone='" + Phone + "',TeachMajor='" + Major + "',intro='" + Intro + "',TeachPic='" + picLink + "'where TeachId='" + userId + "'"; sqlT[i] = "update CourseInfo set teacher='" + Name + "'where teacher='" + Session["userName"].ToString() + "'"; if (DataOperate.ExecTransaction(sqlT)) { ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('成功完善个人信息')</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", " <script>alert('个人信息完善失败,请重试')</script>"); //提示注册失败 } init_Info(); User_Info(); }
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 link_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; string courseName = btn.CommandArgument.ToString(); string sql = "select * from VideoInfo where VideoName=" + "'" + courseName + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); video.Src = sdr["VideoPath"].ToString(); QABindData(sdr["VideoId"].ToString()); RBindData(); currentVideo.Text = sdr["VideoId"].ToString(); }
public static Dictionary <string, string> GetBaseInfo() { string sql = "select * from TeacherInfo where TeachId ='" + HttpContext.Current.Session["userId"].ToString() + "'"; SqlDataReader sdr = DataOperate.GetRow(sql); sdr.Read(); var teachInfo = new Dictionary <string, string>(); teachInfo.Add("TeachPic", sdr["TeachPic"].ToString()); teachInfo.Add("TeachName", sdr["TeachName"].ToString()); return(teachInfo); }