public TakeMedicineTaskItem findItemById(int itemId)
{
TakeMedicineTaskItem item = null;
DataTable table = SqlHelper.ExecuteDataTable("select * from TakeMedicineTaskItem where Id=@id",
new MySqlParameter[] {
new MySqlParameter("@id", itemId)
});
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
item = new TakeMedicineTaskItem();
item.Id = (int)row[0];
item.Task = taskDAL.findTaskById((int)row[1]);
item.Medicine = medicineDAL.findMedicineById((int)row[2]);
item.Amount = (int)row[3];
item.State = (int)row[4];
}
return(item);
}
public Medicine findMedicineById(long id)
{
return(medicineDAL.findMedicineById(id));
}
