/// <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)); }