userinfolist.aspx.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 466 行 · 第 1/2 页

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 UserManagement_UserInfoList : System.Web.UI.Page
{
    private DataAccess.TableAccessor.UserInfo userInfoAccessor = null;
    private Security.RulesManagement rulesManagement;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            #region security
            rulesManagement = new Security.RulesManagement();
            //HttpCookie rolesCookie = Request.Cookies["RolesID"];
            int rolesID = 0;
            int arID = int.Parse(Request.QueryString["arID"].ToString());
            int departID = int.Parse(Request.QueryString ["departID"].ToString());
            try
            {
                //rolesID = int.Parse(rolesCookie.Value);
                rolesID = int.Parse(Session["RolesID"].ToString());
            }
            catch
            {  }
            if (rulesManagement.ValidUserRules(rolesID, 9))
            {
                btnViewUserInfo.Visible = rulesManagement.ValidUserRules(rolesID, 12);
                btnAddUserInfo.Visible = rulesManagement.ValidUserRules(rolesID, 13);
                btnUpdate.Visible = rulesManagement.ValidUserRules(rolesID, 14);
                btnDelete.Visible = rulesManagement.ValidUserRules(rolesID, 15);
                btnMove.Visible = rulesManagement.ValidUserRules(rolesID, 16);
                btnAllData.Visible = rulesManagement.ValidUserRules(rolesID, 11);
                btnQuery.Visible = rulesManagement.ValidUserRules(rolesID, 10);
                Panel2.Visible = false;
                Panel1.Visible = false;
                
                FillComboBox();
                this.cbUserTeam.SelectedValue = arID.ToString();

                cbDept.Items.Clear();
                if (cbUserTeam.SelectedValue != "")
                {
                    int userTeamID = int.Parse(cbUserTeam.SelectedValue);
                    DataAccess.TableAccessor.UserConporation userCorporation = new DataAccess.TableAccessor.UserConporation();
                    cbDept.DataTextField = "CorporationName";
                    cbDept.DataValueField = "CorporationID";
                    cbDept.DataSource = userCorporation.GetMostCorporationByAreaID(userTeamID);
                    cbDept.DataBind();
                    cbDept.Items.Insert(0, "");
                }
                this.cbDept.SelectedValue = departID.ToString();

                if(arID !=0 && departID !=0)
                    FilterUserInfo();
            }
               
            else
            {
                Response.Redirect("../none.aspx");
            }
            #endregion
        }
    }

    private void UserInfoList()
    {
      //  int pageindex = int.Parse(Request.QueryString[0].ToString());

        GridView1.Columns[2].Visible = true;
        userInfoAccessor = new DataAccess.TableAccessor.UserInfo();
        DataTable dt = userInfoAccessor.GetUserInfo();
        dt.Columns.Add("UserDefineID", typeof(int));
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            dt.Rows[i]["UserDefineID"] = i + 1;
           
        }
        if (dt.Rows.Count == 0)
        {
            this.Panel1.Visible = false;
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
        GridView1.Columns[2].Visible = false;
        //if (pageindex != 0)
        //{
        //    GridView1.PageIndex = pageindex;
        //}
        this.Label1.Visible = false;
       
    }

    private void FillComboBox()
    {
        DataAccess.TableAccessor.CountyVillage countyVillage = new DataAccess.TableAccessor.CountyVillage();
        cbUserTeam.DataTextField = "AreaName";
        cbUserTeam.DataValueField = "AreaID";
        cbUserTeam.DataSource = countyVillage.GetAreaInfo();
        cbUserTeam.DataBind();
        cbUserTeam.Items.Insert(0, "");
        
        //for (int i = 0; i < 31; i++)
        //{
        //    cbDay1.Items.Add((i + 1).ToString());
        //}
        
        cbSex.Items.Insert(0,"");
        cbSex.Items.Insert(1,"男");
        cbSex.Items.Insert(2,"女");
    }

    private void FilterUserInfo()
    {
       
        this.Label1.Visible = false;
        GridView2.Columns[2].Visible = true;
        userInfoAccessor = new DataAccess.TableAccessor.UserInfo();
        DataTable filterTeble = userInfoAccessor.GetUserInfo();
        filterTeble.Columns.Add("UserDefineID", typeof(int));

        if (filterTeble.Rows.Count == 0)
            Panel2.Visible = false;
        else
            this.Panel2.Visible = true;

        string filterStr = " (1=1)";

        if (cbUserTeam.SelectedValue != "")
            filterStr += string.Format(" AND (AreaName = '{0}')", cbUserTeam.SelectedItem.Text);
        
        if (cbDept.SelectedValue != "")
            filterStr += string.Format(" AND (CorporationName = '{0}')", cbDept.SelectedItem.Text);
        
        if (cbSex.SelectedValue != "")
            filterStr += string.Format(" AND (Sex = '{0}')", cbSex.SelectedValue);
        
        if (tbName.Text != "")
            filterStr += string.Format(" AND (Name LIKE '%{0}%')", tbName.Text);
        
        if (tbDuty.Text != "")
            filterStr += string.Format(" AND (Duty LIKE '%{0}%')", tbDuty.Text);

        
        //if (tbYear1.Text != "" )
        //{
        //    string m = cbMonth1.SelectedValue.Length == 1 ? "0" + cbMonth1.SelectedValue : cbMonth1.SelectedValue;
        //    string d = cbDay1.SelectedValue.Length == 1 ? "0" + cbDay1.SelectedValue : cbDay1.SelectedValue;
        //    if (cbMonth1.SelectedValue == "" && cbDay1.SelectedValue == "")
        //    {
        //        filterStr += string.Format(" AND (Birthday LIKE '%{0}%')", tbYear1.Text);
        //    }
        //    else 
        //        filterStr += string.Format(" AND (Birthday LIKE '%{0}年{1}月{2}日%')", tbYear1.Text, m, d);
        //}

        DataView dv = filterTeble.DefaultView;
        dv.RowFilter = filterStr;
        dv.Sort = "UserLocation ASC";

        for (int i = 0; i < dv.Count; i++)
        {
            dv[i]["UserDefineID"] = i + 1;
            
        }


        Panel1.Visible = false;
        Panel2.Visible = true;
        GridView2.DataSource = dv;
        GridView2.DataBind();
        GridView2.Columns[2].Visible = false;

        if (GridView2.Rows.Count > 0 && cbUserTeam.SelectedValue != "" && cbDept.SelectedValue != ""
            && cbSex.SelectedValue == "" && tbName.Text == "" && tbDuty.Text == "" && tbYear1.Text == "")
        {
            panleMove.Visible = true;
            //this.btn.Visible = true;
        }

        else
        {
            panleMove.Visible = false;
            // this.btn.Visible = false;
        }
        if (GridView2.Rows.Count >= 0 && cbUserTeam.SelectedValue != "" && cbDept.SelectedValue != ""
           && cbSex.SelectedValue == "" && tbName.Text == "" && tbDuty.Text == "" && tbYear1.Text == "")
        {

            this.btn.Visible = true;
        }
        else
        {

            this.btn.Visible = false;
        }
    }

    private int CheckUserChoose(GridView gridView)
    {
        int checkValue = 0;
        int checkCount = 0;
        for (int i = 0; i < gridView.Rows.Count; i++)
        {
            CheckBox ckb = (CheckBox)gridView.Rows[i].FindControl("chk");
            if (ckb.Checked)
            {
                checkValue = int.Parse(gridView.Rows[i].Cells[2].Text);
                checkCount++;
            }
        }
        if (checkCount > 1)
            return 0;
        else if (checkCount == 0)
            return 0;
        else
            return checkValue;
    }
    private int CheckUserLocation(GridView gridView)
    {
        int checkValue = 0;
        int checkCount = 0;
        for (int i = 0; i < gridView.Rows.Count; i++)
        {
            CheckBox ckb = (CheckBox)gridView.Rows[i].FindControl("chk");