countsmspage.aspx.cs

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

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 DataAccess.TableAccessor;

public partial class MsgManagement_CountSMSPage : System.Web.UI.Page
{
    private SMSInfo smsInfoAccessor;
    private Security.RulesManagement rulesManagement;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            rulesManagement = new Security.RulesManagement();
            HttpCookie rolesCookie = Request.Cookies["RolesID"];
            int rolesID = 0;
            try
            {
                //rolesID = int.Parse(rolesCookie.Value); 
                rolesID = int.Parse(Session["RolesID"].ToString());

            }
            catch
            { Response.Close(); }
            if (rulesManagement.ValidUserRules(rolesID, 39))
            {

                FillGrid();

            }
            else
            {
                Response.Redirect("../none.aspx");
            }
        }
    }

    private void FillGrid()
    {
       
        smsInfoAccessor = new SMSInfo();
        int totalSMS = smsInfoAccessor.GetCount();
        int countSMSNumber = smsInfoAccessor.GetCountSMS();
        int countySMS = totalSMS - countSMSNumber;

        DataTable dt = smsInfoAccessor.CountSMS();
        dt.Columns.Add("ID", typeof(int));
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            dt.Rows[i]["ID"] = i + 1;
        }
        gridView.DataSource = dt;
        gridView.DataBind();
        gridView.Columns[0].Visible = false;
        for (int i = 0; i < this.gridView.Rows.Count; i++)
        {
           
            if (gridView.Rows[i].Cells[4].Text.Length > 10)
            {
                this.gridView.Rows[i].Cells[4].Text = this.gridView.Rows[i].Cells[4].Text.Substring(0, 10) + "......";
            }
            //countSMSNumber += int.Parse(gridView.Rows[i].Cells[4].Text);
            //countySMS += int.Parse(gridView.Rows[i].Cells[5].Text);
        }
        

        lblCountSMS.Text = countSMSNumber.ToString() + "条";
        lblCountySMS.Text = countySMS.ToString() + "条";
    }
    #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[1].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[1].Text;
    //            checkCount++;
    //        }
    //    }
    //    if (checkCount > 1)
    //        return "";
    //    else if (checkCount == 0)
    //        return "";
    //    else
    //        return checkValue;
    //}
    #endregion
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        if (tbBeginDay.Text.Trim() == "" || tbBeginMonth.Text.Trim() == "" || tbBeginYear.Text.Trim() == "" ||
            tbEndDay.Text.Trim() == "" || tbEndMonth.Text.Trim() == "" || tbEndYear.Text.Trim() == "")
        {
            Response.Write("<script language='javascript'>alert('请输入完整信息！');</script>");
            Response.Redirect("CountSMSPage.aspx");
        }
        //int countSMSNumber = 0;
        //int countySMS = 0;
        String beginDate = tbBeginYear.Text + "-" + tbBeginMonth.Text + "-" + tbBeginDay.Text;
        String endDate = tbEndYear.Text + "-" + tbEndMonth.Text + "-" + tbEndDay.Text;

       
        smsInfoAccessor = new SMSInfo();
        DataTable dt = smsInfoAccessor.CountSMSByDate(beginDate, endDate);
        gridView.DataSource = dt;

        gridView.DataBind();
        int totalSMS = smsInfoAccessor.GetCount();
        int countSMSNumber = smsInfoAccessor.GetCountSMS();
        int countySMS = totalSMS - countSMSNumber;
        for (int i = 0; i < this.gridView.Rows.Count; i++)
        {
            
            if (gridView.Rows[i].Cells[4].Text.Length > 10)
            {
                this.gridView.Rows[i].Cells[4].Text = this.gridView.Rows[i].Cells[4].Text.Substring(0, 10) + "......";
            }

        }
       
        lblCountSMS.Text = countSMSNumber.ToString() + "条";
        lblCountySMS.Text = countySMS.ToString() + "条";
    }
    
}