/// <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));
}
