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