using?System;
using?System.Collections;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;
using?System.Data.SqlClient;

public?partial?class?addGuest?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“adminlogin“]?==?null?||?Session[“adminlogin“].ToString（）?==?““）
????????????Response.Redirect（“default.aspx“）;
????}
????private?void?ShowMsg（string?msg）
????{
????????string?js?=?@“ript?language=‘javascript‘>
????????????????????alert（‘“?+?msg?+?“‘）;ript>“;
????????Response.Write（js）;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{

????????string?name?=?TextBox1.Text.Trim（）;
????????string?style?=?TextBox2.Text.Trim（）;
????????string?cont?=?TextBox10.Text.Trim（）;
????????string?contn??=?TextBox7.Text.Trim（）;
????????string?conta?=?TextBox8.Text.Trim（）;
????????string?remark?=?TextBox9.Text.Trim（）;
????????string?sql1?=?“select?*?from?[Guest]?where?[GuestName]=‘“?+?name?+?“‘“;
????????SqlConnection?conn?=?new?SqlConnection（@“Data?Source=.\sqlexpress;Initial?Catalog=SMS;Integrated?Security=True“）;
????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（sql1?conn）;
????????DataSet?ds?=?new?DataSet（）;
????????da.Fill（ds?“SMSlocal“）;
????????if?（ds.Tables[0].Rows.Count?!=?0）
????????{

????????????ShowMsg（“客戶名已存在！“）;
????????}
????????else
????????{
????????????string?sql2?=?“insert?into?Login（GuestNameGueststyleContactContactPhonenumberContactAddressRemarks）?values（‘“?+?name?+?“‘‘“?+?style?+?“‘‘“?+?cont?+?“‘‘“?+?conta?+?“‘‘“?+?contn?+?“‘‘“?+?remark?+?“‘）“;
????????????SqlCommand?cmd1?=?new?SqlCommand（sql2?conn）;
????????????//執行
????????????cmd1.ExecuteNonQuery（）;
????????????cmd1.Dispose（）;
????????????conn.Close（）;
????????????ShowMsg（“客戶信息添加成功！“）;
????????}
????}
}

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

?????文件?????767041??2010-01-13?10:29??數據庫課程設計報告.docx

?????文件????1048576??2010-01-13?14:28??SMS_log.ldf

?????文件????3145728??2010-01-13?14:28??SMS.mdf

?????文件??????53294??2010-01-10?00:52??beta1\200911521512191_2.jpg

?????文件???????4055??2010-01-12?09:21??beta1\addGuest.aspx

?????文件???????2116??2010-01-12?00:23??beta1\addGuest.aspx.cs

?????文件???????2500??2010-01-11?21:32??beta1\addStorage.aspx

?????文件???????2595??2010-01-11?21:32??beta1\addStorage.aspx.cs

?????文件???????7290??2010-01-11?12:37??beta1\addStoreIn.aspx

?????文件???????4817??2010-01-11?14:47??beta1\addStoreIn.aspx.cs

?????文件???????7094??2010-01-11?14:47??beta1\addStoreOut.aspx

?????文件???????4946??2010-01-12?12:00??beta1\addStoreOut.aspx.cs

?????文件???????3619??2010-01-13?10:30??beta1\addUser.aspx

?????文件???????2835??2010-01-11?21:21??beta1\addUser.aspx.cs

?????文件???????9319??2010-01-12?12:24??beta1\admin.aspx

?????文件???????2164??2010-01-12?11:27??beta1\admin.aspx.cs

?????文件???????2470??2005-07-08?06:54??beta1\admin_title.gif

?????文件???????2470??2005-07-08?06:54??beta1\App_Data\admin_title.gif

?????文件????????450??2010-01-12?11:00??beta1\dbduplicate.aspx

?????文件????????456??2010-01-12?11:00??beta1\dbduplicate.aspx.cs

?????文件????????446??2010-01-12?11:00??beta1\dbrestore.aspx

?????文件????????454??2010-01-12?11:00??beta1\dbrestore.aspx.cs

?????文件???????3447??2010-01-10?00:51??beta1\Default.aspx

?????文件???????3461??2010-01-07?21:40??beta1\Default.aspx.cs

?????文件???????3791??2010-01-12?10:20??beta1\editGoods.aspx

?????文件???????3138??2010-01-12?10:24??beta1\editGoods.aspx.cs

?????文件???????3957??2010-01-12?10:10??beta1\editGuest.aspx

?????文件???????3109??2010-01-12?10:11??beta1\editGuest.aspx.cs

?????文件???????2673??2010-01-12?09:57??beta1\editStorage.aspx

?????文件???????2284??2010-01-12?09:59??beta1\editStorage.aspx.cs

............此處省略27個文件信息