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