.net编程

开发平台：
C#

StructureSearch.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;
using com.etong.DBUtility;
public partial class SearchP_StructureSearch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //EtongFlyChouWFPrj project = new EtongFlyChouWFPrj();
            //project.PrjType = Convert.ToInt32(this.RadioButtonList1.SelectedValue.ToString());
            //project.PrjStatus = Convert.ToInt32(this.RadioButtonList2.SelectedValue.ToString());
            //DataView dv = project.PrjQuery();
            string sql = "select * from [tb_construct]";
            if (this.RadioButtonList1.SelectedValue.ToString() == "-1")
            {
                if (this.RadioButtonList2.SelectedValue.ToString() != "-1")
                {
                    sql = sql + " where [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
                }
            }
            else
            {
                if (this.RadioButtonList2.SelectedValue.ToString() == "-1")
                {
                    sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString();
                }
                else
                {
                    sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString() + " and [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
                }
            }
            DataView dv = SqlServer.GetDataView(sql);
            this.GridView1.DataSource = dv;
            this.GridView1.DataBind();
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        int currentpageindex;
        currentpageindex = Convert.ToInt32(e.NewPageIndex);
        if (currentpageindex == -2)
        {
            TextBox txtNewPageIndex;
            txtNewPageIndex = GridView1.BottomPagerRow.FindControl("LinkTextBoxNewPage") as TextBox;
            if (txtNewPageIndex != null)
            {
                try
                {
                    currentpageindex = Convert.ToInt32(txtNewPageIndex.Text) - 1;
                }
                catch
                {
                    currentpageindex = 0;
                }
            }
        }
        currentpageindex = currentpageindex < 0 ? 0 : currentpageindex;
        currentpageindex = currentpageindex >= GridView1.PageCount ? GridView1.PageCount - 1 : currentpageindex;
        GridView1.PageIndex = currentpageindex;
        string sql = "select * from [tb_construct]";
        if (this.RadioButtonList1.SelectedValue.ToString() == "-1")
        {
            if (this.RadioButtonList2.SelectedValue.ToString() != "-1")
            {
                sql = sql + " where [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
            }
        }
        else
        {
            if (this.RadioButtonList2.SelectedValue.ToString() == "-1")
            {
                sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString();
            }
            else
            {
                sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString() + " and [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
            }
        }
        DataView dv = SqlServer.GetDataView(sql);
        dv.Sort = (string)ViewState["sortFieldName"];
        this.GridView1.DataSource = dv;
        this.GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            int iRow;
            iRow = e.Row.DataItemIndex;
            iRow = iRow % 2;
            if (iRow > 0)
                e.Row.Attributes.Add("OnMouseOut", "this.style.backgroundColor='#f0f0f0';");
            else
                e.Row.Attributes.Add("OnMouseOut", "this.style.backgroundColor='White';");
            e.Row.Attributes.Add("OnMouseOver", "this.style.backgroundColor='#E8F2FA';");
            int state;
            int consort;
            if (e.Row.Cells[3].Text != null || e.Row.Cells[3].Text != "")
            {
                try
                {
                    state = Convert.ToInt32(e.Row.Cells[3].Text);
                }
                catch
                {
                    state = -1;
                }
                switch (state)
                {
                    case 1:
                        e.Row.Cells[3].Text = "正常";
                        break;
                    case 2:
                        e.Row.Cells[3].Text = "施工完成";
                        break;
                    case 3:
                        e.Row.Cells[3].Text = "作废";
                        break;
                    default:
                        e.Row.Cells[7].Text = "未知";
                        break;
                }
                try
                {
                    consort = Convert.ToInt32(e.Row.Cells[2].Text);
                }
                catch
                {
                    consort = -1;
                }
                switch (consort)
                {
                    case 1:
                        e.Row.Cells[2].Text = "生产类";
                        break;
                    case 2:
                        e.Row.Cells[2].Text = "科技类";
                        break;
                    case 3:
                        e.Row.Cells[2].Text = "营销类";
                        break;
                    default:
                        e.Row.Cells[2].Text = "未知";
                        break;
                }
            }
        }
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "save")
        {
            DataKey key = GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)];
            int conid = Convert.ToInt32(key.Value.ToString());
            //Session["projectid"] = projectid.ToString();
            //EtongFlyChouWFPrj project = new EtongFlyChouWFPrj();
            //bool returnvalue = etongzwf.UserPwdUpdata(userid);
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='../Workflow/ProjectImplement.aspx?ConID=" + conid + "';</script>");
            //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：密码重置成功,\n          密码为:111111');</script>");
        }
    }
    protected void search_Click(object sender, EventArgs e)
    {
        //EtongFlyChouWFPrj project = new EtongFlyChouWFPrj();
        //project.PrjType = Convert.ToInt32(this.RadioButtonList1.SelectedValue.ToString());
        //project.PrjStatus = Convert.ToInt32(this.RadioButtonList2.SelectedValue.ToString());
        //DataView dv = project.PrjQuery();
        //this.GridView1.DataSource = dv;
        //this.GridView1.DataBind();
        string sql = "select * from [tb_construct]";
        if (this.RadioButtonList1.SelectedValue.ToString() == "-1")
        {
            if (this.RadioButtonList2.SelectedValue.ToString() != "-1")
            {
                sql = sql + " where [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
            }
        }
        else
        {
            if (this.RadioButtonList2.SelectedValue.ToString() == "-1")
            {
                sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString();
            }
            else
            {
                sql = sql + " where [ConSort]=" + this.RadioButtonList1.SelectedValue.ToString() + " and [Status]=" + this.RadioButtonList2.SelectedValue.ToString();
            }
        }
        DataView dv = SqlServer.GetDataView(sql);
        this.GridView1.DataSource = dv;
        this.GridView1.DataBind();
    }    
}

						