moneyoperate.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 MoneyMsg_MoneyOperate : 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 MoneyMag,MoneyKind,WorkersList where ";
        string lei = this.DrDpSeaLei.SelectedValue.ToString().Trim();


        if (lei == "moneymagid")
        {
            sql += "MoneyMag.MoneyMagId";
        }
        if (lei == "dealworkder")
        {
            sql += "WorkersList.WorkerName";
        }

        if (lei == "moneychang")
        {
            sql += "MoneyMag.MoneyChang";
        }
        if (lei == "moneykind")
        {
            sql += "MoneyKind.MoneyKindS";
        }


        sql += " like '%" + this.TbSeaDetail.Text.ToString().Trim() + "%'and MoneyMag.MoneyKindId = MoneyKind.MoneyKindId  and MoneyMag.WorkersListId = WorkersList.WorkersListId";

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


        return sql;

    }

    void searchbind()
    {

        string SearchZt = getsql();
        if (SearchZt == "DefaultSearch")
        {
            string defaultsql = "SELECT * FROM MoneyMag,MoneyKind ,WorkersList where MoneyMag.MoneyKindId = MoneyKind.MoneyKindId  and MoneyMag.WorkersListId = WorkersList.WorkersListId";
            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 Button1_Click(object sender, EventArgs e)
    {

        string time = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

        string moneykind = this.DropDownList3.SelectedValue.ToString();
        string workerlistid = this.DropDownList4.SelectedValue.ToString();
        string jinorchu = this.DropDownList6.SelectedValue.ToString();
        string money = this.TextBox1.Text.ToString();
        string moreinfo = this.TextBox2.Text.ToString();
        string sql = "INSERT INTO [MoneyMag] ([WorkersListId],[JinChu], [MoneyChang], [MoneyKindId], [MoneyMagMoreInfo], [MoneyMagDate]) VALUES ('"+workerlistid+"','"+jinorchu+"', '"+money.Trim()+"','"+moneykind+"','"+moreinfo+"', '"+time+"')";
        string res = DataBindingtest.operate(sql);
        if (res == "ok")
        {
            Response.Write("<script>alert('添加成功！')</script>");

        }
        else
        {
            Response.Write(res);
        }

        this.searchbind();

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

        this.searchbind();
    }



    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

        DropDownList workerid = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("DropDownList1");
        DropDownList moneykind = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("DropDownList2");
        DropDownList jinorchu = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("DropDownList5");
        string time = System.DateTime.Now.ToString("yy-mm-dd,hh:mm:ss");
        string sql = "UPDATE [MoneyMag] SET [WorkersListId] = '" + workerid.SelectedValue.ToString().Trim() + "', [MoneyChang] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "', [MoneyKindId] = '" + moneykind.SelectedValue.ToString() + "',[JinChu]='" + jinorchu.SelectedValue.ToString().Trim() + "', [MoneyMagMoreInfo] = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "', [MoneyMagDate] = '" + time + "' WHERE [MoneyMagId] ='" + 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 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)
        {

            DataRowView dr = (DataRowView)e.Row.DataItem;



            int aa = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "JinChu"));
            Label lbshow = (Label)e.Row.FindControl("Label3");
      

            //HtmlImage deimonline = (HtmlImage)e.Row.FindControl("DeImgOnLine");

            //HtmlImage deimoffline = (HtmlImage)e.Row.FindControl("DeImgOffLine");


            if (aa == 1)
            {
                lbshow.Text = "出款";

             

                //deimonline.Visible = true;
            }

            else
            {
                lbshow.Text = "进款";

          

                //deimoffline.Visible = true;
            }

        }

    }*/

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sql = "delete from MoneyMag where MoneyMagId=" + 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();
    }
}