public static List <ModulesOperator.ModulesList> SortModuleByCount(int level, String type) { List <ModulesOperator.ModulesList> modules = ModulesOperator.CountModuleLevelAndType(level, type); modules = modules.OrderByDescending(module => module.count).ToList(); return(modules); }
public ModuleInfo(MyButton mybtn) { InitializeComponent(); this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; moduleName = mybtn.Text; moduledata = ModulesOperator.LoadModulesInfo(); ShowInfo(); }
private void ModuleEditForm_Load(object sender, EventArgs e) { dataGridView_module.AutoGenerateColumns = false; moduledata = ModulesOperator.LoadModulesInfo(); dataGridView_module.DataSource = moduledata.Tables[ModuleData.MODULES_TABLE].DefaultView; pageStatus = RecordStatus.View; SetFormControlerStatus(); SetFormControlerData(); }
private void btnFolderBrowser_Click(object sender, EventArgs e) { openFileDialog_import.ShowDialog(); if (openFileDialog_import.FileName == null || openFileDialog_import.FileName == "") { return; } SystemOperator.OpenProject(openFileDialog_import.FileName, false); textBox1.Text = globalParameters.secondDbName; dgv_importModule.AutoGenerateColumns = false; ModuleData moduledata = ModulesOperator.LoadModulesInfoForSecondDb(); dgv_importModule.DataSource = moduledata.Tables[ModuleData.MODULES_TABLE].DefaultView; }
//保存 private void btnSave_Click(object sender, EventArgs e) { if (pageStatus == RecordStatus.Edit) { selectModule = dataGridView_module.CurrentCell.Value.ToString(); moduleName = name.Text.Trim(); DataRow oRows = moduledata.Tables[ModuleData.MODULES_TABLE].Select(ModuleData.NAME_FIELD + "='" + selectModule + "'")[0]; ModuleData saveModule = new ModuleData(); DataRow dr = saveModule.Tables[ModuleData.MODULES_TABLE].NewRow(); if (IsFilled()) { dr[ModuleData.NAME_FIELD] = name.Text.Trim(); dr[ModuleData.TYPE_FIELD] = comboBox_Type.SelectedItem.ToString().Trim(); dr[ModuleData.LEVEL_FIELD] = comboBox_Level.SelectedItem.ToString().Trim(); dr[ModuleData.COMMENT_FIELD] = comment.Text.ToString().Trim(); saveModule.Tables[ModuleData.MODULES_TABLE].Rows.Add(dr); if (ModulesOperator.UpdateModulesInfo(saveModule, selectModule)) { ModuleEditForm_Load(sender, e); } else { MessageBox.Show(" 该记录已存在!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else if (pageStatus == RecordStatus.Add) { ModuleData saveModule = new ModuleData(); DataRow dr = saveModule.Tables[ModuleData.MODULES_TABLE].NewRow(); if (IsFilled()) { dr[ModuleData.NAME_FIELD] = name.Text.Trim(); dr[ModuleData.TYPE_FIELD] = comboBox_Type.SelectedItem.ToString().Trim(); dr[ModuleData.LEVEL_FIELD] = comboBox_Level.SelectedItem.ToString().Trim(); dr[ModuleData.COMMENT_FIELD] = comment.Text.ToString().Trim(); saveModule.Tables[ModuleData.MODULES_TABLE].Rows.Add(dr); if (ModulesOperator.InsertModulesInfo(saveModule)) { ModuleEditForm_Load(sender, e); } else { MessageBox.Show(" 该记录已存在!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }
private void StreamForm_Load(object sender, EventArgs e) { //最左边的大表 dgv_stream.AutoGenerateColumns = false; dgv_stream.DataSource = StreamOperator.GetStreamName().Tables[StreamData.STREAM_TABLE].DefaultView; streamdata = StreamOperator.LoadStreamInfo(); dgv_allModule.AutoGenerateColumns = false; moduledata = ModulesOperator.LoadModulesInfo(); dgv_allModule.DataSource = moduledata.Tables[ModuleData.MODULES_TABLE].DefaultView; //dgv_selectModule.AutoGenerateColumns = false; //dgv_selectModule.DataSource = selectData.Tables[StreamData.STREAM_TABLE].DefaultView; pageStatus = RecordStatus.View; SetFormControlerStatus(); SetFormControlerData(); }
private void RelationEditForm_Load(object sender, EventArgs e) { dataGridView_relation.AutoGenerateColumns = false; relationdata = RelationOperator.LoadRelationInfo(); dataGridView_relation.DataSource = relationdata.Tables[RelationData.RELATION_TABLE].DefaultView; dgv_source.AutoGenerateColumns = false; moduledata = ModulesOperator.LoadModulesInfo(); dgv_source.DataSource = moduledata.Tables[ModuleData.MODULES_TABLE].DefaultView; dgv_target.AutoGenerateColumns = false; moduledata = ModulesOperator.LoadModulesInfo(); dgv_target.DataSource = moduledata.Tables[ModuleData.MODULES_TABLE].DefaultView; pageStatus = RecordStatus.View; SetFormControlerStatus(); SetFormControlerData(); }
//导入 private void btn_SelectFinish_Click(object sender, EventArgs e) { selectRelation = new RelationData(); string source; string target; for (int i = 0; i <= this.dgv_importRelation.RowCount - 1; i++) { if (dgv_importRelation.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { source = dgv_importRelation.Rows[i].Cells[2].Value.ToString(); target = dgv_importRelation.Rows[i].Cells[3].Value.ToString(); DataRow odr = relation.Tables[RelationData.RELATION_TABLE].Select(RelationData.SOURCENAME_FIELD + "='" + source + "' and " + RelationData.TARGETNAME_FIELD + "='" + target + "'")[0]; DataRow dr = selectRelation.Tables[RelationData.RELATION_TABLE].NewRow(); dr[2] = odr[RelationData.NAME_FIELD]; dr[0] = odr[RelationData.SOURCENAME_FIELD]; dr[1] = odr[RelationData.TARGETNAME_FIELD]; dr[3] = odr[RelationData.BIDIRECTION_FIELD].ToString(); dr[4] = odr[RelationData.TYPE_FIELD].ToString(); dr[5] = odr[RelationData.COMMENT_FIELD].ToString(); dr[6] = odr[RelationData.SHOW_FIELD]; selectRelation.Tables[RelationData.RELATION_TABLE].Rows.Add(dr); } } if (IsModuleChecked()) { GetModulesList(); if (ModulesOperator.importModules(selectModule)) { MessageBox.Show(" 信息系统导入成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (IsRelationChecked()) { if (RelationOperator.ImportRelation(selectRelation)) { MessageBox.Show(" 关系导入成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } MainForm.isSaved = false; } }
//删除模块 private void btnDelete_Click(object sender, EventArgs e) { pageStatus = RecordStatus.View; SetFormControlerStatus(); SetFormControlerData(); if (MessageBox.Show("您确定要删除所选系统吗?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { selectModule = dataGridView_module.CurrentCell.Value.ToString(); if (ModulesOperator.DeleteModulesInfo(selectModule)) { DataRow rows = moduledata.Tables[ModuleData.MODULES_TABLE].Select(ModuleData.NAME_FIELD + "='" + selectModule + "'")[0]; ModuleEditForm_Load(sender, e); } } else { DataRow odr = moduledata.Tables[ModuleData.MODULES_TABLE].Select(ModuleData.NAME_FIELD + "='" + selectModule + "'")[0]; name.Text = odr[ModuleData.NAME_FIELD].ToString(); type.Text = odr[ModuleData.TYPE_FIELD].ToString(); level.Text = odr[ModuleData.LEVEL_FIELD].ToString(); comment.Text = odr[ModuleData.COMMENT_FIELD].ToString(); } }