首页 > 代码库 > 根据群ID和用户Id查询 + string QueryQunByUserIdAndQunId(int userId, int qunId) V1.0
根据群ID和用户Id查询 + string QueryQunByUserIdAndQunId(int userId, int qunId) V1.0
#region 根据群ID和用户Id查询 + string QueryQunByUserIdAndQunId(int userId, int qunId) V1.0
/// <summary>
/// 13.0 根据群ID和用户Id查询
/// </summary>
/// <param name="userId"></param>
/// <param name="qunId"></param>
/// <returns></returns>
public string QueryQunByUserIdAndQunId(int userId, int qunId)
{
string where = "";
if (userId > 0 && qunId > 0)
where = string.Format("UserId={0} and QunId={1} and Deleted=‘{2}‘", userId, qunId, false);
T_UserRolePermission model = m_userRolePermissionManager.GetModelByQunIdAndUserId(qunId, userId);
//判断是否存在
if (model == null)
{
return Convert.ToString(ErrorCode.DATA_NOT_EXIST);
}
M_User user = m_userManager.GetModel(userId);
#region 格式
//<qun>
// <qunId>xxx</qunId>1
// <qunNo>群编号</qunNo>2
// <qunName>="群名称"</qunName>3
// <iconUrl>群头像地址</iconUrl> 4
// <isPublish>公开/私密</isPublish>5
// <description>群介绍</description>6
// <contact>联系方式</contact> 7
// <address>地点</address>8
// <createrId>群主Id</createrId>9
// <createrIconUrl>群主头像地址</createrIconUrl> 10
// <createrName>群主用户名</createrName> 11
// <qunTypeName>类别名称</qunTypeName> 12
// <groupName>用户所在的组名称</groupName>13
//</qun>
#endregion
M_Qun qun = m_qunManager.GetModel(qunId);
StringBuilder sb = new StringBuilder();
M_QunType qunTypeModel = m_qunTypeManager.GetModelByTypeId((int)t_qunTypeRelationManager.GetModelByqunId(qun.ID).QunTypId);
M_Groups groupsModel = m_groupsManager.GetModelByQunId(qun.ID);
sb.Append("<quns>");
sb.AppendFormat(@"<qun qunId = ""{0}"" qunNo = ""{1}"" qunName = ""{2}"" iconUrl = ""{3}"" isPublish = ""{4}"" description = ""{5}"" contact = ""{6}"" address = ""{7}"" createrId = ""{8}"" createrIconUrl = ""{9}"" createrName = ""{10}"" qunTypeName = ""{11}"" groupName = ""{12}"" />",
qun.ID, //0
qun.QunNo, //1
qun.QunName,//2
qun.Logo, //3
qun.IsOpen, //4
qun.Description, //5
qun.Contact, //6
qun.Address, //7
model.UserId, //8
user.Icon, //9
user.UserName, //10
qunTypeModel == null ? "" : qunTypeModel.TypeName, //11
groupsModel == null ? "" : groupsModel.GroupsName //12
);
sb.Append("</quns>");
return sb.ToString();
}
#endregion
#region 根据群ID和用户Id查询 + string QueryQunByUserIdAndQunId(int userId, int qunId) V2.0
#region 13.0 根据群ID + string QueryQunByUserIdAndQunId(int userId, int qunId)
/// <summary>
/// 13.0 根据群ID查询
/// </summary>
/// <param name="userId"></param>
/// <param name="qunId"></param>
/// <returns></returns>
public string QueryQunByQunId(int qunId)
{
M_Qun qun = m_qunManager.GetModel(qunId);
string where = string.Format("QunId={0} and IsQunCreater=‘true‘ and Deleted=‘false‘", qunId);
DataSet ds = m_userRolePermissionManager.GetList(where);
M_User user = null;
if (ds != null && ds.Tables.Count > 0)
user = m_userManager.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"]));
//判断是否存在
if (user == null)
{
return Convert.ToString(ErrorCode.DATA_NOT_EXIST);
}
#region 格式
//<qun>
// <qunId>xxx</qunId>1
// <qunNo>群编号</qunNo>2
// <qunName>="群名称"</qunName>3
// <iconUrl>群头像地址</iconUrl> 4
// <isPublish>公开/私密</isPublish>5
// <description>群介绍</description>6
// <contact>联系方式</contact> 7
// <address>地点</address>8
// <createrId>群主Id</createrId>9
// <createrIconUrl>群主头像地址</createrIconUrl> 10
// <createrName>群主用户名</createrName> 11
// <qunTypeName>类别名称</qunTypeName> 12
// <groupName>用户所在的组名称</groupName>13
//</qun>
#endregion
StringBuilder sb = new StringBuilder();
M_QunType qunTypeModel = m_qunTypeManager.GetModelByTypeId((int)t_qunTypeRelationManager.GetModelByqunId(qun.ID).QunTypId);
M_Groups groupsModel = m_groupsManager.GetModelByQunId(qun.ID);
sb.Append("<quns>");
sb.AppendFormat(@"<qun qunId = ""{0}"" qunNo = ""{1}"" qunName = ""{2}"" iconUrl = ""{3}"" isPublish = ""{4}"" description = ""{5}"" contact = ""{6}"" address = ""{7}"" createrId = ""{8}"" createrIconUrl = ""{9}"" createrName = ""{10}"" qunTypeName = ""{11}"" groupName = ""{12}"" />",
qun.ID, //0
qun.QunNo, //1
qun.QunName,//2
qun.Logo, //3
qun.IsOpen, //4
qun.Description, //5
qun.Contact, //6
qun.Address, //7
user.ID, //8
user.Icon, //9
user.UserName, //10
qunTypeModel == null ? "" : qunTypeModel.TypeName, //11
groupsModel == null ? "" : groupsModel.GroupsName //12
);
sb.Append("</quns>");
return sb.ToString();
}
#endregion