コード例 #1
0
ファイル: Service16001.svc.cs プロジェクト: chenmj201601/UMP
        /// <summary>
        /// 退出
        /// </summary>
        /// <param name="session"></param>
        public void LogOff(SessionInfo session)
        {
            var dbInfo = session.DatabaseInfo;

            if (dbInfo != null)
            {
                dbInfo.RealPassword        = WCF16001EncryptOperation.DecryptWithM004(dbInfo.Password);
                session.DBConnectionString = dbInfo.GetConnectionString();
            }
            List <string> lstSysMsg = new List <string>();
            //更新数据库中的用户在线属性
            OperationReturn optReturn = ResourceOperations.ChangeUserStatus(session, "0");

            if (!optReturn.Result)
            {
                currCallback.SendSysMessage(S1600MessageType.LogOffFailed, lstSysMsg);
                //LogOperation.WriteLog("Update " + lstLoginUsers[session.UserID].UserName + " status failed : " + optReturn.Message);
                return;
            }

            if (lstLoginUsers.Keys.Contains(currentUser.UserID))
            {
                lstLoginUsers.Remove(currentUser.UserID);
                foreach (KeyValuePair <long, LoginUserInfo> user in lstLoginUsers)
                {
                    if (user.Key != currentUser.UserID)
                    {
                        lstSysMsg.Clear();
                        lstSysMsg.Add(currentUser.UserID.ToString());
                        user.Value.CallBack.SendSysMessage(S1600MessageType.FriendOffline, lstSysMsg);
                    }
                }
            }
            //LogOperation.WriteLog("User " + lstLoginUsers[session.UserID].UserName + " logoff");
        }
コード例 #2
0
ファイル: Service16001.svc.cs プロジェクト: chenmj201601/UMP
        /// <summary>
        /// 结束会话 并通知消息接收方 对话已经结束
        /// </summary>
        /// lstParams[0] : cookieID
        /// lstParams[1] : 消息发送人ID
        /// lstParams[2] : 消息接收人ID 用于通知
        /// <param name="lstParams"></param>
        public void EndCookieByID(List <string> lstParams)
        {
            //LogOperation.WriteLog("End cookie " + lstParams[0]);
            long        lUserID = long.Parse(lstParams[1]);
            SessionInfo session = null;

            if (!lstLoginUsers.Keys.Contains(lUserID))
            {
                //LogOperation.WriteLog("EndCookieByID error ," + lUserID + " is offline");
                return;
            }
            session = currentUser.UserSession;
            var dbInfo = session.DatabaseInfo;

            if (dbInfo != null)
            {
                dbInfo.RealPassword        = WCF16001EncryptOperation.DecryptWithM004(dbInfo.Password);
                session.DBConnectionString = dbInfo.GetConnectionString();
            }
            List <string> lstEndCookieParams = new List <string>();

            lstEndCookieParams.Add(lstParams[0]);
            OperationReturn optReturn = ChatMessageOperation.EndCookie(session, lstEndCookieParams);

            if (!optReturn.Result)
            {
                return;
            }
            long lReceiverID = long.Parse(lstParams[2]);

            if (!lstLoginUsers.Keys.Contains(lReceiverID))
            {
                //如果对方已经下线 不需要通知
                return;
            }
            //如果对方还在线 需要通知对方会话已经结束
            lstEndCookieParams.Clear();
            lstEndCookieParams.Add(lstLoginUsers[lUserID].UserName);
            lstEndCookieParams.Add(lUserID.ToString());
            if (lstLoginUsers.Keys.Contains(lReceiverID))
            {
                try
                {
                    lstLoginUsers[lReceiverID].CallBack.SendSysMessage(S1600MessageType.EndCookie, lstEndCookieParams);
                }
                catch (Exception ex)
                {
                    lstLoginUsers.Remove(lReceiverID);
                    //LogOperation.WriteLog("End cookie, and send message to " + lReceiverID + " failed:" + ex.Message);
                }
            }

            //LogOperation.WriteLog("End cookie done");
        }
コード例 #3
0
ファイル: Service16001.svc.cs プロジェクト: chenmj201601/UMP
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="session"></param>
        /// <param name="lstParams">
        /// </param>
        public void LoginSystem(SessionInfo session)
        {
            List <string> lstSysMsg = new List <string>();

            try
            {
                //判断传过来的参数不为空
                if (session == null)
                {
                    currCallback.SendSysMessage(S1600MessageType.LoginFailed, lstSysMsg);
                    return;
                }
                var dbInfo = session.DatabaseInfo;
                if (dbInfo != null)
                {
                    dbInfo.RealPassword        = WCF16001EncryptOperation.DecryptWithM004(dbInfo.Password);
                    session.DBConnectionString = dbInfo.GetConnectionString();
                }

                string s = string.Empty;
                foreach (KeyValuePair <long, LoginUserInfo> pair in lstLoginUsers)
                {
                    s = WCF16001EncryptOperation.DecryptWithM004(pair.Value.UserName) + " | ";
                }
                //LogOperation.WriteLog(s);

                currentUser             = new LoginUserInfo();
                currentUser.UserID      = session.UserID;
                currentUser.UserSession = session;

                currentUser.UserName = session.UserInfo.Account;
                currentUser.CallBack = currCallback;

                //如果不包含这个用户 则加入该对象
                //lstLoginUsers.Remove(currentUser.UserID);
                if (!lstLoginUsers.Keys.Contains(currentUser.UserID))
                {
                    lstLoginUsers.Add(currentUser.UserID, currentUser);
                    s = "User Login : "******"User Logined : " + WCF16001EncryptOperation.DecryptWithM004(currentUser.UserName);
                        // LogOperation.WriteLog(s);
                    }
                    catch (Exception ex)
                    {
                        //此处无需做任何操作 因为无论消息发送是否成功 该通道都要被删掉
                        s = "User Login send OffLine msg failed : " + WCF16001EncryptOperation.DecryptWithM004(currentUser.UserName) + ",\t" + ex.Message;
                        //LogOperation.WriteLog(s);
                    }

                    lstLoginUsers.Remove(currentUser.UserID);       //此处不可缺 删掉原来的callback 添加进现在的callback 用来更新callback通道
                    lstLoginUsers.Add(currentUser.UserID, currentUser);
                    //LogOperation.WriteLog("Delete old and add new ");
                }
                currCallback.SendSysMessage(S1600MessageType.LoginSuceess, lstSysMsg);
                //更新数据库中的用户在线属性
                OperationReturn optReturn = ResourceOperations.ChangeUserStatus(session, "1");
                if (!optReturn.Result)
                {
                    lstSysMsg.Clear();
                    lstSysMsg.Add("code = " + optReturn.Code + " ; message = " + optReturn.Message);
                    currCallback.SendSysMessage(S1600MessageType.LoginFailed, lstSysMsg);
                    return;
                }

                // currCallback.SendSysMessage(MessageType.TestMsg, "Message = " + optReturn.Message);
                //获得联系人
                optReturn = PermissionFuncs.GetContacters(session);
                if (!optReturn.Result)
                {
                    lstSysMsg.Clear();
                    lstSysMsg.Add("code = " + optReturn.Code + " ; message = " + optReturn.Message);
                    currCallback.SendSysMessage(S1600MessageType.GetFriendFailed, lstSysMsg);
                    return;
                }
                currCallback.InitFriendList(optReturn.Data as List <string>);

                //给在线的用户发送上线通知
                foreach (KeyValuePair <long, LoginUserInfo> user in lstLoginUsers)
                {
                    //通知每个用户 我上线啦 我本人就不用发了
                    if (user.Key != currentUser.UserID)
                    {
                        lstSysMsg.Clear();
                        lstSysMsg.Add(currentUser.UserID.ToString());
                        user.Value.CallBack.SendSysMessage(S1600MessageType.FriendOnline, lstSysMsg);
                    }
                }

                //开始接收离线消息
                List <string> lstParam = new List <string>();
                lstParam.Add(currentUser.UserID.ToString());
                optReturn = ChatMessageOperation.GetAllOffLineMsg(session, lstParam);
                if (optReturn.Result)
                {
                    //LogOperation.WriteLog("Send offline message to " + currentUser.UserName);
                    SendOfflineMsg(optReturn.Data as Dictionary <long, ChatMessage>);
                }
            }
            catch (Exception ex)
            {
                //LogOperation.WriteLog("Login error: " + ex.Message);
            }
        }
コード例 #4
0
ファイル: PermissionFuncs.cs プロジェクト: chenmj201601/UMP
        /// <summary>
        /// 获得我的联系人(包括可以管我的用户、我可以管理用户和坐席,如果传入的UserID是用户(智能客户端),则获取管理这个坐席的人)
        /// </summary>
        /// <param name="session"></param>
        /// <returns></returns>
        public static OperationReturn GetContacters(SessionInfo session)
        {
            OperationReturn optReturn = new OperationReturn();

            optReturn.Result = true;
            optReturn.Code   = 0;
            try
            {
                string strMsg = string.Empty;
                string strSql;
                string strToken  = session.RentInfo.Token;
                string strUserID = session.UserID.ToString();
                long   userID;
                if (!long.TryParse(strUserID, out userID))
                {
                    optReturn.Result  = false;
                    optReturn.Code    = Defines.RET_PARAM_INVALID;
                    optReturn.Message = string.Format("UserID invalid.");
                    return(optReturn);
                }
                int              dbType = session.DatabaseInfo.TypeID;
                DataSet          objDataSet;
                List <Contacter> listContactors = new List <Contacter>();


                #region 获取管理我的用户

                switch (dbType)
                {
                case 2:
                    strSql =
                        string.Format(
                            "SELECT C.*, D.C015 AS ONLINESTATUS FROM (SELECT A.C001 AS USERID, A.C002 AS USERNAME, A.C003 AS FULLNAME, B.C001 AS ORGID, B.C002 AS ORGNAME, B.C004 AS PARENTORGID FROM T_11_005_{0} A, T_11_006_{0} B WHERE A.C006 = B.C001 AND A.C001 IN (SELECT C003 FROM T_11_201_{0} WHERE C004 = {1} AND C003 > 1020000000000000000 AND C003 < 1030000000000000000 AND C003 != C004)) C LEFT JOIN T_11_101_{0} D ON C.USERID = D.C001 ORDER BY C.USERID",
                            strToken, userID);
                    optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
                    break;

                case 3:
                    strSql =
                        string.Format(
                            "SELECT C.*, D.C015 AS ONLINESTATUS FROM (SELECT A.C001 AS USERID, A.C002 AS USERNAME, A.C003 AS FULLNAME, B.C001 AS ORGID, B.C002 AS ORGNAME, B.C004 AS PARENTORGID FROM T_11_005_{0} A, T_11_006_{0} B WHERE A.C006 = B.C001 AND A.C001 IN (SELECT C003 FROM T_11_201_{0} WHERE C004 = {1} AND C003 > 1020000000000000000 AND C003 < 1030000000000000000 AND C003 != C004)) C LEFT JOIN T_11_101_{0} D ON C.USERID = D.C001 ORDER BY C.USERID",
                            strToken, userID);
                    optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
                    break;

                default:
                    optReturn.Result  = false;
                    optReturn.Code    = Defines.RET_PARAM_INVALID;
                    optReturn.Message = string.Format("DBType invalid.");
                    return(optReturn);
                }
                strMsg += "Step1:" + strSql;
                if (!optReturn.Result)
                {
                    optReturn.Message += strMsg;
                    return(optReturn);
                }
                objDataSet = optReturn.Data as DataSet;
                if (objDataSet == null)
                {
                    optReturn.Result  = false;
                    optReturn.Code    = Defines.RET_OBJECT_NULL;
                    optReturn.Message = string.Format("DataSet is null.") + strMsg;
                    return(optReturn);
                }
                for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
                {
                    DataRow dr = objDataSet.Tables[0].Rows[i];

                    long      id        = Convert.ToInt64(dr["USERID"]);
                    Contacter contactor = new Contacter();
                    contactor.UserID      = id;
                    contactor.UserName    = WCF16001EncryptOperation.DecryptWithM002(dr["USERNAME"].ToString());
                    contactor.FullName    = WCF16001EncryptOperation.DecryptWithM002(dr["FULLNAME"].ToString());
                    contactor.OrgID       = Convert.ToInt64(dr["ORGID"]);
                    contactor.OrgName     = WCF16001EncryptOperation.DecryptWithM002(dr["ORGNAME"].ToString());
                    contactor.ParentOrgID = Convert.ToInt64(dr["PARENTORGID"]);
                    string strStatus = dr["ONLINESTATUS"].ToString();
                    if (string.IsNullOrEmpty(strStatus))
                    {
                        contactor.Status = "0";
                    }
                    else
                    {
                        contactor.Status = strStatus;
                    }
                    var temp = listContactors.FirstOrDefault(c => c.UserID == id);
                    if (temp == null)
                    {
                        listContactors.Add(contactor);
                    }
                }

                #endregion


                if (userID > 1020000000000000000 &&
                    userID < 1030000000000000000)
                {
                    #region 获取我管理的用户

                    switch (dbType)
                    {
                    case 2:
                        strSql =
                            string.Format(
                                "SELECT C.*, D.C015 AS ONLINESTATUS FROM (SELECT A.C001 AS USERID, A.C002 AS USERNAME, A.C003 AS FULLNAME, B.C001 AS ORGID, B.C002 AS ORGNAME, B.C004 AS PARENTORGID FROM T_11_005_{0} A, T_11_006_{0} B WHERE A.C006 = B.C001 AND A.C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1} AND C004 > 1020000000000000000 AND C004 < 1030000000000000000 AND C003 != C004)) C LEFT JOIN T_11_101_{0} D ON C.USERID = D.C001 ORDER BY C.USERID",
                                strToken, userID);
                        optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
                        break;

                    case 3:
                        strSql =
                            string.Format(
                                "SELECT C.*, D.C015 AS ONLINESTATUS FROM (SELECT A.C001 AS USERID, A.C002 AS USERNAME, A.C003 AS FULLNAME, B.C001 AS ORGID, B.C002 AS ORGNAME, B.C004 AS PARENTORGID FROM T_11_005_{0} A, T_11_006_{0} B WHERE A.C006 = B.C001 AND A.C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1} AND C004 > 1020000000000000000 AND C004 < 1030000000000000000 AND C003 != C004)) C LEFT JOIN T_11_101_{0} D ON C.USERID = D.C001 ORDER BY C.USERID",
                                strToken, userID);
                        optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
                        break;

                    default:
                        optReturn.Result  = false;
                        optReturn.Code    = Defines.RET_PARAM_INVALID;
                        optReturn.Message = string.Format("DBType invalid.");
                        return(optReturn);
                    }
                    strMsg += "Step2:" + strSql;
                    if (!optReturn.Result)
                    {
                        optReturn.Message += strMsg;
                        return(optReturn);
                    }
                    objDataSet = optReturn.Data as DataSet;
                    if (objDataSet == null)
                    {
                        optReturn.Result  = false;
                        optReturn.Code    = Defines.RET_OBJECT_NULL;
                        optReturn.Message = string.Format("DataSet is null.") + strMsg;
                        return(optReturn);
                    }
                    for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
                    {
                        DataRow dr = objDataSet.Tables[0].Rows[i];

                        long      id        = Convert.ToInt64(dr["USERID"]);
                        Contacter contactor = new Contacter();
                        contactor.UserID      = id;
                        contactor.UserName    = WCF16001EncryptOperation.DecryptWithM002(dr["USERNAME"].ToString());
                        contactor.FullName    = WCF16001EncryptOperation.DecryptWithM002(dr["FULLNAME"].ToString());
                        contactor.OrgID       = Convert.ToInt64(dr["ORGID"]);
                        contactor.OrgName     = WCF16001EncryptOperation.DecryptWithM002(dr["ORGNAME"].ToString());
                        contactor.ParentOrgID = Convert.ToInt64(dr["PARENTORGID"]);
                        string strStatus = dr["ONLINESTATUS"].ToString();
                        if (string.IsNullOrEmpty(strStatus))
                        {
                            contactor.Status = "0";
                        }
                        else
                        {
                            contactor.Status = strStatus;
                        }
                        var temp = listContactors.FirstOrDefault(c => c.UserID == id);
                        if (temp == null)
                        {
                            listContactors.Add(contactor);
                        }
                    }

                    #endregion


                    #region 获取我管理的坐席


                    #region 获取坐席编码

                    switch (dbType)
                    {
                    case 2:
                        strSql =
                            string.Format(
                                "SELECT	A.C001 AS AC001, B.C001 AS BC001, B.C002 AS BC002, B.C004 AS BC004 FROM T_11_101_{0} A, T_11_006_{0} B WHERE A.C011 = B.C001 AND A.C002 = 1 AND A.C001 > 1030000000000000000 AND A.C001 < 1040000000000000000 AND A.C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1} AND C004 > 1030000000000000000 AND C004 < 1040000000000000000)",
                                strToken, userID);
                        optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
                        break;

                    case 3:
                        strSql =
                            string.Format(
                                "SELECT	A.C001 AS AC001, B.C001 AS BC001, B.C002 AS BC002, B.C004 AS BC004 FROM T_11_101_{0} A, T_11_006_{0} B WHERE A.C011 = B.C001 AND A.C002 = 1 AND A.C001 > 1030000000000000000 AND A.C001 < 1040000000000000000 AND A.C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1} AND C004 > 1030000000000000000 AND C004 < 1040000000000000000)",
                                strToken, userID);
                        optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
                        break;

                    default:
                        optReturn.Result  = false;
                        optReturn.Code    = Defines.RET_PARAM_INVALID;
                        optReturn.Message = string.Format("DBType invalid.");
                        return(optReturn);
                    }
                    strMsg += "Step3:" + strSql;
                    if (!optReturn.Result)
                    {
                        optReturn.Message += strMsg;
                        return(optReturn);
                    }
                    objDataSet = optReturn.Data as DataSet;
                    if (objDataSet == null)
                    {
                        optReturn.Result  = false;
                        optReturn.Code    = Defines.RET_OBJECT_NULL;
                        optReturn.Message = string.Format("DataSet is null.") + strMsg;
                        return(optReturn);
                    }
                    for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
                    {
                        DataRow dr = objDataSet.Tables[0].Rows[i];

                        long      id        = Convert.ToInt64(dr["AC001"]);
                        Contacter contactor = new Contacter();
                        contactor.OrgID       = Convert.ToInt64(dr["BC001"]);
                        contactor.OrgName     = WCF16001EncryptOperation.DecryptWithM002(dr["BC002"].ToString());
                        contactor.ParentOrgID = Convert.ToInt64(dr["BC004"]);
                        contactor.UserID      = id;
                        var temp = listContactors.FirstOrDefault(c => c.UserID == id);
                        if (temp == null)
                        {
                            listContactors.Add(contactor);
                        }
                    }

                    #endregion


                    #region 获取坐席其他信息

                    for (int i = 0; i < listContactors.Count; i++)
                    {
                        var  contactor = listContactors[i];
                        long id        = contactor.UserID;
                        if (id > 1030000000000000000 &&
                            id < 1040000000000000000)
                        {
                            switch (dbType)
                            {
                            case 2:
                                strSql =
                                    string.Format(
                                        "SELECT * FROM T_11_101_{0} WHERE C001 = {1} ORDER BY C001, C002",
                                        strToken, id);
                                optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
                                break;

                            case 3:
                                strSql =
                                    string.Format(
                                        "SELECT * FROM T_11_101_{0} WHERE C001 = {1} ORDER BY C001, C002",
                                        strToken, id);
                                optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
                                break;

                            default:
                                optReturn.Result  = false;
                                optReturn.Code    = Defines.RET_PARAM_INVALID;
                                optReturn.Message = string.Format("DBType invalid.");
                                return(optReturn);
                            }
                            strMsg += "Step4:" + strSql;
                            if (!optReturn.Result)
                            {
                                optReturn.Message += strMsg;
                                return(optReturn);
                            }
                            objDataSet = optReturn.Data as DataSet;
                            if (objDataSet == null)
                            {
                                optReturn.Result  = false;
                                optReturn.Code    = Defines.RET_OBJECT_NULL;
                                optReturn.Message = string.Format("DataSet is null.") + strMsg;
                                return(optReturn);
                            }
                            for (int j = 0; j < objDataSet.Tables[0].Rows.Count; j++)
                            {
                                DataRow dr = objDataSet.Tables[0].Rows[j];

                                int row = Convert.ToInt32(dr["C002"]);
                                if (row == 1)
                                {
                                    contactor.UserName = WCF16001EncryptOperation.DecryptWithM002(dr["C017"].ToString());
                                    contactor.FullName = WCF16001EncryptOperation.DecryptWithM002(dr["C018"].ToString());
                                }
                                if (row == 2)
                                {
                                    string strStatus = dr["C020"].ToString();
                                    if (string.IsNullOrEmpty(strStatus))
                                    {
                                        contactor.Status = "0";
                                    }
                                    else
                                    {
                                        contactor.Status = strStatus;
                                    }
                                }
                            }
                        }
                    }

                    #endregion


                    #endregion
                }

                List <string> listReturn = new List <string>();
                for (int i = 0; i < listContactors.Count; i++)
                {
                    var contactor = listContactors[i];

                    optReturn = XMLHelper.SeriallizeObject(contactor);
                    if (!optReturn.Result)
                    {
                        optReturn.Message += "Step5:" + strMsg;
                        return(optReturn);
                    }
                    listReturn.Add(optReturn.Data.ToString());
                }

                optReturn.Data    = listReturn;
                optReturn.Message = strMsg;
            }
            catch (Exception ex)
            {
                optReturn.Code    = (int)S1600WcfError.GetSuperiorException;
                optReturn.Result  = false;
                optReturn.Message = ex.Message;
            }
            return(optReturn);
        }