/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Tasks model) { int rowsAffected; IDataParameter[] parameters = { new SqlParameter("@TaskId", SqlDbType.BigInt, 8), new SqlParameter("@Status", SqlDbType.TinyInt, 1), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@CmdType", SqlDbType.SmallInt, 2), new SqlParameter("@CmdByte", SqlDbType.Int, 4), new SqlParameter("@DevId", SqlDbType.Int, 4), new SqlParameter("@Data", SqlDbType.Binary, 512), new SqlParameter("@Length", SqlDbType.Int, 4) }; parameters[0].Value = model.TaskId; parameters[1].Value = model.Status; parameters[2].Value = model.SendTime; parameters[3].Value = model.CmdType; parameters[4].Value = model.CmdByte; parameters[5].Value = model.DevId; parameters[6].Value = model.Data; parameters[7].Value = model.Length; DbHelperSql.RunProcedure("T_Tasks_Update", parameters, out rowsAffected); return(rowsAffected > 0); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(Model.Tasks model) { int rowsAffected; IDataParameter[] parameters = { new SqlParameter("@TaskId", SqlDbType.BigInt, 8), new SqlParameter("@Status", SqlDbType.TinyInt, 1), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@CmdType", SqlDbType.Int, 4), new SqlParameter("@CmdByte", SqlDbType.Int, 4), new SqlParameter("@DevId", SqlDbType.Int, 4), new SqlParameter("@Data", SqlDbType.Binary, 512), new SqlParameter("@Length", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.Status; parameters[2].Value = model.SendTime; parameters[3].Value = model.CmdType; parameters[4].Value = model.CmdByte; parameters[5].Value = model.DevId; parameters[6].Value = model.Data; parameters[7].Value = model.Length; DbHelperSql.RunProcedure("T_Tasks_ADD", parameters, out rowsAffected); return((long)parameters[0].Value); }
/** * Fonction principale du programme qui permet la création d'une liste de tâches **/ public MainModel() { ListTasks = new ObservableCollection <Model.Tasks>(); NewTask = new Model.Tasks() { date = DateTime.Today }; }
/** * Fonction qui crée une nouvelle tâche avec les paramètre rentré dans le formulaire * **/ public void addSomething(object parameter) { if (NewTask.title == null || NewTask.content == null) { dialogErrorAdd(); } else { ListTasks.Add(NewTask); NotifyPropertyChanged("ListTasks"); NewTask = new Model.Tasks(); } }
/** * Fonction qui permet d'éditer une tâche de la liste **/ public void EditTask(object parameter) { if (NewTask.title == "" || NewTask.title == null || NewTask.content == "" || NewTask.content == null) { dialogErrorAdd(); } else { ListTasks.Add(NewTask); ListTasks.Remove(SelectedModel); NotifyPropertyChanged("ListTasks"); NewTask = new Model.Tasks(); NewTaskTitle = null; NewTaskContent = null; NewTaskDate = DateTime.Today; } }
public MainModel() { //Création de tâche en dur dans l'application ListTasks = new ObservableCollection <Model.Tasks>() { new Model.Tasks { title = "Finir le Todolist", content = "Permettre la suppression des tasks, mieux gerer le datepicker", date = DateTime.Today, urgence = true }, new Model.Tasks { title = "Epicture", content = "Faire tout le projet epicture", date = DateTime.Today, urgence = false }, }; NewTask = new Model.Tasks() { date = DateTime.Today, statut = 1 }; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Tasks DataRowToModel(DataRow row) { var model = new Model.Tasks(); if (row != null) { if (row["TaskId"] != null && row["TaskId"].ToString() != "") { model.TaskId = long.Parse(row["TaskId"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["SendTime"] != null && row["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(row["SendTime"].ToString()); } if (row["CmdType"] != null && row["CmdType"].ToString() != "") { model.CmdType = int.Parse(row["CmdType"].ToString()); } if (row["CmdByte"] != null && row["CmdByte"].ToString() != "") { model.CmdByte = int.Parse(row["CmdByte"].ToString()); } if (row["DevId"] != null && row["DevId"].ToString() != "") { model.DevId = int.Parse(row["DevId"].ToString()); } if (row["Data"] != null && row["Data"].ToString() != "") { model.Data = (byte[])row["Data"]; } if (row["Length"] != null && row["Length"].ToString() != "") { model.Length = int.Parse(row["Length"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Tasks model) { return(_dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(Model.Tasks model) { return(_dal.Add(model)); }