コード例 #1
0
        /// <summary>
        /// 结束会话
        /// </summary>
        /// <param name="session"></param>
        /// <param name="lstParams">
        /// lstParams[0] : CookieID
        /// </param>
        /// <returns></returns>
        public static OperationReturn EndCookie(SessionInfo session, List <string> lstParams)
        {
            OperationReturn optReturn = new OperationReturn();

            try
            {
                //LogOperation.WriteLog("End cookie ");
                string strToken  = session.RentInfo.Token;
                long   lCookieID = long.Parse(lstParams[0]);
                long   now       = 0;
                CommonFuncs.DateTimeToNumber(DateTime.Now, ref now);
                long nowUtc = 0;
                CommonFuncs.DateTimeToNumber(DateTime.Now.ToUniversalTime(), ref nowUtc);
                string strSql = string.Empty;

                switch (session.DBType)
                {
                case 2:
                    strSql    = "update t_16_001_{0} set C004 = {1} ,C005 = {2} where C001 = {3}";
                    strSql    = string.Format(strSql, strToken, now, nowUtc, lCookieID);
                    optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
                    break;

                case 3:
                    strSql    = "update t_16_001_{0} set C004 = {1} ,C005 = {2} where C001 = {3}";
                    strSql    = string.Format(strSql, strToken, now, nowUtc, lCookieID);
                    optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
                    break;
                }
                if (!optReturn.Result)
                {
                    //LogOperation.WriteLog("EndCookie failed : " + optReturn.Message);
                    return(optReturn);
                }
                optReturn.Result = true;
            }
            catch (Exception ex)
            {
                //LogOperation.WriteLog("EndCookie exception : " + ex.Message);
                optReturn.Result = false;
            }
            return(optReturn);
        }
コード例 #2
0
        /// <summary>
        /// 将聊天记录写进数据库
        /// </summary>
        /// <param name="session"></param>
        /// <param name="lstParams">
        /// lstParams[0] : 是否创建新cookie 0:创建 1:不创建
        /// lstParams[1] : 2:在线消息 3:离线消息(直接用此值拼表名)
        /// </param>
        /// <returns></returns>
        public static OperationReturn WriteChatMsg(SessionInfo session, ChatMessage chatMsg, List <string> lstParams)
        {
            OperationReturn optReturn = new OperationReturn();

            try
            {
                string strSql    = string.Empty;
                string strToken  = session.RentInfo.Token;
                long   lCookieID = 0;
                long   now       = 0;
                CommonFuncs.DateTimeToNumber(DateTime.Now, ref now);
                long nowUtc = 0;
                CommonFuncs.DateTimeToNumber(DateTime.Now.ToUniversalTime(), ref nowUtc);
                List <string> lstSerialParam = new List <string>();
                if (lstParams[0] == "0")
                {
                    //创建新会话
                    lstSerialParam.Add("16");
                    lstSerialParam.Add("161");
                    optReturn = GetSerialID(session, lstSerialParam);
                    if (!optReturn.Result)
                    {
                        //LogOperation.WriteLog("WriteChatMsg GetSerialID error: " + optReturn.Message);
                        return(optReturn);
                    }
                    lCookieID = long.Parse(optReturn.Data.ToString());
                    // LogOperation.WriteLog("Create new cookie "+lCookieID.ToString());
                    switch (session.DBType)
                    {
                    case 2:
                        strSql    = "insert into t_16_001_{0}(C001,C002,C003,C006,C007,C008,C009) values({1},{2},{3},{4},'1',{5},'1')";
                        strSql    = string.Format(strSql, strToken, lCookieID, now, nowUtc, chatMsg.SenderID, chatMsg.ResourceID);
                        optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
                        break;

                    case 3:
                        strSql    = "insert into t_16_001_{0}(C001,C002,C003,C006,C007,C008,C009) values({1},{2},{3},{4},'1',{5},'1')";
                        strSql    = string.Format(strSql, strToken, lCookieID, now, nowUtc, chatMsg.SenderID, chatMsg.ResourceID);
                        optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
                        break;
                    }
                    if (!optReturn.Result)
                    {
                        // LogOperation.WriteLog("Create cookie error:" + optReturn.Message);
                        return(optReturn);
                    }
                }
                else
                {
                    // LogOperation.WriteLog("Cookie exists");
                    lCookieID = chatMsg.CookieID;
                }
                //写消息详细记录
                // LogOperation.WriteLog("Add chat message,database type = " + session.DatabaseInfo.TypeName);
                string strTableName = lstParams[1];
                if (strTableName == "3")
                {
                    //如果是离线消息 需要获得流水号 流水号用来在发送完离线消息后删除该消息
                    lstSerialParam.Clear();
                    lstSerialParam.Add("16");
                    lstSerialParam.Add("162");
                    optReturn = GetSerialID(session, lstSerialParam);
                    if (!optReturn.Result)
                    {
                        // LogOperation.WriteLog("Create offline serialID error : " + optReturn.Message);
                        return(optReturn);
                    }
                    // LogOperation.WriteLog("create offline msgID : " + optReturn.Data.ToString());
                    long lMsgID = long.Parse(optReturn.Data.ToString());
                    switch (session.DBType)
                    {
                    case 2:
                        strSql = "insert into t_16_00{0}_{1} values({10},{2},{3},{4},{5},'{6}',{7},'{8}','{9}')";
                        strSql = string.Format(strSql, lstParams[1], strToken, lCookieID, now, nowUtc,
                                               chatMsg.SenderID, chatMsg.SenderName, chatMsg.ReceiverID, chatMsg.ReceiverName, chatMsg.MsgContent, lMsgID);
                        optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);

                        break;

                    case 3:
                        strSql = "insert into t_16_00{0}_{1} values({10},{2},{3},{4},{5},'{6}',{7},'{8}','{9}')";
                        strSql = string.Format(strSql, lstParams[1], strToken, lCookieID, now, nowUtc,
                                               chatMsg.SenderID, chatMsg.SenderName, chatMsg.ReceiverID, chatMsg.ReceiverName, chatMsg.MsgContent, lMsgID);
                        optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
                        break;
                    }
                }
                else
                {
                    switch (session.DBType)
                    {
                    case 2:
                        strSql = "insert into t_16_00{0}_{1} values({2},{3},{4},{5},'{6}',{7},'{8}','{9}')";
                        strSql = string.Format(strSql, lstParams[1], strToken, lCookieID, now, nowUtc,
                                               chatMsg.SenderID, chatMsg.SenderName, chatMsg.ReceiverID, chatMsg.ReceiverName, chatMsg.MsgContent);
                        optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);

                        break;

                    case 3:
                        strSql = "insert into t_16_00{0}_{1} values({2},{3},{4},{5},'{6}',{7},'{8}','{9}')";
                        strSql = string.Format(strSql, lstParams[1], strToken, lCookieID, now, nowUtc,
                                               chatMsg.SenderID, chatMsg.SenderName, chatMsg.ReceiverID, chatMsg.ReceiverName, chatMsg.MsgContent);
                        optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
                        break;
                    }
                }

                //LogOperation.WriteLog("Add chat message done");
                optReturn.Data = lCookieID;
            }
            catch (Exception ex)
            {
                optReturn.Result  = false;
                optReturn.Message = ex.Message;
                //LogOperation.WriteLog("WriteChatMsg exception ,message = " + ex.Message);
            }
            return(optReturn);
        }