eachproducemag.aspx.cs

课程设计了

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 ProduceMag_EachProduceMag : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["flag"] == null)
        {
            Response.Write("<script language=JavaScript>{window.alert('网络超时或你还未登录，请重新登陆!');window.location.href='admin_login.aspx';}</script>");
        }// 在此处放置用户代码以初始化页面
        if(!Page.IsPostBack)
            
     
        {



            this.searchbind();

        }
    }


    public void PagerButtonClick(Object sender, EventArgs e)
    {

        String CommandArgument = ((LinkButton)sender).CommandArgument;

        switch (CommandArgument)
        {
            case ("Next"):
                if (GridView1.PageIndex < (GridView1.PageCount - 1))
                    GridView1.PageIndex++;
                break;
            case ("前一项"):
                if (GridView1.PageIndex > 0)
                    GridView1.PageIndex--;
                break;
            case ("最后一项"):
                GridView1.PageIndex = (GridView1.PageCount - 1);
                break;
            case ("X"):
                GridView1.PageIndex = (Convert.ToInt32(No.Text) - 1);
                break;
            default:

                GridView1.PageIndex = Convert.ToInt32(CommandArgument);
                break;
        }
        this.searchbind();

    }

    void Number()
    {
        lblCurrentIndex.Text = (GridView1.PageIndex + 1).ToString();
        lblPageCount.Text = GridView1.PageCount.ToString();
    }

 

    string getsql()
    {
        string sql = "select * from Produces,ProducesKind where ";
        string lei = this.DrDpSeaLei.SelectedValue.ToString().Trim();


        if (lei == "Producesid")
        {
            sql += "Produces.ProducesId";
        }
		  if (lei == "Produceskind")
        {
            sql += "Produceskind.Produceskinds";
        }
		
        if (lei == "Producesname")
        {
            sql += "Produces.ProducesName";
        }
        if (lei == "ProducesJinJia")
        {
            sql += "Produces.ProducesJinJia";
        }

        if (lei == "Discount")
        {
            sql += "Produces.Discount";
        }
        if (lei == "ProducesPrices")
        {
            sql += "Produces.ProducesPrices";
		}
           if (lei == "ProducesCompany")
        {
            sql += "Produces.ProducesCompany";
        }

        sql += " like '%" + this.TbSeaDetail.Text.ToString().Trim() + "%'and Produces.ProducesKindId=ProducesKind.ProducesKindId";

        if (lei == "all")
        {
            sql = "DefaultSearch";
        }


        return sql;

    }

    void searchbind()
    {

        string SearchZt = getsql();
        if (SearchZt == "DefaultSearch")
        {
            string defaultsql = "select * from Produces,ProducesKind  where Produces.ProducesKindId=ProducesKind.ProducesKindId order by Produces.ProducesKindId desc";
            this.GridView1.DataSource = DataBindingtest.DataBindsear(defaultsql);
            this.label1.Text = DataBindingtest.DataBindsear(defaultsql).Count.ToString();
      this.GridView1.DataBind();

        }
        else
        {
            this.GridView1.DataSource = DataBindingtest.DataBindsear(SearchZt);
            this.label1.Text = DataBindingtest.DataBindsear(SearchZt).Count.ToString();
            this.GridView1.DataBind();
        }
        this.Number();
    }


    protected void BtSearch_Click(object sender, System.EventArgs e)
    {
       this.GridView1.PageIndex = 0;


        this.searchbind();

        this.Number();


    }

 




 

 

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
      
        this.searchbind();
    }


    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

        string sql = "delete from Produces where ProducesId=" + GridView1.DataKeys[(int)e.RowIndex].Value.ToString();

  

        string res = DataBindingtest.operate(sql);

        if (res == "ok")
        {
            Response.Write("<script>alert('删除成功！')</script>");
            GridView1.EditIndex = -1;
        }
        else
        {
            Response.Write(res);

        }
        this.searchbind();

    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
     
        DropDownList produceskind = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("DropDownList1");


        string sql = "UPDATE [Produces] SET [ProducesId]='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',[ProducesKindId] ='" + produceskind.SelectedValue.ToString() + "', [ProducesName] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "', [ProducesGG] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "', [ProducesJinJia] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "', [Discount] ='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "', [ProducesPrices] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "', [ProducesCompany] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim() + "', [ProducesMoreInfo] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim() + "' WHERE [ProducesId] = '" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; 

    string res=DataBindingtest.operate(sql);

        if(res=="ok")

        {
            Response.Write("<script>alert('编辑成功！')</script>");
              GridView1.EditIndex=-1; 
        }
        else
        {
            Response.Write(res);

        }
  
        this.searchbind();

    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;

        this.searchbind();
    }



    protected void Button1_Click(object sender, EventArgs e)
    {
        string Producesid = this.TextBox1.Text.ToString().Trim();
        string Producesname = this.TextBox2.Text.ToString().Trim();
        string Producesgg = this.TextBox3.Text.ToString().Trim();
        string Producesjinjia = this.TextBox4.Text.ToString().Trim();
        string Producesdiscount = this.TextBox5.Text.ToString().Trim();
        string Producesprice = this.TextBox6.Text.ToString().Trim();
        string Producescompany = this.TextBox7.Text.ToString().Trim();
        string Produceskindid = this.DropDownList2.SelectedValue.ToString();
        string Producesmoreinfo=this.TextBox8.Text.ToString().Trim();



        string sql = "insert into [Produces]([ProducesId],[ProducesKindId],[ProducesName],[ProducesGG],[ProducesJinJia],[Discount],[ProducesPrices],[ProducesCompany],[ProducesMoreInfo]) values ('" + Producesid + "','"+Produceskindid+"','"+Producesname+"','" +Producesgg+ "','" +Producesjinjia+ "','" +Producesdiscount + "','" +Producesprice + "','" + Producescompany + "','"+Producesmoreinfo+"')";
   string res = DataBindingtest.operate(sql);
       if(res=="ok")
      {Response.Write("<script>alert('添加成功！')</script>");
            
       }
    else
      {
            Response.Write(res);
      }

      this.searchbind();

    }


    protected void GridView1_PageIndexChanged(object sender, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {

        this.GridView1.PageIndex = 0;
 
        this.GridView1.PageIndex = e.NewPageIndex;

        this.searchbind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
          if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string id = Convert.ToString(GridView1.DataKeys[e.Row.RowIndex].Value.ToString());
       
            Label lbshow = (Label)e.Row.FindControl("ProducesNum");
            string stillck =Convert.ToString( DataBindingtest.stillkc(id));
            lbshow.Text = stillck;
        
        }


    }
}