예제 #1
0
    private void BindLog()
    {
        string whereString = "1=1";

        string key = this.txtKeywords.Text;

        if (!string.IsNullOrEmpty(key))
        {
            //whereString += string.Format(" and (ActionAccount LIKE '%{0}%' or Comment LIKE '%{0}%')", key);
            whereString += string.Format(" and (ActionAccount LIKE '%{0}%')", key);
        }


        if (!string.IsNullOrEmpty(this.ddlActionType.SelectedValue))
        {
            whereString += " and ActionType='" + this.ddlActionType.SelectedValue + "'";
        }

        SysActionLogBus bus = new SysActionLogBus();

        this.NPager1.RecordCount = bus.RecordCount(whereString);

        var dt = bus.Query(this.NPager1.CurrentPage, this.NPager1.PageSize, whereString, "Date DESC");

        this.logs.DataSource = dt;
        this.logs.DataBind();
    }
예제 #2
0
    private void BindLog()
    {
        SysActionLogBus bus = new SysActionLogBus();
        var             dt  = bus.Query(1, 10, "ActionType='Login' AND ActionAccount='" + this.CurrentUserAccount + "'", "Date DESC");

        this.loglist.DataSource = dt;
        this.loglist.DataBind();
    }
예제 #3
0
    private void BindLog()
    {
        SysActionLogBus bus = new SysActionLogBus();
        var             dt  = bus.Query(1, 10, "ActionAccount='" + this.Account.Text + "'", "Date DESC");

        this.details.DataSource = dt;
        this.details.DataBind();
    }