private void DeleteAction(MaterialItem item) { string warningMsg = Application.Current.TryFindResource("dialogDeleteCondition").ToString(); if (dialogService.ShowDialog(warningMsg, "Delete")) { materialDataService.DeleteMaterialItem(item); Reload(); } }
public bool DeleteMaterialItem(MaterialItem item) { string cmdText = "delete from Material where id=@id"; SQLiteParameter[] cmdParameters = { new SQLiteParameter("@id",item.Id), }; return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0; }
private void EditAction(MaterialItem item) { ShowEditArea(); EditState = "Editing the Choosing Item"; //注意以后这一要深拷贝一下 MaterialItem newItem = new MaterialItem(); newItem.Id = item.Id; newItem.MaterialName = item.MaterialName; newItem.MoleWeight = item.MoleWeight; newItem.PopRate = item.PopRate; EditMaterialItem = newItem; }
/// <summary> /// 选择材料库项目的时候,自动填入到计算条件项目中 /// </summary> /// <param name="item"></param> private void SelectMaterialAction(MaterialItem item) { //每次选择材料后,都给材料的PopRate数值+1 item.PopRate++; materialLibraryDS.UpdateMaterialItem(item); ConditionItem.MaterialName = item.MaterialName; ConditionItem.MoleWeight = item.MoleWeight; //引发属性改动事件 RaisePropertyChanged(()=>ConditionItem); }
public bool UpdateMaterialItem(MaterialItem item) { string cmdText = "update material set materialName=@materialName,moleWeight=@moleWeight,popRate=@popRate where id=@id"; SQLiteParameter[] cmdParameters = { new SQLiteParameter("@materialName",item.MaterialName), new SQLiteParameter("@moleWeight",item.MoleWeight), new SQLiteParameter("@popRate",item.PopRate), new SQLiteParameter("@id",item.Id) }; return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0; }
public bool AddMaterialItem(MaterialItem item) { string cmdText = "insert into material (id,materialName,moleWeight,popRate) values (@id,@materialName,@moleWeight,@popRate) "; SQLiteParameter[] cmdParameters = { new SQLiteParameter("@id",item.Id), new SQLiteParameter("@materialName",item.MaterialName), new SQLiteParameter("@moleWeight",item.MoleWeight), new SQLiteParameter("@popRate",item.PopRate) }; return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0; }
/// <summary> /// Initializes a new instance of the MaterialLibraryViewModel class. /// </summary> public MaterialLibraryViewModel(IMaterialLibraryDataService datads, IDialogService dialogds) { materialDataService = datads; dialogService = dialogds; Reload(); HideEditArea(); EditMaterialItem = new MaterialItem() { }; AddCommand = new RelayCommand(AddAction); EditCommand = new RelayCommand<MaterialItem>(EditAction); DeleteCommand = new RelayCommand<MaterialItem>(DeleteAction); SaveCommand = new RelayCommand(SaveAction, CanSaveFunc); CancelCommand = new RelayCommand(CancelAction); }
public IList<MaterialItem> GetAllMaterialItems() { string cmdText = "select id,materialName,moleweight,poprate from material order by materialname,poprate desc"; SQLiteDataReader dr = SqliteHelper.ExecuteReader(cmdText, null); IList<MaterialItem> results = new List<MaterialItem>(); while (dr.Read()) { MaterialItem tmp = new MaterialItem(); tmp.Id = dr.GetGuid(0); tmp.MaterialName = dr.GetString(1); tmp.MoleWeight = dr.GetDouble(2); tmp.PopRate = dr.GetInt32(3); results.Add(tmp); } dr.Close(); return results; }
private void AddAction() { ShowEditArea(); EditState = "Adding New Item"; EditMaterialItem = new MaterialItem() { MaterialName = "default", MoleWeight = 10 }; }