smssend.aspx.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 719 行 · 第 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 = new DataAccess.TableAccessor.UserInfo();
    private DataAccess.TableAccessor.SMSSendUserList smsSendUserList = new DataAccess.TableAccessor.SMSSendUserList();
    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 smsID = 0;
            int operationID = 0;
            //try
            {
                rolesID = int.Parse(rolesCookie.Value);
                smsID = int.Parse(Request.QueryString[0].ToString());
                operationID = int.Parse(Request.QueryString[1].ToString()); //1为提交　2为发送
                string SMSType = Request.QueryString[2].ToString();
                FillUserType();
                if (ddPerson.SelectedValue == "")
                {
                    this.lbworker.Visible = false;
                    this.lbcustomer.Visible = false;
                }
                else if (ddPerson.SelectedValue == "职工信息")
                {
                    this.lbworker.Visible = true;
                    this.lbcustomer.Visible = false;
                    FillComboBox();
                    Panel1.Visible = false;
                    if (operationID == 1)
                    {
                        this.word.Visible = false;
                        btnSend.Visible = false;
                        btnSubmit.Visible = true;
                    }
                    else if (operationID == 2)
                    {
                        this.word.Visible = true;
                        btnSend.Visible = true;
                        btnSubmit.Visible = false;
                        GetSendUserList();

                    }
                }
                else if (ddPerson.SelectedValue == "客户信息")
                {
                    this.lbworker.Visible = false;
                    this.lbcustomer.Visible = true;                   
                    FillType();
                    this.Panel2.Visible = false;
                }
               

            }
            #endregion
        }
    }

    #region 用户类型下框选择邦定
    protected void FillUserType()
    {
        ddPerson.Items.Add("");
        ddPerson.Items.Add("职工信息");
        ddPerson.Items.Add("客户信息");
    }
    #endregion

    #region 职工信息的操作

    #region 职工信息
    private void UserInfoList()
    {
        this.lbworker.Visible = true;
        this.Label1.Visible = false;
        GridView1.Columns[2].Visible = true;
        GridView1.Columns[8].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;
        }
        else
        {
            this.Panel1.Visible = true;
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
        GridView1.Columns[2].Visible = false;
        GridView1.Columns[8].Visible = false;
    }
    #endregion

    #region 得所选择职工信息
    private void GetSendUserList()
    {

        this.Label1.Visible = false;
        GridView1.Columns[2].Visible = true;
        GridView1.Columns[8].Visible = true;
        int smsID = int.Parse(Request.QueryString[0].ToString());
        DataTable dt = smsSendUserList.GetSendUserInfo(smsID);
        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;

        }
        else
        {
            this.Panel1.Visible = true;
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
        GridView1.Columns[2].Visible = false;
        GridView1.Columns[8].Visible = false;
        btnSend.Visible = true;
        btnSubmit.Visible = false;

        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("chk");
            ckb.Checked = true;
        }
    }
    #endregion 

    #region 职工下拉框邦定
    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.Add("");
        cbSex.Items.Add("男");
        cbSex.Items.Add("女");
    }

    protected void cbUserTeam_SelectedIndexChanged(object sender, EventArgs e)
    {
        int userTeamID = int.Parse(cbUserTeam.SelectedValue);
        DataAccess.TableAccessor.UserConporation userCorporation = new DataAccess.TableAccessor.UserConporation();
        cbDept.DataTextField = "CorporationName";
        cbDept.DataValueField = "CorporationName";
        cbDept.DataSource = userCorporation.GetMostCorporationByAreaID(userTeamID);
        cbDept.DataBind();
    }
    protected void cbUserTeam_SelectedIndexChanged1(object sender, EventArgs e)
    {
        if (cbUserTeam.SelectedValue != "")
        {
            DataAccess.TableAccessor.UserConporation userCorporation = new DataAccess.TableAccessor.UserConporation();
            cbDept.DataTextField = "CorporationName";
            cbDept.DataValueField = "CorporationName";
            cbDept.DataSource = userCorporation.GetMostCorporationByAreaID(int.Parse(cbUserTeam.SelectedValue));
            cbDept.DataBind();
            cbDept.Items.Insert(0, "");
        }
    }
    #endregion

    #region 职工信息查询
    private void FilterUserInfo()
    {
        this.Label1.Visible = false;
        GridView1.Columns[2].Visible = true;
        GridView1.Columns[8].Visible = true;
        userInfoAccessor = new DataAccess.TableAccessor.UserInfo();
        DataTable filterTeble = userInfoAccessor.GetUserInfo();
        filterTeble.Columns.Add("UserDefineID", typeof(int));
        for (int i = 0; i < filterTeble.Rows.Count; i++)
        {
            filterTeble.Rows[i]["UserDefineID"] = i + 1;
        }
        if (filterTeble.Rows.Count == 0)
        {
            this.Panel1.Visible = false;

        }
        else
        {
            this.Panel1.Visible = true;
        }

        string filterStr = " (1=1)";

        if (cbUserTeam.SelectedItem.Text != "")
        {
            filterStr += string.Format(" AND (AreaName = '{0}')", cbUserTeam.SelectedItem.Text);
        }
        if (cbDept.SelectedItem.Text != "")
        {
            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;

        GridView1.DataSource = dv;
        GridView1.DataBind();
        GridView1.Columns[2].Visible = false;
        GridView1.Columns[8].Visible = false;
    }

    // 查询
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        //int smsID = int.Parse(Request.QueryString[0].ToString());
        //try
        //{
        //    smsSendUserList.DeleteSendUserInfoBySMSID(smsID);
        //}
        //catch { }
        FilterUserInfo();
    }

    protected void btnAllworker_Click(object sender, EventArgs e)
    {
        UserInfoList();
    }
    #endregion

    #region 复选框选择职工信息
    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;
    }

    protected void btnSelectAll_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("chk");
            ckb.Checked = true;
        }
    }

    

    #endregion    

    #region 提交选择的职工用户
    protected void btnSubmit_Click(object sender, EventArgs e)
    {

        DataAccess.TableAccessor.SMSInfo smsInfo = new DataAccess.TableAccessor.SMSInfo();
        DataAccess.CookieAccessor cookieAccessor = new DataAccess.CookieAccessor();
        int smsID = int.Parse(Request.QueryString[0].ToString());
        int submitUserID = cookieAccessor.GetLoginUserOperationID();
        string SMSType = Request.QueryString[2].ToString();
        //int checkValue = 0;
        int checkCount = 0;
        int userId = 0;
        int cID = 0;
       // try
        {
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("chk");

                if (ckb.Checked)
                {
                    userId = int.Parse(GridView1.Rows[i].Cells[2].Text);
                    string typeN = GridView1.Rows[i].Cells[3].Text.ToString();
                    string mobile = GridView1.Rows[i].Cells[8].Text.ToString();
                    string name = GridView1.Rows[i].Cells[6].Text.ToString();
                    checkCount++;
                    smsSendUserList.AddSMSSendUserList(smsID, userId, cID, typeN, mobile, name);


                }
            }
            if (checkCount >= 1)
            {
                //9-7 
               // smsInfo.ChangeSMSFlag(smsID, 1, submitUserID);//MsgManagement/SMSSend.aspx?smsID=51&operationid=1

                Response.Write("<script language='javascript'>alert('提交短信成功！');</script>");///ReadySMS.aspx?SMSType=1&operationID=0
                String url = String.Format("<script>window.location.href ='SMSEdit.aspx?SMSTyp={0}&operationID={1}&smsID={2}'</script>", Request.QueryString[2].ToString(), Request.QueryString[1].ToString(), smsID);
                Response.Write(url);
            }
           // else
            {
               // this.label.Text = "<script language='javascript'>alert('请选择要发送的用户！');</script>";
            }
        }