public bool create(TakeMedicineTaskItem item)
{
return(SqlHelper.ExecuteNonQuery("insert into TakeMedicineTaskItem(Task,Medicine,Amount,State) values(@task,@medicine,@amount,@state)", new
MySqlParameter[] {
new MySqlParameter("@task", item.Task.Id),
new MySqlParameter("@medicine", item.Medicine.Id),
new MySqlParameter("@amount", item.Amount),
new MySqlParameter("@state", item.State)
}) > 0);
}
public bool update(TakeMedicineTaskItem item)
{
return(SqlHelper.ExecuteNonQuery("update TakeMedicineTaskItem set Task=@task,Medicine=@medicine,Amount=@amount,State=@state where Id=@id", new
MySqlParameter[] {
new MySqlParameter("@task", item.Task.Id),
new MySqlParameter("@medicine", item.Medicine.Id),
new MySqlParameter("@amount", item.Amount),
new MySqlParameter("@state", item.State),
new MySqlParameter("@id", item.Id)
}) > 0);
}
public List <TakeMedicineTaskItem> list()
{
List <TakeMedicineTaskItem> itemList = null;
DataTable table = SqlHelper.ExecuteDataTable("select * from TakeMedicineTaskItem");
foreach (DataRow row in table.Rows)
{
TakeMedicineTaskItem 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];
itemList.Add(item);
}
return(itemList);
}
public List <TakeMedicineTaskItem> findListByTakeId(int taskId)
{
List <TakeMedicineTaskItem> itemList = new List <TakeMedicineTaskItem>();
DataTable table = SqlHelper.ExecuteDataTable("select * from TakeMedicineTaskItem where Task=@task",
new MySqlParameter[] {
new MySqlParameter("@task", taskId)
});
foreach (DataRow row in table.Rows)
{
TakeMedicineTaskItem 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];
itemList.Add(item);
}
return(itemList);
}
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);
}
