private void ButtonModify_Click(object sender, EventArgs e) { var form = new NewStatistics(CurrentStatistics); if (form.ShowDialog() == DialogResult.OK) { var model = form.Result; var result = StatisticsHelperClient.ModifyStatistics(model); if (string.IsNullOrEmpty(result)) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadStatistics(model); ComboModules.SelectedItem = model.Name; } } }
private bool SaveSetting(Sys_Statistics_Item statistics) { var statisticsID = statistics.ID; var selectionModuleID = GetSelectionModuleID(); if (statisticsID == Guid.Empty || selectionModuleID == Guid.Empty) { return(false); } var statisticsSettings = new List <StatisticsSetting>(); try { var settting = JsonConvert.DeserializeObject <List <StatisticsSetting> >(CurrentStatistics.Columns); if (settting != null) { statisticsSettings = settting; } } catch (Exception) { var m = JsonConvert.DeserializeObject <Dictionary <string, string> >(CurrentStatistics.Columns); foreach (var key in m.Keys) { statisticsSettings.Add(new StatisticsSetting() { ItemName = key, BindField = m[key], }); } } StatisticsModuleSetting model = null; StatisticsSetting item = null; var settings = new List <StatisticsModuleSetting>(); for (var i = 0; i < this.TableStatistics.ActiveSheet.Rows.Count; i++) { model = new StatisticsModuleSetting(); item = new StatisticsSetting(); var itemName = TableStatistics.ActiveSheet.Cells[i, 0].Value; var itemType = TableStatistics.ActiveSheet.Cells[i, 1].Value; var sheetName = TableStatistics.ActiveSheet.Cells[i, 2].Value; var sheetID = TableStatistics.ActiveSheet.Cells[i, 2].Tag; var cellName = TableStatistics.ActiveSheet.Cells[i, 3].Value; if (itemName == null || itemType == null) { continue; } var itn = Convert.ToString(itemName); var it = Map[Convert.ToString(itemType)]; var sn = Convert.ToString(sheetName); var si = new Guid(Convert.ToString(sheetID)); var cn = Convert.ToString(cellName); model.BindField = it; model.StatisticsItemName = itn; model.CellName = cn; model.SheetName = sn; model.SheetID = si; item = statisticsSettings.Find(m => m.BindField == it); if (item == null) { item = new StatisticsSetting(); statisticsSettings.Add(item); } item.BindField = it; item.ItemName = itn; settings.Add(model); } var map = JsonConvert.SerializeObject(settings); var result = StatisticsHelperClient.UpdateStatisticsMapOnModule(selectionModuleID, map); if (string.IsNullOrEmpty(result) == false) { MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } statistics.Columns = JsonConvert.SerializeObject(statisticsSettings); result = StatisticsHelperClient.ModifyStatistics(statistics); if (string.IsNullOrEmpty(result) == false) { MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (NeedSynchronous) { result = StatisticsHelperClient.SynchronousStatistics(statistics.ID, statisticsSettings); } result = StatisticsHelperClient.NewStatisticsReference(statistics.ID, selectionModuleID); if (string.IsNullOrEmpty(result) == false) { MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } return(true); }