private void DeleteMaterialBtn_Click(object sender, RoutedEventArgs e)
{
if (currMaterial == null)
{
return;
}
MessageBoxResult result = MessageBox.Show($"你确定要删除 {currMaterial.name} 吗？", "提示", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
int res = DatabaseOPtionHelper.GetInstance().delete(currMaterial);
if (res > 0)
{
String cateid = currMaterial.categoryId;
new System.Threading.Thread(new System.Threading.ThreadStart(() =>
{
String condition = MaterialCategoryEnum.id.ToString() + "=" + Constract.valueSplit + cateid + Constract.valueSplit;
CommonModel.FieldTryDesc(DataTabeName.material_category.ToString(), MaterialCategoryEnum.children_count.ToString(), 1, condition);
})).Start();
MessageBox.Show("删除成功！");
currMaterial = null;
this.MatereialDetailInfoGrid.DataContext = null;
materialNeedRefresh = true;
FillMaterialData();
}
else
{
MessageBox.Show("删除失败！");
}
}
else
{
return;
}
}
/// <summary>
/// Get Weighing Number 获取磅单
/// </summary>
/// <param name="WeightingBillType"> CK OR RK</param>
/// <param name="ExtStr"> BL OR WL</param>
/// <param name="noaml">true 正常过磅 false WeightingBillType + CurrentDateTime</param>
/// <returns></returns>
public static String GetWeighingNumber(WeightingBillType type, bool noaml = true, String ExtStr = null)
{
if (noaml == false)
{
return(type.ToString() + MyHelper.DateTimeHelper.getCurrentDateTime(MyHelper.DateTimeHelper.BillNumberDateTimeFormat));
}
String header = string.Empty;
if (App.currentCompany.customerType == (int)CompanyCustomerTyle.Person)
{
if (String.IsNullOrEmpty(App.currentCompany.nameFirstCase))
{
header = MyHelper.StringHelper.GetFirstPinyin(App.currentCompany.name);
}
else
{
header = App.currentCompany.nameFirstCase;
}
}
else
{
if (string.IsNullOrEmpty(App.currentCompany.abbreviationFirstCase))
{
if (!String.IsNullOrEmpty(App.currentCompany.abbreviation))
{
header = MyHelper.StringHelper.GetFirstPinyin(App.currentCompany.abbreviation);
}
else
{
if (String.IsNullOrEmpty(App.currentCompany.nameFirstCase))
{
header = MyHelper.StringHelper.GetFirstPinyin(App.currentCompany.name);
}
else
{
header = App.currentCompany.nameFirstCase;
}
}
}
else
{
header = App.currentCompany.abbreviationFirstCase;
}
}
String dateStr = MyHelper.DateTimeHelper.getCurrentDateTime(MyHelper.DateTimeHelper.BillNumberDateTimeFormat);
string sort = string.Empty;
int count = CommonModel.GetTodayCount(type);
switch (count.ToString().Length)
{
case 1:
sort = "000" + (count + 1).ToString();
break;
case 2:
sort = "00" + (count + 1).ToString();
break;
case 3:
sort = "0" + (count + 1).ToString();
break;
default:
sort = (count + 1).ToString();
break;
}
if (String.IsNullOrEmpty(ExtStr))
{
return(type.ToString().ToUpper() + "-" + header + dateStr + sort);
}
else
{
return(type.ToString().ToUpper() + "-" + ExtStr.ToUpper() + "-" + header + dateStr + sort);
}
}
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;
}
}
}