closeDrawers.InList< short >(2, 4)>>>
>>> if (startTime > defaultDate && endTime > defaultDate) >>> { >>> whereClause.AppendLine(" AND date_time between @StartTime and @EndTime"); >>> sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >>> sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime; >>> }>>>
>> if (startTime > defaultDate && endTime > defaultDate) >> { >> whereClause.AppendLine(" AND date_time between @StartTime and @EndTime"); >> sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >> sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime; >> } >>else if (startTime > defaultDate && endTime > defaultDate) >> { >> whereClause.AppendLine(" AND date_time between @StartTime and @EndTime"); >> sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >> sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime; >> } >> >>else if (startTime > defaultDate && endTime > defaultDate) >> { >> whereClause.AppendLine(" AND date_time between @StartTime and @EndTime"); >> sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >> sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime; >> } >>else >> { >> whereClause.AppendLine(" AND date_time between @StartTime and @EndTime"); >> sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime; >> sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime; >> } >> >>>>>