/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABBUOYECOLOGY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABBUOYECOLOGY(");
strSql.Append("DEVICECODE,DATETIME,SENDNUM,RECVNUM,CURRENTTEM,WATERTEM,CTDTEM,SALINITY,CONDUCTIVITY,OXYGEN,PH,TURBIDITY,YLS,YLSTEM,UNDERWATERCO2,OXYGENCHEMICAL,MNO4,OXYGENBIOLOGY,NH3N,NO3,NO2,PO4,SIO3,PAHS,RESERV0,RESERV1,RESERV2,RESERV3,RESERV4,RESERV5,RESERV6,RESERV7,RESERV8,RESERV9,P,N,C,S,ALKALINITY,SUSPENSION,CYANIDE,HG,CD,CD6,PB,AS,YLSA,PHYCOCY,PHYCOER,COLIFORM,POTENTIAL,TOTALY,K40,CS134,CS137,CO60,CU,ZN,PHENOL,BOD5,ORGANIC,DETERGENTS,OIL,VIRUS,PETRO,DDT,PCBS,BENZOL,CHLO,ANTIBIOTIC,POISONA,POISONB,RESERV10,RESERV11,RESERV12,RESERV13,RESERV14,RESERV15,RESERV16,RESERV17,RESERV18,RESERV19");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DATETIME,:SENDNUM,:RECVNUM,:CURRENTTEM,:WATERTEM,:CTDTEM,:SALINITY,:CONDUCTIVITY,:OXYGEN,:PH,:TURBIDITY,:YLS,:YLSTEM,:UNDERWATERCO2,:OXYGENCHEMICAL,:MNO4,:OXYGENBIOLOGY,:NH3N,:NO3,:NO2,:PO4,:SIO3,:PAHS,:RESERV0,:RESERV1,:RESERV2,:RESERV3,:RESERV4,:RESERV5,:RESERV6,:RESERV7,:RESERV8,:RESERV9,:P,:N,:C,:S,:ALKALINITY,:SUSPENSION,:CYANIDE,:HG,:CD,:CD6,:PB,:AS,:YLSA,:PHYCOCY,:PHYCOER,:COLIFORM,:POTENTIAL,:TOTALY,:K40,:CS134,:CS137,:CO60,:CU,:ZN,:PHENOL,:BOD5,:ORGANIC,:DETERGENTS,:OIL,:VIRUS,:PETRO,:DDT,:PCBS,:BENZOL,:CHLO,:ANTIBIOTIC,:POISONA,:POISONB,:RESERV10,:RESERV11,:RESERV12,:RESERV13,:RESERV14,:RESERV15,:RESERV16,:RESERV17,:RESERV18,:RESERV19");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DATETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":CURRENTTEM", OracleType.Number, 16),
new OracleParameter(":WATERTEM", OracleType.Number, 16),
new OracleParameter(":CTDTEM", OracleType.Number, 16),
new OracleParameter(":SALINITY", OracleType.Number, 16),
new OracleParameter(":CONDUCTIVITY", OracleType.Number, 16),
new OracleParameter(":OXYGEN", OracleType.Number, 16),
new OracleParameter(":PH", OracleType.Number, 16),
new OracleParameter(":TURBIDITY", OracleType.Number, 16),
new OracleParameter(":YLS", OracleType.Number, 16),
new OracleParameter(":YLSTEM", OracleType.Number, 16),
new OracleParameter(":UNDERWATERCO2", OracleType.Number, 22),
new OracleParameter(":OXYGENCHEMICAL", OracleType.Number, 16),
new OracleParameter(":MNO4", OracleType.Number, 16),
new OracleParameter(":OXYGENBIOLOGY", OracleType.Number, 16),
new OracleParameter(":NH3N", OracleType.Number, 16),
new OracleParameter(":NO3", OracleType.Number, 16),
new OracleParameter(":NO2", OracleType.Number, 16),
new OracleParameter(":PO4", OracleType.Number, 16),
new OracleParameter(":SIO3", OracleType.Number, 16),
new OracleParameter(":PAHS", OracleType.Number, 16),
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),
new OracleParameter(":P", OracleType.Number, 16),
new OracleParameter(":N", OracleType.Number, 16),
new OracleParameter(":C", OracleType.Number, 16),
new OracleParameter(":S", OracleType.Number, 16),
new OracleParameter(":ALKALINITY", OracleType.Number, 16),
new OracleParameter(":SUSPENSION", OracleType.Number, 16),
new OracleParameter(":CYANIDE", OracleType.Number, 16),
new OracleParameter(":HG", OracleType.Number, 16),
new OracleParameter(":CD", OracleType.Number, 16),
new OracleParameter(":CD6", OracleType.Number, 16),
new OracleParameter(":PB", OracleType.Number, 16),
new OracleParameter(":AS", OracleType.Number, 16),
new OracleParameter(":YLSA", OracleType.Number, 16),
new OracleParameter(":PHYCOCY", OracleType.Number, 16),
new OracleParameter(":PHYCOER", OracleType.Number, 16),
new OracleParameter(":COLIFORM", OracleType.Number, 16),
new OracleParameter(":POTENTIAL", OracleType.Number, 16),
new OracleParameter(":TOTALY", OracleType.Number, 16),
new OracleParameter(":K40", OracleType.Number, 16),
new OracleParameter(":CS134", OracleType.Number, 16),
new OracleParameter(":CS137", OracleType.Number, 16),
new OracleParameter(":CO60", OracleType.Number, 16),
new OracleParameter(":CU", OracleType.Number, 16),
new OracleParameter(":ZN", OracleType.Number, 16),
new OracleParameter(":PHENOL", OracleType.Number, 16),
new OracleParameter(":BOD5", OracleType.Number, 16),
new OracleParameter(":ORGANIC", OracleType.Number, 16),
new OracleParameter(":DETERGENTS", OracleType.Number, 16),
new OracleParameter(":OIL", OracleType.Number, 16),
new OracleParameter(":VIRUS", OracleType.Number, 22),
new OracleParameter(":PETRO", OracleType.Number, 16),
new OracleParameter(":DDT", OracleType.Number, 16),
new OracleParameter(":PCBS", OracleType.Number, 16),
new OracleParameter(":BENZOL", OracleType.Number, 16),
new OracleParameter(":CHLO", OracleType.Number, 16),
new OracleParameter(":ANTIBIOTIC", OracleType.Number, 16),
new OracleParameter(":POISONA", OracleType.Number, 16),
new OracleParameter(":POISONB", OracleType.Number, 16),
new OracleParameter(":RESERV10", OracleType.Number, 16),
new OracleParameter(":RESERV11", OracleType.Number, 16),
new OracleParameter(":RESERV12", OracleType.Number, 16),
new OracleParameter(":RESERV13", OracleType.Number, 16),
new OracleParameter(":RESERV14", OracleType.Number, 16),
new OracleParameter(":RESERV15", OracleType.Number, 16),
new OracleParameter(":RESERV16", OracleType.Number, 16),
new OracleParameter(":RESERV17", OracleType.Number, 16),
new OracleParameter(":RESERV18", OracleType.Number, 16),
new OracleParameter(":RESERV19", OracleType.Number, 16)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.CURRENTTEM;
parameters[5].Value = model.WATERTEM;
parameters[6].Value = model.CTDTEM;
parameters[7].Value = model.SALINITY;
parameters[8].Value = model.CONDUCTIVITY;
parameters[9].Value = model.OXYGEN;
parameters[10].Value = model.PH;
parameters[11].Value = model.TURBIDITY;
parameters[12].Value = model.YLS;
parameters[13].Value = model.YLSTEM;
parameters[14].Value = model.UNDERWATERCO2;
parameters[15].Value = model.OXYGENCHEMICAL;
parameters[16].Value = model.MNO4;
parameters[17].Value = model.OXYGENBIOLOGY;
parameters[18].Value = model.NH3N;
parameters[19].Value = model.NO3;
parameters[20].Value = model.NO2;
parameters[21].Value = model.PO4;
parameters[22].Value = model.SIO3;
parameters[23].Value = model.PAHS;
parameters[24].Value = model.RESERV0;
parameters[25].Value = model.RESERV1;
parameters[26].Value = model.RESERV2;
parameters[27].Value = model.RESERV3;
parameters[28].Value = model.RESERV4;
parameters[29].Value = model.RESERV5;
parameters[30].Value = model.RESERV6;
parameters[31].Value = model.RESERV7;
parameters[32].Value = model.RESERV8;
parameters[33].Value = model.RESERV9;
parameters[34].Value = model.P;
parameters[35].Value = model.N;
parameters[36].Value = model.C;
parameters[37].Value = model.S;
parameters[38].Value = model.ALKALINITY;
parameters[39].Value = model.SUSPENSION;
parameters[40].Value = model.CYANIDE;
parameters[41].Value = model.HG;
parameters[42].Value = model.CD;
parameters[43].Value = model.CD6;
parameters[44].Value = model.PB;
parameters[45].Value = model.AS;
parameters[46].Value = model.YLSA;
parameters[47].Value = model.PHYCOCY;
parameters[48].Value = model.PHYCOER;
parameters[49].Value = model.COLIFORM;
parameters[50].Value = model.POTENTIAL;
parameters[51].Value = model.TOTALY;
parameters[52].Value = model.K40;
parameters[53].Value = model.CS134;
parameters[54].Value = model.CS137;
parameters[55].Value = model.CO60;
parameters[56].Value = model.CU;
parameters[57].Value = model.ZN;
parameters[58].Value = model.PHENOL;
parameters[59].Value = model.BOD5;
parameters[60].Value = model.ORGANIC;
parameters[61].Value = model.DETERGENTS;
parameters[62].Value = model.OIL;
parameters[63].Value = model.VIRUS;
parameters[64].Value = model.PETRO;
parameters[65].Value = model.DDT;
parameters[66].Value = model.PCBS;
parameters[67].Value = model.BENZOL;
parameters[68].Value = model.CHLO;
parameters[69].Value = model.ANTIBIOTIC;
parameters[70].Value = model.POISONA;
parameters[71].Value = model.POISONB;
parameters[72].Value = model.RESERV10;
parameters[73].Value = model.RESERV11;
parameters[74].Value = model.RESERV12;
parameters[75].Value = model.RESERV13;
parameters[76].Value = model.RESERV14;
parameters[77].Value = model.RESERV15;
parameters[78].Value = model.RESERV16;
parameters[79].Value = model.RESERV17;
parameters[80].Value = model.RESERV18;
parameters[81].Value = model.RESERV19;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 获取浮标的生态数据
/// </summary>
public Entity.TABBUOYECOLOGY GetModel(string deviceCode)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append(" SELECT CURRENTTEM, WATERTEM, CTDTEM, SALINITY, CONDUCTIVITY, OXYGEN, PH, TURBIDITY, YLS, YLSTEM, UNDERWATERCO2, OXYGENCHEMICAL, MNO4, OXYGENBIOLOGY, NH3N, NO3, NO2, PO4, SIO3, PAHS, 'P', N, C, S, ALKALINITY, SUSPENSION, CYANIDE, HG, CD, CD6, PB, 'AS', YLSA, PHYCOCY, PHYCOER, COLIFORM, POTENTIAL, TOTALY, K40, CS134, CS137, CO60, CU, ZN, PHENOL, BOD5, ORGANIC, DETERGENTS, OIL, VIRUS, PETRO, DDT, PCBS, BENZOL, CHLO, ANTIBIOTIC, POISONA, POISONB ");
strSql.Append(" FROM TABBUOYECOLOGY ");
strSql.Append(" WHERE DEVICECODE=:DEVICECODE");
strSql.Append(" AND DATETIME=(SELECT MAX(DATETIME) DATETIME FROM TABBUOYECOLOGY WHERE DEVICECODE=:DEVICECODE) ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", deviceCode)
};
dbHelper.OpenConn("");
Entity.TABBUOYECOLOGY model = new Entity.TABBUOYECOLOGY();
DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters);
dbHelper.CloseConn();
if (ds.Rows.Count > 0)
{
//model.DEVICECODE = ds.Rows[0]["DEVICECODE"].ToString();
if (ds.Rows[0]["CURRENTTEM"].ToString() != "")
{
model.CURRENTTEM = decimal.Parse(ds.Rows[0]["CURRENTTEM"].ToString());
}
if (ds.Rows[0]["WATERTEM"].ToString() != "")
{
model.WATERTEM = decimal.Parse(ds.Rows[0]["WATERTEM"].ToString());
}
if (ds.Rows[0]["CTDTEM"].ToString() != "")
{
model.CTDTEM = decimal.Parse(ds.Rows[0]["CTDTEM"].ToString());
}
if (ds.Rows[0]["SALINITY"].ToString() != "")
{
model.SALINITY = decimal.Parse(ds.Rows[0]["SALINITY"].ToString());
}
if (ds.Rows[0]["CONDUCTIVITY"].ToString() != "")
{
model.CONDUCTIVITY = decimal.Parse(ds.Rows[0]["CONDUCTIVITY"].ToString());
}
if (ds.Rows[0]["OXYGEN"].ToString() != "")
{
model.OXYGEN = decimal.Parse(ds.Rows[0]["OXYGEN"].ToString());
}
if (ds.Rows[0]["PH"].ToString() != "")
{
model.PH = decimal.Parse(ds.Rows[0]["PH"].ToString());
}
if (ds.Rows[0]["TURBIDITY"].ToString() != "")
{
model.TURBIDITY = decimal.Parse(ds.Rows[0]["TURBIDITY"].ToString());
}
if (ds.Rows[0]["YLS"].ToString() != "")
{
model.YLS = decimal.Parse(ds.Rows[0]["YLS"].ToString());
}
if (ds.Rows[0]["YLSTEM"].ToString() != "")
{
model.YLSTEM = decimal.Parse(ds.Rows[0]["YLSTEM"].ToString());
}
if (ds.Rows[0]["UNDERWATERCO2"].ToString() != "")
{
model.UNDERWATERCO2 = decimal.Parse(ds.Rows[0]["UNDERWATERCO2"].ToString());
}
if (ds.Rows[0]["OXYGENCHEMICAL"].ToString() != "")
{
model.OXYGENCHEMICAL = decimal.Parse(ds.Rows[0]["OXYGENCHEMICAL"].ToString());
}
if (ds.Rows[0]["MNO4"].ToString() != "")
{
model.MNO4 = decimal.Parse(ds.Rows[0]["MNO4"].ToString());
}
if (ds.Rows[0]["OXYGENBIOLOGY"].ToString() != "")
{
model.OXYGENBIOLOGY = decimal.Parse(ds.Rows[0]["OXYGENBIOLOGY"].ToString());
}
if (ds.Rows[0]["NH3N"].ToString() != "")
{
model.NH3N = decimal.Parse(ds.Rows[0]["NH3N"].ToString());
}
if (ds.Rows[0]["NO3"].ToString() != "")
{
model.NO3 = decimal.Parse(ds.Rows[0]["NO3"].ToString());
}
if (ds.Rows[0]["NO2"].ToString() != "")
{
model.NO2 = decimal.Parse(ds.Rows[0]["NO2"].ToString());
}
if (ds.Rows[0]["PO4"].ToString() != "")
{
model.PO4 = decimal.Parse(ds.Rows[0]["PO4"].ToString());
}
if (ds.Rows[0]["SIO3"].ToString() != "")
{
model.SIO3 = decimal.Parse(ds.Rows[0]["SIO3"].ToString());
}
if (ds.Rows[0]["PAHS"].ToString() != "")
{
model.PAHS = decimal.Parse(ds.Rows[0]["PAHS"].ToString());
}
if (ds.Rows[0]["P"].ToString() != "")
{
model.P = decimal.Parse(ds.Rows[0]["P"].ToString());
}
if (ds.Rows[0]["N"].ToString() != "")
{
model.N = decimal.Parse(ds.Rows[0]["N"].ToString());
}
if (ds.Rows[0]["C"].ToString() != "")
{
model.C = decimal.Parse(ds.Rows[0]["C"].ToString());
}
if (ds.Rows[0]["S"].ToString() != "")
{
model.S = decimal.Parse(ds.Rows[0]["S"].ToString());
}
if (ds.Rows[0]["ALKALINITY"].ToString() != "")
{
model.ALKALINITY = decimal.Parse(ds.Rows[0]["ALKALINITY"].ToString());
}
if (ds.Rows[0]["SUSPENSION"].ToString() != "")
{
model.SUSPENSION = decimal.Parse(ds.Rows[0]["SUSPENSION"].ToString());
}
if (ds.Rows[0]["CYANIDE"].ToString() != "")
{
model.CYANIDE = decimal.Parse(ds.Rows[0]["CYANIDE"].ToString());
}
if (ds.Rows[0]["HG"].ToString() != "")
{
model.HG = decimal.Parse(ds.Rows[0]["HG"].ToString());
}
if (ds.Rows[0]["CD"].ToString() != "")
{
model.CD = decimal.Parse(ds.Rows[0]["CD"].ToString());
}
if (ds.Rows[0]["CD6"].ToString() != "")
{
model.CD6 = decimal.Parse(ds.Rows[0]["CD6"].ToString());
}
if (ds.Rows[0]["PB"].ToString() != "")
{
model.PB = decimal.Parse(ds.Rows[0]["PB"].ToString());
}
if (ds.Rows[0]["AS"].ToString() != "")
{
model.AS = decimal.Parse(ds.Rows[0]["AS"].ToString());
}
if (ds.Rows[0]["YLSA"].ToString() != "")
{
model.YLSA = decimal.Parse(ds.Rows[0]["YLSA"].ToString());
}
if (ds.Rows[0]["PHYCOCY"].ToString() != "")
{
model.PHYCOCY = decimal.Parse(ds.Rows[0]["PHYCOCY"].ToString());
}
if (ds.Rows[0]["PHYCOER"].ToString() != "")
{
model.PHYCOER = decimal.Parse(ds.Rows[0]["PHYCOER"].ToString());
}
if (ds.Rows[0]["COLIFORM"].ToString() != "")
{
model.COLIFORM = decimal.Parse(ds.Rows[0]["COLIFORM"].ToString());
}
if (ds.Rows[0]["POTENTIAL"].ToString() != "")
{
model.POTENTIAL = decimal.Parse(ds.Rows[0]["POTENTIAL"].ToString());
}
if (ds.Rows[0]["TOTALY"].ToString() != "")
{
model.TOTALY = decimal.Parse(ds.Rows[0]["TOTALY"].ToString());
}
if (ds.Rows[0]["K40"].ToString() != "")
{
model.K40 = decimal.Parse(ds.Rows[0]["K40"].ToString());
}
if (ds.Rows[0]["CS134"].ToString() != "")
{
model.CS134 = decimal.Parse(ds.Rows[0]["CS134"].ToString());
}
if (ds.Rows[0]["CS137"].ToString() != "")
{
model.CS137 = decimal.Parse(ds.Rows[0]["CS137"].ToString());
}
if (ds.Rows[0]["CO60"].ToString() != "")
{
model.CO60 = decimal.Parse(ds.Rows[0]["CO60"].ToString());
}
if (ds.Rows[0]["CU"].ToString() != "")
{
model.CU = decimal.Parse(ds.Rows[0]["CU"].ToString());
}
if (ds.Rows[0]["ZN"].ToString() != "")
{
model.ZN = decimal.Parse(ds.Rows[0]["ZN"].ToString());
}
if (ds.Rows[0]["PHENOL"].ToString() != "")
{
model.PHENOL = decimal.Parse(ds.Rows[0]["PHENOL"].ToString());
}
if (ds.Rows[0]["BOD5"].ToString() != "")
{
model.BOD5 = decimal.Parse(ds.Rows[0]["BOD5"].ToString());
}
if (ds.Rows[0]["ORGANIC"].ToString() != "")
{
model.ORGANIC = decimal.Parse(ds.Rows[0]["ORGANIC"].ToString());
}
if (ds.Rows[0]["DETERGENTS"].ToString() != "")
{
model.DETERGENTS = decimal.Parse(ds.Rows[0]["DETERGENTS"].ToString());
}
if (ds.Rows[0]["OIL"].ToString() != "")
{
model.OIL = decimal.Parse(ds.Rows[0]["OIL"].ToString());
}
if (ds.Rows[0]["VIRUS"].ToString() != "")
{
model.VIRUS = decimal.Parse(ds.Rows[0]["VIRUS"].ToString());
}
if (ds.Rows[0]["PETRO"].ToString() != "")
{
model.PETRO = decimal.Parse(ds.Rows[0]["PETRO"].ToString());
}
if (ds.Rows[0]["DDT"].ToString() != "")
{
model.DDT = decimal.Parse(ds.Rows[0]["DDT"].ToString());
}
if (ds.Rows[0]["PCBS"].ToString() != "")
{
model.PCBS = decimal.Parse(ds.Rows[0]["PCBS"].ToString());
}
if (ds.Rows[0]["BENZOL"].ToString() != "")
{
model.BENZOL = decimal.Parse(ds.Rows[0]["BENZOL"].ToString());
}
if (ds.Rows[0]["CHLO"].ToString() != "")
{
model.CHLO = decimal.Parse(ds.Rows[0]["CHLO"].ToString());
}
if (ds.Rows[0]["ANTIBIOTIC"].ToString() != "")
{
model.ANTIBIOTIC = decimal.Parse(ds.Rows[0]["ANTIBIOTIC"].ToString());
}
if (ds.Rows[0]["POISONA"].ToString() != "")
{
model.POISONA = decimal.Parse(ds.Rows[0]["POISONA"].ToString());
}
if (ds.Rows[0]["POISONB"].ToString() != "")
{
model.POISONB = decimal.Parse(ds.Rows[0]["POISONB"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.TABBUOYECOLOGY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update TABBUOYECOLOGY set ");
strSql.Append(" DEVICECODE = :DEVICECODE , ");
strSql.Append(" DATETIME = :DATETIME , ");
strSql.Append(" SENDNUM = :SENDNUM , ");
strSql.Append(" RECVNUM = :RECVNUM , ");
strSql.Append(" CURRENTTEM = :CURRENTTEM , ");
strSql.Append(" WATERTEM = :WATERTEM , ");
strSql.Append(" CTDTEM = :CTDTEM , ");
strSql.Append(" SALINITY = :SALINITY , ");
strSql.Append(" CONDUCTIVITY = :CONDUCTIVITY , ");
strSql.Append(" OXYGEN = :OXYGEN , ");
strSql.Append(" PH = :PH , ");
strSql.Append(" TURBIDITY = :TURBIDITY , ");
strSql.Append(" YLS = :YLS , ");
strSql.Append(" YLSTEM = :YLSTEM , ");
strSql.Append(" UNDERWATERCO2 = :UNDERWATERCO2 , ");
strSql.Append(" OXYGENCHEMICAL = :OXYGENCHEMICAL , ");
strSql.Append(" MNO4 = :MNO4 , ");
strSql.Append(" OXYGENBIOLOGY = :OXYGENBIOLOGY , ");
strSql.Append(" NH3N = :NH3N , ");
strSql.Append(" NO3 = :NO3 , ");
strSql.Append(" NO2 = :NO2 , ");
strSql.Append(" PO4 = :PO4 , ");
strSql.Append(" SIO3 = :SIO3 , ");
strSql.Append(" PAHS = :PAHS , ");
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(" P = :P , ");
strSql.Append(" N = :N , ");
strSql.Append(" C = :C , ");
strSql.Append(" S = :S , ");
strSql.Append(" ALKALINITY = :ALKALINITY , ");
strSql.Append(" SUSPENSION = :SUSPENSION , ");
strSql.Append(" CYANIDE = :CYANIDE , ");
strSql.Append(" HG = :HG , ");
strSql.Append(" CD = :CD , ");
strSql.Append(" CD6 = :CD6 , ");
strSql.Append(" PB = :PB , ");
strSql.Append(" AS = :AS , ");
strSql.Append(" YLSA = :YLSA , ");
strSql.Append(" PHYCOCY = :PHYCOCY , ");
strSql.Append(" PHYCOER = :PHYCOER , ");
strSql.Append(" COLIFORM = :COLIFORM , ");
strSql.Append(" POTENTIAL = :POTENTIAL , ");
strSql.Append(" TOTALY = :TOTALY , ");
strSql.Append(" K40 = :K40 , ");
strSql.Append(" CS134 = :CS134 , ");
strSql.Append(" CS137 = :CS137 , ");
strSql.Append(" CO60 = :CO60 , ");
strSql.Append(" CU = :CU , ");
strSql.Append(" ZN = :ZN , ");
strSql.Append(" PHENOL = :PHENOL , ");
strSql.Append(" BOD5 = :BOD5 , ");
strSql.Append(" ORGANIC = :ORGANIC , ");
strSql.Append(" DETERGENTS = :DETERGENTS , ");
strSql.Append(" OIL = :OIL , ");
strSql.Append(" VIRUS = :VIRUS , ");
strSql.Append(" PETRO = :PETRO , ");
strSql.Append(" DDT = :DDT , ");
strSql.Append(" PCBS = :PCBS , ");
strSql.Append(" BENZOL = :BENZOL , ");
strSql.Append(" CHLO = :CHLO , ");
strSql.Append(" ANTIBIOTIC = :ANTIBIOTIC , ");
strSql.Append(" POISONA = :POISONA , ");
strSql.Append(" POISONB = :POISONB , ");
strSql.Append(" RESERV10 = :RESERV10 , ");
strSql.Append(" RESERV11 = :RESERV11 , ");
strSql.Append(" RESERV12 = :RESERV12 , ");
strSql.Append(" RESERV13 = :RESERV13 , ");
strSql.Append(" RESERV14 = :RESERV14 , ");
strSql.Append(" RESERV15 = :RESERV15 , ");
strSql.Append(" RESERV16 = :RESERV16 , ");
strSql.Append(" RESERV17 = :RESERV17 , ");
strSql.Append(" RESERV18 = :RESERV18 , ");
strSql.Append(" RESERV19 = :RESERV19 ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DATETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":CURRENTTEM", OracleType.Number, 16),
new OracleParameter(":WATERTEM", OracleType.Number, 16),
new OracleParameter(":CTDTEM", OracleType.Number, 16),
new OracleParameter(":SALINITY", OracleType.Number, 16),
new OracleParameter(":CONDUCTIVITY", OracleType.Number, 16),
new OracleParameter(":OXYGEN", OracleType.Number, 16),
new OracleParameter(":PH", OracleType.Number, 16),
new OracleParameter(":TURBIDITY", OracleType.Number, 16),
new OracleParameter(":YLS", OracleType.Number, 16),
new OracleParameter(":YLSTEM", OracleType.Number, 16),
new OracleParameter(":UNDERWATERCO2", OracleType.Number, 22),
new OracleParameter(":OXYGENCHEMICAL", OracleType.Number, 16),
new OracleParameter(":MNO4", OracleType.Number, 16),
new OracleParameter(":OXYGENBIOLOGY", OracleType.Number, 16),
new OracleParameter(":NH3N", OracleType.Number, 16),
new OracleParameter(":NO3", OracleType.Number, 16),
new OracleParameter(":NO2", OracleType.Number, 16),
new OracleParameter(":PO4", OracleType.Number, 16),
new OracleParameter(":SIO3", OracleType.Number, 16),
new OracleParameter(":PAHS", OracleType.Number, 16),
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),
new OracleParameter(":P", OracleType.Number, 16),
new OracleParameter(":N", OracleType.Number, 16),
new OracleParameter(":C", OracleType.Number, 16),
new OracleParameter(":S", OracleType.Number, 16),
new OracleParameter(":ALKALINITY", OracleType.Number, 16),
new OracleParameter(":SUSPENSION", OracleType.Number, 16),
new OracleParameter(":CYANIDE", OracleType.Number, 16),
new OracleParameter(":HG", OracleType.Number, 16),
new OracleParameter(":CD", OracleType.Number, 16),
new OracleParameter(":CD6", OracleType.Number, 16),
new OracleParameter(":PB", OracleType.Number, 16),
new OracleParameter(":AS", OracleType.Number, 16),
new OracleParameter(":YLSA", OracleType.Number, 16),
new OracleParameter(":PHYCOCY", OracleType.Number, 16),
new OracleParameter(":PHYCOER", OracleType.Number, 16),
new OracleParameter(":COLIFORM", OracleType.Number, 16),
new OracleParameter(":POTENTIAL", OracleType.Number, 16),
new OracleParameter(":TOTALY", OracleType.Number, 16),
new OracleParameter(":K40", OracleType.Number, 16),
new OracleParameter(":CS134", OracleType.Number, 16),
new OracleParameter(":CS137", OracleType.Number, 16),
new OracleParameter(":CO60", OracleType.Number, 16),
new OracleParameter(":CU", OracleType.Number, 16),
new OracleParameter(":ZN", OracleType.Number, 16),
new OracleParameter(":PHENOL", OracleType.Number, 16),
new OracleParameter(":BOD5", OracleType.Number, 16),
new OracleParameter(":ORGANIC", OracleType.Number, 16),
new OracleParameter(":DETERGENTS", OracleType.Number, 16),
new OracleParameter(":OIL", OracleType.Number, 16),
new OracleParameter(":VIRUS", OracleType.Number, 22),
new OracleParameter(":PETRO", OracleType.Number, 16),
new OracleParameter(":DDT", OracleType.Number, 16),
new OracleParameter(":PCBS", OracleType.Number, 16),
new OracleParameter(":BENZOL", OracleType.Number, 16),
new OracleParameter(":CHLO", OracleType.Number, 16),
new OracleParameter(":ANTIBIOTIC", OracleType.Number, 16),
new OracleParameter(":POISONA", OracleType.Number, 16),
new OracleParameter(":POISONB", OracleType.Number, 16),
new OracleParameter(":RESERV10", OracleType.Number, 16),
new OracleParameter(":RESERV11", OracleType.Number, 16),
new OracleParameter(":RESERV12", OracleType.Number, 16),
new OracleParameter(":RESERV13", OracleType.Number, 16),
new OracleParameter(":RESERV14", OracleType.Number, 16),
new OracleParameter(":RESERV15", OracleType.Number, 16),
new OracleParameter(":RESERV16", OracleType.Number, 16),
new OracleParameter(":RESERV17", OracleType.Number, 16),
new OracleParameter(":RESERV18", OracleType.Number, 16),
new OracleParameter(":RESERV19", OracleType.Number, 16)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.CURRENTTEM;
parameters[5].Value = model.WATERTEM;
parameters[6].Value = model.CTDTEM;
parameters[7].Value = model.SALINITY;
parameters[8].Value = model.CONDUCTIVITY;
parameters[9].Value = model.OXYGEN;
parameters[10].Value = model.PH;
parameters[11].Value = model.TURBIDITY;
parameters[12].Value = model.YLS;
parameters[13].Value = model.YLSTEM;
parameters[14].Value = model.UNDERWATERCO2;
parameters[15].Value = model.OXYGENCHEMICAL;
parameters[16].Value = model.MNO4;
parameters[17].Value = model.OXYGENBIOLOGY;
parameters[18].Value = model.NH3N;
parameters[19].Value = model.NO3;
parameters[20].Value = model.NO2;
parameters[21].Value = model.PO4;
parameters[22].Value = model.SIO3;
parameters[23].Value = model.PAHS;
parameters[24].Value = model.RESERV0;
parameters[25].Value = model.RESERV1;
parameters[26].Value = model.RESERV2;
parameters[27].Value = model.RESERV3;
parameters[28].Value = model.RESERV4;
parameters[29].Value = model.RESERV5;
parameters[30].Value = model.RESERV6;
parameters[31].Value = model.RESERV7;
parameters[32].Value = model.RESERV8;
parameters[33].Value = model.RESERV9;
parameters[34].Value = model.P;
parameters[35].Value = model.N;
parameters[36].Value = model.C;
parameters[37].Value = model.S;
parameters[38].Value = model.ALKALINITY;
parameters[39].Value = model.SUSPENSION;
parameters[40].Value = model.CYANIDE;
parameters[41].Value = model.HG;
parameters[42].Value = model.CD;
parameters[43].Value = model.CD6;
parameters[44].Value = model.PB;
parameters[45].Value = model.AS;
parameters[46].Value = model.YLSA;
parameters[47].Value = model.PHYCOCY;
parameters[48].Value = model.PHYCOER;
parameters[49].Value = model.COLIFORM;
parameters[50].Value = model.POTENTIAL;
parameters[51].Value = model.TOTALY;
parameters[52].Value = model.K40;
parameters[53].Value = model.CS134;
parameters[54].Value = model.CS137;
parameters[55].Value = model.CO60;
parameters[56].Value = model.CU;
parameters[57].Value = model.ZN;
parameters[58].Value = model.PHENOL;
parameters[59].Value = model.BOD5;
parameters[60].Value = model.ORGANIC;
parameters[61].Value = model.DETERGENTS;
parameters[62].Value = model.OIL;
parameters[63].Value = model.VIRUS;
parameters[64].Value = model.PETRO;
parameters[65].Value = model.DDT;
parameters[66].Value = model.PCBS;
parameters[67].Value = model.BENZOL;
parameters[68].Value = model.CHLO;
parameters[69].Value = model.ANTIBIOTIC;
parameters[70].Value = model.POISONA;
parameters[71].Value = model.POISONB;
parameters[72].Value = model.RESERV10;
parameters[73].Value = model.RESERV11;
parameters[74].Value = model.RESERV12;
parameters[75].Value = model.RESERV13;
parameters[76].Value = model.RESERV14;
parameters[77].Value = model.RESERV15;
parameters[78].Value = model.RESERV16;
parameters[79].Value = model.RESERV17;
parameters[80].Value = model.RESERV18;
parameters[81].Value = model.RESERV19;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
