public TakeMedicinePage(MainWindow parent, Page last, TakeMedicineTask task) { InitializeComponent(); parentWindow = parent; lastPage = last; this.task = task; }
public bool create(TakeMedicineTask task) { return(SqlHelper.ExecuteNonQuery("insert into TakeMedicineTask(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(TakeMedicineTask task) { return(SqlHelper.ExecuteNonQuery("update TakeMedicineTask 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 <TakeMedicineTask> list() { List <TakeMedicineTask> list = new List <TakeMedicineTask>(); DataTable table = SqlHelper.ExecuteDataTable("select * from TakeMedicineTask"); foreach (DataRow row in table.Rows) { TakeMedicineTask task = new TakeMedicineTask(); 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 TakeMedicineTask findTaskById(int taskId) { TakeMedicineTask task = null; DataTable table = SqlHelper.ExecuteDataTable("select * from TakeMedicineTask where Id=@id", new MySqlParameter[] { new MySqlParameter("@id", taskId) }); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; task = new TakeMedicineTask(); 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(TakeMedicineTask task) { return(takeMedicineTaskDAL.update(task)); }
public bool create(TakeMedicineTask task) { return(takeMedicineTaskDAL.create(task)); }