/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.T_PUB_SATELLITEPARA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.T_PUB_SATELLITEPARA(");
strSql.Append("SAT_ID,SAT_STKNAME,MAXGSD,OPENCLOSETIME,WORKLASTTIME,SATANGLE,SATANGLEH,SENSOR_ID,SENSOR_STKNAME)");
strSql.Append(" VALUES (");
strSql.Append("@in_SAT_ID,@in_SAT_STKNAME,@in_MAXGSD,@in_OPENCLOSETIME,@in_WORKLASTTIME,@in_SATANGLE,@in_SATANGLEH,@in_SENSOR_ID,@in_SENSOR_STKNAME)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", SqlDbType.NVarChar),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal),
new SqlParameter("@in_OPENCLOSETIME", SqlDbType.Decimal),
new SqlParameter("@in_WORKLASTTIME", SqlDbType.Decimal),
new SqlParameter("@in_SATANGLE", SqlDbType.Decimal),
new SqlParameter("@in_SATANGLEH", SqlDbType.Decimal),
new SqlParameter("@in_SENSOR_ID", SqlDbType.Decimal),
new SqlParameter("@in_SENSOR_STKNAME", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.SAT_STKNAME;
cmdParms[2].Value = model.MAXGSD;
cmdParms[3].Value = model.OPENCLOSETIME;
cmdParms[4].Value = model.WORKLASTTIME;
cmdParms[5].Value = model.SATANGLE;
cmdParms[6].Value = model.SATANGLEH;
cmdParms[7].Value = model.SENSOR_ID;
cmdParms[8].Value = model.SENSOR_STKNAME;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.T_PUB_SATELLITEPARA GetModel(DbDataReader dr)
{
Model.T_PUB_SATELLITEPARA model = new Model.T_PUB_SATELLITEPARA();
model.SAT_ID = Convert.ToDecimal(dr["SAT_ID"]);
model.SAT_STKNAME = Convert.ToString(dr["SAT_STKNAME"]);
model.MAXGSD = Convert.ToDecimal(dr["MAXGSD"]);
model.OPENCLOSETIME = Convert.ToDecimal(dr["OPENCLOSETIME"]);
model.WORKLASTTIME = Convert.ToDecimal(dr["WORKLASTTIME"]);
model.SATANGLE = Convert.ToDecimal(dr["SATANGLE"]);
model.SATANGLEH = Convert.ToDecimal(dr["SATANGLEH"]);
model.SENSOR_ID = Convert.ToDecimal(dr["SENSOR_ID"]);
model.SENSOR_STKNAME = Convert.ToString(dr["SENSOR_STKNAME"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.T_PUB_SATELLITEPARA GetModel(decimal SENSOR_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM LHF.T_PUB_SATELLITEPARA ");
strSql.Append(" WHERE SENSOR_ID=" + SENSOR_ID);
Model.T_PUB_SATELLITEPARA model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.T_PUB_SATELLITEPARA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.T_PUB_SATELLITEPARA SET ");
strSql.Append("SAT_STKNAME=@in_SAT_STKNAME,");
strSql.Append("MAXGSD=@in_MAXGSD,");
strSql.Append("OPENCLOSETIME=@in_OPENCLOSETIME,");
strSql.Append("WORKLASTTIME=@in_WORKLASTTIME,");
strSql.Append("SATANGLE=@in_SATANGLE,");
strSql.Append("SATANGLEH=@in_SATANGLEH,");
strSql.Append("SENSOR_ID=@in_SENSOR_ID,");
strSql.Append("SENSOR_STKNAME=@in_SENSOR_STKNAME");
strSql.Append(" WHERE SAT_ID=@in_SAT_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", SqlDbType.NVarChar),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal),
new SqlParameter("@in_OPENCLOSETIME", SqlDbType.Decimal),
new SqlParameter("@in_WORKLASTTIME", SqlDbType.Decimal),
new SqlParameter("@in_SATANGLE", SqlDbType.Decimal),
new SqlParameter("@in_SATANGLEH", SqlDbType.Decimal),
new SqlParameter("@in_SENSOR_ID", SqlDbType.Decimal),
new SqlParameter("@in_SENSOR_STKNAME", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.SAT_STKNAME;
cmdParms[2].Value = model.MAXGSD;
cmdParms[3].Value = model.OPENCLOSETIME;
cmdParms[4].Value = model.WORKLASTTIME;
cmdParms[5].Value = model.SATANGLE;
cmdParms[6].Value = model.SATANGLEH;
cmdParms[7].Value = model.SENSOR_ID;
cmdParms[8].Value = model.SENSOR_STKNAME;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
