private void btnRTI10_Click(object sender, EventArgs e)
{
try
{
//string sStation = "C0A530";
string sStation = ddlstation.Text;
RtiProc oRtiProc = new RtiProc(ddlver.Text, sStation, ddlTimeDelay.Text, sConnectionString,ddltype.Text);
//進行計算
oRtiProc.RtiCal();
dataGridView2.DataSource = oRtiProc.dt_rti;
dataGridView2.AutoGenerateColumns = true;
dataGridView3.DataSource = oRtiProc.dt_rti90;
dataGridView3.AutoGenerateColumns = true;
lblrti10.Text = oRtiProc.dRTI10.ToString();
lblrti30.Text = oRtiProc.dRTI30.ToString();
lblrti50.Text = oRtiProc.dRTI50.ToString();
lblrti70.Text = oRtiProc.dRTI70.ToString();
lblrti90.Text = oRtiProc.dRTI90.ToString();
}
catch (Exception)
{
throw;
}
}
private void btnstart_Click(object sender, EventArgs e)
{
try
{
int rowindex = 0;
foreach (DataRow dr in dt_rtidetail.Rows)
{
string sStation = dr["station"].ToString();
//工作延時(delaytime)
dr["delaytime"] = ddlTimeDelay.Text;
Application.DoEvents();
//移動資料行
dataGridView1.CurrentCell = dataGridView1.Rows[rowindex].Cells[0];
//取得總筆數
ssql = " select count(*) as total from RtiData "
+ " where station = '" + sStation + "' "
+ " and ver = '" + ddlver.Text + "' "
;
if (ddlTimeDelay.Text != "0")
{
ssql += " and raindelay > " + ddlTimeDelay.Text + " ";
}
oDal.CommandText = ssql;
string sTotalcount = oDal.Value().ToString().Trim();
dr["totalcount"] = sTotalcount;
Application.DoEvents();
//取得開始時間
ssql = " select MIN(date) from RtiData "
+ " where station = '" + sStation + "' "
+ " and ver = '" + ddlver.Text + "' "
;
if (ddlTimeDelay.Text != "0")
{
ssql += " and raindelay > " + ddlTimeDelay.Text + " ";
}
oDal.CommandText = ssql;
string sStartDate = oDal.Value().ToString().Trim();
dr["startdate"] = sStartDate;
Application.DoEvents();
//取得結束時間
ssql = " select MAX(date) from RtiData "
+ " where station = '" + sStation + "' "
+ " and ver = '" + ddlver.Text + "' "
;
if (ddlTimeDelay.Text != "0")
{
ssql += " and raindelay > " + ddlTimeDelay.Text + " ";
}
oDal.CommandText = ssql;
string sEndDate = oDal.Value().ToString().Trim();
dr["enddate"] = sEndDate;
Application.DoEvents();
RtiProc oRtiProc = new RtiProc(ddlver.Text, sStation, ddlTimeDelay.Text, sConnectionString,ddltype.Text);
//進行計算
oRtiProc.RtiCal();
//計算RTI10
dr["rti10"] = oRtiProc.dRTI10.ToString();
Application.DoEvents();
//計算RTI30
dr["rti30"] = oRtiProc.dRTI30.ToString();
Application.DoEvents();
//計算RTI50
dr["rti50"] = oRtiProc.dRTI50.ToString();
Application.DoEvents();
//計算RTI70
dr["rti70"] = oRtiProc.dRTI70.ToString();
Application.DoEvents();
//計算RTI90
dr["rti90"] = oRtiProc.dRTI90.ToString();
Application.DoEvents();
//寫入資料庫
InsertData(dr);
rowindex++;
}
}
catch (Exception)
{
throw;
}
}