Exemplo n.º 1
0
        protected void btnNormalEventQuery_Click(object sender, EventArgs e)
        {
            paras          = new EventParameters();
            paras.EventNo  = txtEventNo.Text.Trim();
            paras.TypeCode = txtTypeCode.Text.Trim();
            if (txtAEventTime.Text.Trim() == "")
            {
                paras.EventTimeA = txtAEventTime.Text.Trim();
            }
            else
            {
                paras.EventTimeA = txtAEventTime.Text.Trim() + " 00:00:00";
            }
            if (txtBEventTime.Text.Trim() == "")
            {
                paras.EventTimeB = txtAEventTime.Text.Trim();
            }
            else
            {
                paras.EventTimeB = txtBEventTime.Text.Trim() + " 23:59:59";
            }
            paras.StoreNo    = txtStoreNo.Text.Trim();
            paras.EventState = ddlEventState.SelectedValue;
            paras.User       = ddlUser.SelectedValue;

            DataSet ds        = DAL.EventLogsDAL.GetEventLogsTotal(paras.EventTimeA, paras.EventTimeB, paras.StoreNo, paras.TypeCode, paras.EventState, paras.EventNo, paras.User);
            int     rowsCount = ds.Tables[0].Rows.Count;

            if (rowsCount > pageSize)
            {
                totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
            }
            else
            {
                totalPage = 1;
            }
            GvEventDataBind(1);
        }
Exemplo n.º 2
0
        protected void btnNormalEventQuery_Click(object sender, EventArgs e)
        {
            paras = new EventParameters();
            paras.EventNo = txtEventNo.Text.Trim();
            paras.TypeCode = txtTypeCode.Text.Trim();
            if (txtAEventTime.Text.Trim() == "")
            { paras.EventTimeA = txtAEventTime.Text.Trim(); }
            else
            { paras.EventTimeA = txtAEventTime.Text.Trim() + " 00:00:00"; }
            if (txtBEventTime.Text.Trim() == "")
            { paras.EventTimeB = txtAEventTime.Text.Trim(); }
            else
            { paras.EventTimeB = txtBEventTime.Text.Trim() + " 23:59:59"; }
            paras.StoreNo = txtStoreNo.Text.Trim();
            paras.EventState = ddlEventState.SelectedValue;
            paras.User = ddlUser.SelectedValue;

            DataSet ds = DAL.EventLogsDAL.GetEventLogsTotal(paras.EventTimeA, paras.EventTimeB, paras.StoreNo, paras.TypeCode, paras.EventState, paras.EventNo, paras.User);
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > pageSize)
            {
                totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
            }
            else
            {
                totalPage = 1;
            }
            GvEventDataBind(1);
        }