/// <summary>
/// 获取实时的车辆信息
/// </summary>
/// <returns></returns>
public List <VEHICLEREALSTATUS> getNewSSVehInfo()
{
try
{
List <VEHICLEREALSTATUS> list = new List <VEHICLEREALSTATUS>();
DataTable dt = DB120Help.GetRecord(GetDataSql.GetSSVehDataStr());
foreach (DataRow r in dt.Rows)
{
VEHICLEREALSTATUS aci = new VEHICLEREALSTATUS();
try
{
aci.VEHICLENAME = r["VEHICLENAME"].ToString();
aci.VEHICLECARD = r["VEHICLECARD"].ToString();
aci.VEHICLEDEPARTMENT = r["VEHICLEDEPARTMENT"].ToString();
aci.STATUS = r["STATUS"].ToString();
aci.JD = double.Parse(r["JD"].ToString());
aci.WD = double.Parse(r["WD"].ToString());
aci.LASTTIME = DateTime.Now;
aci.READFLAG = 1;
list.Add(aci);
}
catch (Exception ex)
{
LogHelper.WriteLog(aci.VEHICLENAME + ex.Message);
}
}
return(list);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEREALSTATUS Data)
{
ParameterSql sqlpar = new ParameterSql();
//20151210 修改人:朱星汉 修改内容:添加系统人员密码
sqlpar.StrSql = "insert into VEHICLEREALSTATUS(VEHICLECARD,VEHICLENAME,VEHICLEDEPARTMENT,STATUS,JD,WD,LASTTIME,READFLAG)values(:VEHICLECARD,:VEHICLENAME,:VEHICLEDEPARTMENT,:STATUS,:JD,:WD,:LASTTIME,:READFLAG)";
OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)),
new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)),
new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)),
new OracleParameter(":STATUS", GetString(Data.STATUS)),
new OracleParameter(":JD", Data.JD),
new OracleParameter(":WD", Data.WD),
new OracleParameter(":LASTTIME", GetDateTime(Data.LASTTIME.ToString())),
new OracleParameter(":READFLAG", Data.READFLAG), };
sqlpar.OrclPar = par;
return(sqlpar);
}
