private void button6_Click(object sender, EventArgs e) //应力在线保存预览
{
string date_t = year + "-" + month + "-" + day;
string date_y = year1 + "-" + month1 + "-" + day1;
gt.setToday(date_t);
gt.setYesToday(date_y);
gt.setWorkFace(working_face);
string constr_test = "server=.;database=UPRESSURE;uid=sa;pwd=sakjdx";
string sqlString_ins = string.Format(@"IF NOT EXISTS(SELECT 1
FROM [UPRESSURE].[dbo].[地表沉降数据]
WHERE [日期] = '{0}')
BEGIN
INSERT INTO
[UPRESSURE].[dbo].[地表沉降数据]([日期], [观察日期], [最大沉降量],
[平均沉降量], [最大沉降位置])
VALUES('{0}', N'{1}', N'{2}', N'{3}', N'{4}')
END
ELSE
BEGIN
UPDATE [UPRESSURE].[dbo].[地表沉降数据]
SET [观察日期] = N'{1}', [最大沉降量] = N'{2}',
[平均沉降量] = N'{3}', [最大沉降位置] = N'{4}'
WHERE [日期] = '{0}'
END", date_t,
(textBox7.Text == "") ? null : textBox7.Text,
(textBox8.Text == "") ? null : textBox8.Text,
(textBox9.Text == "") ? null : textBox9.Text,
(textBox10.Text == "") ? null : textBox10.Text
);
using (SqlConnection sqlConnection = new SqlConnection(constr_test))
{
bool conok = SqlExtensions.QuickOpen(sqlConnection, 5000); //连接到数据库
if (conok)
{
SqlCommand cmd_ins = new SqlCommand(sqlString_ins, sqlConnection);
cmd_ins.ExecuteNonQuery();
Properties.Settings.Default.Save();
MessageBox.Show("完成");
StressTest st = new StressTest(working_face);
st.Start(gt);
MessageBox.Show("应力监测ok");
}
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
string date_t = year + "-" + month + "-" + day;
string date_y = year1 + "-" + month1 + "-" + day1;
gt.setToday(date_t);
gt.setYesToday(date_y);
gt.setWorkFace(working_face);
string constr_test = "server=.;database=UPRESSURE;uid=sa;pwd=sakjdx";
string sqlString_ins = string.Format(@"IF NOT EXISTS(SELECT 1
FROM [UPRESSURE].[dbo].[地表沉降数据]
WHERE [日期] = '{0}')
BEGIN
INSERT INTO
[UPRESSURE].[dbo].[地表沉降数据]([日期], [观察日期], [最大沉降量],
[平均沉降量], [最大沉降位置])
VALUES('{0}', N'{1}', N'{2}', N'{3}', N'{4}')
END
ELSE
BEGIN
UPDATE [UPRESSURE].[dbo].[地表沉降数据]
SET [观察日期] = N'{1}', [最大沉降量] = N'{2}',
[平均沉降量] = N'{3}', [最大沉降位置] = N'{4}'
WHERE [日期] = '{0}'
END", date_t,
(textBox7.Text == "") ? null : textBox7.Text,
(textBox8.Text == "") ? null : textBox8.Text,
(textBox9.Text == "") ? null : textBox9.Text,
(textBox10.Text == "") ? null : textBox10.Text
);
using (SqlConnection sqlConnection = new SqlConnection(constr_test))
{
bool conok = SqlExtensions.QuickOpen(sqlConnection, 5000); //连接到数据库
if (conok)
{
SqlCommand cmd_ins = new SqlCommand(sqlString_ins, sqlConnection);
cmd_ins.ExecuteNonQuery();
Properties.Settings.Default.Save();
//MessageBox.Show("完成");
}
}
try
{
StressTest st = new StressTest(working_face);
st.Start(gt);
for (int i = 0; i < 100; i++)
{
Thread.Sleep(100);
worker.ReportProgress(i);
}
MessageBox.Show("完成");
MessageBox.Show("应力监测ok");
}
catch (Exception)
{
MessageBox.Show("应力监测数据错误");
}
sign[5] = true;
for (int i = 0; i < sign.Length; i++)
{
if (sign[i] == false)
{
sign_ = false;
}
}
if (sign_ == true)
{
button2.Enabled = true;
}
sign_ = true;
}