/// <summary> /// Change province ChildrenCount /// </summary> /// <param name="isAdd"></param> private void ChangeChildrenCount(int provinceId = 0, bool isAdd = true) { return; String condition = string.Empty; int id = provinceId; if (provinceId != 0) { if (CompanyRB.IsChecked == true) { id = mCompany.affiliatedProvinceId; } else { id = mPersonCompany.affiliatedProvinceId;; } } condition = ProvinceEnum.id.ToString() + "=" + Constract.valueSplit + id + Constract.valueSplit; if (isAdd == true) { new System.Threading.Thread(new System.Threading.ThreadStart(() => { CommonModel.FieldTryAsc(DataTabeName.province.ToString(), ProvinceEnum.children_count.ToString(), 1, condition); })).Start(); } else { new System.Threading.Thread(new System.Threading.ThreadStart(() => { CommonModel.FieldTryDesc(DataTabeName.province.ToString(), ProvinceEnum.children_count.ToString(), 1, condition); })).Start(); } }
private void saveBtn_Click(object sender, RoutedEventArgs e) { SqlDao.DbHelper optionHelper = DatabaseOPtionHelper.GetInstance(); int res = 0; if (!String.IsNullOrEmpty(mMaterial.id)) { //update mMaterial.name = this.nameTb.Text; mMaterial.nameFirstCase = StringHelper.GetFirstPinyin(mMaterial.name); mMaterial.syncTime = (Int32)DateTimeHelper.GetTimeStamp(); res = optionHelper.update(mMaterial); if (res > 0) { MessageBox.Show("修改成功!"); RefreshParentData(); this.Close(); } else { MessageBox.Show("修改失败!"); return; } } else { //insert if (mMaterial.isDelete == 1) { mMaterial.isDelete = 0; mMaterial.deleteTime = null; mMaterial.nameFirstCase = StringHelper.GetFirstPinyin(mMaterial.name); mMaterial.updateTime = DateTimeHelper.getCurrentDateTime(); mMaterial.updateUserId = App.currentUser.id; mMaterial.updateUserName = App.currentUser.name; mMaterial.syncTime = DateTimeHelper.GetTimeStamp(); res = optionHelper.update(mMaterial); } else { if (String.IsNullOrEmpty(mMaterial.categoryId) || String.IsNullOrEmpty(mMaterial.categoryName)) { MessageBox.Show("添加物资名称必须先选择物资的分类!"); return; } mMaterial.id = Guid.NewGuid().ToString(); mMaterial.name = this.nameTb.Text.Trim(); mMaterial.addtime = DateTimeHelper.getCurrentDateTime(); mMaterial.addUserId = App.currentUser.id; mMaterial.addUserName = App.currentUser.name; mMaterial.isDelete = 0; mMaterial.deleteTime = null; mMaterial.syncTime = DateTimeHelper.GetTimeStamp(); mMaterial.nameFirstCase = StringHelper.GetFirstPinyin(mMaterial.name); res = optionHelper.insert(mMaterial); } if (res > 0) { MessageBox.Show("保存成功!"); new System.Threading.Thread(new System.Threading.ThreadStart(() => { String condition = MaterialCategoryEnum.id.ToString() + "=" + Constract.valueSplit + mMaterial.categoryId + Constract.valueSplit; CommonModel.FieldTryAsc(DataTabeName.material_category.ToString(), MaterialCategoryEnum.children_count.ToString(), 1, condition); })).Start(); RefreshParentData(); ChangeCategoryChildredCount(); this.Close(); } else { MessageBox.Show("保存失败!"); return; } } }