예제 #1
0
        public DataTable FilteredData(PatientLogModel db, DateTime start, DateTime end, List <string> users, List <string> hospitals, List <string> types, bool rounding)
        {
            //DbDataAdapter da = Db.CreateDataAdapter("SELECT * FROM [event] WHERE NOT (([eventend] <= @start) OR ([eventstart] >= @end))");
            //Db.AddParameterWithValue(da.SelectCommand, "start", start);
            //Db.AddParameterWithValue(da.SelectCommand, "end", end);

            DataTable dt = new DataTable();

            dt = DataCollections.getSchedule(db, start, end, users, hospitals, types, rounding);
            return(dt);
        }