• 根据群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

  • 相关阅读:
    js代码性能优化的几个方法
    BOM(浏览器对象模型)的一些内置对象总结
    js产生对象的3种基本方式(工厂模式,构造函数模式,原型模式)
    ELF文件格式
    Python 语言之 map/reduce
    LeetCode
    快速排序
    网络问题诊断
    Notepad++ 用法技巧
    Python图形开发之PIL
  • 原文地址:https://www.cnblogs.com/qiankundai/p/3736183.html
Copyright © 2020-2023  润新知