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