Пример #1
0
        private void JPush_Insert(ReturnDalInfo info, string alarmContent, string isPush, string errInfo)
        {
            Tb_WechatMessage_Mod w = new Tb_WechatMessage_Mod();

            w.ListId       = Guid.NewGuid().ToString("N");
            w.WechatId     = info.UserToken;
            w.MessageType  = 1;
            w.ProtocolType = Convert.ToInt32(Info.ProtocolType);
            w.Message      = alarmContent;
            w.IsSuccess    = isPush;
            w.PushType     = "4";
            w.SourceId     = Info.Reason;
            w.Reserved1    = errInfo;
            w.Reserved2    = info.Identitycard;
            w.Reserved4    = GetName(info.AppcardType);
            Tb_WechatMessage_Dal.Insert(w);
        }
        public static void Insert(Tb_WechatMessage_Mod info)
        {
            Database  db  = DataConnect.GetConnect;
            DbCommand cmd = db.GetSqlStringCommand("insert into TB_WECHATMESSAGE (listid,wechatid,messagetype,protocoltype,message,pushtime,issuccess,sourceid,isalarm,reserved1,reserved2,reserved3,reserved4,PushType)values(:listid,:wechatid,:messagetype,:protocoltype,:message,sysdate,:issuccess,:sourceid,:isalarm,:reserved1,:reserved2,:reserved3,:reserved4,:PushType)");

            db.AddInParameter(cmd, ":listid", DbType.String, info.ListId);
            db.AddInParameter(cmd, ":wechatid", DbType.String, info.WechatId);
            db.AddInParameter(cmd, ":messagetype", DbType.String, info.MessageType);
            db.AddInParameter(cmd, ":protocoltype", DbType.String, info.ProtocolType);
            db.AddInParameter(cmd, ":message", DbType.String, info.Message);
            db.AddInParameter(cmd, ":issuccess", DbType.String, info.IsSuccess);
            db.AddInParameter(cmd, ":sourceid", DbType.String, info.SourceId);
            db.AddInParameter(cmd, ":isalarm", DbType.String, info.IsAlarm);
            db.AddInParameter(cmd, ":reserved1", DbType.String, info.Reserved1);
            db.AddInParameter(cmd, ":reserved2", DbType.String, info.Reserved2);
            db.AddInParameter(cmd, ":reserved3", DbType.String, info.Reserved3);
            db.AddInParameter(cmd, ":reserved4", DbType.String, info.Reserved4);
            db.AddInParameter(cmd, ":PushType", DbType.String, info.PushType);
            db.ExecuteNonQuery(cmd);
        }
        private void Insert(string content, bool IsSend, string SendResult)
        {
            Tb_WechatMessage_Mod log = new Tb_WechatMessage_Mod();

            log.ListId       = Guid.NewGuid().ToString("N");
            log.WechatId     = Info.Phone;
            log.MessageType  = 1;
            log.ProtocolType = Convert.ToInt32(Info.SubCmd);
            log.SourceId     = Info.Reason;
            log.Message      = content;
            log.Reserved2    = Info.UserId;
            log.PushType     = "2";
            log.IsSuccess    = IsSend ? "1" : "2";
            if (SendResult.Length >= 100)
            {
                SendResult = SendResult.Substring(0, 100);
            }
            log.Reserved1 = log.IsSuccess == "1" ? "" : SendResult;
            Tb_WechatMessage_Dal.Insert(log);
        }