private void BindData() { StringBuilder sbSql = new StringBuilder("Select logId,menuName,operationType,cuserId,operationContent,cdate FROM sys_client_syslog WHERE 1=1 "); if (txtUserName.Text.Trim() != "") { sbSql.Append(" AND cuserId='" + txtUserName.Text.Trim() + "' "); } if (cmbOperationType.SelectedIndex > 0) { sbSql.Append(" AND operationType='" + (cmbOperationType.SelectedItem as ComboBoxItem).Content.ToString() + "' "); } sbSql.Append(" AND DATE(cdate)>='" + Convert.ToDateTime(dtpStartDate.SelectedDate).ToString("yyyy-MM-dd") + "' AND DATE(cdate)<='" + Convert.ToDateTime(dtpEndDate.SelectedDate).ToString("yyyy-MM-dd") + "'"); try { IOperationContract operationService = ServiceFactory.GetWcfService <IOperationContract>(); lvlist.DataContext = operationService.GetClientLog(sbSql.ToString()); currentTable = operationService.GetClientLog(sbSql.ToString()); } catch (Exception) { return; } }