/// <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");
}
/// <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");
}
/// <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);
}
}
/// <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);
}
