/// <summary>
/// クローン用コンストラクタ
/// </summary>
/// <param name="pesticideMaster"></param>
public PesticideMaster(PesticideMaster pesticideMaster)
{
this.Id = pesticideMaster.Id;
this.Name = pesticideMaster.Name;
this.Unit = pesticideMaster.Unit;
this.URI = pesticideMaster.URI;
this.Description = pesticideMaster.Description;
}
/// <summary>
/// 農薬マスタリスト取得
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <PesticideMaster> GetPesticideMasters(int id = -1)
{
List <PesticideMaster> result = new List <PesticideMaster>();
try
{
if (-1 != id)
{
PrepareCommandParameter("SELECT * FROM M_Pesticide WHERE id = ?", new List <object> {
id
});
}
else
{
command.CommandText = "SELECT * FROM M_Pesticide";
}
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
PesticideMaster tmp = new PesticideMaster()
{
Id = int.Parse(reader["id"].ToString()),
Name = reader["name"].ToString(),
Unit = reader["unit"].ToString(),
URI = reader["uri"].ToString(),
Description = reader["description"].ToString()
};
result.Add(tmp);
}
}
}
catch (Exception ex)
{
throw new SQLiteException(ex.ToString());
}
return(result);
}