示例#1
0
    protected void Sort(string sortExpression, params string[] sortExpr)
    {
        DataTable dataTable = Session["data_sms_credit"] as DataTable;

        if (dataTable != null)
        {
            if (Session["sortExpression_sms_credit"] == null)
            {
                Session["sortExpression_sms_credit"] = "";
            }

            DataView dataView = new DataView(dataTable);
            string[] sortData = Session["sortExpression_sms_credit"].ToString().Trim().Split(' ');

            string newSortExpr = (sortExpr.Length == 0) ?
                                 (sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" :
                                 sortExpr[0];

            dataView.Sort = sortExpression + " " + newSortExpr;
            Session["sortExpression_sms_credit"] = sortExpression + " " + newSortExpr;

            GrdSMSCredit.DataSource = dataView;
            GrdSMSCredit.DataBind();
        }
    }
示例#2
0
    protected void FillGrid()
    {
        DataTable dt = SMSCreditDataDB.GetDataTable();

        Session["data_sms_credit"] = dt;

        if (dt.Rows.Count > 0)
        {
            if (IsPostBack && Session["sortExpression_sms_credit"] != null && Session["sortExpression_sms_credit"].ToString().Length > 0)
            {
                DataView dataView = new DataView(dt);
                dataView.Sort           = Session["sortExpression_sms_credit"].ToString();
                GrdSMSCredit.DataSource = dataView;
            }
            else
            {
                GrdSMSCredit.DataSource = dt;
            }


            try
            {
                GrdSMSCredit.DataBind();
                GrdSMSCredit.PagerSettings.FirstPageText = "1";
                GrdSMSCredit.PagerSettings.LastPageText  = GrdSMSCredit.PageCount.ToString();
                GrdSMSCredit.DataBind();
            }
            catch (Exception ex)
            {
                SetErrorMessage(ex.ToString());
            }
        }
        else
        {
            dt.Rows.Add(dt.NewRow());
            GrdSMSCredit.DataSource = dt;
            GrdSMSCredit.DataBind();

            int TotalColumns = GrdSMSCredit.Rows[0].Cells.Count;
            GrdSMSCredit.Rows[0].Cells.Clear();
            GrdSMSCredit.Rows[0].Cells.Add(new TableCell());
            GrdSMSCredit.Rows[0].Cells[0].ColumnSpan = TotalColumns;
            GrdSMSCredit.Rows[0].Cells[0].Text       = "No Record Found";
        }

        if (hideFotter)
        {
            GrdSMSCredit.FooterRow.Visible = false;
        }


        decimal credit = SMSCreditDataDB.GetTotal();
        decimal used   = SMSHistoryDataDB.GetTotal();

        lblTotalCredit.Text    = credit.ToString("0.00");
        lblTotalUsed.Text      = used.ToString("0.00");
        lblTotalRemaining.Text = (credit - used).ToString("0.00");



        DateTime fromDate = IsValidDate(txtStartDate.Text) ? GetDate(txtStartDate.Text) : DateTime.MinValue;
        DateTime toDate   = IsValidDate(txtEndDate.Text)   ? GetDate(txtEndDate.Text).Add(new TimeSpan(23, 59, 59)) : DateTime.MinValue;

        decimal ptRemidners    = SMSHistoryDataDB.GetPTReminders(fromDate, toDate);
        decimal ptBirthdays    = SMSHistoryDataDB.GetPTBirthdays(fromDate, toDate);
        decimal staffRemidners = SMSHistoryDataDB.GetStaffReminders(fromDate, toDate);

        lblPTReminders.Text    = ptRemidners.ToString("0.00");
        lblPTBirthdays.Text    = ptBirthdays.ToString("0.00");
        lblStaffReminders.Text = staffRemidners.ToString("0.00");
    }