public List <weightModel> search(weightModel data) { string query = "SELECT top 20 * from weight where 1=1 "; if (data.ownerUserId > 0) { query += " and owner_user_id = " + data.ownerUserId; } if (data.driverUserId > 0) { query += " and driver_user_id = " + data.driverUserId; } if (data.carId > 0) { query += " and car_id = " + data.carId; } if (data.itemTypeId > 0) { query += " and item_type = " + data.itemTypeId; } if (data.date != null) { query += " and date >= " + data.date + " and date =<" + data.time; } if (BaseData.Connection.State == System.Data.ConnectionState.Closed) { BaseData.Connection.Open(); } List <weightModel> result = new List <weightModel>(); SqlCeCommand command = new SqlCeCommand(query, BaseData.Connection); try { var reader = command.ExecuteReader(); while (reader.Read()) { result.Add(map(reader)); } } catch { } BaseData.Connection.Close(); return(result); }
private weightModel map(SqlCeDataReader reader) { weightModel result = new weightModel(); try { result.id = (int)reader["id"]; result.ownerUserId = (int)reader["owner_user_id"]; result.driverUserId = (int)reader["driver_user_id"]; result.opperatorUserId = (int)reader["opperator_user_id"]; result.itemTypeId = (int)reader["item_type"]; result.carId = (int)reader["car_id"]; result.date = reader["insert_date"].ToString(); result.time = reader["insert_time"].ToString(); result.weight = (double)reader["weight"]; result.weight2 = (double)reader["weight2"]; result.pestPercent = (double)reader["pest_percent"]; result.positiveDecreas = (double)reader["positive_decrease"]; result.negativeDecreas = (double)reader["negative_decrease"]; result.description = reader["description"].ToString(); result.serial = reader["serial"].ToString(); } catch { } return(result); }