/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.SATELLITE_UPDATE GetModel(DbDataReader dr)
{
Model.SATELLITE_UPDATE model = new Model.SATELLITE_UPDATE();
model.UPDATE_ID = Convert.ToInt32(dr["UPDATE_ID"]);
model.UPDATE_TABLE = Convert.ToString(dr["UPDATE_TABLE"]);
model.UPDATE_TIME = Convert.ToDateTime(dr["UPDATE_TIME"]);
model.UPDATE_LOG = Convert.ToString(dr["UPDATE_LOG"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SATELLITE_UPDATE GetModel(int UPDATE_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM SATELLITE_UPDATE ");
strSql.Append(" WHERE UPDATE_ID=" + UPDATE_ID);
Model.SATELLITE_UPDATE model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.SATELLITE_UPDATE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO SATELLITE_UPDATE(");
strSql.Append("UPDATE_TABLE,UPDATE_TIME,UPDATE_LOG)");
strSql.Append(" VALUES (");
strSql.Append("@in_UPDATE_TABLE,@in_UPDATE_TIME,@in_UPDATE_LOG)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_UPDATE_TABLE", SqlDbType.NVarChar),
new SqlParameter("@in_UPDATE_TIME", SqlDbType.NVarChar),
new SqlParameter("@in_UPDATE_LOG", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.UPDATE_TABLE;
cmdParms[1].Value = model.UPDATE_TIME;
cmdParms[2].Value = model.UPDATE_LOG;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.SATELLITE_UPDATE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE SATELLITE_UPDATE SET ");
strSql.Append("UPDATE_TABLE=@in_UPDATE_TABLE,");
strSql.Append("UPDATE_TIME=@in_UPDATE_TIME,");
strSql.Append("UPDATE_LOG=@in_UPDATE_LOG");
strSql.Append(" WHERE UPDATE_ID=@in_UPDATE_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_UPDATE_ID", SqlDbType.Int),
new SqlParameter("@in_UPDATE_TABLE", SqlDbType.NVarChar),
new SqlParameter("@in_UPDATE_TIME", SqlDbType.NVarChar),
new SqlParameter("@in_UPDATE_LOG", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.UPDATE_ID;
cmdParms[1].Value = model.UPDATE_TABLE;
cmdParms[2].Value = model.UPDATE_TIME;
cmdParms[3].Value = model.UPDATE_LOG;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}