Exemple #1
0
        private ErrorCode DBAsynQueryGameMailList(DBActiveWrapper db, long objIdx)
        {
            string sqlStr = "select * from game_mail where mail_del_state<> " + MailCurtState.Del;

            if (objIdx > 0)
            {
                sqlStr += " and mail_user_id = " + objIdx;
            }
            else
            {
                sqlStr += " and (mail_user_id is NULL or mail_user_id < 1) ";
            }
            sqlStr += " and unix_timestamp(mail_over_time ) > unix_timestamp(NOW()) order by mail_id DESC;";

            ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
            {
                while (dataReader.Read())
                {
                    MailDBData mailDb = new MailDBData
                    {
                        mailId      = dataReader.GetInt32("mail_id"),
                        mailType    = ( MailType )dataReader.GetInt32("mail_type"),
                        channelId   = dataReader.GetInt32("mail_sdk"),
                        mailTitle   = dataReader.GetString("mail_title"),
                        mailContent = dataReader.GetString("mail_content"),
                        mailGift    = dataReader.GetString("mail_gift"),
                        szSender    = dataReader.GetString("mail_send"),
                        mCreateTime = dataReader.GetString("mail_create_time"),
                        mEndTime    = dataReader.GetString("mail_over_time")
                    };
                    mailDb.objIdx = objIdx > 0 ? objIdx : mailDb.objIdx;

                    DBToCS.MailCallBack pMsg = new DBToCS.MailCallBack
                    {
                        Mailid     = mailDb.mailId,
                        Mailtype   = ( int )mailDb.mailType,
                        Channel    = mailDb.channelId,
                        Title      = mailDb.mailTitle,
                        Content    = mailDb.mailContent,
                        Gift       = mailDb.mailGift,
                        Sender     = mailDb.szSender,
                        Createtime = mailDb.mCreateTime,
                        Objid      = mailDb.objIdx
                    };
                    CS.instance.userMgr.EncodeAndSendToLogicThread(pMsg, ( int )DBToCS.MsgID.EMailCallBack);
                }
                return(ErrorCode.Success);
            });

            return(errorCode);
        }
Exemple #2
0
        private void SynHandleMailCallback(GBuffer buffer)
        {
            DBToCS.MailCallBack pMsg = new DBToCS.MailCallBack();
            pMsg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);

            MailDBData mailDb = new MailDBData();

            mailDb.mailId      = pMsg.Mailid;
            mailDb.mailType    = ( MailType )pMsg.Mailtype;
            mailDb.channelId   = pMsg.Channel;
            mailDb.mailContent = pMsg.Content;
            mailDb.mailTitle   = pMsg.Title;
            mailDb.mailGift    = pMsg.Gift;
            mailDb.szSender    = pMsg.Sender;
            mailDb.mCreateTime = pMsg.Createtime;
            //todo
            //mailDb.n64CreateTime = CFunction::FormatTime2TimeT( mailDb.mCreateTime );
            //mailDb.n64EndTime = CFunction::FormatTime2TimeT( mailDb.mEndTime );
            mailDb.objIdx = pMsg.Objid;
            CS.instance.mailMgr.AddGameMail(mailDb);
        }