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