private void DeleteAction(ProjectItem item)
{
string warningMsg = Application.Current.TryFindResource("dialogDeleteProject").ToString();
if (dialogDS.ShowDialog(warningMsg,"Delete"))
{
mainDS.DeleteProject(item);
mainDS.DeleteConditionsByProjectId(item.ProjectId);
LoadProjects();
}
}
private void LoadConditionsAction(ProjectItem item)
{
if (item!=null)
{
var data = mainDataService.GetCalculationsByProjectId(item.ProjectId);
//将数据插入到TempCondition里
mainDataService.AddConditions(data);
LoadConditions();
}
}
private void SaveConditionsAction(ProjectItem item)
{
if (item!=null&&Conditions.Count>0)
{
mainDataService.AddProject(item);
mainDataService.AddConditionsByProjectId(Conditions, item.ProjectId);
}
}
private void InitialCurrentProjectItem()
{
CurrentProjectItem = new ProjectItem() { ProjectId = Guid.NewGuid(), ProjectName = "default", SaveDate = DateTime.Now };
}
public bool DeleteProject(ProjectItem item)
{
string cmdText = "delete from project where id=@id";
SQLiteParameter[] cmdParameters = new SQLiteParameter[]
{
new SQLiteParameter("@id",item.ProjectId),
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public bool AddProject(ProjectItem item)
{
string cmdText = "insert into project (id,projectname,savedate) values (@id,@projectname,@savedate)";
SQLiteParameter[] cmdParameters = new SQLiteParameter[]
{
new SQLiteParameter("@id",item.ProjectId),
new SQLiteParameter("@projectname",item.ProjectName),
new SQLiteParameter("@savedate",item.SaveDate)
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public List<ProjectItem> GetAllProjects()
{
List<ProjectItem> results = new List<ProjectItem>();
string cmdText = "select id,projectname,savedate from project order by savedate desc ";
SQLiteDataReader sdr = SqliteHelper.ExecuteReader(cmdText, null);
while (sdr.Read())
{
ProjectItem tmp = new ProjectItem();
tmp.ProjectId = sdr.GetGuid(0);
tmp.ProjectName = sdr.GetString(1);
tmp.SaveDate = sdr.GetDateTime(2);
results.Add(tmp);
}
sdr.Close();
return results;
}
private void LoadAction(ProjectItem obj)
{
Messenger.Default.Send<ProjectItem>(obj, "LoadConditions");
Messenger.Default.Send<object>(null, "LoadClose");
}
