public void SaveMenu(MenuTableMap menu)
{
var tran = DBHelper.GetInstance(mContext).BeginTransaction();
try
{
if (DBHelper.GetInstance(mContext).Exist(tran, string.Format("select 1 from _MenuTableMap where _group = '{0}' and _name ='{1}'", menu.group, menu.name)))
{
DBHelper.GetInstance(mContext).ExecuteSql(tran,
string.Format("UPDATE [_MenuTableMap] SET [_header] = '{0}',[_financeForm] = '{1}',[_index] = {2} WHERE [_group] ='{3}' and [_name] = '{4}'",
menu.header, menu.financeForm, menu.index, menu.group, menu.name));
}
else
{
DBHelper.GetInstance(mContext).ExecuteSql(tran,
string.Format("INSERT INTO [_MenuTableMap]([_group],[_name],[_header],[_financeForm],[_index])VALUES('{0}','{1}','{2}','{3}',{4});",
menu.group, menu.name, menu.header, menu.financeForm, menu.index));
}
DBHelper.GetInstance(mContext).CommitTransaction(tran);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
DBHelper.GetInstance(mContext).RollbackTransaction(tran);
}
}
private void btn_Click(object sender, RoutedEventArgs e)
{
try
{
var txt = (sender as Button).Name;
switch (txt)
{
case "savenew":
if (NeedSave())
{
Save();
}
else
{
Console.WriteLine("don't change,no need save.");
}
_itemSource = new MenuTableMap();
_originItemSource = new MenuTableMap();
break;
case "save":
if (NeedSave())
{
Save();
}
else
{
Console.WriteLine("don't change,no need save.");
}
FinanceMessageBox.Info("保存成功");
Close();
break;
case "close":
case "exit":
if (NeedSave())
{
MessageBoxResult ret = FinanceMessageBox.Quest("修改了项目，需要进行保存吗？");
if (ret == MessageBoxResult.Yes)
{
Save();
}
else if (ret == MessageBoxResult.Cancel)
{
break;
}
}
Close();
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
FinanceMessageBox.Error(ex.Message);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
_originItemSource = JsonConvert.DeserializeObject <MenuTableMap>(JsonConvert.SerializeObject(_itemSource));
txtGroup.ItemsSource = UiUtils.FirstMenuDisplayNameMap;
List <string> lstFinanceForm = new List <string>();
Assembly.GetExecutingAssembly().GetTypes().ToList().ForEach(t => {
if (t.IsSubclassOf(typeof(FinanceForm)))
{
lstFinanceForm.Add(t.Name);
}
});
txtFinanceForm.ItemsSource = lstFinanceForm;
}
public void DeleteMenu(MenuTableMap menu)
{
DBHelper.GetInstance(mContext).ExecuteSql(string.Format("delete from _MenuTableMap where _group = '{0}' and _name ='{1}'", menu.group, menu.name));
}
public void DeleteMenuItem(MenuTableMap menu)
{
Execute(new MenuTableDeleteRequest {
Content = menu
});
}
public void SaveMenuTable(MenuTableMap menu)
{
Execute(new MenuTableSaveRequest {
Content = menu
});
}
