C# (CSharp) MicroBSC.Integration.CTL.Biz Biz_Ctl_Common.GetConnectLog Examples

Example #1

File: CTL_ConnectLog.aspx.cs Project: schifflee/bscgit

    private void SetResultGrid()
    {
        string sDeptID = string.Empty;
        string sUserNM = string.Empty;
        string sSDT    = string.Empty;
        string sEDT    = string.Empty;

        sDeptID = txtDeptID.Text + "%";
        sUserNM = txtUserNM.Text + "%";
        if (wdcSDate.Value != null)
        {
            sSDT = wdcSDate.Text.ToString().Replace("-", "");
            sEDT = Convert.ToDateTime(wdcEDate.Text).AddDays(1).ToShortDateString().Replace("-", "");
        }
        else
        {
            sSDT = "20000101";
            sEDT = "99990101";
            //sSDT = DateTime.Now.ToShortDateString().Replace("-", "");
            //sEDT = DateTime.Now.AddDays(1).ToShortDateString().Replace("-", "");
        }


        MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common Biz = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common();

        int iTotalRows = Biz.GetConnectLogCount(sDeptID, sUserNM, sSDT, sEDT);
        int iLastPage  = (int)Math.Ceiling((Double)iTotalRows / ugrdResultStatus.DisplayLayout.Pager.PageSize);
        int iFirstRow  = (ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex - 1) * ugrdResultStatus.DisplayLayout.Pager.PageSize;
        int iLastRow   = ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex * ugrdResultStatus.DisplayLayout.Pager.PageSize;


        ViewState.Add("CurrentPageIndex", ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex);
        ViewState.Add("PageCount", iLastPage);


        DataTable dt = Biz.GetConnectLog(sDeptID, sUserNM, sSDT, sEDT, iFirstRow + 1, iLastRow);

        ugrdResultStatus.Clear();
        ugrdResultStatus.DataSource = dt;
        ugrdResultStatus.DataBind();

        //DataRow[] row = dt.Select(" SEQ < 3 AND  ");

        //DataTypeUtility.FilterSortDataTable(dt,"");

        //DataTypeUtility.GetBoolean ("");



        lblRowCount.Text = iTotalRows.ToString();
    }