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(); }
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(); }
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(); }