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