/// <summary>
/// 获取子系统信息集合
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.SysStructure.MSysInfo> GetSyss(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SysStructure.MSysSearchInfo searchInfo)
{
IList <Model.SysStructure.MSysInfo> list = null;
string fields = " SysId,SysName,IssueTime,CompanyId,AdminInfo ";
string tableName = "view_SysAndCompanyAndUser";
string orderByString = " [IssueTime] asc ";
string identityColumnName = " SysId ";
using (IDataReader dr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, identityColumnName, fields, string.Empty, orderByString))
{
list = new List <Model.SysStructure.MSysInfo>();
while (dr.Read())
{
var model = new Model.SysStructure.MSysInfo();
if (!dr.IsDBNull(dr.GetOrdinal("SysId")))
{
model.SysId = dr.GetString(dr.GetOrdinal("SysId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SysName")))
{
model.SysName = dr.GetString(dr.GetOrdinal("SysName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AdminInfo")))
{
GetSysAdminInfo(dr.GetString(dr.GetOrdinal("AdminInfo")), model);
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取子系统信息集合
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.SysStructure.MSysInfo> GetSyss(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SysStructure.MSysSearchInfo searchInfo)
{
var items = dal.GetSyss(pageSize, pageIndex, ref recordCount, searchInfo);
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
var setting = new EyouSoft.BLL.ComStructure.BComSetting().GetModel(item.CompanyId);
if (setting != null)
{
item.SmsConfig = setting.SmsConfig;
}
}
}
return(items);
}
/// <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);
}
