資源簡介
可以進行簡單的教室預約,學生與老師都分別有不同的權限,簡單實現功能,ASP.NET與SqlServer 2000實現

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;
public?partial?class?Classbook?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????}
????protected?void?Button1_Click(object?sender?EventArgs?e)
????{
????????string?crname?=?DropDownList1.SelectedItem.ToString().Trim();
????????string?jiaoshi?=?DropDownList2.SelectedItem.ToString().Trim();
????????string?riqi?=?datetime.Text.Trim();
????????string?jieci?=?DropDownList3.SelectedItem.ToString().Trim();
????????string?sql=“delete?from?JS_order?where?crname=‘“+crname+“‘and?jiaoshi=‘“+jiaoshi+“‘and?riqi=‘“+riqi+“‘and?jieci=‘“+jieci+“‘“;?????
???????//string?sql?=?“select?*?from?users?where?username=‘“?+?txtusername.Text?+?“‘?and?pwd=‘“?+?txtPwd.Text?+?“‘?and?usertype=‘“?+?DropDownList1.SelectedValue.ToString()+?“‘“;
????????SqlConnection?con?=?new?SqlConnection(ConfigurationManager.ConnectionStrings[“JSorder“].ConnectionString);
????????con.Open();
????????SqlCommand?cmd?=?new?SqlCommand(sql?con);
???????
??????
????????int?f?=?cmd.ExecuteNonQuery();
????????if?(f?>=?1)
????????{
????????????Response.Write(“ript?language=javascript>alert(‘您已成功取消預約!‘); ript>“);
????????}
????????else
????????{
????????????Response.Write(“ript?language=javascript>alert(‘取消預約失敗!‘); ript>“);
????????}
????}
????protected?void?Calendar1_Selectionchanged(object?sender?EventArgs?e)
????{
????????datetime.Text?=?Calendar1.SelectedDate.ToString().Substring(0?Calendar1.SelectedDate.ToString().LastIndexOf(“?“)?+?1);
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????1048576??2009-09-23?16:52??多功能教室預約系統-最后\data\JS_data.mdf
?????文件????2097152??2009-09-23?16:52??多功能教室預約系統-最后\data\JS_log.ldf
?????文件???????1245??2009-09-18?11:42??多功能教室預約系統-最后\web\App_Code\DB.cs
?????文件????1835008??2009-09-14?11:48??多功能教室預約系統-最后\web\App_Data\JS_data.mdf
?????文件????1572864??2009-09-14?11:48??多功能教室預約系統-最后\web\App_Data\JS_data_log.ldf
?????文件????2097152??2009-09-10?16:53??多功能教室預約系統-最后\web\App_Data\JS_log.ldf
?????文件???????3188??2009-09-22?18:05??多功能教室預約系統-最后\web\cancel.aspx
?????文件???????1846??2009-09-22?21:00??多功能教室預約系統-最后\web\cancel.aspx.cs
?????文件???????3190??2009-09-23?16:08??多功能教室預約系統-最后\web\cancelt.aspx
?????文件???????1847??2009-09-23?16:09??多功能教室預約系統-最后\web\cancelt.aspx.cs
?????文件???????3107??2009-09-15?11:11??多功能教室預約系統-最后\web\changePwd.aspx
?????文件???????2553??2009-09-15?11:13??多功能教室預約系統-最后\web\changePwd.aspx.cs
?????文件???????3110??2009-09-23?16:35??多功能教室預約系統-最后\web\changePwds.aspx
?????文件???????2546??2009-09-23?16:35??多功能教室預約系統-最后\web\changePwds.aspx.cs
?????文件???????3110??2009-09-23?16:31??多功能教室預約系統-最后\web\changePwdt.aspx
?????文件???????2554??2009-09-23?16:31??多功能教室預約系統-最后\web\changePwdt.aspx.cs
?????文件???????2282??2009-09-23?09:20??多功能教室預約系統-最后\web\denglu.aspx
?????文件???????2602??2009-09-23?09:05??多功能教室預約系統-最后\web\denglu.aspx.cs
?????文件???????1908??2009-09-23?15:41??多功能教室預約系統-最后\web\editclass.aspx
?????文件???????3425??2009-09-23?15:42??多功能教室預約系統-最后\web\editclass.aspx.cs
?????文件??????36452??2009-09-09?08:36??多功能教室預約系統-最后\web\img\1.jpg
?????文件??????13760??2009-09-09?08:57??多功能教室預約系統-最后\web\img\2.jpg
?????文件??????23646??2007-12-30?23:39??多功能教室預約系統-最后\web\img\200612522413.jpg
?????文件??????17733??2009-09-09?08:37??多功能教室預約系統-最后\web\img\3.GIF
?????文件???????8758??2009-09-09?08:58??多功能教室預約系統-最后\web\img\3.jpg
?????文件????????716??2009-09-09?09:16??多功能教室預約系統-最后\web\img\4.jpg
?????文件???????3816??2008-11-23?22:22??多功能教室預約系統-最后\web\img\43.jpg
?????文件????????879??2009-09-09?09:14??多功能教室預約系統-最后\web\img\5.jpg
?????文件????????749??2009-09-09?09:16??多功能教室預約系統-最后\web\img\6.jpg
?????文件??????54117??2009-09-09?08:34??多功能教室預約系統-最后\web\img\815_0_20090313161258.jpg
............此處省略76個文件信息
評論
共有 條評論