Ejemplo n.º 1
0
        private List <RoadFlow.Data.Model.WeiXinMessage> DataReaderToList(MySqlDataReader dataReader)
        {
            List <RoadFlow.Data.Model.WeiXinMessage> list = new List <RoadFlow.Data.Model.WeiXinMessage>();

            RoadFlow.Data.Model.WeiXinMessage weiXinMessage = null;
            while (((DbDataReader)dataReader).Read())
            {
                weiXinMessage             = new RoadFlow.Data.Model.WeiXinMessage();
                weiXinMessage.ID          = ((DbDataReader)dataReader).GetGuid(0);
                weiXinMessage.ToUserName  = ((DbDataReader)dataReader).GetString(1);
                weiXinMessage.CreateTime  = ((DbDataReader)dataReader).GetInt32(3);
                weiXinMessage.CreateTime1 = ((DbDataReader)dataReader).GetDateTime(4);
                weiXinMessage.MsgType     = ((DbDataReader)dataReader).GetString(5);
                weiXinMessage.MsgId       = ((DbDataReader)dataReader).GetInt64(6);
                weiXinMessage.AgentID     = ((DbDataReader)dataReader).GetInt32(7);
                if (!((DbDataReader)dataReader).IsDBNull(8))
                {
                    weiXinMessage.Contents = ((DbDataReader)dataReader).GetString(8);
                }
                if (!((DbDataReader)dataReader).IsDBNull(9))
                {
                    weiXinMessage.PicUrl = ((DbDataReader)dataReader).GetString(9);
                }
                if (!((DbDataReader)dataReader).IsDBNull(10))
                {
                    weiXinMessage.MediaId = ((DbDataReader)dataReader).GetString(10);
                }
                if (!((DbDataReader)dataReader).IsDBNull(11))
                {
                    weiXinMessage.Format = ((DbDataReader)dataReader).GetString(11);
                }
                if (!((DbDataReader)dataReader).IsDBNull(12))
                {
                    weiXinMessage.ThumbMediaId = ((DbDataReader)dataReader).GetString(12);
                }
                if (!((DbDataReader)dataReader).IsDBNull(13))
                {
                    weiXinMessage.Location_X = ((DbDataReader)dataReader).GetString(13);
                }
                if (!((DbDataReader)dataReader).IsDBNull(14))
                {
                    weiXinMessage.Location_Y = ((DbDataReader)dataReader).GetString(14);
                }
                if (!((DbDataReader)dataReader).IsDBNull(15))
                {
                    weiXinMessage.Scale = ((DbDataReader)dataReader).GetString(15);
                }
                if (!((DbDataReader)dataReader).IsDBNull(16))
                {
                    weiXinMessage.Label = ((DbDataReader)dataReader).GetString(16);
                }
                if (!((DbDataReader)dataReader).IsDBNull(17))
                {
                    weiXinMessage.Title = ((DbDataReader)dataReader).GetString(17);
                }
                if (!((DbDataReader)dataReader).IsDBNull(18))
                {
                    weiXinMessage.Description = ((DbDataReader)dataReader).GetString(18);
                }
                weiXinMessage.AddTime = ((DbDataReader)dataReader).GetDateTime(19);
                list.Add(weiXinMessage);
            }
            return(list);
        }
Ejemplo n.º 2
0
        public void Receive(string xml)
        {
            XElement      root          = XDocument.Parse(xml).Root;
            string        value         = root.Element("ToUserName").Value;
            string        value2        = root.Element("FromUserName").Value;
            string        value3        = root.Element("CreateTime").Value;
            string        value4        = root.Element("MsgType").Value;
            string        value5        = root.Element("MsgId").Value;
            string        value6        = root.Element("AgentID").Value;
            WeiXinMessage weiXinMessage = new WeiXinMessage();

            RoadFlow.Data.Model.WeiXinMessage weiXinMessage2 = new RoadFlow.Data.Model.WeiXinMessage();
            weiXinMessage2.ID           = Guid.NewGuid();
            weiXinMessage2.AddTime      = DateTimeNew.Now;
            weiXinMessage2.AgentID      = value6.ToInt();
            weiXinMessage2.CreateTime   = value3.ToInt();
            weiXinMessage2.CreateTime1  = Tools.JavaLongToDateTime(weiXinMessage2.CreateTime);
            weiXinMessage2.MsgType      = value4;
            weiXinMessage2.MsgId        = value5.ToLong();
            weiXinMessage2.ToUserName   = value;
            weiXinMessage2.FromUserName = value2;
            switch (value4)
            {
            case "text":
                weiXinMessage2.Contents = root.Element("Content").Value;
                break;

            case "image":
                weiXinMessage2.PicUrl  = root.Element("PicUrl").Value;
                weiXinMessage2.MediaId = root.Element("MediaId").Value;
                break;

            case "voice":
                weiXinMessage2.Format  = root.Element("Format").Value;
                weiXinMessage2.MediaId = root.Element("MediaId").Value;
                break;

            case "video":
                weiXinMessage2.ThumbMediaId = root.Element("ThumbMediaId").Value;
                weiXinMessage2.MediaId      = root.Element("MediaId").Value;
                break;

            case "shortvideo":
                weiXinMessage2.ThumbMediaId = root.Element("ThumbMediaId").Value;
                weiXinMessage2.MediaId      = root.Element("MediaId").Value;
                break;

            case "location":
                weiXinMessage2.Location_X = root.Element("Location_X").Value;
                weiXinMessage2.Location_Y = root.Element("Location_Y").Value;
                weiXinMessage2.Scale      = root.Element("Scale").Value;
                weiXinMessage2.Label      = root.Element("Label").Value;
                break;

            case "link":
                weiXinMessage2.Title       = root.Element("Title").Value;
                weiXinMessage2.Description = root.Element("Description").Value;
                weiXinMessage2.PicUrl      = root.Element("PicUrl").Value;
                break;
            }
            weiXinMessage.Add(weiXinMessage2);
        }
Ejemplo n.º 3
0
        public int Add(RoadFlow.Data.Model.WeiXinMessage model)
        {
            //IL_001b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0020: Unknown result type (might be due to invalid IL or missing references)
            //IL_0031: Expected O, but got Unknown
            //IL_0032: Expected O, but got Unknown
            //IL_0043: Unknown result type (might be due to invalid IL or missing references)
            //IL_0048: Unknown result type (might be due to invalid IL or missing references)
            //IL_0054: Expected O, but got Unknown
            //IL_0055: Expected O, but got Unknown
            //IL_0066: Unknown result type (might be due to invalid IL or missing references)
            //IL_006b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0077: Expected O, but got Unknown
            //IL_0078: Expected O, but got Unknown
            //IL_0081: Unknown result type (might be due to invalid IL or missing references)
            //IL_0086: Unknown result type (might be due to invalid IL or missing references)
            //IL_0097: Expected O, but got Unknown
            //IL_0098: Expected O, but got Unknown
            //IL_00a2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a7: Unknown result type (might be due to invalid IL or missing references)
            //IL_00b8: Expected O, but got Unknown
            //IL_00b9: Expected O, but got Unknown
            //IL_00c7: Unknown result type (might be due to invalid IL or missing references)
            //IL_00cc: Unknown result type (might be due to invalid IL or missing references)
            //IL_00d8: Expected O, but got Unknown
            //IL_00d9: Expected O, but got Unknown
            //IL_00e2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00e7: Unknown result type (might be due to invalid IL or missing references)
            //IL_00f8: Expected O, but got Unknown
            //IL_00f9: Expected O, but got Unknown
            //IL_0102: Unknown result type (might be due to invalid IL or missing references)
            //IL_0107: Unknown result type (might be due to invalid IL or missing references)
            //IL_0118: Expected O, but got Unknown
            //IL_0119: Expected O, but got Unknown
            //IL_012e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0133: Unknown result type (might be due to invalid IL or missing references)
            //IL_013f: Expected O, but got Unknown
            //IL_014c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0151: Unknown result type (might be due to invalid IL or missing references)
            //IL_015c: Expected O, but got Unknown
            //IL_015d: Expected O, but got Unknown
            //IL_0177: Unknown result type (might be due to invalid IL or missing references)
            //IL_017c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0188: Expected O, but got Unknown
            //IL_0199: Unknown result type (might be due to invalid IL or missing references)
            //IL_019e: Unknown result type (might be due to invalid IL or missing references)
            //IL_01a9: Expected O, but got Unknown
            //IL_01aa: Expected O, but got Unknown
            //IL_01c4: Unknown result type (might be due to invalid IL or missing references)
            //IL_01c9: Unknown result type (might be due to invalid IL or missing references)
            //IL_01d5: Expected O, but got Unknown
            //IL_01e6: Unknown result type (might be due to invalid IL or missing references)
            //IL_01eb: Unknown result type (might be due to invalid IL or missing references)
            //IL_01f6: Expected O, but got Unknown
            //IL_01f7: Expected O, but got Unknown
            //IL_020e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0213: Unknown result type (might be due to invalid IL or missing references)
            //IL_021f: Expected O, but got Unknown
            //IL_022d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0232: Unknown result type (might be due to invalid IL or missing references)
            //IL_023d: Expected O, but got Unknown
            //IL_023e: Expected O, but got Unknown
            //IL_0255: Unknown result type (might be due to invalid IL or missing references)
            //IL_025a: Unknown result type (might be due to invalid IL or missing references)
            //IL_0266: Expected O, but got Unknown
            //IL_0274: Unknown result type (might be due to invalid IL or missing references)
            //IL_0279: Unknown result type (might be due to invalid IL or missing references)
            //IL_0284: Expected O, but got Unknown
            //IL_0285: Expected O, but got Unknown
            //IL_029c: Unknown result type (might be due to invalid IL or missing references)
            //IL_02a1: Unknown result type (might be due to invalid IL or missing references)
            //IL_02ad: Expected O, but got Unknown
            //IL_02bb: Unknown result type (might be due to invalid IL or missing references)
            //IL_02c0: Unknown result type (might be due to invalid IL or missing references)
            //IL_02cb: Expected O, but got Unknown
            //IL_02cc: Expected O, but got Unknown
            //IL_02e3: Unknown result type (might be due to invalid IL or missing references)
            //IL_02e8: Unknown result type (might be due to invalid IL or missing references)
            //IL_02f4: Expected O, but got Unknown
            //IL_0302: Unknown result type (might be due to invalid IL or missing references)
            //IL_0307: Unknown result type (might be due to invalid IL or missing references)
            //IL_0312: Expected O, but got Unknown
            //IL_0313: Expected O, but got Unknown
            //IL_032a: Unknown result type (might be due to invalid IL or missing references)
            //IL_032f: Unknown result type (might be due to invalid IL or missing references)
            //IL_033b: Expected O, but got Unknown
            //IL_0349: Unknown result type (might be due to invalid IL or missing references)
            //IL_034e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0359: Expected O, but got Unknown
            //IL_035a: Expected O, but got Unknown
            //IL_0374: Unknown result type (might be due to invalid IL or missing references)
            //IL_0379: Unknown result type (might be due to invalid IL or missing references)
            //IL_0385: Expected O, but got Unknown
            //IL_0396: Unknown result type (might be due to invalid IL or missing references)
            //IL_039b: Unknown result type (might be due to invalid IL or missing references)
            //IL_03a6: Expected O, but got Unknown
            //IL_03a7: Expected O, but got Unknown
            //IL_03c1: Unknown result type (might be due to invalid IL or missing references)
            //IL_03c6: Unknown result type (might be due to invalid IL or missing references)
            //IL_03d2: Expected O, but got Unknown
            //IL_03e3: Unknown result type (might be due to invalid IL or missing references)
            //IL_03e8: Unknown result type (might be due to invalid IL or missing references)
            //IL_03f3: Expected O, but got Unknown
            //IL_03f4: Expected O, but got Unknown
            //IL_040e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0413: Unknown result type (might be due to invalid IL or missing references)
            //IL_041f: Expected O, but got Unknown
            //IL_0430: Unknown result type (might be due to invalid IL or missing references)
            //IL_0435: Unknown result type (might be due to invalid IL or missing references)
            //IL_0440: Expected O, but got Unknown
            //IL_0441: Expected O, but got Unknown
            //IL_044c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0451: Unknown result type (might be due to invalid IL or missing references)
            //IL_0462: Expected O, but got Unknown
            //IL_0463: Expected O, but got Unknown
            string sql = "INSERT INTO WeiXinMessage\r\n\t\t\t\t(ID,ToUserName,FromUserName,CreateTime,CreateTime1,MsgType,MsgId,AgentID,Contents,PicUrl,MediaId,Format,ThumbMediaId,Location_X,Location_Y,Scale,Label,Title,Description,AddTime) \r\n\t\t\t\tVALUES(@ID,@ToUserName,@FromUserName,@CreateTime,@CreateTime1,@MsgType,@MsgId,@AgentID,@Contents,@PicUrl,@MediaId,@Format,@ThumbMediaId,@Location_X,@Location_Y,@Scale,@Label,@Title,@Description,@AddTime)";

            MySqlParameter[] obj = new MySqlParameter[20];
            MySqlParameter   val = new MySqlParameter("@ID", 253, 36);

            ((DbParameter)val).Value = model.ID;
            obj[0] = val;
            MySqlParameter val2 = new MySqlParameter("@ToUserName", 253, 200);

            ((DbParameter)val2).Value = model.ToUserName;
            obj[1] = val2;
            MySqlParameter val3 = new MySqlParameter("@FromUserName", 253, 200);

            ((DbParameter)val3).Value = model.FromUserName;
            obj[2] = val3;
            MySqlParameter val4 = new MySqlParameter("@CreateTime", 3, -1);

            ((DbParameter)val4).Value = model.CreateTime;
            obj[3] = val4;
            MySqlParameter val5 = new MySqlParameter("@CreateTime1", 12, 8);

            ((DbParameter)val5).Value = model.CreateTime1;
            obj[4] = val5;
            MySqlParameter val6 = new MySqlParameter("@MsgType", 253, 50);

            ((DbParameter)val6).Value = model.MsgType;
            obj[5] = val6;
            MySqlParameter val7 = new MySqlParameter("@MsgId", 8, -1);

            ((DbParameter)val7).Value = model.MsgId;
            obj[6] = val7;
            MySqlParameter val8 = new MySqlParameter("@AgentID", 3, -1);

            ((DbParameter)val8).Value = model.AgentID;
            obj[7] = val8;
            _003F val9;

            if (model.Contents != null)
            {
                val9 = new MySqlParameter("@Contents", 253, -1);
                ((DbParameter)val9).Value = model.Contents;
            }
            else
            {
                val9 = new MySqlParameter("@Contents", 253, -1);
                ((DbParameter)val9).Value = DBNull.Value;
            }
            obj[8] = val9;
            _003F val10;

            if (model.PicUrl != null)
            {
                val10 = new MySqlParameter("@PicUrl", 253, 500);
                ((DbParameter)val10).Value = model.PicUrl;
            }
            else
            {
                val10 = new MySqlParameter("@PicUrl", 253, 500);
                ((DbParameter)val10).Value = DBNull.Value;
            }
            obj[9] = val10;
            _003F val11;

            if (model.MediaId != null)
            {
                val11 = new MySqlParameter("@MediaId", 253, 500);
                ((DbParameter)val11).Value = model.MediaId;
            }
            else
            {
                val11 = new MySqlParameter("@MediaId", 253, 500);
                ((DbParameter)val11).Value = DBNull.Value;
            }
            obj[10] = val11;
            _003F val12;

            if (model.Format != null)
            {
                val12 = new MySqlParameter("@Format", 253, 50);
                ((DbParameter)val12).Value = model.Format;
            }
            else
            {
                val12 = new MySqlParameter("@Format", 253, 50);
                ((DbParameter)val12).Value = DBNull.Value;
            }
            obj[11] = val12;
            _003F val13;

            if (model.ThumbMediaId != null)
            {
                val13 = new MySqlParameter("@ThumbMediaId", 253, 50);
                ((DbParameter)val13).Value = model.ThumbMediaId;
            }
            else
            {
                val13 = new MySqlParameter("@ThumbMediaId", 253, 50);
                ((DbParameter)val13).Value = DBNull.Value;
            }
            obj[12] = val13;
            _003F val14;

            if (model.Location_X != null)
            {
                val14 = new MySqlParameter("@Location_X", 253, 50);
                ((DbParameter)val14).Value = model.Location_X;
            }
            else
            {
                val14 = new MySqlParameter("@Location_X", 253, 50);
                ((DbParameter)val14).Value = DBNull.Value;
            }
            obj[13] = val14;
            _003F val15;

            if (model.Location_Y != null)
            {
                val15 = new MySqlParameter("@Location_Y", 253, 50);
                ((DbParameter)val15).Value = model.Location_Y;
            }
            else
            {
                val15 = new MySqlParameter("@Location_Y", 253, 50);
                ((DbParameter)val15).Value = DBNull.Value;
            }
            obj[14] = val15;
            _003F val16;

            if (model.Scale != null)
            {
                val16 = new MySqlParameter("@Scale", 253, 50);
                ((DbParameter)val16).Value = model.Scale;
            }
            else
            {
                val16 = new MySqlParameter("@Scale", 253, 50);
                ((DbParameter)val16).Value = DBNull.Value;
            }
            obj[15] = val16;
            _003F val17;

            if (model.Label != null)
            {
                val17 = new MySqlParameter("@Label", 253, 1000);
                ((DbParameter)val17).Value = model.Label;
            }
            else
            {
                val17 = new MySqlParameter("@Label", 253, 1000);
                ((DbParameter)val17).Value = DBNull.Value;
            }
            obj[16] = val17;
            _003F val18;

            if (model.Title != null)
            {
                val18 = new MySqlParameter("@Title", 253, 1000);
                ((DbParameter)val18).Value = model.Title;
            }
            else
            {
                val18 = new MySqlParameter("@Title", 253, 1000);
                ((DbParameter)val18).Value = DBNull.Value;
            }
            obj[17] = val18;
            _003F val19;

            if (model.Description != null)
            {
                val19 = new MySqlParameter("@Description", 253, 2000);
                ((DbParameter)val19).Value = model.Description;
            }
            else
            {
                val19 = new MySqlParameter("@Description", 253, 2000);
                ((DbParameter)val19).Value = DBNull.Value;
            }
            obj[18] = val19;
            MySqlParameter val20 = new MySqlParameter("@AddTime", 12, 8);

            ((DbParameter)val20).Value = model.AddTime;
            obj[19] = val20;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
Ejemplo n.º 4
0
        public int Update(RoadFlow.Data.Model.WeiXinMessage model)
        {
            //IL_001e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0023: Unknown result type (might be due to invalid IL or missing references)
            //IL_002f: Expected O, but got Unknown
            //IL_0030: Expected O, but got Unknown
            //IL_0041: Unknown result type (might be due to invalid IL or missing references)
            //IL_0046: Unknown result type (might be due to invalid IL or missing references)
            //IL_0052: Expected O, but got Unknown
            //IL_0053: Expected O, but got Unknown
            //IL_005c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0061: Unknown result type (might be due to invalid IL or missing references)
            //IL_0072: Expected O, but got Unknown
            //IL_0073: Expected O, but got Unknown
            //IL_007d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0082: Unknown result type (might be due to invalid IL or missing references)
            //IL_0093: Expected O, but got Unknown
            //IL_0094: Expected O, but got Unknown
            //IL_00a2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a7: Unknown result type (might be due to invalid IL or missing references)
            //IL_00b3: Expected O, but got Unknown
            //IL_00b4: Expected O, but got Unknown
            //IL_00bd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00d3: Expected O, but got Unknown
            //IL_00d4: Expected O, but got Unknown
            //IL_00dd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00e2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00f3: Expected O, but got Unknown
            //IL_00f4: Expected O, but got Unknown
            //IL_0109: Unknown result type (might be due to invalid IL or missing references)
            //IL_010e: Unknown result type (might be due to invalid IL or missing references)
            //IL_011a: Expected O, but got Unknown
            //IL_0127: Unknown result type (might be due to invalid IL or missing references)
            //IL_012c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0137: Expected O, but got Unknown
            //IL_0138: Expected O, but got Unknown
            //IL_0151: Unknown result type (might be due to invalid IL or missing references)
            //IL_0156: Unknown result type (might be due to invalid IL or missing references)
            //IL_0162: Expected O, but got Unknown
            //IL_0173: Unknown result type (might be due to invalid IL or missing references)
            //IL_0178: Unknown result type (might be due to invalid IL or missing references)
            //IL_0183: Expected O, but got Unknown
            //IL_0184: Expected O, but got Unknown
            //IL_019e: Unknown result type (might be due to invalid IL or missing references)
            //IL_01a3: Unknown result type (might be due to invalid IL or missing references)
            //IL_01af: Expected O, but got Unknown
            //IL_01c0: Unknown result type (might be due to invalid IL or missing references)
            //IL_01c5: Unknown result type (might be due to invalid IL or missing references)
            //IL_01d0: Expected O, but got Unknown
            //IL_01d1: Expected O, but got Unknown
            //IL_01e8: Unknown result type (might be due to invalid IL or missing references)
            //IL_01ed: Unknown result type (might be due to invalid IL or missing references)
            //IL_01f9: Expected O, but got Unknown
            //IL_0207: Unknown result type (might be due to invalid IL or missing references)
            //IL_020c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0217: Expected O, but got Unknown
            //IL_0218: Expected O, but got Unknown
            //IL_022f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0234: Unknown result type (might be due to invalid IL or missing references)
            //IL_0240: Expected O, but got Unknown
            //IL_024e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0253: Unknown result type (might be due to invalid IL or missing references)
            //IL_025e: Expected O, but got Unknown
            //IL_025f: Expected O, but got Unknown
            //IL_0276: Unknown result type (might be due to invalid IL or missing references)
            //IL_027b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0287: Expected O, but got Unknown
            //IL_0295: Unknown result type (might be due to invalid IL or missing references)
            //IL_029a: Unknown result type (might be due to invalid IL or missing references)
            //IL_02a5: Expected O, but got Unknown
            //IL_02a6: Expected O, but got Unknown
            //IL_02bd: Unknown result type (might be due to invalid IL or missing references)
            //IL_02c2: Unknown result type (might be due to invalid IL or missing references)
            //IL_02ce: Expected O, but got Unknown
            //IL_02dc: Unknown result type (might be due to invalid IL or missing references)
            //IL_02e1: Unknown result type (might be due to invalid IL or missing references)
            //IL_02ec: Expected O, but got Unknown
            //IL_02ed: Expected O, but got Unknown
            //IL_0304: Unknown result type (might be due to invalid IL or missing references)
            //IL_0309: Unknown result type (might be due to invalid IL or missing references)
            //IL_0315: Expected O, but got Unknown
            //IL_0323: Unknown result type (might be due to invalid IL or missing references)
            //IL_0328: Unknown result type (might be due to invalid IL or missing references)
            //IL_0333: Expected O, but got Unknown
            //IL_0334: Expected O, but got Unknown
            //IL_034e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0353: Unknown result type (might be due to invalid IL or missing references)
            //IL_035f: Expected O, but got Unknown
            //IL_0370: Unknown result type (might be due to invalid IL or missing references)
            //IL_0375: Unknown result type (might be due to invalid IL or missing references)
            //IL_0380: Expected O, but got Unknown
            //IL_0381: Expected O, but got Unknown
            //IL_039b: Unknown result type (might be due to invalid IL or missing references)
            //IL_03a0: Unknown result type (might be due to invalid IL or missing references)
            //IL_03ac: Expected O, but got Unknown
            //IL_03bd: Unknown result type (might be due to invalid IL or missing references)
            //IL_03c2: Unknown result type (might be due to invalid IL or missing references)
            //IL_03cd: Expected O, but got Unknown
            //IL_03ce: Expected O, but got Unknown
            //IL_03e8: Unknown result type (might be due to invalid IL or missing references)
            //IL_03ed: Unknown result type (might be due to invalid IL or missing references)
            //IL_03f9: Expected O, but got Unknown
            //IL_040a: Unknown result type (might be due to invalid IL or missing references)
            //IL_040f: Unknown result type (might be due to invalid IL or missing references)
            //IL_041a: Expected O, but got Unknown
            //IL_041b: Expected O, but got Unknown
            //IL_0426: Unknown result type (might be due to invalid IL or missing references)
            //IL_042b: Unknown result type (might be due to invalid IL or missing references)
            //IL_043c: Expected O, but got Unknown
            //IL_043d: Expected O, but got Unknown
            //IL_044b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0450: Unknown result type (might be due to invalid IL or missing references)
            //IL_0461: Expected O, but got Unknown
            //IL_0462: Expected O, but got Unknown
            string sql = "UPDATE WeiXinMessage SET \r\n\t\t\t\tToUserName=@ToUserName,FromUserName=@FromUserName,CreateTime=@CreateTime,CreateTime1=@CreateTime1,MsgType=@MsgType,MsgId=@MsgId,AgentID=@AgentID,Contents=@Contents,PicUrl=@PicUrl,MediaId=@MediaId,Format=@Format,ThumbMediaId=@ThumbMediaId,Location_X=@Location_X,Location_Y=@Location_Y,Scale=@Scale,Label=@Label,Title=@Title,Description=@Description,AddTime=@AddTime\r\n\t\t\t\tWHERE ID=@ID";

            MySqlParameter[] obj = new MySqlParameter[20];
            MySqlParameter   val = new MySqlParameter("@ToUserName", 253, 200);

            ((DbParameter)val).Value = model.ToUserName;
            obj[0] = val;
            MySqlParameter val2 = new MySqlParameter("@FromUserName", 253, 200);

            ((DbParameter)val2).Value = model.FromUserName;
            obj[1] = val2;
            MySqlParameter val3 = new MySqlParameter("@CreateTime", 3, -1);

            ((DbParameter)val3).Value = model.CreateTime;
            obj[2] = val3;
            MySqlParameter val4 = new MySqlParameter("@CreateTime1", 12, 8);

            ((DbParameter)val4).Value = model.CreateTime1;
            obj[3] = val4;
            MySqlParameter val5 = new MySqlParameter("@MsgType", 253, 50);

            ((DbParameter)val5).Value = model.MsgType;
            obj[4] = val5;
            MySqlParameter val6 = new MySqlParameter("@MsgId", 8, -1);

            ((DbParameter)val6).Value = model.MsgId;
            obj[5] = val6;
            MySqlParameter val7 = new MySqlParameter("@AgentID", 3, -1);

            ((DbParameter)val7).Value = model.AgentID;
            obj[6] = val7;
            _003F val8;

            if (model.Contents != null)
            {
                val8 = new MySqlParameter("@Contents", 253, -1);
                ((DbParameter)val8).Value = model.Contents;
            }
            else
            {
                val8 = new MySqlParameter("@Contents", 253, -1);
                ((DbParameter)val8).Value = DBNull.Value;
            }
            obj[7] = val8;
            _003F val9;

            if (model.PicUrl != null)
            {
                val9 = new MySqlParameter("@PicUrl", 253, 500);
                ((DbParameter)val9).Value = model.PicUrl;
            }
            else
            {
                val9 = new MySqlParameter("@PicUrl", 253, 500);
                ((DbParameter)val9).Value = DBNull.Value;
            }
            obj[8] = val9;
            _003F val10;

            if (model.MediaId != null)
            {
                val10 = new MySqlParameter("@MediaId", 253, 500);
                ((DbParameter)val10).Value = model.MediaId;
            }
            else
            {
                val10 = new MySqlParameter("@MediaId", 253, 500);
                ((DbParameter)val10).Value = DBNull.Value;
            }
            obj[9] = val10;
            _003F val11;

            if (model.Format != null)
            {
                val11 = new MySqlParameter("@Format", 253, 50);
                ((DbParameter)val11).Value = model.Format;
            }
            else
            {
                val11 = new MySqlParameter("@Format", 253, 50);
                ((DbParameter)val11).Value = DBNull.Value;
            }
            obj[10] = val11;
            _003F val12;

            if (model.ThumbMediaId != null)
            {
                val12 = new MySqlParameter("@ThumbMediaId", 253, 50);
                ((DbParameter)val12).Value = model.ThumbMediaId;
            }
            else
            {
                val12 = new MySqlParameter("@ThumbMediaId", 253, 50);
                ((DbParameter)val12).Value = DBNull.Value;
            }
            obj[11] = val12;
            _003F val13;

            if (model.Location_X != null)
            {
                val13 = new MySqlParameter("@Location_X", 253, 50);
                ((DbParameter)val13).Value = model.Location_X;
            }
            else
            {
                val13 = new MySqlParameter("@Location_X", 253, 50);
                ((DbParameter)val13).Value = DBNull.Value;
            }
            obj[12] = val13;
            _003F val14;

            if (model.Location_Y != null)
            {
                val14 = new MySqlParameter("@Location_Y", 253, 50);
                ((DbParameter)val14).Value = model.Location_Y;
            }
            else
            {
                val14 = new MySqlParameter("@Location_Y", 253, 50);
                ((DbParameter)val14).Value = DBNull.Value;
            }
            obj[13] = val14;
            _003F val15;

            if (model.Scale != null)
            {
                val15 = new MySqlParameter("@Scale", 253, 50);
                ((DbParameter)val15).Value = model.Scale;
            }
            else
            {
                val15 = new MySqlParameter("@Scale", 253, 50);
                ((DbParameter)val15).Value = DBNull.Value;
            }
            obj[14] = val15;
            _003F val16;

            if (model.Label != null)
            {
                val16 = new MySqlParameter("@Label", 253, 1000);
                ((DbParameter)val16).Value = model.Label;
            }
            else
            {
                val16 = new MySqlParameter("@Label", 253, 1000);
                ((DbParameter)val16).Value = DBNull.Value;
            }
            obj[15] = val16;
            _003F val17;

            if (model.Title != null)
            {
                val17 = new MySqlParameter("@Title", 253, 1000);
                ((DbParameter)val17).Value = model.Title;
            }
            else
            {
                val17 = new MySqlParameter("@Title", 253, 1000);
                ((DbParameter)val17).Value = DBNull.Value;
            }
            obj[16] = val17;
            _003F val18;

            if (model.Description != null)
            {
                val18 = new MySqlParameter("@Description", 253, 2000);
                ((DbParameter)val18).Value = model.Description;
            }
            else
            {
                val18 = new MySqlParameter("@Description", 253, 2000);
                ((DbParameter)val18).Value = DBNull.Value;
            }
            obj[17] = val18;
            MySqlParameter val19 = new MySqlParameter("@AddTime", 12, 8);

            ((DbParameter)val19).Value = model.AddTime;
            obj[18] = val19;
            MySqlParameter val20 = new MySqlParameter("@ID", 253, -1);

            ((DbParameter)val20).Value = model.ID;
            obj[19] = val20;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
Ejemplo n.º 5
0
 public int Update(RoadFlow.Data.Model.WeiXinMessage model)
 {
     return(dataWeiXinMessage.Update(model));
 }
Ejemplo n.º 6
0
 public int Add(RoadFlow.Data.Model.WeiXinMessage model)
 {
     return(dataWeiXinMessage.Add(model));
 }
Ejemplo n.º 7
0

        
Ejemplo n.º 8
0
        public int Update(RoadFlow.Data.Model.WeiXinMessage model)
        {
            //IL_001b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0020: Unknown result type (might be due to invalid IL or missing references)
            //IL_002c: Expected O, but got Unknown
            //IL_002d: Expected O, but got Unknown
            //IL_003b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0040: Unknown result type (might be due to invalid IL or missing references)
            //IL_004c: Expected O, but got Unknown
            //IL_004d: Expected O, but got Unknown
            //IL_0057: Unknown result type (might be due to invalid IL or missing references)
            //IL_005c: Unknown result type (might be due to invalid IL or missing references)
            //IL_006d: Expected O, but got Unknown
            //IL_006e: Expected O, but got Unknown
            //IL_0078: Unknown result type (might be due to invalid IL or missing references)
            //IL_007d: Unknown result type (might be due to invalid IL or missing references)
            //IL_008e: Expected O, but got Unknown
            //IL_008f: Expected O, but got Unknown
            //IL_009a: Unknown result type (might be due to invalid IL or missing references)
            //IL_009f: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ab: Expected O, but got Unknown
            //IL_00ac: Expected O, but got Unknown
            //IL_00b6: Unknown result type (might be due to invalid IL or missing references)
            //IL_00bb: Unknown result type (might be due to invalid IL or missing references)
            //IL_00cc: Expected O, but got Unknown
            //IL_00cd: Expected O, but got Unknown
            //IL_00d7: Unknown result type (might be due to invalid IL or missing references)
            //IL_00dc: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ed: Expected O, but got Unknown
            //IL_00ee: Expected O, but got Unknown
            //IL_0100: Unknown result type (might be due to invalid IL or missing references)
            //IL_0105: Unknown result type (might be due to invalid IL or missing references)
            //IL_0111: Expected O, but got Unknown
            //IL_011b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0120: Unknown result type (might be due to invalid IL or missing references)
            //IL_012b: Expected O, but got Unknown
            //IL_012c: Expected O, but got Unknown
            //IL_0142: Unknown result type (might be due to invalid IL or missing references)
            //IL_0147: Unknown result type (might be due to invalid IL or missing references)
            //IL_0153: Expected O, but got Unknown
            //IL_0161: Unknown result type (might be due to invalid IL or missing references)
            //IL_0166: Unknown result type (might be due to invalid IL or missing references)
            //IL_0171: Expected O, but got Unknown
            //IL_0172: Expected O, but got Unknown
            //IL_0189: Unknown result type (might be due to invalid IL or missing references)
            //IL_018e: Unknown result type (might be due to invalid IL or missing references)
            //IL_019a: Expected O, but got Unknown
            //IL_01a8: Unknown result type (might be due to invalid IL or missing references)
            //IL_01ad: Unknown result type (might be due to invalid IL or missing references)
            //IL_01b8: Expected O, but got Unknown
            //IL_01b9: Expected O, but got Unknown
            //IL_01cd: Unknown result type (might be due to invalid IL or missing references)
            //IL_01d2: Unknown result type (might be due to invalid IL or missing references)
            //IL_01de: Expected O, but got Unknown
            //IL_01e9: Unknown result type (might be due to invalid IL or missing references)
            //IL_01ee: Unknown result type (might be due to invalid IL or missing references)
            //IL_01f9: Expected O, but got Unknown
            //IL_01fa: Expected O, but got Unknown
            //IL_020e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0213: Unknown result type (might be due to invalid IL or missing references)
            //IL_021f: Expected O, but got Unknown
            //IL_022a: Unknown result type (might be due to invalid IL or missing references)
            //IL_022f: Unknown result type (might be due to invalid IL or missing references)
            //IL_023a: Expected O, but got Unknown
            //IL_023b: Expected O, but got Unknown
            //IL_024f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0254: Unknown result type (might be due to invalid IL or missing references)
            //IL_0260: Expected O, but got Unknown
            //IL_026b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0270: Unknown result type (might be due to invalid IL or missing references)
            //IL_027b: Expected O, but got Unknown
            //IL_027c: Expected O, but got Unknown
            //IL_0290: Unknown result type (might be due to invalid IL or missing references)
            //IL_0295: Unknown result type (might be due to invalid IL or missing references)
            //IL_02a1: Expected O, but got Unknown
            //IL_02ac: Unknown result type (might be due to invalid IL or missing references)
            //IL_02b1: Unknown result type (might be due to invalid IL or missing references)
            //IL_02bc: Expected O, but got Unknown
            //IL_02bd: Expected O, but got Unknown
            //IL_02d1: Unknown result type (might be due to invalid IL or missing references)
            //IL_02d6: Unknown result type (might be due to invalid IL or missing references)
            //IL_02e2: Expected O, but got Unknown
            //IL_02ed: Unknown result type (might be due to invalid IL or missing references)
            //IL_02f2: Unknown result type (might be due to invalid IL or missing references)
            //IL_02fd: Expected O, but got Unknown
            //IL_02fe: Expected O, but got Unknown
            //IL_0315: Unknown result type (might be due to invalid IL or missing references)
            //IL_031a: Unknown result type (might be due to invalid IL or missing references)
            //IL_0326: Expected O, but got Unknown
            //IL_0334: Unknown result type (might be due to invalid IL or missing references)
            //IL_0339: Unknown result type (might be due to invalid IL or missing references)
            //IL_0344: Expected O, but got Unknown
            //IL_0345: Expected O, but got Unknown
            //IL_035c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0361: Unknown result type (might be due to invalid IL or missing references)
            //IL_036d: Expected O, but got Unknown
            //IL_037b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0380: Unknown result type (might be due to invalid IL or missing references)
            //IL_038b: Expected O, but got Unknown
            //IL_038c: Expected O, but got Unknown
            //IL_03a3: Unknown result type (might be due to invalid IL or missing references)
            //IL_03a8: Unknown result type (might be due to invalid IL or missing references)
            //IL_03b4: Expected O, but got Unknown
            //IL_03c2: Unknown result type (might be due to invalid IL or missing references)
            //IL_03c7: Unknown result type (might be due to invalid IL or missing references)
            //IL_03d2: Expected O, but got Unknown
            //IL_03d3: Expected O, but got Unknown
            //IL_03de: Unknown result type (might be due to invalid IL or missing references)
            //IL_03e3: Unknown result type (might be due to invalid IL or missing references)
            //IL_03f4: Expected O, but got Unknown
            //IL_03f5: Expected O, but got Unknown
            //IL_0400: Unknown result type (might be due to invalid IL or missing references)
            //IL_0405: Unknown result type (might be due to invalid IL or missing references)
            //IL_0416: Expected O, but got Unknown
            //IL_0417: Expected O, but got Unknown
            string sql = "UPDATE WeiXinMessage SET \r\n\t\t\t\tToUserName=:ToUserName,FromUserName=:FromUserName,CreateTime=:CreateTime,CreateTime1=:CreateTime1,MsgType=:MsgType,MsgId=:MsgId,AgentID=:AgentID,Contents=:Contents,PicUrl=:PicUrl,MediaId=:MediaId,Format=:Format,ThumbMediaId=:ThumbMediaId,Location_X=:Location_X,Location_Y=:Location_Y,Scale=:Scale,Label=:Label,Title=:Title,Description=:Description,AddTime=:AddTime\r\n\t\t\t\tWHERE ID=:ID";

            OracleParameter[] obj = new OracleParameter[20];
            OracleParameter   val = new OracleParameter(":ToUserName", 126, 200);

            ((DbParameter)val).Value = model.ToUserName;
            obj[0] = val;
            OracleParameter val2 = new OracleParameter(":FromUserName", 126, 200);

            ((DbParameter)val2).Value = model.FromUserName;
            obj[1] = val2;
            OracleParameter val3 = new OracleParameter(":CreateTime", 112, -1);

            ((DbParameter)val3).Value = model.CreateTime;
            obj[2] = val3;
            OracleParameter val4 = new OracleParameter(":CreateTime1", 106, 8);

            ((DbParameter)val4).Value = model.CreateTime1;
            obj[3] = val4;
            OracleParameter val5 = new OracleParameter(":MsgType", 126, 50);

            ((DbParameter)val5).Value = model.MsgType;
            obj[4] = val5;
            OracleParameter val6 = new OracleParameter(":MsgId", 113, -1);

            ((DbParameter)val6).Value = model.MsgId;
            obj[5] = val6;
            OracleParameter val7 = new OracleParameter(":AgentID", 112, -1);

            ((DbParameter)val7).Value = model.AgentID;
            obj[6] = val7;
            _003F val8;

            if (model.Contents != null)
            {
                val8 = new OracleParameter(":Contents", 119, -1);
                ((DbParameter)val8).Value = model.Contents;
            }
            else
            {
                val8 = new OracleParameter(":Contents", 119, -1);
                ((DbParameter)val8).Value = DBNull.Value;
            }
            obj[7] = val8;
            _003F val9;

            if (model.PicUrl != null)
            {
                val9 = new OracleParameter(":PicUrl", 126, 500);
                ((DbParameter)val9).Value = model.PicUrl;
            }
            else
            {
                val9 = new OracleParameter(":PicUrl", 126, 500);
                ((DbParameter)val9).Value = DBNull.Value;
            }
            obj[8] = val9;
            _003F val10;

            if (model.MediaId != null)
            {
                val10 = new OracleParameter(":MediaId", 126, 500);
                ((DbParameter)val10).Value = model.MediaId;
            }
            else
            {
                val10 = new OracleParameter(":MediaId", 126, 500);
                ((DbParameter)val10).Value = DBNull.Value;
            }
            obj[9] = val10;
            _003F val11;

            if (model.Format != null)
            {
                val11 = new OracleParameter(":Format", 126, 50);
                ((DbParameter)val11).Value = model.Format;
            }
            else
            {
                val11 = new OracleParameter(":Format", 126, 50);
                ((DbParameter)val11).Value = DBNull.Value;
            }
            obj[10] = val11;
            _003F val12;

            if (model.ThumbMediaId != null)
            {
                val12 = new OracleParameter(":ThumbMediaId", 126, 50);
                ((DbParameter)val12).Value = model.ThumbMediaId;
            }
            else
            {
                val12 = new OracleParameter(":ThumbMediaId", 126, 50);
                ((DbParameter)val12).Value = DBNull.Value;
            }
            obj[11] = val12;
            _003F val13;

            if (model.Location_X != null)
            {
                val13 = new OracleParameter(":Location_X", 126, 50);
                ((DbParameter)val13).Value = model.Location_X;
            }
            else
            {
                val13 = new OracleParameter(":Location_X", 126, 50);
                ((DbParameter)val13).Value = DBNull.Value;
            }
            obj[12] = val13;
            _003F val14;

            if (model.Location_Y != null)
            {
                val14 = new OracleParameter(":Location_Y", 126, 50);
                ((DbParameter)val14).Value = model.Location_Y;
            }
            else
            {
                val14 = new OracleParameter(":Location_Y", 126, 50);
                ((DbParameter)val14).Value = DBNull.Value;
            }
            obj[13] = val14;
            _003F val15;

            if (model.Scale != null)
            {
                val15 = new OracleParameter(":Scale", 126, 50);
                ((DbParameter)val15).Value = model.Scale;
            }
            else
            {
                val15 = new OracleParameter(":Scale", 126, 50);
                ((DbParameter)val15).Value = DBNull.Value;
            }
            obj[14] = val15;
            _003F val16;

            if (model.Label != null)
            {
                val16 = new OracleParameter(":Label", 119, 1000);
                ((DbParameter)val16).Value = model.Label;
            }
            else
            {
                val16 = new OracleParameter(":Label", 119, 1000);
                ((DbParameter)val16).Value = DBNull.Value;
            }
            obj[15] = val16;
            _003F val17;

            if (model.Title != null)
            {
                val17 = new OracleParameter(":Title", 119, 1000);
                ((DbParameter)val17).Value = model.Title;
            }
            else
            {
                val17 = new OracleParameter(":Title", 119, 1000);
                ((DbParameter)val17).Value = DBNull.Value;
            }
            obj[16] = val17;
            _003F val18;

            if (model.Description != null)
            {
                val18 = new OracleParameter(":Description", 119, 2000);
                ((DbParameter)val18).Value = model.Description;
            }
            else
            {
                val18 = new OracleParameter(":Description", 119, 2000);
                ((DbParameter)val18).Value = DBNull.Value;
            }
            obj[17] = val18;
            OracleParameter val19 = new OracleParameter(":AddTime", 106, 8);

            ((DbParameter)val19).Value = model.AddTime;
            obj[18] = val19;
            OracleParameter val20 = new OracleParameter(":ID", 126, -1);

            ((DbParameter)val20).Value = model.ID;
            obj[19] = val20;
            OracleParameter[] parameter = (OracleParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
Ejemplo n.º 9
0
        public int Add(RoadFlow.Data.Model.WeiXinMessage model)
        {
            //IL_0018: Unknown result type (might be due to invalid IL or missing references)
            //IL_001d: Unknown result type (might be due to invalid IL or missing references)
            //IL_002e: Expected O, but got Unknown
            //IL_002f: Expected O, but got Unknown
            //IL_003d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0042: Unknown result type (might be due to invalid IL or missing references)
            //IL_004e: Expected O, but got Unknown
            //IL_004f: Expected O, but got Unknown
            //IL_005d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0062: Unknown result type (might be due to invalid IL or missing references)
            //IL_006e: Expected O, but got Unknown
            //IL_006f: Expected O, but got Unknown
            //IL_0079: Unknown result type (might be due to invalid IL or missing references)
            //IL_007e: Unknown result type (might be due to invalid IL or missing references)
            //IL_008f: Expected O, but got Unknown
            //IL_0090: Expected O, but got Unknown
            //IL_009a: Unknown result type (might be due to invalid IL or missing references)
            //IL_009f: Unknown result type (might be due to invalid IL or missing references)
            //IL_00b0: Expected O, but got Unknown
            //IL_00b1: Expected O, but got Unknown
            //IL_00bc: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c1: Unknown result type (might be due to invalid IL or missing references)
            //IL_00cd: Expected O, but got Unknown
            //IL_00ce: Expected O, but got Unknown
            //IL_00d8: Unknown result type (might be due to invalid IL or missing references)
            //IL_00dd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ee: Expected O, but got Unknown
            //IL_00ef: Expected O, but got Unknown
            //IL_00f9: Unknown result type (might be due to invalid IL or missing references)
            //IL_00fe: Unknown result type (might be due to invalid IL or missing references)
            //IL_010f: Expected O, but got Unknown
            //IL_0110: Expected O, but got Unknown
            //IL_0122: Unknown result type (might be due to invalid IL or missing references)
            //IL_0127: Unknown result type (might be due to invalid IL or missing references)
            //IL_0133: Expected O, but got Unknown
            //IL_013d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0142: Unknown result type (might be due to invalid IL or missing references)
            //IL_014d: Expected O, but got Unknown
            //IL_014e: Expected O, but got Unknown
            //IL_0165: Unknown result type (might be due to invalid IL or missing references)
            //IL_016a: Unknown result type (might be due to invalid IL or missing references)
            //IL_0176: Expected O, but got Unknown
            //IL_0184: Unknown result type (might be due to invalid IL or missing references)
            //IL_0189: Unknown result type (might be due to invalid IL or missing references)
            //IL_0194: Expected O, but got Unknown
            //IL_0195: Expected O, but got Unknown
            //IL_01ac: Unknown result type (might be due to invalid IL or missing references)
            //IL_01b1: Unknown result type (might be due to invalid IL or missing references)
            //IL_01bd: Expected O, but got Unknown
            //IL_01cb: Unknown result type (might be due to invalid IL or missing references)
            //IL_01d0: Unknown result type (might be due to invalid IL or missing references)
            //IL_01db: Expected O, but got Unknown
            //IL_01dc: Expected O, but got Unknown
            //IL_01f0: Unknown result type (might be due to invalid IL or missing references)
            //IL_01f5: Unknown result type (might be due to invalid IL or missing references)
            //IL_0201: Expected O, but got Unknown
            //IL_020c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0211: Unknown result type (might be due to invalid IL or missing references)
            //IL_021c: Expected O, but got Unknown
            //IL_021d: Expected O, but got Unknown
            //IL_0231: Unknown result type (might be due to invalid IL or missing references)
            //IL_0236: Unknown result type (might be due to invalid IL or missing references)
            //IL_0242: Expected O, but got Unknown
            //IL_024d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0252: Unknown result type (might be due to invalid IL or missing references)
            //IL_025d: Expected O, but got Unknown
            //IL_025e: Expected O, but got Unknown
            //IL_0272: Unknown result type (might be due to invalid IL or missing references)
            //IL_0277: Unknown result type (might be due to invalid IL or missing references)
            //IL_0283: Expected O, but got Unknown
            //IL_028e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0293: Unknown result type (might be due to invalid IL or missing references)
            //IL_029e: Expected O, but got Unknown
            //IL_029f: Expected O, but got Unknown
            //IL_02b3: Unknown result type (might be due to invalid IL or missing references)
            //IL_02b8: Unknown result type (might be due to invalid IL or missing references)
            //IL_02c4: Expected O, but got Unknown
            //IL_02cf: Unknown result type (might be due to invalid IL or missing references)
            //IL_02d4: Unknown result type (might be due to invalid IL or missing references)
            //IL_02df: Expected O, but got Unknown
            //IL_02e0: Expected O, but got Unknown
            //IL_02f4: Unknown result type (might be due to invalid IL or missing references)
            //IL_02f9: Unknown result type (might be due to invalid IL or missing references)
            //IL_0305: Expected O, but got Unknown
            //IL_0310: Unknown result type (might be due to invalid IL or missing references)
            //IL_0315: Unknown result type (might be due to invalid IL or missing references)
            //IL_0320: Expected O, but got Unknown
            //IL_0321: Expected O, but got Unknown
            //IL_0338: Unknown result type (might be due to invalid IL or missing references)
            //IL_033d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0349: Expected O, but got Unknown
            //IL_0357: Unknown result type (might be due to invalid IL or missing references)
            //IL_035c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0367: Expected O, but got Unknown
            //IL_0368: Expected O, but got Unknown
            //IL_037f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0384: Unknown result type (might be due to invalid IL or missing references)
            //IL_0390: Expected O, but got Unknown
            //IL_039e: Unknown result type (might be due to invalid IL or missing references)
            //IL_03a3: Unknown result type (might be due to invalid IL or missing references)
            //IL_03ae: Expected O, but got Unknown
            //IL_03af: Expected O, but got Unknown
            //IL_03c6: Unknown result type (might be due to invalid IL or missing references)
            //IL_03cb: Unknown result type (might be due to invalid IL or missing references)
            //IL_03d7: Expected O, but got Unknown
            //IL_03e5: Unknown result type (might be due to invalid IL or missing references)
            //IL_03ea: Unknown result type (might be due to invalid IL or missing references)
            //IL_03f5: Expected O, but got Unknown
            //IL_03f6: Expected O, but got Unknown
            //IL_0401: Unknown result type (might be due to invalid IL or missing references)
            //IL_0406: Unknown result type (might be due to invalid IL or missing references)
            //IL_0417: Expected O, but got Unknown
            //IL_0418: Expected O, but got Unknown
            string sql = "INSERT INTO WeiXinMessage\r\n\t\t\t\t(ID,ToUserName,FromUserName,CreateTime,CreateTime1,MsgType,MsgId,AgentID,Contents,PicUrl,MediaId,Format,ThumbMediaId,Location_X,Location_Y,Scale,Label,Title,Description,AddTime) \r\n\t\t\t\tVALUES(:ID,:ToUserName,:FromUserName,:CreateTime,:CreateTime1,:MsgType,:MsgId,:AgentID,:Contents,:PicUrl,:MediaId,:Format,:ThumbMediaId,:Location_X,:Location_Y,:Scale,:Label,:Title,:Description,:AddTime)";

            OracleParameter[] obj = new OracleParameter[20];
            OracleParameter   val = new OracleParameter(":ID", 126, 36);

            ((DbParameter)val).Value = model.ID;
            obj[0] = val;
            OracleParameter val2 = new OracleParameter(":ToUserName", 126, 200);

            ((DbParameter)val2).Value = model.ToUserName;
            obj[1] = val2;
            OracleParameter val3 = new OracleParameter(":FromUserName", 126, 200);

            ((DbParameter)val3).Value = model.FromUserName;
            obj[2] = val3;
            OracleParameter val4 = new OracleParameter(":CreateTime", 112, -1);

            ((DbParameter)val4).Value = model.CreateTime;
            obj[3] = val4;
            OracleParameter val5 = new OracleParameter(":CreateTime1", 106, 8);

            ((DbParameter)val5).Value = model.CreateTime1;
            obj[4] = val5;
            OracleParameter val6 = new OracleParameter(":MsgType", 126, 50);

            ((DbParameter)val6).Value = model.MsgType;
            obj[5] = val6;
            OracleParameter val7 = new OracleParameter(":MsgId", 113, -1);

            ((DbParameter)val7).Value = model.MsgId;
            obj[6] = val7;
            OracleParameter val8 = new OracleParameter(":AgentID", 112, -1);

            ((DbParameter)val8).Value = model.AgentID;
            obj[7] = val8;
            _003F val9;

            if (model.Contents != null)
            {
                val9 = new OracleParameter(":Contents", 119, -1);
                ((DbParameter)val9).Value = model.Contents;
            }
            else
            {
                val9 = new OracleParameter(":Contents", 119, -1);
                ((DbParameter)val9).Value = DBNull.Value;
            }
            obj[8] = val9;
            _003F val10;

            if (model.PicUrl != null)
            {
                val10 = new OracleParameter(":PicUrl", 126, 500);
                ((DbParameter)val10).Value = model.PicUrl;
            }
            else
            {
                val10 = new OracleParameter(":PicUrl", 126, 500);
                ((DbParameter)val10).Value = DBNull.Value;
            }
            obj[9] = val10;
            _003F val11;

            if (model.MediaId != null)
            {
                val11 = new OracleParameter(":MediaId", 126, 500);
                ((DbParameter)val11).Value = model.MediaId;
            }
            else
            {
                val11 = new OracleParameter(":MediaId", 126, 500);
                ((DbParameter)val11).Value = DBNull.Value;
            }
            obj[10] = val11;
            _003F val12;

            if (model.Format != null)
            {
                val12 = new OracleParameter(":Format", 126, 50);
                ((DbParameter)val12).Value = model.Format;
            }
            else
            {
                val12 = new OracleParameter(":Format", 126, 50);
                ((DbParameter)val12).Value = DBNull.Value;
            }
            obj[11] = val12;
            _003F val13;

            if (model.ThumbMediaId != null)
            {
                val13 = new OracleParameter(":ThumbMediaId", 126, 50);
                ((DbParameter)val13).Value = model.ThumbMediaId;
            }
            else
            {
                val13 = new OracleParameter(":ThumbMediaId", 126, 50);
                ((DbParameter)val13).Value = DBNull.Value;
            }
            obj[12] = val13;
            _003F val14;

            if (model.Location_X != null)
            {
                val14 = new OracleParameter(":Location_X", 126, 50);
                ((DbParameter)val14).Value = model.Location_X;
            }
            else
            {
                val14 = new OracleParameter(":Location_X", 126, 50);
                ((DbParameter)val14).Value = DBNull.Value;
            }
            obj[13] = val14;
            _003F val15;

            if (model.Location_Y != null)
            {
                val15 = new OracleParameter(":Location_Y", 126, 50);
                ((DbParameter)val15).Value = model.Location_Y;
            }
            else
            {
                val15 = new OracleParameter(":Location_Y", 126, 50);
                ((DbParameter)val15).Value = DBNull.Value;
            }
            obj[14] = val15;
            _003F val16;

            if (model.Scale != null)
            {
                val16 = new OracleParameter(":Scale", 126, 50);
                ((DbParameter)val16).Value = model.Scale;
            }
            else
            {
                val16 = new OracleParameter(":Scale", 126, 50);
                ((DbParameter)val16).Value = DBNull.Value;
            }
            obj[15] = val16;
            _003F val17;

            if (model.Label != null)
            {
                val17 = new OracleParameter(":Label", 119, 1000);
                ((DbParameter)val17).Value = model.Label;
            }
            else
            {
                val17 = new OracleParameter(":Label", 119, 1000);
                ((DbParameter)val17).Value = DBNull.Value;
            }
            obj[16] = val17;
            _003F val18;

            if (model.Title != null)
            {
                val18 = new OracleParameter(":Title", 119, 1000);
                ((DbParameter)val18).Value = model.Title;
            }
            else
            {
                val18 = new OracleParameter(":Title", 119, 1000);
                ((DbParameter)val18).Value = DBNull.Value;
            }
            obj[17] = val18;
            _003F val19;

            if (model.Description != null)
            {
                val19 = new OracleParameter(":Description", 119, 2000);
                ((DbParameter)val19).Value = model.Description;
            }
            else
            {
                val19 = new OracleParameter(":Description", 119, 2000);
                ((DbParameter)val19).Value = DBNull.Value;
            }
            obj[18] = val19;
            OracleParameter val20 = new OracleParameter(":AddTime", 106, 8);

            ((DbParameter)val20).Value = model.AddTime;
            obj[19] = val20;
            OracleParameter[] parameter = (OracleParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }