コード例 #1
0
        private void SetTable()
        {
            try
            {
                DataTable dt = CreateTable();
                if (Session["passcar"] != null)
                {
                    System.Collections.Generic.List <string> liststr = Session["passcar"] as System.Collections.Generic.List <string>;
                    listMq.Clear();
                    foreach (string mqstr in liststr)
                    {
                        if (mqstr.Substring(0, 11) == "<<< MESSAGE")
                        {
                            int  mqstart = mqstr.IndexOf("{");
                            Json json    = new Json(mqstr.Substring(mqstart));
                            System.Collections.Hashtable carhs = json["car"] as System.Collections.Hashtable;
                            carhs.Add("layoutId", json["layoutId"]);
                            carhs.Add("alarmTime", json["alarmTime"]);
                            listMq.Add(carhs);
                        }
                    }
                    dt = settable();

                    dt.DefaultView.Sort = "col7 desc";
                    dt = dt.DefaultView.ToTable();
                    StorePassCar.DataSource = dt;
                    StorePassCar.DataBind();
                    if (dt.Rows.Count > 0)
                    {
                        string surl1  = dt.Rows[0][27].ToString();
                        string surl2  = dt.Rows[0][28].ToString();
                        string hpzl   = dt.Rows[0][5].ToString();
                        string hpzlms = dt.Rows[0][6].ToString();
                        string hphm   = dt.Rows[0][4].ToString();
                        string gwsj   = dt.Rows[0][7].ToString();
                        string xlsd   = dt.Rows[0][19].ToString();
                        string kkmc   = dt.Rows[0][3].ToString();
                        string fxmc   = dt.Rows[0][17].ToString();
                        string cjjg   = dt.Rows[0][26].ToString();
                        string msg    = GetHtml(hpzl, hphm, hpzlms, gwsj, xlsd, kkmc, fxmc, cjjg);

                        ApplyImage(surl1, surl2);
                        ApplyText(msg);
                    }
                }
            }
            catch (Exception ex)
            {
                ILog.WriteErrorLog(ex.Message);
                logManager.InsertLogError("TgsPassCarAmply.aspx-SetTable", ex.Message + ";" + ex.StackTrace, "SetTable has an exception");
            }
        }
コード例 #2
0
        /// <summary>
        /// xml文件解析
        /// </summary>
        /// <param name="xmlStr">xml字符串</param>
        public void CXmlToDataTable(string xmlStr)
        {
            try
            {
                DataTable   dt     = CreateTable();
                XmlDocument xmlDoc = new XmlDocument();
                xmlDoc.LoadXml(xmlStr);

                XmlNodeList listNodes = xmlDoc.SelectNodes("Message/Body/Return/passcarinfolist/passcarinfo");

                dt = settableweb(listNodes);
                dt.DefaultView.Sort = "col7 desc";
                dt = dt.DefaultView.ToTable();
                StorePassCar.DataSource = dt;
                StorePassCar.DataBind();
                if (dt.Rows.Count > 0)
                {
                    string surl1  = dt.Rows[0][27].ToString();
                    string surl2  = dt.Rows[0][28].ToString();
                    string hpzl   = dt.Rows[0][5].ToString();
                    string hpzlms = dt.Rows[0][6].ToString();
                    string hphm   = dt.Rows[0][4].ToString();
                    string gwsj   = dt.Rows[0][7].ToString();
                    string xlsd   = dt.Rows[0][19].ToString();
                    string kkmc   = dt.Rows[0][3].ToString();
                    string fxmc   = dt.Rows[0][17].ToString();
                    string cjjg   = dt.Rows[0][26].ToString();
                    string msg    = GetHtml(hpzl, hphm, hpzlms, gwsj, xlsd, kkmc, fxmc, cjjg);
                    ApplyImage(surl1, surl2);
                    ApplyText(msg);
                }
            }
            catch (Exception ex)
            {
                ILog.WriteErrorLog(ex.Message);
                logManager.InsertLogError("TgsPassCarAmply.aspx-CXmlToDataTable", ex.Message + ";" + ex.StackTrace, "CXmlToDataTable has an exception");
            }
        }