private List <CarReport_ZDTJView> GetCarRptZDTJList(DataTable dt)
{
List <CarReport_ZDTJView> list = new List <CarReport_ZDTJView>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
//DataRow dr = foundRows[0];
CarReport_ZDTJView node = new CarReport_ZDTJView();
node.TerNo = dr["ter_no"].ToString();
node.CarNo = dr["car_no"].ToString();
//回传时间
if (dr["HCSJ"] != DBNull.Value)
{
node.HCSJ = Convert.ToDateTime(dr["HCSJ"]).ToString("yyyy-MM-dd HH:mm:ss");
}
//总里程
if (dr["ZLC"] != DBNull.Value)
{
node.LCTJ = int.Parse(dr["ZLC"].ToString(), System.Globalization.NumberStyles.HexNumber);
}
//离线天数
if (dr["LXTS"] != DBNull.Value)
{
node.LJLXTS = dr["LXTS"].ToString();
}
//当前报警状态
if (dr["DQBJZT"] != DBNull.Value)
{
node.DQBJZT = dr["DQBJZT"].ToString();
}
//标准比例
if (dr["MS_BZBL"] != DBNull.Value)
{
node.MS_BZBL = dr["MS_BZBL"].ToString();
if (node.MS_BZBL.Trim().Length > 0)
{
node.MS_BZBL += "%";
}
}
//精准比例
if (dr["MS_JZBL"] != DBNull.Value)
{
node.MS_JZBL = dr["MS_JZBL"].ToString();
if (node.MS_JZBL.Trim().Length > 0)
{
node.MS_JZBL += "%";
}
}
//追车比例
if (dr["MS_ZCBL"] != DBNull.Value)
{
node.MS_ZCBL = dr["MS_ZCBL"].ToString();
if (node.MS_ZCBL.Trim().Length > 0)
{
node.MS_ZCBL += "%";
}
}
//回传次数
if (dr["HCCS"] != DBNull.Value)
{
node.LJHCCS = dr["HCCS"].ToString();
}
//累计工时
if (dr["LJGS"] != DBNull.Value)
{
node.LJGS = dr["LJGS"].ToString();
}
//统计时间
if (dr["TJSJ"] != DBNull.Value)
{
node.TJSJ = Convert.ToDateTime(dr["TJSJ"]).ToString("yyyy-MM-dd HH:mm:ss");
}
node.FXJG = "";
list.Add(node);
}
}
return(list);
}
private List <CarReport_ZDTJView> GetCarRptZDTJList(ArrayList terNos, DataTable dt)
{
List <CarReport_ZDTJView> list = new List <CarReport_ZDTJView>();
if (terNos.Count > 0)
{
foreach (DictionaryEntry e in terNos)
{
DataRow[] foundRows = dt.Select(" TER_NO = '" + e.Value.ToString() + "'");
if (foundRows.Length > 0)
{
DataRow dr = foundRows[0];
CarReport_ZDTJView node = new CarReport_ZDTJView();
node.TerNo = dr["ter_no"].ToString();
node.CarNo = dr["car_no"].ToString();
//回传时间
if (dr["HCSJ"] != DBNull.Value)
{
node.HCSJ = Convert.ToDateTime(dr["HCSJ"]).ToString("G");
}
//总里程
if (dr["ZLC"] != DBNull.Value)
{
node.LCTJ = int.Parse(dr["ZLC"].ToString(), System.Globalization.NumberStyles.HexNumber);
}
//离线天数
if (dr["LXTS"] != DBNull.Value)
{
node.LJLXTS = dr["LXTS"].ToString();
}
//当前报警状态
if (dr["DQBJZT"] != DBNull.Value)
{
node.DQBJZT = dr["DQBJZT"].ToString();
}
//标准比例
if (dr["MS_BZBL"] != DBNull.Value)
{
node.MS_BZBL = dr["MS_BZBL"].ToString();
if (node.MS_BZBL.Trim().Length > 0)
{
node.MS_BZBL += "%";
}
}
//精准比例
if (dr["MS_JZBL"] != DBNull.Value)
{
node.MS_JZBL = dr["MS_JZBL"].ToString();
if (node.MS_JZBL.Trim().Length > 0)
{
node.MS_JZBL += "%";
}
}
//追车比例
if (dr["MS_ZCBL"] != DBNull.Value)
{
node.MS_ZCBL = dr["MS_ZCBL"].ToString();
if (node.MS_ZCBL.Trim().Length > 0)
{
node.MS_ZCBL += "%";
}
}
//回传次数
if (dr["HCCS"] != DBNull.Value)
{
node.LJHCCS = dr["HCCS"].ToString();
}
//累计工时
if (dr["LJGS"] != DBNull.Value)
{
node.LJGS = dr["LJGS"].ToString();
}
//统计时间
if (dr["TJSJ"] != DBNull.Value)
{
node.TJSJ = dr["TJSJ"].ToString();
}
node.FXJG = "";
list.Add(node);
}
}
}
return(list);
}
