/// <summary> /// 获取历史的车辆信息 /// </summary> /// <returns></returns> public List <VEHICLEHISTROYSTATE> getNewLSVehInfo(string strID, string strLSH, string strCCXH) { int nCCXH = 0; try { List <VEHICLEHISTROYSTATE> list = new List <VEHICLEHISTROYSTATE>(); if (strID == "") { return(list); } if (strLSH != "") { if (strCCXH != "") { int.TryParse(strCCXH, out nCCXH); } else { int.TryParse((DB120Help.GetSingle(GetDataSql.GetCCXH(strLSH, strID)) == null ? "0" : DB120Help.GetSingle(GetDataSql.GetCCXH(strLSH, strID)).ToString()), out nCCXH); } } DataTable dt = DB120Help.GetRecord(GetDataSql.GetLSVehDataStr(strID)); foreach (DataRow r in dt.Rows) { try { VEHICLEHISTROYSTATE aci = new VEHICLEHISTROYSTATE(); aci.LSH = strLSH; aci.CCXH = nCCXH; aci.VEHICLENAME = r["VEHICLENAME"].ToString(); aci.VEHICLECARD = r["VEHICLECARD"].ToString(); aci.VEHICLEDEPARTMENT = r["VEHICLEDEPARTMENT"].ToString(); aci.JD = double.Parse(r["JD"].ToString()); aci.WD = double.Parse(r["WD"].ToString()); aci.REPORTTIME = DateTime.Now; aci.READFLAG = 1; list.Add(aci); } catch (Exception ex) { throw ex; } } return(list); } catch (System.Exception ex) { throw ex; } }
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEHISTROYSTATE Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "insert into VEHICLEHISTROYSTATE(VEHICLECARD,VEHICLENAME,VEHICLEDEPARTMENT,LSH,CCXH,JD,WD,REPORTTIME,READFLAG)values(:VEHICLECARD,:VEHICLENAME,:VEHICLEDEPARTMENT,:LSH,:CCXH,:JD,:WD,:REPORTTIME,:READFLAG)"; OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)), new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)), new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CCXH", GetNumber(Data.CCXH == 0? "":Data.CCXH.ToString())), new OracleParameter(":JD", Data.JD), new OracleParameter(":WD", Data.WD), new OracleParameter(":REPORTTIME", GetDateTime(Data.REPORTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEHISTROYSTATE Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "update VEHICLEHISTROYSTATE set VEHICLENAME:=VEHICLENAME,VEHICLEDEPARTMENT:=VEHICLEDEPARTMENT,LSH:=LSH,CCXH:=CCXH,JD:=JD,WD:=WD,REPORTTIME=:REPORTTIME,READFLAG=:READFLAG where VEHICLECARD=:VEHICLECARD"; OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)), new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)), new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CCXH", Data.CCXH), new OracleParameter(":JD", Data.JD), new OracleParameter(":WD", Data.WD), new OracleParameter(":REPORTTIME", GetDateTime(Data.REPORTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }