/// <summary>
/// 加子库按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button5_Click(object sender, EventArgs e)
{
// 打开选择子库界面
var frmChooseSubDatabase = new FrmChooseSubDatabase(this.User)
{
Owner = this
};
var dialogResult = frmChooseSubDatabase.ShowDialog();
if (dialogResult == DialogResult.OK)
{
this.label7.Text = frmChooseSubDatabase.DbNameAndType;
Logger.Info("DbNameAndType:" + frmChooseSubDatabase.DbNameAndType);
var databaseName = frmChooseSubDatabase.DbNameAndType.Split(',')[0];
var databaseType = frmChooseSubDatabase.DbNameAndType.Split(',')[1];
Logger.Info("选定的数据库名：{0}，类型：{1}", databaseName, databaseType);
var dt = GetCategories(databaseName, databaseType);
//查询出来的记录默认选中
dt = ExtendMethodDataTable.AddCheckColumn(dt);
RefreshDataGridView(dt);
//从查询出的数据中找到日期、震级的最大最小值
var minDate = Convert.ToDateTime(dt.AsEnumerable().Min(r => r["发震日期"]));
var maxDate = Convert.ToDateTime(dt.AsEnumerable().Max(r => r["发震日期"]));
var minMag = Convert.ToSingle(dt.AsEnumerable().Min(r => r["震级值"]));
var maxMag = Convert.ToSingle(dt.AsEnumerable().Max(r => r["震级值"]));
this.dateTimePicker1.Value = minDate;
this.dateTimePicker2.Value = maxDate;
this.textBox1.Text = minMag.ToString();
this.textBox2.Text = maxMag.ToString();
}
}
void FrmDisplayRawData_Load(object sender, EventArgs e)
{
this.StartPosition = FormStartPosition.CenterScreen;
string[] lines = System.IO.File.ReadAllLines(_fileName);
foreach (string line in lines)
{
var date = DateTime.ParseExact(ParseValueFromString(line, 0, 8), "yyyyMMdd",
CultureInfo.CurrentCulture);
var value = Convert.ToDouble(ParseValueFromString(line, 8, -1));
var dataRow = this._dataTable.NewRow();
dataRow["观测日期"] = date;
dataRow["观测值"] = value;
_dataTable.Rows.Add(dataRow);
}
var dt = ExtendMethodDataTable.IdentifyDataTable(_dataTable);
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
dataGridView1.RowHeadersVisible = false;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.AllowUserToResizeColumns = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].FillWeight = 30;
dataGridView1.Columns[1].FillWeight = 50;
dataGridView1.Columns[2].FillWeight = 50;
dataGridView1.Columns[1].DefaultCellStyle.Format = "yyyy/MM/dd";
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.MultiSelect = false;
}
private void FrmEditLabelDatabase_Load(object sender, EventArgs e)
{
// 根据用户编号查询地震标注库信息
var dt = DaoObject.GetLabelDatabasesInfo(this.User.ID);
RefreshDataGridView1(ExtendMethodDataTable.IdentifyDataTable(dt));
}
/// <summary>
/// 删除标注库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
if (this.dataGridView1.DataSource == null || this.dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("请先选择一个标注库再删除！");
return;
}
var dbname = dataGridView1.SelectedRows[0].Cells["标注库名称"].Value.ToString();
var ans = MessageBox.Show("确定删除标注库【" + dbname + "】吗？", "提问",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (ans == DialogResult.OK)
{
var sql = "delete from {0} where 用户编号={1} and 标注库名称='{2}'";
sql = string.Format(sql, DaoObject.TnLabelDb(), User.ID, dbname);
var n = MySqlHelper.ExecuteNonQuery(DaoObject.ConnectionString, sql);
if (n > 0)
{
MessageBox.Show("删除成功！");
// 删除成功后需要重新绑定数据，以表明数据已删除
var dt = DaoObject.GetLabelDatabasesInfo(this.User.ID);
RefreshDataGridView1(ExtendMethodDataTable.IdentifyDataTable(dt));
// 从表数据源设为空
RefreshDataGridView2(new DataTable());
}
}
}
private void RefreshDataGridView()
{
var commandText = "select 编号,视图名称 as 名称,视图体 from {0} where 用户编号={1}";
commandText = string.Format(commandText, DaoObject.TnRQMItem(), this.User.ID);
Logger.Debug(commandText);
var dt = MySqlHelper.ExecuteDataset(DaoObject.ConnectionString, commandText).Tables[0];
Logger.Info("查询用户 {0} 的区域查询视图信息， 共返回 {1} 条", this.User.ID, dt.Rows.Count);
//加入测项表，即不使用区域查询
var dr = dt.NewRow();
dr["名称"] = "测项";
dr["视图体"] = DaoObject.TnMItem();
dt.Rows.InsertAt(dr, 0);
dt = ExtendMethodDataTable.IdentifyDataTable(dt);
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
dataGridView1.MultiSelect = false;
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.AllowUserToResizeColumns = false;
if (dataGridView1.Columns["序号"] != null)
{
dataGridView1.Columns["序号"].FillWeight = 10;
}
if (dataGridView1.Columns["名称"] != null)
{
dataGridView1.Columns["名称"].FillWeight = 50;
}
//隐藏视图体列、编号列
if (dataGridView1.Columns["视图体"] != null)
{
dataGridView1.Columns["视图体"].Visible = false;
}
if (dataGridView1.Columns["编号"] != null)
{
dataGridView1.Columns["编号"].Visible = false;
}
// 设置DataGridView不可排序
foreach (DataGridViewColumn datagridviewcolumn in dataGridView1.Columns)
{
datagridviewcolumn.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private void RefreshDataGridView()
{
var sql = "select 命令名称,命令文本 from {0} where 用户编号={1}";
sql = string.Format(sql, DaoObject.TnQCategory(), this.User.ID);
var dt = MySqlHelper.ExecuteDataset(DaoObject.ConnectionString, sql).Tables[0];
var identifiedTable = ExtendMethodDataTable.IdentifyDataTable(dt);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = identifiedTable;
this.dataGridView1.Columns["命令文本"].Visible = false;
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
this.dataGridView1.Columns[0].Width = 35;
this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
