/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.IMG_LAYOUT_RESULT GetModel(DbDataReader dr) { Model.IMG_LAYOUT_RESULT model = new Model.IMG_LAYOUT_RESULT(); model.MPPERIODID = Convert.ToDecimal(dr["MPPERIODID"]); model.TASKID = Convert.ToDecimal(dr["TASKID"]); model.SUBTASKID = Convert.ToString(dr["SUBTASKID"]); model.SATID = Convert.ToDecimal(dr["SATID"]); model.ZCSTARTTIME = Convert.ToDateTime(dr["ZCSTARTTIME"]); model.ZCENDTIME = Convert.ToDateTime(dr["ZCENDTIME"]); model.SLEWANGLE = Convert.ToDouble(dr["SLEWANGLE"]); try { model.DLTYPE = Convert.ToDecimal(dr["DLTYPE"]); } catch (System.Exception ex) { model.DLTYPE = 0; } try { model.DLWINDOWID = Convert.ToDecimal(dr["DLWINDOWID"]); } catch (System.Exception ex) { model.DLWINDOWID = 0; } model.COMPOSEDNUMBER = Convert.ToString(dr["COMPOSEDNUMBER"]); model.RESOLUTION = Convert.ToDouble(dr["RESOLUTION"]); model.QUANTITY = Convert.ToDouble(dr["QUANTITY"]); model.SENSORID = Convert.ToDecimal(dr["SENSORID"]); model.GROUNDID = Convert.ToString(dr["GROUNDID"]); model.DOWNSTART = Convert.ToDateTime(dr["DOWNSTART"]); model.DOWNEND = Convert.ToDateTime(dr["DOWNEND"]); model.TASK_TYPE = Convert.ToDecimal(dr["TASK_TYPE"]); model.PRIORITY = Convert.ToDecimal(dr["PRIORITY"]); model.IMAGEREGION = Convert.ToString(dr["IMAGEREGION"]); model.SIMTASK_STATE = Convert.ToDecimal(dr["SIMTASK_STATE"]); model.IS_ABLE = Convert.ToDecimal(dr["IS_ABLE"]); model.DATACAP = Convert.ToDecimal(dr["DATACAP"]); model.SATSTKNAME = Convert.ToString(dr["SATSTKNAME"]); model.ISCONTINUEDSPY = Convert.ToDecimal(dr["ISCONTINUEDSPY"]); model.TASKENDTIME = Convert.ToDateTime(dr["TASKENDTIME"]); model.IF_SEND = Convert.ToDecimal(dr["IF_SEND"]); model.LSTR_SEQID = Convert.ToDecimal(dr["LSTR_SEQID"]); model.PRECISION = Convert.ToDecimal(dr["PRECISION"]); model.TARGET_ID = Convert.ToDecimal(dr["TARGET_ID"]); model.SCHEMEID = Convert.ToDecimal(dr["SCHEMEID"]); model.TASKSTARTTIME = Convert.ToDateTime(dr["TASKSTARTTIME"]); model.SENSORSTKNAME = Convert.ToString(dr["SENSORSTKNAME"]); return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.IMG_LAYOUT_RESULT GetModel(int LSTR_SEQID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM LHF.IMG_LAYOUT_RESULT "); strSql.Append(" WHERE LSTR_SEQID=" + LSTR_SEQID); Model.IMG_LAYOUT_RESULT model = null; using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return model; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.IMG_LAYOUT_RESULT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO LHF.IMG_LAYOUT_RESULT("); strSql.Append("MPPERIODID,TASKID,SUBTASKID,SATID,ZCSTARTTIME,ZCENDTIME,SLEWANGLE,DLTYPE,DLWINDOWID,COMPOSEDNUMBER,RESOLUTION,QUANTITY,SENSORID,GROUNDID,DOWNSTART,DOWNEND,TASK_TYPE,PRIORITY,IMAGEREGION,SIMTASK_STATE,IS_ABLE,DATACAP,SATSTKNAME,ISCONTINUEDSPY,TASKENDTIME,IF_SEND,LSTR_SEQID,PRECISION,TARGET_ID,SCHEMEID,TASKSTARTTIME,SENSORSTKNAME)"); strSql.Append(" VALUES ("); strSql.Append("@in_MPPERIODID,@in_TASKID,@in_SUBTASKID,@in_SATID,@in_ZCSTARTTIME,@in_ZCENDTIME,@in_SLEWANGLE,@in_DLTYPE,@in_DLWINDOWID,@in_COMPOSEDNUMBER,@in_RESOLUTION,@in_QUANTITY,@in_SENSORID,@in_GROUNDID,@in_DOWNSTART,@in_DOWNEND,@in_TASK_TYPE,@in_PRIORITY,@in_IMAGEREGION,@in_SIMTASK_STATE,@in_IS_ABLE,@in_DATACAP,@in_SATSTKNAME,@in_ISCONTINUEDSPY,@in_TASKENDTIME,@in_IF_SEND,@in_LSTR_SEQID,@in_PRECISION,@in_TARGET_ID,@in_SCHEMEID,@in_TASKSTARTTIME,@in_SENSORSTKNAME)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_MPPERIODID", SqlDbType.Decimal), new SqlParameter("@in_TASKID", SqlDbType.Decimal), new SqlParameter("@in_SUBTASKID", SqlDbType.NVarChar), new SqlParameter("@in_SATID", SqlDbType.Decimal), new SqlParameter("@in_ZCSTARTTIME", SqlDbType.DateTime), new SqlParameter("@in_ZCENDTIME", SqlDbType.DateTime), new SqlParameter("@in_SLEWANGLE", DbType.Double), new SqlParameter("@in_DLTYPE", SqlDbType.Decimal), new SqlParameter("@in_DLWINDOWID", SqlDbType.Decimal), new SqlParameter("@in_COMPOSEDNUMBER", SqlDbType.NVarChar), new SqlParameter("@in_RESOLUTION", DbType.Double), new SqlParameter("@in_QUANTITY", DbType.Double), new SqlParameter("@in_SENSORID", SqlDbType.Decimal), new SqlParameter("@in_GROUNDID", SqlDbType.NVarChar), new SqlParameter("@in_DOWNSTART", SqlDbType.DateTime), new SqlParameter("@in_DOWNEND", SqlDbType.DateTime), new SqlParameter("@in_TASK_TYPE", SqlDbType.Decimal), new SqlParameter("@in_PRIORITY", SqlDbType.Decimal), new SqlParameter("@in_IMAGEREGION", SqlDbType.NVarChar), new SqlParameter("@in_SIMTASK_STATE", SqlDbType.Decimal), new SqlParameter("@in_IS_ABLE", SqlDbType.Decimal), new SqlParameter("@in_DATACAP", SqlDbType.Decimal), new SqlParameter("@in_SATSTKNAME", SqlDbType.NVarChar), new SqlParameter("@in_ISCONTINUEDSPY", SqlDbType.Decimal), new SqlParameter("@in_TASKENDTIME", SqlDbType.DateTime), new SqlParameter("@in_IF_SEND", SqlDbType.Decimal), new SqlParameter("@in_LSTR_SEQID", SqlDbType.Decimal), new SqlParameter("@in_PRECISION", SqlDbType.Decimal), new SqlParameter("@in_TARGET_ID", SqlDbType.Decimal), new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal), new SqlParameter("@in_TASKSTARTTIME", SqlDbType.DateTime), new SqlParameter("@in_SENSORSTKNAME", SqlDbType.NVarChar)}; cmdParms[0].Value = model.MPPERIODID; cmdParms[1].Value = model.TASKID; cmdParms[2].Value = model.SUBTASKID; cmdParms[3].Value = model.SATID; cmdParms[4].Value = model.ZCSTARTTIME; cmdParms[5].Value = model.ZCENDTIME; cmdParms[6].Value = model.SLEWANGLE; cmdParms[7].Value = model.DLTYPE; cmdParms[8].Value = model.DLWINDOWID; cmdParms[9].Value = model.COMPOSEDNUMBER; cmdParms[10].Value = model.RESOLUTION; cmdParms[11].Value = model.QUANTITY; cmdParms[12].Value = model.SENSORID; cmdParms[13].Value = model.GROUNDID; cmdParms[14].Value = model.DOWNSTART; cmdParms[15].Value = model.DOWNEND; cmdParms[16].Value = model.TASK_TYPE; cmdParms[17].Value = model.PRIORITY; cmdParms[18].Value = model.IMAGEREGION; cmdParms[19].Value = model.SIMTASK_STATE; cmdParms[20].Value = model.IS_ABLE; cmdParms[21].Value = model.DATACAP; cmdParms[22].Value = model.SATSTKNAME; cmdParms[23].Value = model.ISCONTINUEDSPY; cmdParms[24].Value = model.TASKENDTIME; cmdParms[25].Value = model.IF_SEND; cmdParms[26].Value = model.LSTR_SEQID; cmdParms[27].Value = model.PRECISION; cmdParms[28].Value = model.TARGET_ID; cmdParms[29].Value = model.SCHEMEID; cmdParms[30].Value = model.TASKSTARTTIME; cmdParms[31].Value = model.SENSORSTKNAME; return DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.IMG_LAYOUT_RESULT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE LHF.IMG_LAYOUT_RESULT SET "); strSql.Append("TASKID=@in_TASKID,"); strSql.Append("SUBTASKID=@in_SUBTASKID,"); strSql.Append("SATID=@in_SATID,"); strSql.Append("ZCSTARTTIME=@in_ZCSTARTTIME,"); strSql.Append("ZCENDTIME=@in_ZCENDTIME,"); strSql.Append("SLEWANGLE=@in_SLEWANGLE,"); strSql.Append("DLTYPE=@in_DLTYPE,"); strSql.Append("DLWINDOWID=@in_DLWINDOWID,"); strSql.Append("COMPOSEDNUMBER=@in_COMPOSEDNUMBER,"); strSql.Append("RESOLUTION=@in_RESOLUTION,"); strSql.Append("QUANTITY=@in_QUANTITY,"); strSql.Append("SENSORID=@in_SENSORID,"); strSql.Append("GROUNDID=@in_GROUNDID,"); strSql.Append("DOWNSTART=@in_DOWNSTART,"); strSql.Append("DOWNEND=@in_DOWNEND,"); strSql.Append("TASK_TYPE=@in_TASK_TYPE,"); strSql.Append("PRIORITY=@in_PRIORITY,"); strSql.Append("IMAGEREGION=@in_IMAGEREGION,"); strSql.Append("SIMTASK_STATE=@in_SIMTASK_STATE,"); strSql.Append("IS_ABLE=@in_IS_ABLE,"); strSql.Append("DATACAP=@in_DATACAP,"); strSql.Append("SATSTKNAME=@in_SATSTKNAME,"); strSql.Append("ISCONTINUEDSPY=@in_ISCONTINUEDSPY,"); strSql.Append("TASKENDTIME=@in_TASKENDTIME,"); strSql.Append("IF_SEND=@in_IF_SEND,"); strSql.Append("MPPERIODID=@in_MPPERIODID,"); strSql.Append("PRECISION=@in_PRECISION,"); strSql.Append("TARGET_ID=@in_TARGET_ID,"); strSql.Append("SCHEMEID=@in_SCHEMEID,"); strSql.Append("TASKSTARTTIME=@in_TASKSTARTTIME"); strSql.Append("SENSORSTKNAME=@in_SENSORSTKNAME"); strSql.Append(" WHERE LSTR_SEQID=@in_LSTR_SEQID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_MPPERIODID", SqlDbType.Decimal), new SqlParameter("@in_TASKID", SqlDbType.Decimal), new SqlParameter("@in_SUBTASKID", SqlDbType.NVarChar), new SqlParameter("@in_SATID", SqlDbType.Decimal), new SqlParameter("@in_ZCSTARTTIME", SqlDbType.DateTime), new SqlParameter("@in_ZCENDTIME", SqlDbType.DateTime), new SqlParameter("@in_SLEWANGLE", DbType.Double), new SqlParameter("@in_DLTYPE", SqlDbType.Decimal), new SqlParameter("@in_DLWINDOWID", SqlDbType.Decimal), new SqlParameter("@in_COMPOSEDNUMBER", SqlDbType.NVarChar), new SqlParameter("@in_RESOLUTION", DbType.Double), new SqlParameter("@in_QUANTITY", DbType.Double), new SqlParameter("@in_SENSORID", SqlDbType.Decimal), new SqlParameter("@in_GROUNDID", SqlDbType.NVarChar), new SqlParameter("@in_DOWNSTART", SqlDbType.DateTime), new SqlParameter("@in_DOWNEND", SqlDbType.DateTime), new SqlParameter("@in_TASK_TYPE", SqlDbType.Decimal), new SqlParameter("@in_PRIORITY", SqlDbType.Decimal), new SqlParameter("@in_IMAGEREGION", SqlDbType.NVarChar), new SqlParameter("@in_SIMTASK_STATE", SqlDbType.Decimal), new SqlParameter("@in_IS_ABLE", SqlDbType.Decimal), new SqlParameter("@in_DATACAP", SqlDbType.Decimal), new SqlParameter("@in_SATSTKNAME", SqlDbType.NVarChar), new SqlParameter("@in_ISCONTINUEDSPY", SqlDbType.Decimal), new SqlParameter("@in_TASKENDTIME", SqlDbType.DateTime), new SqlParameter("@in_IF_SEND", SqlDbType.Decimal), new SqlParameter("@in_LSTR_SEQID", SqlDbType.Decimal), new SqlParameter("@in_PRECISION", SqlDbType.Decimal), new SqlParameter("@in_TARGET_ID", SqlDbType.Decimal), new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal), new SqlParameter("@in_TASKSTARTTIME", SqlDbType.DateTime), new SqlParameter("@in_SENSORSTKNAME", SqlDbType.NVarChar)}; cmdParms[0].Value = model.MPPERIODID; cmdParms[1].Value = model.TASKID; cmdParms[2].Value = model.SUBTASKID; cmdParms[3].Value = model.SATID; cmdParms[4].Value = model.ZCSTARTTIME; cmdParms[5].Value = model.ZCENDTIME; cmdParms[6].Value = model.SLEWANGLE; cmdParms[7].Value = model.DLTYPE; cmdParms[8].Value = model.DLWINDOWID; cmdParms[9].Value = model.COMPOSEDNUMBER; cmdParms[10].Value = model.RESOLUTION; cmdParms[11].Value = model.QUANTITY; cmdParms[12].Value = model.SENSORID; cmdParms[13].Value = model.GROUNDID; cmdParms[14].Value = model.DOWNSTART; cmdParms[15].Value = model.DOWNEND; cmdParms[16].Value = model.TASK_TYPE; cmdParms[17].Value = model.PRIORITY; cmdParms[18].Value = model.IMAGEREGION; cmdParms[19].Value = model.SIMTASK_STATE; cmdParms[20].Value = model.IS_ABLE; cmdParms[21].Value = model.DATACAP; cmdParms[22].Value = model.SATSTKNAME; cmdParms[23].Value = model.ISCONTINUEDSPY; cmdParms[24].Value = model.TASKENDTIME; cmdParms[25].Value = model.IF_SEND; cmdParms[26].Value = model.LSTR_SEQID; cmdParms[27].Value = model.PRECISION; cmdParms[28].Value = model.TARGET_ID; cmdParms[29].Value = model.SCHEMEID; cmdParms[30].Value = model.TASKSTARTTIME; cmdParms[31].Value = model.SENSORSTKNAME; return DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms); }