/// <summary> /// rptSys_ItemDataBound /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rptSys_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemIndex < 0) { return; } Literal ltrDomain = (Literal)e.Item.FindControl("ltrDomain"); EyouSoft.Model.SysStructure.MLBSysInfo sysInfo = (EyouSoft.Model.SysStructure.MLBSysInfo)e.Item.DataItem; if (ltrDomain != null && sysInfo != null && sysInfo.Domains != null && sysInfo.Domains.Count > 0) { System.Text.StringBuilder s = new System.Text.StringBuilder(); s.AppendFormat(" {0}", sysInfo.Domains[0].Domain); for (int i = 1; i < sysInfo.Domains.Count; i++) { s.AppendFormat("<br /> {0}", sysInfo.Domains[i].Domain); } ltrDomain.Text = s.ToString(); } }
/// <summary> /// 获取所有子系统信息集合 /// </summary> /// <returns></returns> public IList <EyouSoft.Model.SysStructure.MLBSysInfo> GetSyss(EyouSoft.Model.SysStructure.MSysSearchInfo searchInfo) { IList <EyouSoft.Model.SysStructure.MLBSysInfo> items = new List <EyouSoft.Model.SysStructure.MLBSysInfo>(); StringBuilder cmdText = new StringBuilder(); cmdText.Append(" SELECT "); cmdText.Append(" A.[SysId],A.[SysName],A.[CreateTime] "); cmdText.Append(" ,B.[Id] AS CompanyId,B.[CompanyName],B.[ContactName],B.[ContactTel],B.[ContactFax] "); cmdText.Append(" ,C.[Id] AS UserId,C.[UserName],C.[Password] "); cmdText.Append(" ,(SELECT * FROM [tbl_SysDomain] AS D WHERE D.[SysId]=A.[SysId] FOR XML RAW,ROOT('root')) AS Domains "); cmdText.Append(" FROM [tbl_Sys] AS A INNER JOIN [tbl_CompanyInfo] AS B "); cmdText.Append(" ON A.[SysId]=B.[SystemId] INNER JOIN [tbl_CompanyUser] AS C "); cmdText.Append(" ON B.[Id]=C.[CompanyId] AND C.[IsAdmin]='1' AND C.[IsDelete]='0' "); cmdText.Append(" ORDER BY A.[SysId] "); DbCommand cmd = this._db.GetSqlStringCommand(cmdText.ToString()); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this._db)) { while (rdr.Read()) { EyouSoft.Model.SysStructure.MLBSysInfo item = new EyouSoft.Model.SysStructure.MLBSysInfo(); item.AdminPassword = rdr["Password"].ToString(); item.AdminUserId = rdr.GetInt32(rdr.GetOrdinal("UserId")); item.AdminUsername = rdr["UserName"].ToString(); item.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")); item.CompanyName = rdr["CompanyName"].ToString(); item.Domains = new List <EyouSoft.Model.SysStructure.SystemDomain>(); item.Fax = rdr["ContactFax"].ToString(); item.Realname = rdr["ContactName"].ToString(); item.SysCreateTime = rdr.GetDateTime(rdr.GetOrdinal("CreateTime")); item.SysId = rdr.GetInt32(rdr.GetOrdinal("SysId")); item.SysName = rdr["SysName"].ToString(); item.Telephone = rdr["ContactTel"].ToString(); string xml = rdr["Domains"].ToString(); if (!string.IsNullOrEmpty(xml)) { XElement xRoot = XElement.Parse(xml); var xRows = Utils.GetXElements(xRoot, "row"); foreach (var xRow in xRows) { item.Domains.Add(new EyouSoft.Model.SysStructure.SystemDomain() { CompanyId = item.CompanyId, Domain = Utils.GetXAttributeValue(xRow, "Domain"), SysId = item.SysId,//Utils.GetInt(Utils.GetXAttributeValue(xRow, "SysId")), Url = Utils.GetXAttributeValue(xRow, "Url") }); } } items.Add(item); } } return(items); }