using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data;
using?System.Data.SqlClient;

public?partial?class?masterpageaspx?:?System.Web.UI.Page
{
????public?string?idsave?nameput?stateput?classnumber?qqput?phoneput?classput?sexput?=?““;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????idsave?=?（string）（Session[Session.SessionID]）;
????????if?（idsave?==?null）
????????{
????????????Response.Redirect（“loginpage.aspx“）;
????????}
????????else
????????{
????????????idlable.Text?=?idsave;
????????????rdatabase（idsave）;
????????????namelable.Text?=?nameput;
????????????statelable.Text?=?stateput;
????????????Image1.ImageUrl?=?“~/studentpics/“?+?idsave?+?“.jpg“;
????????????
????????}
????}

????public?void?rdatabase（string?tag）
????{
????????SqlConnection?connection?=?new?SqlConnection（“server=MAQIC-PC\\MAQIC;?uid=sa;?password=123456;?database=winhit“）;
????????connection.Open（）;
????????SqlCommand?cmd?=?new?SqlCommand（“select*from?studentinformation“?connection）;
????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????while?（reader.Read（））
????????{
????????????if?（reader.GetString（0）.Equals（tag））
????????????{
????????????????nameput?=?reader.GetString（1）;
????????????????sexput?=?reader.GetString（2）;
????????????????classnumber?=?reader.GetString（3）;
????????????????phoneput?=?reader.GetString（4）;
????????????????stateput?=?reader.GetString（5）;
????????????????qqput?=?reader.GetString（6）;
????????????}
????????}
????}

????protected?void?Repeater1_ItemCommand（object?source?RepeaterCommandEventArgs?e）
????{
????????if?（（Repeater1.Items[e.Item.ItemIndex].FindControl（“Label2“）?as?Label）.Text?!=?namelable.Text）
????????????Label1.Text?=?（Repeater1.Items[e.Item.ItemIndex].FindControl（“Label2“）?as?Label）.Text;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????Label1.Text?=?““;
????????TextBox1.Text?=?““;
????????Label3.Visible?=?false;
????}
????protected?void?Button2_Click（object?sender?EventArgs?e）
????{
????????if?（Label1.Text?==?““?||?TextBox1.Text?==?““）
????????{
????????????Label3.Visible?=?true;
????????}
????????else
????????{
????????????SqlConnection?con?=?new?SqlConnection（“server=MAQIC-PC\\MAQIC;?uid=sa;?password=123456;?database=winhit“）;
????????????con.Open（）;
????????????SqlCommand?com?=?new?SqlCommand（“insert?into?letter?values（‘“+?namelable.Text?+?“‘‘“?+?Label1.Text?+?“‘‘“?+?TextBox1.Text?+?“‘‘“?+?DateTime.Now?+?“‘）“?con）;
????????????com.ExecuteNonQuery（）;
????????????con.Close（）;
????????????Label1.Text?=?““;
????????????TextBox1.Text?=?““;
????????????Label3.Visible?=?false;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????10093??2012-04-18?18:43??student?holiday?manager_website\homepage.aspx

?????文件???????2803??2012-04-18?19:53??student?holiday?manager_website\homepage.aspx.cs

?????文件??????11296??2012-04-05?12:46??student?holiday?manager_website\img\bg.png

?????文件???????3568??2012-04-05?12:18??student?holiday?manager_website\img\bg_top_light.png

?????文件????????393??2012-04-11?09:35??student?holiday?manager_website\img\date.png

?????文件?????508597??2012-04-06?00:52??student?holiday?manager_website\img\loginpic.png

?????文件??????11912??2012-04-18?19:57??student?holiday?manager_website\letterpage.aspx

?????文件???????1610??2012-04-18?23:25??student?holiday?manager_website\letterpage.aspx.cs

?????文件???????6578??2012-04-18?18:43??student?holiday?manager_website\loginpage.aspx

?????文件???????3878??2012-04-18?13:27??student?holiday?manager_website\loginpage.aspx.cs

?????文件???????7568??2012-04-18?12:16??student?holiday?manager_website\scorepage.aspx

?????文件???????3777??2012-04-10?01:34??student?holiday?manager_website\scorepage.aspx.cs

?????文件????????440??2012-04-10?15:22??student?holiday?manager_website\sesssionabandon.aspx

?????文件????????798??2012-04-11?19:38??student?holiday?manager_website\sesssionabandon.aspx.cs

?????文件??????12689??2012-04-18?12:16??student?holiday?manager_website\settingpage.aspx

?????文件???????5970??2012-04-10?01:35??student?holiday?manager_website\settingpage.aspx.cs

?????文件???????3144??2012-04-18?19:22??student?holiday?manager_website\styleSheet.css

?????文件????????780??2012-04-11?20:31??student?holiday?manager_website\web.config

?????目錄??????????0??2012-04-24?12:18??student?holiday?manager_website\img

?????目錄??????????0??2012-04-24?12:19??student?holiday?manager_website\studentpics

?????目錄??????????0??2012-04-24?12:18??student?holiday?manager_website

-----------?---------??----------?-----??----

???????????????595894????????????????????21