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;

public?partial?class?caipinlist?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{

????????????string?sql;
????????????sql?=?“select?*?from?caipin?where?1=1“;
????????????if?（Request.QueryString[“dj“]?!=?null）
????????????{
????????????????sql?=?sql?+?“?and?dianjia=‘“?+?Request.QueryString[“dj“].ToString（）.Trim（）?+?“‘“;
????????????}
????????????sql=sql+“?order?by?id?desc“;
????????????getdata（sql）;
????????}
????}

????private?void?getdata（string?sql）
????{
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{

????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????DataGrid1.DataSource?=?result.Tables[0];
????????????????DataGrid1.DataBind（）;
????????????????Label1.Text?=?“以上數據中共“?+?result.Tables[0].Rows.Count?+?“條“;
????????????}
????????????else
????????????{
????????????????DataGrid1.DataSource?=?null;
????????????????DataGrid1.DataBind（）;
????????????????Label1.Text?=?“暫無任何數據“;
????????????}
????????}
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????string?sql;
????????sql?=?“select?*?from?caipin?where?1=1“;
????????if?（bh.Text.ToString（）.Trim（）?!=?““）
????????{
????????????sql?=?sql?+?“?and?bianhao?like?‘%“?+?bh.Text.ToString（）.Trim（）?+?“%‘“;
????????}
????????if?（mc.Text.ToString（）.Trim（）?!=?““）
????????{
????????????sql?=?sql?+?“?and?mingcheng?like?‘%“?+?mc.Text.ToString（）.Trim（）?+?“%‘“;
????????}

????????sql?=?sql?+?“?order?by?id?desc“;

????????getdata（sql）;
????}

????protected?void?DataGrid1_PageIndexChanged（object?source?DataGridPageChangedEventArgs?e）
????{
????????string?sql;
????????sql?=?“select?*?from?caipin?order?by?id?desc“;
????????getdata（sql）;
????????DataGrid1.CurrentPageIndex?=?e.NewPageIndex;
????????DataGrid1.DataBind（）;
????}
}

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

?????文件????1048576??2011-04-05?16:27??database\netwangshangdingcanlwgx_Data.MDF

?????文件????1048576??2011-04-05?16:27??database\netwangshangdingcanlwgx_Log.LDF

?????目錄??????????0??2011-04-05?18:10??database

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

??????????????2097152????????????????????3