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();
}
}
