chaxun.aspx.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

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 System.Data.SqlClient;
using BLL;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

public partial class ChaXun : System.Web.UI.Page
{
    SQLHelper sqlHelper = new SQLHelper();
    //SqlDataReader dr;

    DataSet ds = new DataSet();
    string sqlCounts = "select RowCounts=Count(*) from GeRenXMV where MingCheng!=''";
    string sql = "select XMId,MingCheng,ShiJian,XMZhuanYe,HangYe,XingMing,FuZeRenId from GeRenXMV where MingCheng!=''";
    protected void Page_Load(object sender, EventArgs e)
    {

        if(!IsPostBack ){
           if(Session ["UserName"]==null){
               Response.Redirect("Default.aspx");
           }
           BindZhuanYeData();
           BindHangYeData(drlZhuanYe.SelectedValue);
           pager.RecordCount = GetRowCounts(sqlCounts );
           BindGeRenXM(sql);
        }
    }

    protected void BindZhuanYeData()
    {
        drlZhuanYe.DataSource = ZhuanYe.GetAllZhuanYe();
        drlZhuanYe.DataTextField = "MingCheng";
        drlZhuanYe.DataValueField = "ZhuanYeId";
        drlZhuanYe.DataBind();
        drlZhuanYe.Items.Add("不限");
        drlZhuanYe.Items.FindByText("不限").Value = "-1";
        drlZhuanYe.Items.FindByText("不限").Selected = true;
    }

    protected void BindHangYeData(string ZhuanYeId)
    {
        if (rblHangYe.Items.Count > 0)
        {
            rblHangYe.Items.Clear();

        }
        rblHangYe.DataSource = HangYe.GetHangYeByZhuanYe(ZhuanYeId);
        rblHangYe.DataTextField = "MingCheng";
        rblHangYe.DataBind();
        rblHangYe.Items.Add("不限");
    }

    protected void drlZhuanYe_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindHangYeData(drlZhuanYe.SelectedValue);
    }
    protected void dgGeRenXM_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )
        {
            
            e.Item.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='E8F4FF'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");


        }

    }


    protected void GetSearchString()
    {
          if (tbMingCheng .Text .Trim() !="")
            {
                sql = sql + " and MingCheng like '%" + tbMingCheng .Text .Trim () + "%'";
                sqlCounts = sqlCounts + " and MingCheng like '%" + tbMingCheng .Text .Trim () + "%'";
            }
            if (drlZhuanYe .SelectedItem !=null&&drlZhuanYe .SelectedItem .Text !="不限" )
            {
                sql = sql + " and XMZhuanYe like '%" + drlZhuanYe .SelectedItem .Text  + "%'";
                sqlCounts = sqlCounts + " and XMZhuanYe like '%" + drlZhuanYe .SelectedItem .Text  + "%'";
            }
            if (rblHangYe.SelectedItem !=null&&rblHangYe .SelectedItem .Text !="不限"&&drlZhuanYe .SelectedItem .Value !="不限")
            {
                sql = sql + " and HangYe like '%" + rblHangYe .SelectedItem .Text  + "%'";
                sqlCounts = sqlCounts + " and HangYe like '%" + rblHangYe .SelectedItem .Text  + "%'";
            }

          if(tbXingMing .Text .Trim ()!=""){
              sql = sql + " and XingMing like '%" + tbXingMing.Text.Trim() + "%'";
              sqlCounts = sqlCounts + " and XingMing like '%" + tbXingMing.Text.Trim() + "%'";
          }

    }


    protected int GetRowCounts(string sqlCounts)
    {
        int RowCounts = 0;
        if (ds.Tables["RowCounts"] != null)
        {
            ds.Tables.Remove("RowCounts");
        }
        sqlHelper.RunSQL(sqlCounts, ref ds, "RowCounts");
        RowCounts = Convert.ToInt32(ds.Tables["RowCounts"].Rows[0]["RowCounts"].ToString());
        return RowCounts;
    }

    

    protected void BindGeRenXM(string sql) {
        SqlCommand cmd = new SqlCommand();
        sqlHelper.Open();
        cmd.Connection = sqlHelper.myConnection;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = sql;
        SqlDataAdapter sa = new SqlDataAdapter(cmd);
        if (ds.Tables["GeRenXM"]!= null)
        {
            ds.Tables.Clear();
        }
        sa.Fill(ds, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "GeRenXM");
        dgGeRenXM.DataSource = ds.Tables["GeRenXM"];
        dgGeRenXM.DataBind();
        AddCustomText();
        

    }

    public void AddCustomText()
    {
        pager.CustomInfoText = "项目总数：<font color=\"Green\"><b>" + pager.RecordCount.ToString() + "</b></font>";
        pager.CustomInfoText += " 总页数：<font color=\"Green\"><b>" + pager.PageCount.ToString() + "</b></font>";
        pager.CustomInfoText += " 当前页：<font color=\"red\"><b>" + pager.CurrentPageIndex.ToString() + "</b></font>";

    }

    protected void ibtSearch_Click(object sender, ImageClickEventArgs e)
    {
        GetSearchString();
        pager.RecordCount = GetRowCounts(sqlCounts);
        BindGeRenXM(sql);
    }

    protected void pager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
    {
        pager.CurrentPageIndex = e.NewPageIndex;
        GetSearchString();
        pager.RecordCount = GetRowCounts(sqlCounts);
        BindGeRenXM(sql);
    }

}