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