课程设计在线学习系统
} else {
Common.ShowMessage(this.Page, \对不起，您提供的工号或学号不存在！\, \); } }
#endregion
protected void DropDownList_type_SelectedIndexChanged(object sender, EventArgs e) {
if (DropDownList_type.SelectedValue == \教师\) {
lb_code.Text = \工号：\; } else {
lb_code.Text = \学号：\; } }
4.2系统登录
截图与主要代码：
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) {
SqlConnection cn = DB.OpenConnection();
string user = Common.UrnHtml(txt_user.Text.Trim()); string pwd =
22
课程设计在线学习系统
FormsAuthentication.HashPasswordForStoringInConfigFile(txt_pwd.Text, \);
string sql = \ + user + \X_Manager_Pwd='\ + pwd + \;
SqlDataReader dr = DB.getDataReader(sql,cn); if (AuthCode1.IsMatch) {
if (dr.Read()) {
if (dr[\].ToString() == \未审核\) {
Common.ShowMessage(Page, \对不起，您的帐号暂时未审核通过！\,\); } else {
HttpCookie cookies;
cookies = new HttpCookie(\); cookies.Values.Add(\, HttpUtility.UrlEncode(this.txt_user.Text.Trim())); cookies.Values.Add(\, HttpUtility.UrlEncode(dr[\].ToString()));
cookies.Expires = DateTime.Now.AddHours(24);//1天有效24小时 Response.Cookies.Set(cookies);//存储！～ dr.Close(); dr.Dispose();
DB.DisposeConnection(cn);
Response.Redirect(\); } } else {
dr.Close(); dr.Dispose();
DB.DisposeConnection(cn);
Common.ShowMessage(Page, \登陆失败，请检查用户名及密码是否正确！\, \);
} } else {
dr.Close(); dr.Dispose();
DB.DisposeConnection(cn);
23
课程设计在线学习系统
Common.ShowMessage(Page, \验证码错误\, \); } }
注：以下模块均以教师角色登录，由于其他角色功能操作代码与教师操作功能代码模式相同，在此仅列出教师功能模块代码：
4.3在线交流
截图与主要代码：
public static string sqltxt = \; public static string cmdtxt2 = \; protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
Get_Pager_Data();//获取列表数据 } }
24
课程设计在线学习系统
void Get_Pager_Data() {
SqlConnection cn = DB.OpenConnection();
SqlCommand cmd0 = new SqlCommand(cmdtxt2, cn); AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 14;
AspNetPager1.RecordCount = (int)cmd0.ExecuteScalar(); cn.Close(); Get_Data(); }
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) {
AspNetPager1.CurrentPageIndex = e.NewPageIndex; Get_Data(); }
void Get_Data()//绑定数据 {
SqlConnection cn=DB.OpenConnection();
SqlCommand cmd=new SqlCommand (sqltxt,cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet();
da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, \);
DataView dv = ds.Tables[\].DefaultView; this.Repeater1.DataSource = dv; this.Repeater1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e)//提交信息 {
string user = \;
if (Request.Cookies[\] != null) {
if (Request.Cookies[\][\] != null) {
user =
HttpUtility.UrlDecode(Request.Cookies[\][\].ToString()); DB.ExecuteSql(\
X_Message(X_Message_Content,X_Message_Author)values('\+txt_content.Text+\+user+\);
25
课程设计在线学习系统
Get_Pager_Data(); } else {
Response.Redirect(\); } } else {
Response.Redirect(\); } }
4.4课设管理
截图与主要代码：
public static string sqltxt = \; public static string cmdtxt2 = \; protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
26
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库课程设计在线学习系统的设计与实现(6)在线全文阅读。
相关推荐：