AD_DataSoure.StartYear = dateTimeStart.Value.Year;//开始年份
AD_DataSoure.StartMont = dateTimeStart.Value.Month;//开始月份
AD_DataSoure.StartDate = dateTimeStart.Value.Day;//开始天数
AD_DataSoure.EndYear = dateTimeEnd.Value.Year;//结束年份
AD_DataSoure.EndMont = dateTimeEnd.Value.Month;//结束月份
AD_DataSoure.EndDate = dateTimeEnd.Value.Day;//结束日数
DialogResult result = MessageBox.Show("开始时间: " + dateTimeStart.Text + "\n" + "结束时间: " + dateTimeEnd.Text + "\n" + "共计: " + days + "天" +"\n" +"监测类型："+comMonitorType.Text, "信息确认", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (wave == "0")//非毫米
{
if (comMonitorType.Text == "表面位移")
{
int yue = 1;//1月30天
Random rnd = new Random();
for (int i = AD_DataSoure.StartDate; i <= 30; i++)
{
int honor = 0;//从0点开始
for (int j = 0; j <= 23; j++)//一天24小时
{
string num = AD_ReturnRandom.ReturnNumber(txt1.Text.Trim(), txt2.Text.Trim());
string num1 = AD_ReturnRandom.ReturnNumber(txtv2d.Text.Trim(), txtv2x.Text.Trim());
string num2= AD_ReturnRandom.ReturnNumber(txtv3d.Text.Trim(), txtv3x.Text.Trim());
string sql = string.Format(@"insert into [SURF_DeviceDataHist]
(DeviceID,DeviceDataTypeID,V1,V2,V3,DacTime)
values('{0}',7,'{1}','{2}','{3}',{4}-{5}-{6} {7}:00:00')",
txtDevice.Text.Trim(), num, num1, num2, AD_DataSoure.StartYear, AD_DataSoure.StartMont,honor);
SqlHelper.ExecuteSql(sql);
honor++;
}
yue++;
}
}
两个datetimepicker控件 一个是开始时间 一个是结束时间
比如我选择开始时间是2017-01-02 结束时间是2017-07-20
那么从2017-01-02 00:00:00 起 每小时起往数据库插入一条数据 一直插到2017-07-20 23:00:00
