/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABBUOYHYDROLOGY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABBUOYHYDROLOGY(");
strSql.Append("DEVICECODE,DTAETIME,SENDNUM,RECVNUM,CURRENTSPD1,CURRENTDIR1,CURRENTSPD41,CURRENTDIR41,CURRENTSPD42,CURRENTDIR42,CURRENTSPD43,CURRENTDIR43,CURRENTSPD2,CURRENTDIR2,CURRENTSPD3,CURRENTDIR3,CURRENTSPD4,CURRENTDIR4,CURRENTSPD5,CURRENTDIR5,CURRENTSPD6,CURRENTDIR6,CURRENTSPD7,CURRENTDIR7,CURRENTSPD8,CURRENTDIR8,CURRENTSPD9,CURRENTDIR9,CURRENTSPD10,CURRENTDIR10,CURRENTSPD11,CURRENTDIR11,CURRENTSPD12,CURRENTDIR12,CURRENTSPD13,CURRENTDIR13,CURRENTSPD14,CURRENTDIR14,CURRENTSPD15,CURRENTDIR15,CURRENTSPD16,CURRENTDIR16,CURRENTSPD17,CURRENTDIR17,CURRENTSPD18,CURRENTDIR18,CURRENTSPD19,CURRENTDIR19,CURRENTSPD20,CURRENTDIR20,CURRENTSPD21,CURRENTDIR21,CURRENTSPD22,CURRENTDIR22,CURRENTSPD23,CURRENTDIR23,CURRENTSPD24,CURRENTDIR24,CURRENTSPD25,CURRENTDIR25,CURRENTSPD26,CURRENTDIR26,CURRENTSPD27,CURRENTDIR27,CURRENTSPD28,CURRENTDIR28,CURRENTSPD29,CURRENTDIR29,CURRENTSPD30,CURRENTDIR30,CURRENTSPD31,CURRENTDIR31,CURRENTSPD32,CURRENTDIR32,CURRENTSPD33,CURRENTDIR33,CURRENTSPD34,CURRENTDIR34,CURRENTSPD35,CURRENTDIR35,CURRENTSPD36,CURRENTDIR36,CURRENTSPD37,CURRENTDIR37,MAXWAVEHIGH,MAXWAVEPIOD,TENTHWAVEHIGH,TENTHWAVEPIOD,AVEWAVEHIGH,AVEWAVEPIOD,WALIDWAVEHIGH,WALIDWAVEPIOD,WAVEDIR,WAVENUM,RESERV0,RESERV1,RESERV2,RESERV3,RESERV4,RESERV5,RESERV6,RESERV7,RESERV8,RESERV9");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DTAETIME,:SENDNUM,:RECVNUM,:CURRENTSPD1,:CURRENTDIR1,:CURRENTSPD41,:CURRENTDIR41,:CURRENTSPD42,:CURRENTDIR42,:CURRENTSPD43,:CURRENTDIR43,:CURRENTSPD2,:CURRENTDIR2,:CURRENTSPD3,:CURRENTDIR3,:CURRENTSPD4,:CURRENTDIR4,:CURRENTSPD5,:CURRENTDIR5,:CURRENTSPD6,:CURRENTDIR6,:CURRENTSPD7,:CURRENTDIR7,:CURRENTSPD8,:CURRENTDIR8,:CURRENTSPD9,:CURRENTDIR9,:CURRENTSPD10,:CURRENTDIR10,:CURRENTSPD11,:CURRENTDIR11,:CURRENTSPD12,:CURRENTDIR12,:CURRENTSPD13,:CURRENTDIR13,:CURRENTSPD14,:CURRENTDIR14,:CURRENTSPD15,:CURRENTDIR15,:CURRENTSPD16,:CURRENTDIR16,:CURRENTSPD17,:CURRENTDIR17,:CURRENTSPD18,:CURRENTDIR18,:CURRENTSPD19,:CURRENTDIR19,:CURRENTSPD20,:CURRENTDIR20,:CURRENTSPD21,:CURRENTDIR21,:CURRENTSPD22,:CURRENTDIR22,:CURRENTSPD23,:CURRENTDIR23,:CURRENTSPD24,:CURRENTDIR24,:CURRENTSPD25,:CURRENTDIR25,:CURRENTSPD26,:CURRENTDIR26,:CURRENTSPD27,:CURRENTDIR27,:CURRENTSPD28,:CURRENTDIR28,:CURRENTSPD29,:CURRENTDIR29,:CURRENTSPD30,:CURRENTDIR30,:CURRENTSPD31,:CURRENTDIR31,:CURRENTSPD32,:CURRENTDIR32,:CURRENTSPD33,:CURRENTDIR33,:CURRENTSPD34,:CURRENTDIR34,:CURRENTSPD35,:CURRENTDIR35,:CURRENTSPD36,:CURRENTDIR36,:CURRENTSPD37,:CURRENTDIR37,:MAXWAVEHIGH,:MAXWAVEPIOD,:TENTHWAVEHIGH,:TENTHWAVEPIOD,:AVEWAVEHIGH,:AVEWAVEPIOD,:WALIDWAVEHIGH,:WALIDWAVEPIOD,:WAVEDIR,:WAVENUM,:RESERV0,:RESERV1,:RESERV2,:RESERV3,:RESERV4,:RESERV5,:RESERV6,:RESERV7,:RESERV8,:RESERV9");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DTAETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD1", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR1", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD41", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR41", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD42", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR42", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD43", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR43", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD2", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR2", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD3", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR3", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD4", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR4", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD5", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR5", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD6", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR6", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD7", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR7", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD8", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR8", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD9", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR9", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD10", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR10", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD11", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR11", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD12", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR12", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD13", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR13", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD14", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR14", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD15", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR15", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD16", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR16", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD17", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR17", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD18", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR18", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD19", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR19", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD20", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR20", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD21", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR21", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD22", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR22", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD23", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR23", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD24", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR24", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD25", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR25", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD26", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR26", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD27", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR27", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD28", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR28", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD29", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR29", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD30", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR30", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD31", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR31", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD32", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR32", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD33", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR33", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD34", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR34", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD35", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR35", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD36", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR36", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD37", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR37", OracleType.Number, 22),
new OracleParameter(":MAXWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":MAXWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":TENTHWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":TENTHWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":AVEWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":AVEWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":WALIDWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":WALIDWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":WAVEDIR", OracleType.Number, 22),
new OracleParameter(":WAVENUM", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":RESERV3", OracleType.Number, 16),
new OracleParameter(":RESERV4", OracleType.Number, 16),
new OracleParameter(":RESERV5", OracleType.Number, 16),
new OracleParameter(":RESERV6", OracleType.Number, 16),
new OracleParameter(":RESERV7", OracleType.Number, 16),
new OracleParameter(":RESERV8", OracleType.Number, 16),
new OracleParameter(":RESERV9", OracleType.Number, 16)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DTAETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.CURRENTSPD1;
parameters[5].Value = model.CURRENTDIR1;
parameters[6].Value = model.CURRENTSPD41;
parameters[7].Value = model.CURRENTDIR41;
parameters[8].Value = model.CURRENTSPD42;
parameters[9].Value = model.CURRENTDIR42;
parameters[10].Value = model.CURRENTSPD43;
parameters[11].Value = model.CURRENTDIR43;
parameters[12].Value = model.CURRENTSPD2;
parameters[13].Value = model.CURRENTDIR2;
parameters[14].Value = model.CURRENTSPD3;
parameters[15].Value = model.CURRENTDIR3;
parameters[16].Value = model.CURRENTSPD4;
parameters[17].Value = model.CURRENTDIR4;
parameters[18].Value = model.CURRENTSPD5;
parameters[19].Value = model.CURRENTDIR5;
parameters[20].Value = model.CURRENTSPD6;
parameters[21].Value = model.CURRENTDIR6;
parameters[22].Value = model.CURRENTSPD7;
parameters[23].Value = model.CURRENTDIR7;
parameters[24].Value = model.CURRENTSPD8;
parameters[25].Value = model.CURRENTDIR8;
parameters[26].Value = model.CURRENTSPD9;
parameters[27].Value = model.CURRENTDIR9;
parameters[28].Value = model.CURRENTSPD10;
parameters[29].Value = model.CURRENTDIR10;
parameters[30].Value = model.CURRENTSPD11;
parameters[31].Value = model.CURRENTDIR11;
parameters[32].Value = model.CURRENTSPD12;
parameters[33].Value = model.CURRENTDIR12;
parameters[34].Value = model.CURRENTSPD13;
parameters[35].Value = model.CURRENTDIR13;
parameters[36].Value = model.CURRENTSPD14;
parameters[37].Value = model.CURRENTDIR14;
parameters[38].Value = model.CURRENTSPD15;
parameters[39].Value = model.CURRENTDIR15;
parameters[40].Value = model.CURRENTSPD16;
parameters[41].Value = model.CURRENTDIR16;
parameters[42].Value = model.CURRENTSPD17;
parameters[43].Value = model.CURRENTDIR17;
parameters[44].Value = model.CURRENTSPD18;
parameters[45].Value = model.CURRENTDIR18;
parameters[46].Value = model.CURRENTSPD19;
parameters[47].Value = model.CURRENTDIR19;
parameters[48].Value = model.CURRENTSPD20;
parameters[49].Value = model.CURRENTDIR20;
parameters[50].Value = model.CURRENTSPD21;
parameters[51].Value = model.CURRENTDIR21;
parameters[52].Value = model.CURRENTSPD22;
parameters[53].Value = model.CURRENTDIR22;
parameters[54].Value = model.CURRENTSPD23;
parameters[55].Value = model.CURRENTDIR23;
parameters[56].Value = model.CURRENTSPD24;
parameters[57].Value = model.CURRENTDIR24;
parameters[58].Value = model.CURRENTSPD25;
parameters[59].Value = model.CURRENTDIR25;
parameters[60].Value = model.CURRENTSPD26;
parameters[61].Value = model.CURRENTDIR26;
parameters[62].Value = model.CURRENTSPD27;
parameters[63].Value = model.CURRENTDIR27;
parameters[64].Value = model.CURRENTSPD28;
parameters[65].Value = model.CURRENTDIR28;
parameters[66].Value = model.CURRENTSPD29;
parameters[67].Value = model.CURRENTDIR29;
parameters[68].Value = model.CURRENTSPD30;
parameters[69].Value = model.CURRENTDIR30;
parameters[70].Value = model.CURRENTSPD31;
parameters[71].Value = model.CURRENTDIR31;
parameters[72].Value = model.CURRENTSPD32;
parameters[73].Value = model.CURRENTDIR32;
parameters[74].Value = model.CURRENTSPD33;
parameters[75].Value = model.CURRENTDIR33;
parameters[76].Value = model.CURRENTSPD34;
parameters[77].Value = model.CURRENTDIR34;
parameters[78].Value = model.CURRENTSPD35;
parameters[79].Value = model.CURRENTDIR35;
parameters[80].Value = model.CURRENTSPD36;
parameters[81].Value = model.CURRENTDIR36;
parameters[82].Value = model.CURRENTSPD37;
parameters[83].Value = model.CURRENTDIR37;
parameters[84].Value = model.MAXWAVEHIGH;
parameters[85].Value = model.MAXWAVEPIOD;
parameters[86].Value = model.TENTHWAVEHIGH;
parameters[87].Value = model.TENTHWAVEPIOD;
parameters[88].Value = model.AVEWAVEHIGH;
parameters[89].Value = model.AVEWAVEPIOD;
parameters[90].Value = model.WALIDWAVEHIGH;
parameters[91].Value = model.WALIDWAVEPIOD;
parameters[92].Value = model.WAVEDIR;
parameters[93].Value = model.WAVENUM;
parameters[94].Value = model.RESERV0;
parameters[95].Value = model.RESERV1;
parameters[96].Value = model.RESERV2;
parameters[97].Value = model.RESERV3;
parameters[98].Value = model.RESERV4;
parameters[99].Value = model.RESERV5;
parameters[100].Value = model.RESERV6;
parameters[101].Value = model.RESERV7;
parameters[102].Value = model.RESERV8;
parameters[103].Value = model.RESERV9;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 获取浮标的水文数据
/// </summary>
public Entity.TABBUOYHYDROLOGY GetModel(string deviceCode)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append(" SELECT DTAETIME,MAXWAVEHIGH, MAXWAVEPIOD, TENTHWAVEHIGH, TENTHWAVEPIOD, AVEWAVEHIGH,AVEWAVEPIOD, WALIDWAVEHIGH, WALIDWAVEPIOD, WAVEDIR, WAVENUM ");
strSql.Append(" FROM TABBUOYHYDROLOGY ");
strSql.Append(" WHERE DEVICECODE=:DEVICECODE ");
strSql.Append(" AND DTAETIME=(SELECT MAX(DTAETIME) DTAETIME FROM TABBUOYHYDROLOGY WHERE DEVICECODE=:DEVICECODE) ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", deviceCode)
};
Entity.TABBUOYHYDROLOGY model = new Entity.TABBUOYHYDROLOGY();
DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters);
if (ds.Rows.Count > 0)
{
//model.DEVICECODE = ds.Rows[0]["DEVICECODE"].ToString();
if (ds.Rows[0]["DTAETIME"].ToString() != "")
{
model.DTAETIME = DateTime.Parse(ds.Rows[0]["DTAETIME"].ToString());
}
if (ds.Rows[0]["MAXWAVEHIGH"].ToString() != "")
{
model.MAXWAVEHIGH = decimal.Parse(ds.Rows[0]["MAXWAVEHIGH"].ToString());
}
if (ds.Rows[0]["MAXWAVEPIOD"].ToString() != "")
{
model.MAXWAVEPIOD = decimal.Parse(ds.Rows[0]["MAXWAVEPIOD"].ToString());
}
if (ds.Rows[0]["TENTHWAVEHIGH"].ToString() != "")
{
model.TENTHWAVEHIGH = decimal.Parse(ds.Rows[0]["TENTHWAVEHIGH"].ToString());
}
if (ds.Rows[0]["TENTHWAVEPIOD"].ToString() != "")
{
model.TENTHWAVEPIOD = decimal.Parse(ds.Rows[0]["TENTHWAVEPIOD"].ToString());
}
if (ds.Rows[0]["AVEWAVEHIGH"].ToString() != "")
{
model.AVEWAVEHIGH = decimal.Parse(ds.Rows[0]["AVEWAVEHIGH"].ToString());
}
if (ds.Rows[0]["AVEWAVEPIOD"].ToString() != "")
{
model.AVEWAVEPIOD = decimal.Parse(ds.Rows[0]["AVEWAVEPIOD"].ToString());
}
if (ds.Rows[0]["WALIDWAVEHIGH"].ToString() != "")
{
model.WALIDWAVEHIGH = decimal.Parse(ds.Rows[0]["WALIDWAVEHIGH"].ToString());
}
if (ds.Rows[0]["WALIDWAVEPIOD"].ToString() != "")
{
model.WALIDWAVEPIOD = decimal.Parse(ds.Rows[0]["WALIDWAVEPIOD"].ToString());
}
if (ds.Rows[0]["WAVEDIR"].ToString() != "")
{
model.WAVEDIR = decimal.Parse(ds.Rows[0]["WAVEDIR"].ToString());
}
if (ds.Rows[0]["WAVENUM"].ToString() != "")
{
model.WAVENUM = decimal.Parse(ds.Rows[0]["WAVENUM"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.TABBUOYHYDROLOGY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update TABBUOYHYDROLOGY set ");
strSql.Append(" DEVICECODE = :DEVICECODE , ");
strSql.Append(" DTAETIME = :DTAETIME , ");
strSql.Append(" SENDNUM = :SENDNUM , ");
strSql.Append(" RECVNUM = :RECVNUM , ");
strSql.Append(" CURRENTSPD1 = :CURRENTSPD1 , ");
strSql.Append(" CURRENTDIR1 = :CURRENTDIR1 , ");
strSql.Append(" CURRENTSPD41 = :CURRENTSPD41 , ");
strSql.Append(" CURRENTDIR41 = :CURRENTDIR41 , ");
strSql.Append(" CURRENTSPD42 = :CURRENTSPD42 , ");
strSql.Append(" CURRENTDIR42 = :CURRENTDIR42 , ");
strSql.Append(" CURRENTSPD43 = :CURRENTSPD43 , ");
strSql.Append(" CURRENTDIR43 = :CURRENTDIR43 , ");
strSql.Append(" CURRENTSPD2 = :CURRENTSPD2 , ");
strSql.Append(" CURRENTDIR2 = :CURRENTDIR2 , ");
strSql.Append(" CURRENTSPD3 = :CURRENTSPD3 , ");
strSql.Append(" CURRENTDIR3 = :CURRENTDIR3 , ");
strSql.Append(" CURRENTSPD4 = :CURRENTSPD4 , ");
strSql.Append(" CURRENTDIR4 = :CURRENTDIR4 , ");
strSql.Append(" CURRENTSPD5 = :CURRENTSPD5 , ");
strSql.Append(" CURRENTDIR5 = :CURRENTDIR5 , ");
strSql.Append(" CURRENTSPD6 = :CURRENTSPD6 , ");
strSql.Append(" CURRENTDIR6 = :CURRENTDIR6 , ");
strSql.Append(" CURRENTSPD7 = :CURRENTSPD7 , ");
strSql.Append(" CURRENTDIR7 = :CURRENTDIR7 , ");
strSql.Append(" CURRENTSPD8 = :CURRENTSPD8 , ");
strSql.Append(" CURRENTDIR8 = :CURRENTDIR8 , ");
strSql.Append(" CURRENTSPD9 = :CURRENTSPD9 , ");
strSql.Append(" CURRENTDIR9 = :CURRENTDIR9 , ");
strSql.Append(" CURRENTSPD10 = :CURRENTSPD10 , ");
strSql.Append(" CURRENTDIR10 = :CURRENTDIR10 , ");
strSql.Append(" CURRENTSPD11 = :CURRENTSPD11 , ");
strSql.Append(" CURRENTDIR11 = :CURRENTDIR11 , ");
strSql.Append(" CURRENTSPD12 = :CURRENTSPD12 , ");
strSql.Append(" CURRENTDIR12 = :CURRENTDIR12 , ");
strSql.Append(" CURRENTSPD13 = :CURRENTSPD13 , ");
strSql.Append(" CURRENTDIR13 = :CURRENTDIR13 , ");
strSql.Append(" CURRENTSPD14 = :CURRENTSPD14 , ");
strSql.Append(" CURRENTDIR14 = :CURRENTDIR14 , ");
strSql.Append(" CURRENTSPD15 = :CURRENTSPD15 , ");
strSql.Append(" CURRENTDIR15 = :CURRENTDIR15 , ");
strSql.Append(" CURRENTSPD16 = :CURRENTSPD16 , ");
strSql.Append(" CURRENTDIR16 = :CURRENTDIR16 , ");
strSql.Append(" CURRENTSPD17 = :CURRENTSPD17 , ");
strSql.Append(" CURRENTDIR17 = :CURRENTDIR17 , ");
strSql.Append(" CURRENTSPD18 = :CURRENTSPD18 , ");
strSql.Append(" CURRENTDIR18 = :CURRENTDIR18 , ");
strSql.Append(" CURRENTSPD19 = :CURRENTSPD19 , ");
strSql.Append(" CURRENTDIR19 = :CURRENTDIR19 , ");
strSql.Append(" CURRENTSPD20 = :CURRENTSPD20 , ");
strSql.Append(" CURRENTDIR20 = :CURRENTDIR20 , ");
strSql.Append(" CURRENTSPD21 = :CURRENTSPD21 , ");
strSql.Append(" CURRENTDIR21 = :CURRENTDIR21 , ");
strSql.Append(" CURRENTSPD22 = :CURRENTSPD22 , ");
strSql.Append(" CURRENTDIR22 = :CURRENTDIR22 , ");
strSql.Append(" CURRENTSPD23 = :CURRENTSPD23 , ");
strSql.Append(" CURRENTDIR23 = :CURRENTDIR23 , ");
strSql.Append(" CURRENTSPD24 = :CURRENTSPD24 , ");
strSql.Append(" CURRENTDIR24 = :CURRENTDIR24 , ");
strSql.Append(" CURRENTSPD25 = :CURRENTSPD25 , ");
strSql.Append(" CURRENTDIR25 = :CURRENTDIR25 , ");
strSql.Append(" CURRENTSPD26 = :CURRENTSPD26 , ");
strSql.Append(" CURRENTDIR26 = :CURRENTDIR26 , ");
strSql.Append(" CURRENTSPD27 = :CURRENTSPD27 , ");
strSql.Append(" CURRENTDIR27 = :CURRENTDIR27 , ");
strSql.Append(" CURRENTSPD28 = :CURRENTSPD28 , ");
strSql.Append(" CURRENTDIR28 = :CURRENTDIR28 , ");
strSql.Append(" CURRENTSPD29 = :CURRENTSPD29 , ");
strSql.Append(" CURRENTDIR29 = :CURRENTDIR29 , ");
strSql.Append(" CURRENTSPD30 = :CURRENTSPD30 , ");
strSql.Append(" CURRENTDIR30 = :CURRENTDIR30 , ");
strSql.Append(" CURRENTSPD31 = :CURRENTSPD31 , ");
strSql.Append(" CURRENTDIR31 = :CURRENTDIR31 , ");
strSql.Append(" CURRENTSPD32 = :CURRENTSPD32 , ");
strSql.Append(" CURRENTDIR32 = :CURRENTDIR32 , ");
strSql.Append(" CURRENTSPD33 = :CURRENTSPD33 , ");
strSql.Append(" CURRENTDIR33 = :CURRENTDIR33 , ");
strSql.Append(" CURRENTSPD34 = :CURRENTSPD34 , ");
strSql.Append(" CURRENTDIR34 = :CURRENTDIR34 , ");
strSql.Append(" CURRENTSPD35 = :CURRENTSPD35 , ");
strSql.Append(" CURRENTDIR35 = :CURRENTDIR35 , ");
strSql.Append(" CURRENTSPD36 = :CURRENTSPD36 , ");
strSql.Append(" CURRENTDIR36 = :CURRENTDIR36 , ");
strSql.Append(" CURRENTSPD37 = :CURRENTSPD37 , ");
strSql.Append(" CURRENTDIR37 = :CURRENTDIR37 , ");
strSql.Append(" MAXWAVEHIGH = :MAXWAVEHIGH , ");
strSql.Append(" MAXWAVEPIOD = :MAXWAVEPIOD , ");
strSql.Append(" TENTHWAVEHIGH = :TENTHWAVEHIGH , ");
strSql.Append(" TENTHWAVEPIOD = :TENTHWAVEPIOD , ");
strSql.Append(" AVEWAVEHIGH = :AVEWAVEHIGH , ");
strSql.Append(" AVEWAVEPIOD = :AVEWAVEPIOD , ");
strSql.Append(" WALIDWAVEHIGH = :WALIDWAVEHIGH , ");
strSql.Append(" WALIDWAVEPIOD = :WALIDWAVEPIOD , ");
strSql.Append(" WAVEDIR = :WAVEDIR , ");
strSql.Append(" WAVENUM = :WAVENUM , ");
strSql.Append(" RESERV0 = :RESERV0 , ");
strSql.Append(" RESERV1 = :RESERV1 , ");
strSql.Append(" RESERV2 = :RESERV2 , ");
strSql.Append(" RESERV3 = :RESERV3 , ");
strSql.Append(" RESERV4 = :RESERV4 , ");
strSql.Append(" RESERV5 = :RESERV5 , ");
strSql.Append(" RESERV6 = :RESERV6 , ");
strSql.Append(" RESERV7 = :RESERV7 , ");
strSql.Append(" RESERV8 = :RESERV8 , ");
strSql.Append(" RESERV9 = :RESERV9 ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DTAETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD1", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR1", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD41", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR41", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD42", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR42", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD43", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR43", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD2", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR2", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD3", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR3", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD4", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR4", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD5", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR5", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD6", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR6", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD7", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR7", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD8", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR8", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD9", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR9", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD10", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR10", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD11", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR11", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD12", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR12", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD13", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR13", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD14", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR14", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD15", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR15", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD16", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR16", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD17", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR17", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD18", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR18", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD19", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR19", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD20", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR20", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD21", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR21", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD22", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR22", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD23", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR23", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD24", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR24", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD25", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR25", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD26", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR26", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD27", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR27", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD28", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR28", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD29", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR29", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD30", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR30", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD31", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR31", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD32", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR32", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD33", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR33", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD34", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR34", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD35", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR35", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD36", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR36", OracleType.Number, 22),
new OracleParameter(":CURRENTSPD37", OracleType.Number, 16),
new OracleParameter(":CURRENTDIR37", OracleType.Number, 22),
new OracleParameter(":MAXWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":MAXWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":TENTHWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":TENTHWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":AVEWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":AVEWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":WALIDWAVEHIGH", OracleType.Number, 16),
new OracleParameter(":WALIDWAVEPIOD", OracleType.Number, 16),
new OracleParameter(":WAVEDIR", OracleType.Number, 22),
new OracleParameter(":WAVENUM", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":RESERV3", OracleType.Number, 16),
new OracleParameter(":RESERV4", OracleType.Number, 16),
new OracleParameter(":RESERV5", OracleType.Number, 16),
new OracleParameter(":RESERV6", OracleType.Number, 16),
new OracleParameter(":RESERV7", OracleType.Number, 16),
new OracleParameter(":RESERV8", OracleType.Number, 16),
new OracleParameter(":RESERV9", OracleType.Number, 16)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DTAETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.CURRENTSPD1;
parameters[5].Value = model.CURRENTDIR1;
parameters[6].Value = model.CURRENTSPD41;
parameters[7].Value = model.CURRENTDIR41;
parameters[8].Value = model.CURRENTSPD42;
parameters[9].Value = model.CURRENTDIR42;
parameters[10].Value = model.CURRENTSPD43;
parameters[11].Value = model.CURRENTDIR43;
parameters[12].Value = model.CURRENTSPD2;
parameters[13].Value = model.CURRENTDIR2;
parameters[14].Value = model.CURRENTSPD3;
parameters[15].Value = model.CURRENTDIR3;
parameters[16].Value = model.CURRENTSPD4;
parameters[17].Value = model.CURRENTDIR4;
parameters[18].Value = model.CURRENTSPD5;
parameters[19].Value = model.CURRENTDIR5;
parameters[20].Value = model.CURRENTSPD6;
parameters[21].Value = model.CURRENTDIR6;
parameters[22].Value = model.CURRENTSPD7;
parameters[23].Value = model.CURRENTDIR7;
parameters[24].Value = model.CURRENTSPD8;
parameters[25].Value = model.CURRENTDIR8;
parameters[26].Value = model.CURRENTSPD9;
parameters[27].Value = model.CURRENTDIR9;
parameters[28].Value = model.CURRENTSPD10;
parameters[29].Value = model.CURRENTDIR10;
parameters[30].Value = model.CURRENTSPD11;
parameters[31].Value = model.CURRENTDIR11;
parameters[32].Value = model.CURRENTSPD12;
parameters[33].Value = model.CURRENTDIR12;
parameters[34].Value = model.CURRENTSPD13;
parameters[35].Value = model.CURRENTDIR13;
parameters[36].Value = model.CURRENTSPD14;
parameters[37].Value = model.CURRENTDIR14;
parameters[38].Value = model.CURRENTSPD15;
parameters[39].Value = model.CURRENTDIR15;
parameters[40].Value = model.CURRENTSPD16;
parameters[41].Value = model.CURRENTDIR16;
parameters[42].Value = model.CURRENTSPD17;
parameters[43].Value = model.CURRENTDIR17;
parameters[44].Value = model.CURRENTSPD18;
parameters[45].Value = model.CURRENTDIR18;
parameters[46].Value = model.CURRENTSPD19;
parameters[47].Value = model.CURRENTDIR19;
parameters[48].Value = model.CURRENTSPD20;
parameters[49].Value = model.CURRENTDIR20;
parameters[50].Value = model.CURRENTSPD21;
parameters[51].Value = model.CURRENTDIR21;
parameters[52].Value = model.CURRENTSPD22;
parameters[53].Value = model.CURRENTDIR22;
parameters[54].Value = model.CURRENTSPD23;
parameters[55].Value = model.CURRENTDIR23;
parameters[56].Value = model.CURRENTSPD24;
parameters[57].Value = model.CURRENTDIR24;
parameters[58].Value = model.CURRENTSPD25;
parameters[59].Value = model.CURRENTDIR25;
parameters[60].Value = model.CURRENTSPD26;
parameters[61].Value = model.CURRENTDIR26;
parameters[62].Value = model.CURRENTSPD27;
parameters[63].Value = model.CURRENTDIR27;
parameters[64].Value = model.CURRENTSPD28;
parameters[65].Value = model.CURRENTDIR28;
parameters[66].Value = model.CURRENTSPD29;
parameters[67].Value = model.CURRENTDIR29;
parameters[68].Value = model.CURRENTSPD30;
parameters[69].Value = model.CURRENTDIR30;
parameters[70].Value = model.CURRENTSPD31;
parameters[71].Value = model.CURRENTDIR31;
parameters[72].Value = model.CURRENTSPD32;
parameters[73].Value = model.CURRENTDIR32;
parameters[74].Value = model.CURRENTSPD33;
parameters[75].Value = model.CURRENTDIR33;
parameters[76].Value = model.CURRENTSPD34;
parameters[77].Value = model.CURRENTDIR34;
parameters[78].Value = model.CURRENTSPD35;
parameters[79].Value = model.CURRENTDIR35;
parameters[80].Value = model.CURRENTSPD36;
parameters[81].Value = model.CURRENTDIR36;
parameters[82].Value = model.CURRENTSPD37;
parameters[83].Value = model.CURRENTDIR37;
parameters[84].Value = model.MAXWAVEHIGH;
parameters[85].Value = model.MAXWAVEPIOD;
parameters[86].Value = model.TENTHWAVEHIGH;
parameters[87].Value = model.TENTHWAVEPIOD;
parameters[88].Value = model.AVEWAVEHIGH;
parameters[89].Value = model.AVEWAVEPIOD;
parameters[90].Value = model.WALIDWAVEHIGH;
parameters[91].Value = model.WALIDWAVEPIOD;
parameters[92].Value = model.WAVEDIR;
parameters[93].Value = model.WAVENUM;
parameters[94].Value = model.RESERV0;
parameters[95].Value = model.RESERV1;
parameters[96].Value = model.RESERV2;
parameters[97].Value = model.RESERV3;
parameters[98].Value = model.RESERV4;
parameters[99].Value = model.RESERV5;
parameters[100].Value = model.RESERV6;
parameters[101].Value = model.RESERV7;
parameters[102].Value = model.RESERV8;
parameters[103].Value = model.RESERV9;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
