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