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