/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.T_PUB_SENSOR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.T_PUB_SENSOR SET ");
strSql.Append("SENSOR_NAME=@in_SENSOR_NAME,");
strSql.Append("SENSOR_STKNAME=@in_SENSOR_STKNAME,");
strSql.Append("SAT_ID=@in_SAT_ID,");
strSql.Append("SAT_STKNAME=@in_SAT_STKNAME,");
strSql.Append("SENSOR_TYPE=@in_SENSOR_TYPE,");
strSql.Append("SENSOR_PARONE=@in_SENSOR_PARONE,");
strSql.Append("SENSOR_PARTWO=@in_SENSOR_PARTWO,");
strSql.Append("SENSOR_PARTHREE=@in_SENSOR_PARTHREE,");
strSql.Append("SENSOR_PARFOUR=@in_SENSOR_PARFOUR,");
strSql.Append("TYPEID=@in_TYPEID,");
strSql.Append("SATTYPE=@in_SATTYPE,");
strSql.Append("SENSORANGLE=@in_SENSORANGLE,");
strSql.Append("SENSORANGLEH=@in_SENSORANGLEH");
strSql.Append(" WHERE SENSOR_ID=@in_SENSOR_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SENSOR_ID", DbType.Decimal),
new SqlParameter("@in_SENSOR_NAME", DbType.AnsiString),
new SqlParameter("@in_SENSOR_STKNAME", DbType.AnsiString),
new SqlParameter("@in_SAT_ID", DbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", DbType.AnsiString),
new SqlParameter("@in_SENSOR_TYPE", DbType.AnsiString),
new SqlParameter("@in_SENSOR_PARONE", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARTWO", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARTHREE", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARFOUR", DbType.Decimal),
new SqlParameter("@in_TYPEID", DbType.Decimal),
new SqlParameter("@in_SATTYPE", DbType.Decimal),
new SqlParameter("@in_SENSORANGLE", DbType.Decimal),
new SqlParameter("@in_SENSORANGLEH", DbType.Decimal)
};
cmdParms[0].Value = model.SENSOR_ID;
cmdParms[1].Value = model.SENSOR_NAME;
cmdParms[2].Value = model.SENSOR_STKNAME;
cmdParms[3].Value = model.SAT_ID;
cmdParms[4].Value = model.SAT_STKNAME;
cmdParms[5].Value = model.SENSOR_TYPE;
cmdParms[6].Value = model.SENSOR_PARONE;
cmdParms[7].Value = model.SENSOR_PARTWO;
cmdParms[8].Value = model.SENSOR_PARTHREE;
cmdParms[9].Value = model.SENSOR_PARFOUR;
cmdParms[10].Value = model.TYPEID;
cmdParms[11].Value = model.SATTYPE;
cmdParms[12].Value = model.SENSORANGLE;
cmdParms[13].Value = model.SENSORANGLEH;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.T_PUB_SENSOR GetModel(DbDataReader dr)
{
Model.T_PUB_SENSOR model = new Model.T_PUB_SENSOR();
model.SENSOR_ID = Convert.ToDecimal(dr["SENSOR_ID"]);
model.SENSOR_NAME = Convert.ToString(dr["SENSOR_NAME"]);
model.SENSOR_STKNAME = Convert.ToString(dr["SENSOR_STKNAME"]);
model.SAT_ID = Convert.ToDecimal(dr["SAT_ID"]);
model.SAT_STKNAME = Convert.ToString(dr["SAT_STKNAME"]);
model.SENSOR_TYPE = Convert.ToString(dr["SENSOR_TYPE"]);
model.SENSOR_PARONE = Convert.ToDecimal(dr["SENSOR_PARONE"]);
model.SENSOR_PARTWO = Convert.ToDecimal(dr["SENSOR_PARTWO"]);
model.SENSOR_PARTHREE = Convert.ToDecimal(dr["SENSOR_PARTHREE"]);
model.SENSOR_PARFOUR = Convert.ToDecimal(dr["SENSOR_PARFOUR"]);
model.TYPEID = Convert.ToDecimal(dr["TYPEID"]);
model.SATTYPE = Convert.ToDecimal(dr["SATTYPE"]);
model.SENSORANGLE = Convert.ToDecimal(dr["SENSORANGLE"]);
model.SENSORANGLEH = Convert.ToDecimal(dr["SENSORANGLEH"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.T_PUB_SENSOR GetModel(decimal SENSOR_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM LHF.T_PUB_SENSOR ");
strSql.Append(" WHERE SENSOR_ID=@in_SENSOR_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SENSOR_ID", DbType.Decimal)
};
cmdParms[0].Value = SENSOR_ID;
Model.T_PUB_SENSOR model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString(), cmdParms))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.T_PUB_SENSOR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.T_PUB_SENSOR(");
strSql.Append("SENSOR_ID,SENSOR_NAME,SENSOR_STKNAME,SAT_ID,SAT_STKNAME,SENSOR_TYPE,SENSOR_PARONE,SENSOR_PARTWO,SENSOR_PARTHREE,SENSOR_PARFOUR,TYPEID,SATTYPE,SENSORANGLE,SENSORANGLEH)");
strSql.Append(" VALUES (");
strSql.Append("@in_SENSOR_ID,@in_SENSOR_NAME,@in_SENSOR_STKNAME,@in_SAT_ID,@in_SAT_STKNAME,@in_SENSOR_TYPE,@in_SENSOR_PARONE,@in_SENSOR_PARTWO,@in_SENSOR_PARTHREE,@in_SENSOR_PARFOUR,@in_TYPEID,@in_SATTYPE,@in_SENSORANGLE,@in_SENSORANGLEH)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SENSOR_ID", DbType.Decimal),
new SqlParameter("@in_SENSOR_NAME", DbType.AnsiString),
new SqlParameter("@in_SENSOR_STKNAME", DbType.AnsiString),
new SqlParameter("@in_SAT_ID", DbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", DbType.AnsiString),
new SqlParameter("@in_SENSOR_TYPE", DbType.AnsiString),
new SqlParameter("@in_SENSOR_PARONE", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARTWO", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARTHREE", DbType.Decimal),
new SqlParameter("@in_SENSOR_PARFOUR", DbType.Decimal),
new SqlParameter("@in_TYPEID", DbType.Decimal),
new SqlParameter("@in_SATTYPE", DbType.Decimal),
new SqlParameter("@in_SENSORANGLE", DbType.Decimal),
new SqlParameter("@in_SENSORANGLEH", DbType.Decimal)
};
cmdParms[0].Value = model.SENSOR_ID;
cmdParms[1].Value = model.SENSOR_NAME;
cmdParms[2].Value = model.SENSOR_STKNAME;
cmdParms[3].Value = model.SAT_ID;
cmdParms[4].Value = model.SAT_STKNAME;
cmdParms[5].Value = model.SENSOR_TYPE;
cmdParms[6].Value = model.SENSOR_PARONE;
cmdParms[7].Value = model.SENSOR_PARTWO;
cmdParms[8].Value = model.SENSOR_PARTHREE;
cmdParms[9].Value = model.SENSOR_PARFOUR;
cmdParms[10].Value = model.TYPEID;
cmdParms[11].Value = model.SATTYPE;
cmdParms[12].Value = model.SENSORANGLE;
cmdParms[13].Value = model.SENSORANGLEH;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
