public void LoadStatistics(Sys_Statistics_Item select) { ComboModules.Items.Clear(); Statistics = StatisticsHelperClient.GetStatisticsList(); if (Statistics == null || Statistics.Rows.Count == 0) { return; } ComboModules.SelectedIndexChanged -= new EventHandler(ComboModules_SelectedIndexChanged); { for (var i = 0; i < Statistics.Rows.Count; i++) { var row = Statistics.Rows[i]; ComboModules.Items.Add(row["ItemName"] as string); } if (select == null) { ComboModules.SelectedIndex = 0; } else { ComboModules.SelectedItem = select.Name; } } ComboModules.SelectedIndexChanged += new EventHandler(ComboModules_SelectedIndexChanged); }
public string NewStatistics(Sys_Statistics_Item model) { if (ExistsName(model.Name, model.ID)) { return("项目名称不能重复"); } var sql = @"INSERT INTO [dbo].[sys_TJ_Item] ([ItemID] ,[ItemName] ,[Columns] ,[ItemType] ,[Weight] ,[Status]) VALUES (@ItemID ,@ItemName ,@Columns ,@ItemType ,@Weight ,@Status)"; var command = GetDbCommand(sql); command.Parameters.Add(new SqlParameter("@ItemID", model.ID)); command.Parameters.Add(new SqlParameter("@ItemName", model.Name)); command.Parameters.Add(new SqlParameter("@Columns", model.Columns)); command.Parameters.Add(new SqlParameter("@ItemType", model.Type)); command.Parameters.Add(new SqlParameter("@Weight", model.Weight)); command.Parameters.Add(new SqlParameter("@Status", model.Status)); try { if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } command.ExecuteNonQuery(); return(null); } catch (Exception) { Logger.Error("在新增统计项时发生错误"); } finally { try { command.Connection.Close(); command.Connection.Dispose(); } catch (Exception) { } } return("添加失败, 服务器发生错误"); }
public NewStatistics(Sys_Statistics_Item model) { InitializeComponent(); this.TextItemName.Text = model.Name; this.TextWeight.Text = model.Weight.ToString(); this.RadioMaterial.Checked = model.Type == 1; this.Result = model; }
public string ModifyStatistics(Sys_Statistics_Item model) { if (ExistsName(model.Name, model.ID)) { return("项目名称不能重复"); } var sql = @"UPDATE [dbo].[sys_TJ_Item] SET [ItemName] = @ItemName ,[Columns] = @Columns ,[ItemType] = @ItemType ,[Weight] = @Weight ,[Status] = @Status WHERE ItemID = @ItemID "; var command = GetDbCommand(sql); command.Parameters.Add(new SqlParameter("@ItemID", model.ID)); command.Parameters.Add(new SqlParameter("@ItemName", model.Name)); command.Parameters.Add(new SqlParameter("@Columns", model.Columns)); command.Parameters.Add(new SqlParameter("@ItemType", model.Type)); command.Parameters.Add(new SqlParameter("@Weight", model.Weight)); command.Parameters.Add(new SqlParameter("@Status", model.Status)); try { if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } command.ExecuteNonQuery(); return(null); } catch (Exception e) { Logger.Error("在修改统计项时发生异常"); Logger.Error(e); } finally { try { command.Connection.Close(); command.Connection.Dispose(); } catch (Exception) { } } return("保存失败, 服务器发生错误"); }
private void ButtonOK_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { if (Result == null) { Result = new Sys_Statistics_Item(); Result.Columns = ""; } Result.Name = TextItemName.Text; Result.Weight = int.Parse(TextWeight.Text); Result.Type = RadioMaterial.Checked ? 1 : 2; Result.Status = 1; DialogResult = DialogResult.OK; } }
public static string ModifyStatistics(Sys_Statistics_Item model) { return(Agent.CallService(DLL, "ModifyStatistics", new object[] { model }) as string); }
private void ComboModules_SelectedIndexChanged(object sender, EventArgs e) { var SetCurrentModule = true; Modules = null; NeedSynchronous = false; TableModules_Sheet1.Rows.Count = 0; LinkModifyStatistics.Enabled = false; LinkDeleteStatistics.Enabled = false; var sheet = CloneSheet(TableModules.ActiveSheet, 0); if (Statistics != null && Statistics.Rows.Count > 0) { var row = Statistics.Rows[ComboModules.SelectedIndex]; CurrentStatistics = new Sys_Statistics_Item() { ID = new Guid(Convert.ToString(row["ItemID"])), Columns = Convert.ToString(row["Columns"]), Name = Convert.ToString(row["ItemName"]), Type = Convert.ToInt32(row["ItemType"]), Weight = Convert.ToInt32(row["Weight"]), Status = 1 }; LinkDeleteStatistics.Enabled = true; LinkModifyStatistics.Enabled = true; Modules = StatisticsHelperClient.GetStatisticsModules(CurrentStatistics.ID); Modules.PrimaryKey = new DataColumn[] { Modules.Columns["ModuleID"] }; if (Modules != null && Modules.Rows.Count > 0) { var currentModuleID = Guid.Empty; if (CurrentModule != null) { currentModuleID = CurrentModule.ID; } sheet.Rows.Count = Modules.Rows.Count; for (var i = 0; i < Modules.Rows.Count; i++) { row = Modules.Rows[i]; var id = new Guid(Convert.ToString(row["ModuleID"])); if (currentModuleID == id) { SetCurrentModule = false; } sheet.Cells[i, 0].Value = row["Name"]; sheet.Cells[i, 0].Tag = row["ModuleID"]; } } } if (SetCurrentModule) { LoadCurrentModule(sheet); } TableModules.Sheets.Clear(); TableModules.Sheets.Add(sheet); }
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); }