/// <summary>
/// 删除一条数据
/// </summary>
public ReturnResult DeleteRole(string F_ROLECODE)
{
ReturnResult result = new ReturnResult();
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
try
{
dbHelper.OpenConn("");
dbHelper.OpenTrans();
strSql.Append("delete from ROLEINFO ");
strSql.Append(" where F_ROLECODE=:F_ROLECODE ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(F_ROLECODE))
};
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
strSql.Clear();
strSql.Append("delete from ROLEFUNCTION ");
strSql.Append(" where F_ROLECODE=:F_ROLECODE ");
OracleParameter[] parameters1 =
{
new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(F_ROLECODE))
};
int rows1 = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters1);
if (rows1 <= 0)
{
goto Over;
}
result.success = true;
result.Message = "操作成功";
dbHelper.CommitTrans();
dbHelper.CloseConn();
return(result);
}
else
{
goto Over;
}
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(ROLEINFO_BN), "DeleteRole 程序段的异常" + ex);
goto Over;
}
Over:
result.success = false;
result.Message = "操作失败";
dbHelper.RollBack();
dbHelper.CloseConn();
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(USERROLE model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update USERROLE set ");
strSql.Append(" F_ID = :F_ID , ");
strSql.Append(" F_ACCOUNT = :F_ACCOUNT , ");
strSql.Append(" F_ROLECODE = :F_ROLECODE ");
strSql.Append(" where F_ID=:F_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ID", OracleType.VarChar, 36),
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":F_ROLECODE", OracleType.VarChar, 36)
};
parameters[0].Value = model.F_ID;
parameters[1].Value = model.F_ACCOUNT;
parameters[2].Value = model.F_ROLECODE;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.DEVICEATTACH model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into DEVICEATTACH(");
strSql.Append("DEVICECODE,SEAAREA,PROVINCE,BAY,BUREAUDEVICE,LOCALDEVICE,SERVICE");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:SEAAREA,:PROVINCE,:BAY,:BUREAUDEVICE,:LOCALDEVICE,:SERVICE");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":SEAAREA", OracleType.VarChar, 50),
new OracleParameter(":PROVINCE", OracleType.VarChar, 50),
new OracleParameter(":BAY", OracleType.VarChar, 50),
new OracleParameter(":BUREAUDEVICE", OracleType.VarChar, 50),
new OracleParameter(":LOCALDEVICE", OracleType.VarChar, 50),
new OracleParameter(":SERVICE", OracleType.VarChar, 50)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.SEAAREA;
parameters[2].Value = model.PROVINCE;
parameters[3].Value = model.BAY;
parameters[4].Value = model.BUREAUDEVICE;
parameters[5].Value = model.LOCALDEVICE;
parameters[6].Value = model.SERVICE;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="roleinfo">角色实体类</param>
/// <returns>是否成功</returns>
public bool EditRoleMain(ROLEINFO roleinfo)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("UPDATE ROLEINFO SET F_NAME=:F_NAME,F_DESCRIPTION=:F_DESCRIPTION WHERE F_ROLECODE=:F_ROLECODE");
OracleParameter[] parms =
{
new OracleParameter("F_NAME", roleinfo.F_NAME),
new OracleParameter("F_DESCRIPTION", roleinfo.F_DESCRIPTION),
new OracleParameter("F_ROLECODE", roleinfo.F_ROLECODE)
};
try
{
dbHelper.OpenConn("");
var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms);
dbHelper.CloseConn();
return(rstInt > 0);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(ROLEINFO_BN), "修改角色EditRoleMain 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.FUNCTIONINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into FUNCTIONINFO(");
strSql.Append("F_FUNCTIONCODE,F_NAME,F_DESCRIPTION,F_CAPTION,F_PRIORITY,F_PARENTID,URL");
strSql.Append(") values (");
strSql.Append(":F_FUNCTIONCODE,:F_NAME,:F_DESCRIPTION,:F_CAPTION,:F_PRIORITY,:F_PARENTID,:URL");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":F_FUNCTIONCODE", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.NVarChar),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar),
new OracleParameter(":F_CAPTION", OracleType.NVarChar),
new OracleParameter(":F_PRIORITY", OracleType.Number, 22),
new OracleParameter(":F_PARENTID", OracleType.VarChar, 36),
new OracleParameter(":URL", OracleType.NVarChar)
};
parameters[0].Value = model.F_FUNCTIONCODE;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_DESCRIPTION;
parameters[3].Value = model.F_CAPTION;
parameters[4].Value = model.F_PRIORITY;
parameters[5].Value = model.F_PARENTID;
parameters[6].Value = model.URL;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.DEPARTMENTINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into DEPARTMENTINFO(");
strSql.Append("F_DEPARTMENTCODE,F_NAME,F_DESCRIPTION,F_PARENT");
strSql.Append(") values (");
strSql.Append(":F_DEPARTMENTCODE,:F_NAME,:F_DESCRIPTION,:F_PARENT");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":F_DEPARTMENTCODE", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.NVarChar),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar),
new OracleParameter(":F_PARENT", OracleType.VarChar, 36)
};
parameters[0].Value = model.F_DEPARTMENTCODE;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_DESCRIPTION;
parameters[3].Value = model.F_PARENT;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="roleinfo">角色实体类</param>
/// <returns>是否成功</returns>
public bool AddRoleMain(ROLEINFO roleinfo)
{
var strSql = new StringBuilder();
var dbHelper = new DbAPI();
strSql.Append("INSERT INTO ROLEINFO(F_ROLECODE, F_NAME, F_DESCRIPTION)VALUES(SYS_GUID(),:F_NAME,:F_DESCRIPTION)");
OracleParameter[] parms =
{
new OracleParameter("F_NAME", roleinfo.F_NAME),
new OracleParameter("F_DESCRIPTION", roleinfo.F_DESCRIPTION ?? "")
};
try
{
dbHelper.OpenConn("");
var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms);
dbHelper.CloseConn();
return(rstInt > 0);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(ROLEINFO_BN), "新增角色AddRoleMain 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 修改部门
/// </summary>
/// <param name="deptName">部门名称</param>
/// <param name="id">部门ID</param>
/// <returns>是否成功的JSON结果</returns>
public bool UpdateDepartment(string deptName, string id)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update departmentinfo set f_name=:deptName where f_departmentcode=:id");
OracleParameter[] parms =
{
new OracleParameter("deptName", deptName),
new OracleParameter("id", id)
};
try
{
dbHelper.OpenConn("");
var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms);
dbHelper.CloseConn();
return(rstInt > 0);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(DEPARTMENTINFO_BN), "修改部门AddDepartment 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 新增部门
/// </summary>
/// <param name="deptName">部门名称</param>
/// <param name="pid">父节点ID</param>
public bool AddDepartment(string deptName, string pid)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into departmentinfo(f_departmentcode, f_name, f_description, f_parent)values((SELECT TO_CHAR(MAX(TO_NUMBER(f_departmentcode))+1) FROM departmentinfo),:deptName,'',:pid)");
OracleParameter[] parms =
{
new OracleParameter("deptName", deptName),
new OracleParameter("pid", pid)
};
try
{
dbHelper.OpenConn("");
var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms);
dbHelper.CloseConn();
return(rstInt > 0);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(DEPARTMENTINFO_BN), "新增部门AddDepartment 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.TABDICTIONARY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update TABDICTIONARY set ");
strSql.Append(" DICTIONARYID = :DICTIONARYID , ");
strSql.Append(" CONTENT = :CONTENT , ");
strSql.Append(" BEIZHU = :BEIZHU ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DICTIONARYID", OracleType.NVarChar),
new OracleParameter(":CONTENT", OracleType.NVarChar),
new OracleParameter(":BEIZHU", OracleType.NVarChar)
};
parameters[0].Value = model.DICTIONARYID;
parameters[1].Value = model.CONTENT;
parameters[2].Value = model.BEIZHU;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string F_ID)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("delete from USERROLE ");
strSql.Append(" where F_ID=:F_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ID", OracleType.VarChar, 36)
};
parameters[0].Value = F_ID;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.ROLEINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update ROLEINFO set ");
strSql.Append(" F_ROLECODE = :F_ROLECODE , ");
strSql.Append(" F_NAME = :F_NAME , ");
strSql.Append(" F_DESCRIPTION = :F_DESCRIPTION ");
strSql.Append(" where F_ROLECODE=:F_ROLECODE ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ROLECODE", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.NVarChar),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar)
};
parameters[0].Value = model.F_ROLECODE;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_DESCRIPTION;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.USERINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update USERINFO set ");
strSql.Append(" F_ACCOUNT = :F_ACCOUNT , ");
strSql.Append(" F_NAME = :F_NAME , ");
strSql.Append(" F_PASSWORD = :F_PASSWORD , ");
strSql.Append(" F_EMAIL = :F_EMAIL , ");
strSql.Append(" F_PHONE = :F_PHONE , ");
strSql.Append(" F_TEL = :F_TEL , ");
strSql.Append(" F_DESCRIPTION = :F_DESCRIPTION , ");
strSql.Append(" F_PHOTO = :F_PHOTO , ");
strSql.Append(" F_ADDRESS = :F_ADDRESS , ");
strSql.Append(" F_REALNAME = :F_REALNAME ");
strSql.Append(" where F_ACCOUNT=:F_ACCOUNT ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.VarChar, 64),
new OracleParameter(":F_PASSWORD", OracleType.VarChar, 128),
new OracleParameter(":F_EMAIL", OracleType.VarChar, 128),
new OracleParameter(":F_PHONE", OracleType.VarChar, 16),
new OracleParameter(":F_TEL", OracleType.VarChar, 16),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar),
new OracleParameter(":F_PHOTO", OracleType.Blob),
new OracleParameter(":F_ADDRESS", OracleType.NVarChar),
new OracleParameter(":F_REALNAME", OracleType.NVarChar)
};
parameters[0].Value = model.F_ACCOUNT;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_PASSWORD;
parameters[3].Value = model.F_EMAIL;
parameters[4].Value = model.F_PHONE;
parameters[5].Value = model.F_TEL;
parameters[6].Value = model.F_DESCRIPTION;
parameters[7].Value = model.F_PHOTO;
parameters[8].Value = model.F_ADDRESS;
parameters[9].Value = model.F_REALNAME;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABBUOYSTATUS model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABBUOYSTATUS(");
strSql.Append("DEVICECODE,DATETIME,SENDNUM,RECVNUM,LON,LAT,AZIMUTH,VOLTAGE,ANCHOR,WATERALARM,DOORALARM,GPSALARM,FREEMEMO,SENSERSTATUS,RESERV0,RESERV1,RESERV2,BUOYSTATUS");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DATETIME,:SENDNUM,:RECVNUM,:LON,:LAT,:AZIMUTH,:VOLTAGE,:ANCHOR,:WATERALARM,:DOORALARM,:GPSALARM,:FREEMEMO,:SENSERSTATUS,:RESERV0,:RESERV1,:RESERV2,:BUOYSTATUS");
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(":LON", OracleType.Number, 16),
new OracleParameter(":LAT", OracleType.Number, 16),
new OracleParameter(":AZIMUTH", OracleType.Number, 22),
new OracleParameter(":VOLTAGE", OracleType.Number, 16),
new OracleParameter(":ANCHOR", OracleType.Number, 22),
new OracleParameter(":WATERALARM", OracleType.Number, 22),
new OracleParameter(":DOORALARM", OracleType.Number, 22),
new OracleParameter(":GPSALARM", OracleType.Number, 22),
new OracleParameter(":FREEMEMO", OracleType.Number, 22),
new OracleParameter(":SENSERSTATUS", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":BUOYSTATUS", OracleType.Number, 22)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.LON;
parameters[5].Value = model.LAT;
parameters[6].Value = model.AZIMUTH;
parameters[7].Value = model.VOLTAGE;
parameters[8].Value = model.ANCHOR;
parameters[9].Value = model.WATERALARM;
parameters[10].Value = model.DOORALARM;
parameters[11].Value = model.GPSALARM;
parameters[12].Value = model.FREEMEMO;
parameters[13].Value = model.SENSERSTATUS;
parameters[14].Value = model.RESERV0;
parameters[15].Value = model.RESERV1;
parameters[16].Value = model.RESERV2;
parameters[17].Value = model.BUOYSTATUS;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.DEVICEINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into DEVICEINFO(");
strSql.Append("DEVICECODE,DEVICENAME,DEVICEUSER,DEVICETYPE,LAYTIME,ELON,ELAT,COMTYPE,STRUCTTYPE,COMARRAY,PACKNUM,RUNNINGSTATUS,POSITION,PRODUCER,MANAGER,RESERV0,RESERV1,RESERV2");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DEVICENAME,:DEVICEUSER,:DEVICETYPE,:LAYTIME,:ELON,:ELAT,:COMTYPE,:STRUCTTYPE,:COMARRAY,:PACKNUM,:RUNNINGSTATUS,:POSITION,:PRODUCER,:MANAGER,:RESERV0,:RESERV1,:RESERV2");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DEVICENAME", OracleType.VarChar, 20),
new OracleParameter(":DEVICEUSER", OracleType.VarChar, 30),
new OracleParameter(":DEVICETYPE", OracleType.Number, 22),
new OracleParameter(":LAYTIME", OracleType.DateTime),
new OracleParameter(":ELON", OracleType.Number, 16),
new OracleParameter(":ELAT", OracleType.Number, 16),
new OracleParameter(":COMTYPE", OracleType.VarChar, 50),
new OracleParameter(":STRUCTTYPE", OracleType.Number, 22),
new OracleParameter(":COMARRAY", OracleType.Blob),
new OracleParameter(":PACKNUM", OracleType.Number, 22),
new OracleParameter(":RUNNINGSTATUS", OracleType.Number, 22),
new OracleParameter(":POSITION", OracleType.VarChar, 20),
new OracleParameter(":PRODUCER", OracleType.VarChar, 30),
new OracleParameter(":MANAGER", OracleType.VarChar, 30),
new OracleParameter(":RESERV0", OracleType.VarChar, 50),
new OracleParameter(":RESERV1", OracleType.VarChar, 50),
new OracleParameter(":RESERV2", OracleType.VarChar, 50)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DEVICENAME;
parameters[2].Value = model.DEVICEUSER;
parameters[3].Value = model.DEVICETYPE;
parameters[4].Value = model.LAYTIME;
parameters[5].Value = model.ELON;
parameters[6].Value = model.ELAT;
parameters[7].Value = model.COMTYPE;
parameters[8].Value = model.STRUCTTYPE;
parameters[9].Value = model.COMARRAY;
parameters[10].Value = model.PACKNUM;
parameters[11].Value = model.RUNNINGSTATUS;
parameters[12].Value = model.POSITION;
parameters[13].Value = model.PRODUCER;
parameters[14].Value = model.MANAGER;
parameters[15].Value = model.RESERV0;
parameters[16].Value = model.RESERV1;
parameters[17].Value = model.RESERV2;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Entity.SYSTEMLOG model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into SYSTEMLOG(");
strSql.Append("LOG_ID,LOGNAME,TYPE,CONTENT,F_ACCOUNT,REMARK,DATETIME");
strSql.Append(") values (");
strSql.Append(":LOG_ID,:LOGNAME,:TYPE,:CONTENT,:F_ACCOUNT,:REMARK,:DATETIME");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":LOG_ID", OracleType.VarChar, 36),
new OracleParameter(":LOGNAME", OracleType.VarChar, 256),
new OracleParameter(":TYPE", OracleType.VarChar, 36),
new OracleParameter(":CONTENT", OracleType.VarChar, 1000),
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":REMARK", OracleType.VarChar, 128),
new OracleParameter(":DATETIME", OracleType.DateTime)
};
parameters[0].Value = dbHelper.GUID();
parameters[1].Value = model.LOGNAME;
parameters[2].Value = model.TYPE;
parameters[3].Value = model.CONTENT;
parameters[4].Value = model.F_ACCOUNT;
parameters[5].Value = model.REMARK;
parameters[6].Value = model.DATETIME;
try
{
dbHelper.OpenConn("");
int result = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
dbHelper.CloseConn();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(SYSTEMLOG_BN), "Add 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABSTATUS model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABSTATUS(");
strSql.Append("DEVICECODE,DATETIME,SENDNUM,RECVNUM,TEMPERATURE,POWERSTATUS,FREEMEMO,WATERALARM,DOORALARM,SMOGALARM,STATIONSTATUS,RESERV0,RESERV1,RESERV2,HUMI");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DATETIME,:SENDNUM,:RECVNUM,:TEMPERATURE,:POWERSTATUS,:FREEMEMO,:WATERALARM,:DOORALARM,:SMOGALARM,,:STATIONSTATUS,:RESERV0,:RESERV1,:RESERV2,:HUMI");
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(":TEMPERATURE", OracleType.Number, 16),
new OracleParameter(":POWERSTATUS", OracleType.Number, 22),
new OracleParameter(":FREEMEMO", OracleType.Number, 22),
new OracleParameter(":WATERALARM", OracleType.Number, 22),
new OracleParameter(":DOORALARM", OracleType.Number, 22),
new OracleParameter(":SMOGALARM", OracleType.Number, 22),
//new OracleParameter(":SENSERSTATUS", OracleType.Number,22) ,
new OracleParameter(":STATIONSTATUS", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":HUMI", OracleType.Number, 22)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.TEMPERATURE;
parameters[5].Value = model.POWERSTATUS;
parameters[6].Value = model.FREEMEMO;
parameters[7].Value = model.WATERALARM;
parameters[8].Value = model.DOORALARM;
parameters[9].Value = model.SMOGALARM;
//parameters[10].Value = model.SENSERSTATUS;
parameters[11].Value = model.STATIONSTATUS;
parameters[12].Value = model.RESERV0;
parameters[13].Value = model.RESERV1;
parameters[14].Value = model.RESERV2;
parameters[15].Value = model.HUMI;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.DEVICEATTACH model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update DEVICEATTACH set ");
strSql.Append(" DEVICECODE = :DEVICECODE , ");
strSql.Append(" SEAAREA = :SEAAREA , ");
strSql.Append(" PROVINCE = :PROVINCE , ");
strSql.Append(" BAY = :BAY , ");
strSql.Append(" BUREAUDEVICE = :BUREAUDEVICE , ");
strSql.Append(" LOCALDEVICE = :LOCALDEVICE , ");
strSql.Append(" SERVICE = :SERVICE ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":SEAAREA", OracleType.VarChar, 50),
new OracleParameter(":PROVINCE", OracleType.VarChar, 50),
new OracleParameter(":BAY", OracleType.VarChar, 50),
new OracleParameter(":BUREAUDEVICE", OracleType.VarChar, 50),
new OracleParameter(":LOCALDEVICE", OracleType.VarChar, 50),
new OracleParameter(":SERVICE", OracleType.VarChar, 50)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.SEAAREA;
parameters[2].Value = model.PROVINCE;
parameters[3].Value = model.BAY;
parameters[4].Value = model.BUREAUDEVICE;
parameters[5].Value = model.LOCALDEVICE;
parameters[6].Value = model.SERVICE;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.SYSTEMLOG model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update SYSTEMLOG set ");
strSql.Append(" LOG_ID = :LOG_ID , ");
strSql.Append(" LOGNAME = :LOGNAME , ");
strSql.Append(" TYPE = :TYPE , ");
strSql.Append(" CONTENT = :CONTENT , ");
strSql.Append(" F_ACCOUNT = :F_ACCOUNT , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" DATETIME = :DATETIME ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":LOG_ID", OracleType.VarChar, 36),
new OracleParameter(":LOGNAME", OracleType.VarChar, 256),
new OracleParameter(":TYPE", OracleType.VarChar, 36),
new OracleParameter(":CONTENT", OracleType.VarChar, 1000),
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":REMARK", OracleType.VarChar, 128),
new OracleParameter(":DATETIME", OracleType.DateTime)
};
parameters[0].Value = model.LOG_ID;
parameters[1].Value = model.LOGNAME;
parameters[2].Value = model.TYPE;
parameters[3].Value = model.CONTENT;
parameters[4].Value = model.F_ACCOUNT;
parameters[5].Value = model.REMARK;
parameters[6].Value = model.DATETIME;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.FUNCTIONINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update FUNCTIONINFO set ");
strSql.Append(" F_FUNCTIONCODE = :F_FUNCTIONCODE , ");
strSql.Append(" F_NAME = :F_NAME , ");
strSql.Append(" F_DESCRIPTION = :F_DESCRIPTION , ");
strSql.Append(" F_CAPTION = :F_CAPTION , ");
strSql.Append(" F_PRIORITY = :F_PRIORITY , ");
strSql.Append(" F_PARENTID = :F_PARENTID , ");
strSql.Append(" URL = :URL ");
strSql.Append(" where F_FUNCTIONCODE=:F_FUNCTIONCODE ");
OracleParameter[] parameters =
{
new OracleParameter(":F_FUNCTIONCODE", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.NVarChar),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar),
new OracleParameter(":F_CAPTION", OracleType.NVarChar),
new OracleParameter(":F_PRIORITY", OracleType.Number, 22),
new OracleParameter(":F_PARENTID", OracleType.VarChar, 36),
new OracleParameter(":URL", OracleType.NVarChar)
};
parameters[0].Value = model.F_FUNCTIONCODE;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_DESCRIPTION;
parameters[3].Value = model.F_CAPTION;
parameters[4].Value = model.F_PRIORITY;
parameters[5].Value = model.F_PARENTID;
parameters[6].Value = model.URL;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Exists()
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("select count(1) from DEVICEATTACH");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
if (dbHelper.ExecuteNonQuery(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete()
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("delete from DEVICEATTACH ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(USERROLE model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into USERROLE(");
strSql.Append("F_ID,F_ACCOUNT,F_ROLECODE");
strSql.Append(") values (");
strSql.Append(":F_ID,:F_ACCOUNT,:F_ROLECODE");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ID", OracleType.VarChar, 36),
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":F_ROLECODE", OracleType.VarChar, 36)
};
parameters[0].Value = model.F_ID;
parameters[1].Value = model.F_ACCOUNT;
parameters[2].Value = model.F_ROLECODE;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABDICTIONARY model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABDICTIONARY(");
strSql.Append("DICTIONARYID,CONTENT,BEIZHU");
strSql.Append(") values (");
strSql.Append(":DICTIONARYID,:CONTENT,:BEIZHU");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DICTIONARYID", OracleType.NVarChar),
new OracleParameter(":CONTENT", OracleType.NVarChar),
new OracleParameter(":BEIZHU", OracleType.NVarChar)
};
parameters[0].Value = model.DICTIONARYID;
parameters[1].Value = model.CONTENT;
parameters[2].Value = model.BEIZHU;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
public bool Exists(string F_ID)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("select count(1) from USERROLE");
strSql.Append(" where ");
strSql.Append(" F_ID = :F_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ID", OracleType.VarChar, 36)
};
parameters[0].Value = F_ID;
if (dbHelper.ExecuteNonQuery(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.USERINFO model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into USERINFO(");
strSql.Append("F_ACCOUNT,F_NAME,F_PASSWORD,F_EMAIL,F_PHONE,F_TEL,F_DESCRIPTION,F_PHOTO,F_ADDRESS,F_REALNAME");
strSql.Append(") values (");
strSql.Append(":F_ACCOUNT,:F_NAME,:F_PASSWORD,:F_EMAIL,:F_PHONE,:F_TEL,:F_DESCRIPTION,:F_PHOTO,:F_ADDRESS,:F_REALNAME");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36),
new OracleParameter(":F_NAME", OracleType.VarChar, 64),
new OracleParameter(":F_PASSWORD", OracleType.VarChar, 128),
new OracleParameter(":F_EMAIL", OracleType.VarChar, 128),
new OracleParameter(":F_PHONE", OracleType.VarChar, 16),
new OracleParameter(":F_TEL", OracleType.VarChar, 16),
new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar),
new OracleParameter(":F_PHOTO", OracleType.Blob),
new OracleParameter(":F_ADDRESS", OracleType.NVarChar),
new OracleParameter(":F_REALNAME", OracleType.NVarChar)
};
parameters[0].Value = model.F_ACCOUNT;
parameters[1].Value = model.F_NAME;
parameters[2].Value = model.F_PASSWORD;
parameters[3].Value = model.F_EMAIL;
parameters[4].Value = model.F_PHONE;
parameters[5].Value = model.F_TEL;
parameters[6].Value = model.F_DESCRIPTION;
parameters[7].Value = model.F_PHOTO;
parameters[8].Value = model.F_ADDRESS;
parameters[9].Value = model.F_REALNAME;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <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 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);
}
}
/// <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);
}
}
/// <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);
}
