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?Insert?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“nickname“]?!=?null）
????????{
????????????lblWelcome.Text?=?“歡迎“?+?Session[“nickname“].ToString（）?+?“進入后臺“;
????????}
????????else
????????{
????????????Response.Redirect（“Login.aspx“）;
????????}
????}
????protected?void?btnAdd_Click（object?sender?EventArgs?e）
????{
????????if?（（txtDrugName.Text?==?““）?||?（txtDrugID.Text?==?““）?||?（txtTotal.Text?==?““））
????????{
????????????Response.Write（“ript>alert（‘藥品信息不能為空‘）;location=‘Insert.aspx‘;ript>“）;
????????}
????????else
????????{
????????????string?strDrugName?=?txtDrugName.Text;
????????????string?strDrugID?=?txtDrugID.Text;
????????????int?iTotal?=?Convert.ToInt32（txtTotal.Text）;
????????????DB?db?=?new?DB（）;
????????????SqlConnection?con?=?db.CreateCon（）;
????????????SqlCommand?cmd?=?new?SqlCommand（““?con）;
????????????try
????????????{
????????????????con.Open（）;
????????????????cmd.CommandText?=?“insert?into?DrugInfo?values（@DrugName@DrugID@Total）“;
????????????????cmd.Parameters.AddWithValue（“@DrugName“?strDrugName）;
????????????????cmd.Parameters.AddWithValue（“@DrugID“?strDrugID）;
????????????????cmd.Parameters.AddWithValue（“@Total“?iTotal）;
????????????????int?iCount?=?cmd.ExecuteNonQuery（）;
????????????????if?（iCount?>?0）
????????????????{
????????????????????Response.Write（“ript>alert（‘新藥品入庫成功‘）;location=‘Insert.aspx‘;ript>“）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????Response.Write（ex.Message）;
????????????}
????????????finally
????????????{
????????????????cmd?=?null;
????????????????con.Close（）;
????????????????con?=?null;
????????????}
????????}
????}
}

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

?????文件????????684??2009-12-23?20:22??藥店管理系統\App_Code\DB.cs

?????文件????1048576??2009-12-25?18:37??藥店管理系統\App_Data\DrugStore_Data.MDF

?????文件????1048576??2009-12-25?18:37??藥店管理系統\App_Data\DrugStore_Log.LDF

?????文件???????3659??2009-12-24?10:28??藥店管理系統\Insert.aspx

?????文件???????2227??2009-12-24?12:48??藥店管理系統\Insert.aspx.cs

?????文件???????2731??2009-12-23?21:17??藥店管理系統\Login.aspx

?????文件???????1536??2009-12-23?20:36??藥店管理系統\Login.aspx.cs

?????文件????????712??2009-12-24?20:17??藥店管理系統\MainNav.ascx

?????文件????????459??2009-12-23?20:45??藥店管理系統\MainNav.ascx.cs

?????文件???????2323??2009-12-23?21:15??藥店管理系統\Manage.aspx

?????文件????????718??2009-12-23?20:44??藥店管理系統\Manage.aspx.cs

?????文件???????4289??2009-12-24?20:19??藥店管理系統\Select.aspx

?????文件???????3719??2009-12-24?11:55??藥店管理系統\Select.aspx.cs

?????文件???????3984??2009-12-25?11:50??藥店管理系統\Sell.aspx

?????文件???????5428??2009-12-25?15:25??藥店管理系統\Sell.aspx.cs

?????文件???????3196??2009-12-25?15:38??藥店管理系統\SellShow.aspx

?????文件???????1106??2009-12-24?20:17??藥店管理系統\SellShow.aspx.cs

?????文件???????3456??2009-12-25?15:44??藥店管理系統\ShowInfo.aspx

?????文件???????1429??2009-12-24?11:32??藥店管理系統\ShowInfo.aspx.cs

?????文件???????8631??2009-12-23?19:40??藥店管理系統\web.config

?????目錄??????????0??2009-12-23?20:22??藥店管理系統\App_Code

?????目錄??????????0??2009-12-25?18:37??藥店管理系統\App_Data

?????目錄??????????0??2009-12-26?22:53??藥店管理系統

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

??????????????2147439????????????????????23