Esempio n. 1
0
        private List <CarReport_BJView> GetCarRptBJTJList(DataTable dt)
        {
            List <CarReport_BJView> list = new List <CarReport_BJView>();

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    CarReport_BJView node = new CarReport_BJView();

                    node.TerNo = dr["ter_no"].ToString();
                    node.CarNo = dr["car_no"].ToString();

                    if (dr["rtime"] != DBNull.Value)
                    {
                        node.HCSJ = Convert.ToDateTime(dr["rtime"]).ToString("yyyy-MM-dd HH:mm:ss");
                    }
                    node.Position      = dr["position"].ToString();
                    node.Postbacktimes = dr["postbacktimes"].ToString();
                    if (dr["rtime"] != DBNull.Value)
                    {
                        node.LJLXTS = dr["lx"].ToString();
                    }
                    node.TerStatus     = dr["ter_status"].ToString();
                    node.ReplyDataName = dr["replydataname"].ToString();
                    node.FXJG          = "";
                    list.Add(node);
                }
            }

            return(list);
        }
Esempio n. 2
0
        private List <CarReport_BJView> GetCarRptBJTJList(ArrayList terNos, DataTable dt)
        {
            List <CarReport_BJView> list = new List <CarReport_BJView>();

            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_BJView node = new CarReport_BJView();

                        node.TerNo = dr["ter_no"].ToString();
                        node.CarNo = dr["car_no"].ToString();

                        if (dr["rtime"] != DBNull.Value)
                        {
                            node.HCSJ = Convert.ToDateTime(dr["rtime"]).ToString("yyyy-MM-dd HH:mm:ss");
                        }
                        node.Position      = dr["position"].ToString();
                        node.Postbacktimes = dr["postbacktimes"].ToString();
                        if (dr["rtime"] != DBNull.Value)
                        {
                            node.LJLXTS = dr["lx"].ToString();
                        }
                        node.TerStatus     = dr["ter_status"].ToString();
                        node.ReplyDataName = dr["replydataname"].ToString();
                        node.FXJG          = "";

                        list.Add(node);
                    }
                }
            }

            return(list);
        }