public AddMedicinePage(MainWindow parent, Page last, AddMedicineTask task)
{
InitializeComponent();
parentWindow = parent;
lastPage = last;
this.task = task;
}
public bool create(AddMedicineTask task)
{
return(SqlHelper.ExecuteNonQuery("insert into AddMedicineTask(Name,Items_All,Items_Complete,Manager,Operator,State) values(@name,@items_all,@items_complete,@manager,@operator,@state)",
new MySqlParameter[] {
new MySqlParameter("@name", task.Name),
new MySqlParameter("@items_all", task.Items_All),
new MySqlParameter("@items_complete", task.Items_Complete),
new MySqlParameter("@manager", task.Manager.Id),
new MySqlParameter("@operator", task.Operator.Id),
new MySqlParameter("@state", task.State)
}) > 0);
}
public bool update(AddMedicineTask task)
{
return(SqlHelper.ExecuteNonQuery("update AddMedicineTask set Name=@name,Items_All=@items_all,Items_Complete=@items_complete,Manager=@manager,Operator=@operator,State=@state where Id=@id",
new MySqlParameter[] {
new MySqlParameter("@name", task.Name),
new MySqlParameter("@items_all", task.Items_All),
new MySqlParameter("@items_complete", task.Items_Complete),
new MySqlParameter("@manager", task.Manager.Id),
new MySqlParameter("@operator", task.Operator.Id),
new MySqlParameter("@state", task.State),
new MySqlParameter("@id", task.Id)
}) > 0);
}
public List <AddMedicineTask> list()
{
List <AddMedicineTask> list = new List <AddMedicineTask>();
DataTable table = SqlHelper.ExecuteDataTable("select * from AddMedicineTask");
foreach (DataRow row in table.Rows)
{
AddMedicineTask task = new AddMedicineTask();
task.Id = (int)row[0];
task.Name = (string)row[1];
task.Items_All = (int)row[2];
task.Items_Complete = (int)row[3];
task.Manager = userDAL.findUserById((int)row[4]);
task.Operator = userDAL.findUserById((int)row[5]);
task.State = (string)row[6];
list.Add(task);
}
return(list);
}
public AddMedicineTask findTaskById(int taskId)
{
AddMedicineTask task = null;
DataTable table = SqlHelper.ExecuteDataTable("select * from AddMedicineTask where Id=@id", new MySqlParameter[] {
new MySqlParameter("@id", taskId)
});
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
task = new AddMedicineTask();
task.Id = (int)row[0];
task.Name = (string)row[1];
task.Items_All = (int)row[2];
task.Items_Complete = (int)row[3];
task.Manager = userDAL.findUserById((int)row[4]);
task.Operator = userDAL.findUserById((int)row[5]);
task.State = (string)row[6];
}
return(task);
}
public bool update(AddMedicineTask task)
{
return(addMedicineTaskDAL.update(task));
}
public bool create(AddMedicineTask task)
{
return(addMedicineTaskDAL.create(task));
}
