cklist.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 CkMag_CkList : 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 (!IsPostBack)
        {



            this.searchbind();

        }
    }


    public void PagerButtonClick(Object sender, EventArgs e)
    {

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

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

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

    }

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

 

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


        if (lei == "ckid")
        {
            sql += "Cklist.CkId";
        }
        if (lei == "ckname")
        {
            sql += "Cklist.CkName";
        }
        if (lei == "manager")
        {
            sql += "WorkersList.WorkerName";
        }

        if (lei == "phone")
        {
            sql += "Cklist.CkPhone";
        }
        if (lei == "address")
        {
            sql += "Cklist.CkAddress";
        }
        sql += " like '%" + this.TbSeaDetail.Text.ToString().Trim()+ "%' and cklist.workerslistid=workerslist.workerslistid";

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


        return sql;

    }

    void searchbind()
    {

        string SearchZt = getsql();
        if (SearchZt == "DefaultSearch")
        {
            string defaultsql = "select * from Cklist,WorkersList where Cklist.WorkersListId=WorkersList.WorkersListId";
            this.GridView2.DataSource = DataBindingtest.DataBindsear(defaultsql);
            this.label1.Text = DataBindingtest.DataBindsear(defaultsql).Count.ToString();


            this.GridView2.DataBind();




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


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


       this.searchbind();

      this.Number();


    }




 

 

    protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView2.EditIndex = e.NewEditIndex;
      
        this.searchbind();
    }
    protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

        string sql = "delete from Cklist where CkId=" + GridView2.DataKeys[(int)e.RowIndex].Value.ToString();

  

        string res = DataBindingtest.operate(sql);

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

        }
        this.searchbind();

    }
    protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

        DropDownList Ckmag = (DropDownList)GridView2.Rows[GridView2.EditIndex].FindControl("DropDownList1");


        string sql = "update Cklist set Cklist.CkId='" + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "', Cklist.CkName='" + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',Cklist.WorkersListId='"+Ckmag.SelectedValue.ToString()+"',Cklist.CkPhone='" + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',Cklist.CkAddress='" + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',Cklist.CkMoreInfo='" + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "' where Cklist.CkId='" + GridView2.DataKeys[e.RowIndex].Value.ToString() + "'"; 

string res=DataBindingtest.operate(sql);

        if(res=="ok")

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

        }
  
        this.searchbind();
      

    }

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

        this.searchbind();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string Ckid = this.TextBox1.Text.ToString().Trim();
        string Ckname = this.TextBox2.Text.ToString().Trim();
        string CkMag = this.DropDownList2.SelectedValue.ToString();
        string Ckphone = this.TextBox4.Text.ToString().Trim();
        string Ckaddress = this.TextBox5.Text.ToString().Trim();
        string Ckmoreinfo = this.TextBox6.Text.ToString().Trim();
        string sql = "insert into [Cklist]([CkId],[CkName],[WorkersListId],[CkPhone],[CkAddress],[CkMoreInfo]) values ('"+Ckid+"','"+Ckname+"','"+CkMag+"','"+Ckphone+"','"+Ckaddress+"','"+Ckmoreinfo+"')";
    string res = DataBindingtest.operate(sql);
       if(res=="ok")
      {Response.Write("<script>alert('添加成功！')</script>");
            
       }
    else
      {
            Response.Write(res);
      }

      this.searchbind();
    }


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

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

        this.searchbind();
    }
}