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