Èí¼þ¹¤³Ì±ÏÒµÉè¼Æ_ÍøÂçͼÊé¹ÜÀíϵͳ ÏÂÔØ±¾ÎÄ

phpͼÊé¹Ý¹ÜÀíϵͳ

using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient;

public partial class libraryInfo : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (Session[\ //ÅжϹÜÀíÔ±ÊÇ·ñµÇ¼ {

if (getSet()) //ÅжÏÊÇ·ñÓµÓÐȨÏÞ

{

if (!IsPostBack) {

bindLibrary(); } } else

Response.Write(\ÄúûÓдËȨÏÞ');location='index.aspx';\

} else {

Response.Redirect(\ //·µ»Øµ½µÇÂ¼Ò³Ãæ } }

protected void btnSave_Click(object sender, EventArgs e) {

string libraryName = txtLibraryName.Text; string curator = txtCurator.Text; string tel = txtTel.Text;

string address = txtAddress.Text; string email = txtEmail.Text; string net = txtNet.Text;

string upbuildTime = txtUpbuildTime.Text; string remark = txtRemark.Text;

string sql = \

\\

net + \ if (dataOperate.execSQL(sql))

28

phpͼÊé¹Ý¹ÜÀíϵͳ

{

RegisterStartupScript(\±£´æ³É¹¦£¡')\ } else {

RegisterStartupScript(\±£´æÊ§°Ü£¡')\ }

}

//×Ô¶¨Òå·½·¨Åжϵ±Ç°¹ÜÀíÔ±ÊÇ·ñÓµÓйÜÀí´ËÒ³ÃæµÄȨÏÞ public bool getSet() {

string userName = Session[\ //»ñÈ¡¹ÜÀíÔ±µÇ¼Ãû

string sql = \ SqlDataReader sdr = dataOperate.getRow(sql);

sdr.Read(); //¶ÁȡһÌõ¼Ç¼

return Convert.ToBoolean(sdr[\ //·µ»ØÊÇ·ñÓµÓÐȨÏÞ }

//×Ô¶¨Òå·½·¨ÏÔʾͼÊé¹ÝÐÅÏ¢ public void bindLibrary() {

string sql = \

SqlDataReader sdr = dataOperate.getRow(sql); sdr.Read();

txtLibraryName.Text = sdr[\ //»ñȡͼÊé¹ÝÃû³Æ

txtCurator.Text = sdr[\ //»ñÈ¡¹Ý³¤ txtTel.Text = sdr[\ //»ñÈ¡µç»° txtAddress.Text = sdr[\ //»ñÈ¡µØÖ· txtEmail.Text = sdr[\ //»ñÈ¡µç×ÓÓʼþ

txtNet.Text = sdr[\ //»ñÈ¡ÍøÖ· txtUpbuildTime.Text = sdr[\ //»ñÈ¡½¨¹Ýʱ¼ä

txtRemark.Text = sdr[\ //»ñÈ¡±¸×¢ }[15]

protected void txtRemark_TextChanged(object sender, EventArgs e) {

}

29

phpͼÊé¹Ý¹ÜÀíϵͳ

}

¢Û ¹ÜÀíÔ±ÉèÖÃÖ÷Òª´úÂ룺 using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient;

public partial class userManage : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (Session[\ //ÅжϹÜÀíÔ±ÊÇ·ñµÇ¼ {

if (getSet()) //ÅжÏÊÇ·ñÓµÓÐȨÏÞ

{

bindUerManage(); } else

Response.Write(\ÄúûÓдËȨÏÞ');location='index.aspx';\ } else {

Response.Redirect(\ //·µ»Øµ½µÇÂ¼Ò³Ãæ } }

public void bindUerManage() {

string sql = \

gvAdmSet.DataSource = dataOperate.getDataset(sql, \»ñÈ¡Êý¾ÝÔ´

gvAdmSet.DataKeyNames=new string[] {\ //ÉèÖÃÖ÷¼ü×Ö¶Î

gvAdmSet.DataBind(); //°ó¶¥GridView¿Ø¼þÏÔʾ¹ÜÀíÔ±ÐÅÏ¢ }

protected void gvAdmSet_RowDeleting(object sender, GridViewDeleteEventArgs e) {

30

phpͼÊé¹Ý¹ÜÀíϵͳ

string userName = this.gvAdmSet.DataKeys[e.RowIndex].Value.ToString(); //»ñÈ¡Ö÷¼ü×Ö¶Î

string sql = \

dataOperate.execSQL(sql); //ɾ³ý¹ÜÀíÔ±ÐÅÏ¢

bindUerManage(); //ÖØÐ°󶨹ÜÀíÔ±ÐÅÏ¢ }

public bool getSet() {

string userName = Session[\ //»ñÈ¡¹ÜÀíÔ±µÇ¼Ãû

string sql = \ SqlDataReader sdr = dataOperate.getRow(sql);

sdr.Read(); //¶ÁȡһÌõ¼Ç¼

return Convert.ToBoolean(sdr[\ //·µ»ØÊÇ·ñÓµÓÐȨÏÞ }

protected void Header1_Load(object sender, EventArgs e) {

}

}

31