areadysendsms.aspx.cs

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

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 MsgManagement_AreadySendSMS : System.Web.UI.Page
{
    private DataAccess.TableAccessor.SMSInfo smsInfoAccessor = new DataAccess.TableAccessor.SMSInfo();
    private DataAccess.TableAccessor.SMSTypeInfo smstypeAccessor = null;
    private Security.OperationUserManagement operationUser = new Security.OperationUserManagement();
    private Security.RulesManagement rulesManagement;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            rulesManagement = new Security.RulesManagement();
            HttpCookie rulesCookie = Request.Cookies["RolesID"];
            int rulesID = 0;
            try
            { 
                //rulesID = int.Parse(rulesCookie.Value);
                rulesID = int.Parse(Session["RolesID"].ToString());
            }
            catch
            { }
            if (rulesManagement.ValidUserRules(rulesID, 34))
            {
                btnView.Visible = rulesManagement.ValidUserRules(rulesID, 36);
                btnTurnSend.Visible = rulesManagement.ValidUserRules(rulesID, 35);
                try
                {
                    int smsType = int.Parse(Request.QueryString[0].ToString());
                    FillGrid(smsType);
                    FillLbl(smsType);
                }
                catch
                {
                    return;
                }
            }
            else
            {
                Response.Redirect("../none.aspx");
            }
        }
    }
    #region fill grid
    private void FillGrid(int smsType)
    {
        gvResult.Columns[2].Visible = true;
        smsInfoAccessor = new DataAccess.TableAccessor.SMSInfo();
        DataTable dataTable = smsInfoAccessor.GetMostAreadySendSMS(smsType);
        dataTable.Columns.Add("SID", typeof(int));
        Cache["AreadySMS"] = dataTable;
        if (tbSendMan.Text =="" && dttext .Value == "")
        {
            DataView dv = dataTable.DefaultView;
            dv.Sort = "SMSID DESC";
            gvResult.DataSource = dv;
            gvResult.DataBind();
            for (int i = 0; i < this.gvResult.Rows.Count; i++)
            {
                if (this.gvResult.Rows[i].Cells[3].Text.Length > 10)
                    this.gvResult.Rows[i].Cells[3].Text = this.gvResult.Rows[i].Cells[3].Text.Substring(0, 10) + "......";
            }
            gvResult.Columns[2].Visible = false;
        }
        else
        {
            string queryStr = "(1=1)";
            if (tbSendMan.Text != "")
                queryStr += string.Format(" AND (UserName LIKE '%{0}%')", tbSendMan.Text);
            //if (dttext.Value != "")
            //    queryStr += string .Format( " AND (SMSDate LIKE '%{0}%')", Request .Form["dttext"]);

            DataTable table = (DataTable)Cache["AreadySMS"];
            DataView dv = table.DefaultView;

            dv.RowFilter = queryStr;
            dv.Sort = "SMSID DESC";
            gvResult.DataSource = dv;
            gvResult.DataBind();
            for (int i = 0; i < this.gvResult.Rows.Count; i++)
            {
                if (this.gvResult.Rows[i].Cells[3].Text.Length > 10)
                    this.gvResult.Rows[i].Cells[3].Text = this.gvResult.Rows[i].Cells[3].Text.Substring(0, 10) + "......";
            }
            gvResult.Columns[2].Visible = false;

        }
        for (int i = 0; i < this.gvResult.Rows.Count; i++)
        {
            gvResult.Rows[i].Cells[1].Text = (i + 1).ToString();
        }
    }
    //protected void gvResult_RowDataBound(object sender, GridViewRowEventArgs e)
    //{
    //    if (e.Row.RowType == DataControlRowType.DataRow)
    //    {
    //        e.Row.Cells[1].Text = (e.Row.DataItemIndex + 1).ToString();
    //    }
    //} 

    #endregion

    #region 按日期查询邦定
    private void Filldate()
    {
        gvResult.Columns[2].Visible = true;
        smsInfoAccessor = new DataAccess.TableAccessor.SMSInfo();
        DataTable dataTable = smsInfoAccessor.GetSendSMSDater(Request.Form["dttext"]);
        dataTable.Columns.Add("SID", typeof(int));
        Cache["AreadySMS"] = dataTable;
        DataView dv = dataTable.DefaultView;
        dv.Sort = "SMSID DESC";
        gvResult.DataSource = dv;
        gvResult.DataBind();
        for (int i = 0; i < this.gvResult.Rows.Count; i++)
        {
            if (this.gvResult.Rows[i].Cells[3].Text.Length > 10)
                this.gvResult.Rows[i].Cells[3].Text = this.gvResult.Rows[i].Cells[3].Text.Substring(0, 10) + "......";
        }
        gvResult.Columns[2].Visible = false;
        for (int i = 0; i < this.gvResult.Rows.Count; i++)
        {
            gvResult.Rows[i].Cells[1].Text = (i + 1).ToString();
            
        }
    }        
    #endregion

    #region 按日期，ID查询  
    private void FilldateandId(int smsType)
    {
        gvResult.Columns[2].Visible = true;
        smsInfoAccessor = new DataAccess.TableAccessor.SMSInfo();
        DataTable dataTable = smsInfoAccessor.GetSendSMSInfo(smsType, Request.Form["dttext"]);
        dataTable.Columns.Add("SID", typeof(int));
        Cache["AreadySMS"] = dataTable;
        DataView dv = dataTable.DefaultView;
        dv.Sort = "SMSID DESC";
        gvResult.DataSource = dv;
        gvResult.DataBind();
        for (int i = 0; i < this.gvResult.Rows.Count; i++)
        {
            if (this.gvResult.Rows[i].Cells[3].Text.Length > 10)
                this.gvResult.Rows[i].Cells[3].Text = this.gvResult.Rows[i].Cells[3].Text.Substring(0, 10) + "......";
        }
        gvResult.Columns[2].Visible = false;
        for (int i = 0; i < this.gvResult.Rows.Count; i++)
        {
            gvResult.Rows[i].Cells[1].Text = (i + 1).ToString();
        }
    }        
    #endregion

    #region check user choose
    private int CheckUserSingleChoose(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)
            {
                //string ss = gridView.Rows[i].Cells[0].Text;
                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 string CheckUserSingleChooseSMS(GridView gridView)
    {
        string checkValue = "";
        int checkCount = 0;
        for (int i = 0; i < gridView.Rows.Count; i++)
        {
            CheckBox ckb = (CheckBox)gridView.Rows[i].FindControl("chk");
            if (ckb.Checked)
            {
                checkValue = gridView.Rows[i].Cells[2].Text;
                checkCount++;
            }
        }
        if (checkCount > 1)
            return "";
        else if (checkCount == 0)
            return "";
        else
            return checkValue;
    }
    #endregion


    private void FillLbl(int smstype)
    {
        smstypeAccessor = new DataAccess.TableAccessor.SMSTypeInfo();
        DataSet ds = smstypeAccessor.GetSmsTypeName(smstype);

        string SmsTypename = ds.Tables["Table"].Rows[0][0].ToString();
        string lblstring = string.Format("位置: &nbsp; 短信管理 &nbsp;> &nbsp; {0}已发短信", SmsTypename);
        this.Label1.Text = lblstring;

    }


    protected void btnQuery_Click(object sender, EventArgs e)
    {
        if (this.tbSendMan.Text != "" || this.dttext .Value!= "")
        {
           int smsType = int.Parse(Request.QueryString[0].ToString());           
           if (this.dttext.Value != "" && this.tbSendMan.Text != "")
            {
                FilldateandId(smsType);
            }
            else if (this.dttext.Value != "")
            {
                Filldate();
            }
            else if (this.tbSendMan.Text != "")
            {
                FillGrid(smsType);
            }
        }
        else
        {
            Response.Write("<script language='javascript'>alert('发送人或日期不能为空！');</script>");
            string goUrl = string.Format("<script>windows.location.href='AreadySendSMS.aspx'</script>");
            Response.Write(goUrl);
        }
    }

    protected void btnTurnSend_Click1(object sender, EventArgs e)
    {
        String smsID = CheckUserSingleChooseSMS(gvResult);

        if (smsID == "")
        {
            Response.Write("<script language='javascript'>alert('转发功能只能对一行短信进行操作！');</script>");
            return;
        }
        smsInfoAccessor = new DataAccess.TableAccessor.SMSInfo();
        DataTable dt = smsInfoAccessor.GetSMSInfoByID(int.Parse(smsID));
        string smsMessage = dt.Rows[0][0].ToString();
        string goUrl = string.Format("<script>window.location.href = 'ZhuanfaSMS.aspx?SMSType={0}&operationID={1}&smsContent={2}&smsID=0'</script>",
            int.Parse(Request.QueryString[0].ToString()), 1, HttpUtility.UrlEncode(smsMessage));
        Response.Write(goUrl);
    }

    protected void btnView_Click1(object sender, EventArgs e)
    {
        string smsType = Request.QueryString[0].ToString();
        int smsID = 0;

        smsID = CheckUserSingleChoose(gvResult);

        if (smsID != 0)
        {
            string goUrl = string.Format("<script>window.location.href = 'ViewAndUpdateSMS.aspx?smsID={0}&operationID=1&smsFalg=2&smsType={1}'</script>", smsID, Request.QueryString[0].ToString());
            Response.Write(goUrl);
            
        }

        else
        {
            Response.Write("<script language='javascript'>alert('查看操作只能对一行短信进行操作！');</script>");
            //string strUrl = string.Format("<script>window.location.href = 'SubmisionMsg.aspx?smsType={0}'</script>",
            //    int.Parse(Request.QueryString[0].ToString()));
            //Response.Write(strUrl);
        }
    }

    protected void gvResult_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvResult.PageIndex = e.NewPageIndex;
        int smsType = int.Parse(Request.QueryString[0].ToString());
        FillGrid(smsType);
    }
    protected void gvResult_SelectedIndexChanged(object sender, EventArgs e)
    {
        // FillGrid(int.Parse(gvResult.SelectedValue()));

    }
   
}