/// <summary>
/// コンストラクタ
/// </summary>
public WorkContent()
{
this.Id = 0;
this.UserId = 0;
this.Content = "";
this.Weather = "";
this.PesticideContents = new ObservableCollection <PesticideContent>();
DateTime nowDate = DateTime.Now;
this.StartWorkTime = new DateTime(nowDate.Year, nowDate.Month, nowDate.Day, 6, 0, 0);
this.EndWorkTime = new DateTime(nowDate.Year, nowDate.Month, nowDate.Day, 6, 0, 0);
this.WorkerMaster = new WorkerMaster();
}
/// <summary>
/// クローン用コンストラクタ
/// </summary>
public WorkContent(WorkContent workContent)
{
this.Id = workContent.Id;
this.UserId = workContent.UserId;
this.Content = workContent.Content;
this.Weather = workContent.Weather;
this.PesticideContents = new ObservableCollection <PesticideContent>();
foreach (PesticideContent pestcide in workContent.PesticideContents)
{
this.PesticideContents.Add(new PesticideContent(pestcide));
}
this.StartWorkTime = workContent.StartWorkTime;
this.EndWorkTime = workContent.EndWorkTime;
this.WorkerMaster = workContent.WorkerMaster;
}
/// <summary>
/// 農薬マスタリスト取得
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <WorkerMaster> GetWorkerMasters(int id = -1)
{
List <WorkerMaster> result = new List <WorkerMaster>();
try
{
if (-1 != id)
{
PrepareCommandParameter("SELECT * FROM M_Worker WHERE id = ?", new List <object> {
id
});
}
else
{
command.CommandText = "SELECT * FROM M_Worker";
}
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
WorkerMaster tmp = new WorkerMaster()
{
Id = int.Parse(reader["id"].ToString()),
Name = reader["name"].ToString(),
};
result.Add(tmp);
}
}
}
catch (Exception ex)
{
throw new SQLiteException(ex.ToString());
}
return(result);
}
/// <summary>
/// クローン用コンストラクタ
/// </summary>
/// <param name="workerMaster"></param>
public WorkerMaster(WorkerMaster workerMaster)
{
this.Id = workerMaster.Id;
this.Name = workerMaster.Name;
}
