private void delete_Click(object sender, RoutedEventArgs e)
{
if (LV.SelectedIndex != -1)
{
OleDbConnection conn = new OleDbConnection(odbcConnStr);
conn.Open();
string sql = "select 测站,N,E,Z from Buildstation";
OleDbDataAdapter adp = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
adp.Fill(ds, "Buildstation");
int c = LV.SelectedIndex;
string s = ds.Tables["Buildstation"].Rows[c]["测站"].ToString().Trim();
DBClass.Manipulation("Delete from Buildstation where 测站='" + s + "'");
Window_jianzhan7_1 window_jianzhan7_1 = new Window_jianzhan7_1();//刷新界面
window_jianzhan7_1.Show();
this.Close();//关闭当前窗口
}
else
{
MessageBox.Show("请选择数据！", "提示");
}
}
private void ESC_Click()
{
Window_jianzhan7_1 window_jianzhan7 = new Window_jianzhan7_1();
window_jianzhan7.Show();
this.Close();//关闭当前窗口
}
private void Next_Click(object sender, RoutedEventArgs e)
{
if (station.Text.ToString() != "")
{
if (DBClass.Judge("select 测站 from Buildstation where 测站='" + station.Text.Trim() + "'"))//判断测站是否存在，不存在不能进行下一步
{
DBClass.Manipulation("Update Buildstation set 仪高='" + YH.Text.Trim() + "',镜高='" + JH.Text.Trim() + "' where 测站='" + station.Text.Trim() + "' ");
Window_jianzhan7_1 window_jianzhan7_1 = new Window_jianzhan7_1();
window_jianzhan7_1.Show();
this.Close();//关闭当前窗口
}
else
{
MessageBox.Show("该测站不存在！");
}
}
else
{
MessageBox.Show("请输入站名！");
}
}
private void ESC_Click(object sender, RoutedEventArgs e)
{
Window_jianzhan7_1 window_jianzhan7_1 = new Window_jianzhan7_1();
window_jianzhan7_1.Show();
this.Close();//关闭当前窗口
}