/// <summary>
/// 构造系统信息的管理员信息
/// </summary>
/// <param name="adminSqlXml">管理员SqlXml</param>
/// <param name="model">系统信息实体</param>
private void GetSysAdminInfo(string adminSqlXml, Model.SysStructure.MSysInfo model)
{
if (string.IsNullOrEmpty(adminSqlXml) || model == null)
{
return;
}
XElement xRoot = XElement.Parse(adminSqlXml);
var xRows = Utils.GetXElements(xRoot, "row");
if (xRows == null || xRows.Count() <= 0)
{
return;
}
foreach (var t in xRows)
{
model.UserId = Utils.GetXAttributeValue(t, "UserId");
model.Username = Utils.GetXAttributeValue(t, "UserName");
model.FullName = Utils.GetXAttributeValue(t, "ContactName");
model.Telephone = Utils.GetXAttributeValue(t, "ContactTel");
model.Mobile = Utils.GetXAttributeValue(t, "ContactMobile");
model.Password = new Model.ComStructure.MPasswordInfo {
NoEncryptPassword = Utils.GetXAttributeValue(t, "Password")
};
model.OnlineStatus = Utils.GetEnumValue <EyouSoft.Model.EnumType.ComStructure.UserOnlineStatus>(Utils.GetXAttributeValue(t, "OnlineStatus"), UserOnlineStatus.Offline);
break;
}
}
/// <summary>
/// 获取子系统信息，仅取WEBMASTER修改子系统时使用的数据
/// </summary>
/// <param name="sysId">系统编号</param>
/// <returns></returns>
public Model.SysStructure.MSysInfo GetSysInfo(int sysId)
{
if (sysId < 1)
{
return(null);
}
Model.SysStructure.MSysInfo sysInfo = dal.GetSysInfo(sysId);
if (sysInfo != null)
{
int companyId = dal.GetCompanyIdBySysId(sysId);
EyouSoft.BLL.CompanyStructure.CompanyInfo companybll = new EyouSoft.BLL.CompanyStructure.CompanyInfo();
sysInfo.CompanyInfo = companybll.GetModel(companyId, sysId);
companybll = null;
EyouSoft.BLL.CompanyStructure.CompanyUser userbll = new EyouSoft.BLL.CompanyStructure.CompanyUser();
sysInfo.AdminInfo = userbll.GetAdminModel(companyId);
userbll = null;
EyouSoft.BLL.CompanyStructure.Department departmentbll = new EyouSoft.BLL.CompanyStructure.Department();
sysInfo.DepartmentInfo = departmentbll.GetModel(dal.GetHeadOfficeIdByCompanyId(companyId));
departmentbll = null;
EyouSoft.BLL.CompanyStructure.CompanySetting settingbll = new EyouSoft.BLL.CompanyStructure.CompanySetting();
sysInfo.Setting = settingbll.GetSetting(companyId);
settingbll = null;
EyouSoft.BLL.SysStructure.SystemDomain domainbll = new EyouSoft.BLL.SysStructure.SystemDomain();
sysInfo.Domains = domainbll.GetDomains(sysId);
domainbll = null;
if (sysInfo.ModuleIds == null || sysInfo.ModuleIds.Length < 1)
{
sysInfo.ModuleIds = new int[] { -1 };
}
if (sysInfo.PartIds == null || sysInfo.PartIds.Length < 1)
{
sysInfo.PartIds = new int[] { -1 };
}
if (sysInfo.PermissionIds == null || sysInfo.PermissionIds.Length < 1)
{
sysInfo.PermissionIds = new int[] { -1 };
}
}
return(sysInfo);
}
/// <summary>
/// 获取子系统信息
/// </summary>
/// <param name="sysId">子系统编号</param>
/// <returns></returns>
public EyouSoft.Model.SysStructure.MSysInfo GetSysInfo(string sysId)
{
Model.SysStructure.MSysInfo model = null;
if (string.IsNullOrEmpty(sysId))
{
return(model);
}
string strSql = " select SysId,SysName,IssueTime,CompanyId,AdminInfo from view_SysAndCompanyAndUser where SysId = @SysId ";
DbCommand dc = _db.GetSqlStringCommand(strSql);
_db.AddInParameter(dc, "SysId", DbType.AnsiStringFixedLength, sysId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
if (dr.Read())
{
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);
}
}
}
return(model);
}
/// <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>
/// 创建子系统，返回1成功，其他失败
/// </summary>
/// <param name="sysInfo">系统实体</param>
/// <returns>返回1成功，其他失败</returns>
public int CreateSys(Model.SysStructure.MSysInfo sysInfo)
{
#region data validate
if (sysInfo == null)
{
return(0);
}
if (sysInfo.Domains == null || sysInfo.Domains.Count < 1)
{
return(-1);
}
if (sysInfo.AdminInfo == null || string.IsNullOrEmpty(sysInfo.AdminInfo.UserName))
{
return(-2);
}
#region 打印单据配置验证
if (sysInfo.Setting != null && sysInfo.Setting.PrintDocument != null && sysInfo.Setting.PrintDocument.Count > 0)//打印单据配置验证
{
IDictionary <EyouSoft.Model.EnumType.CompanyStructure.PrintTemplateType, int> dic = new Dictionary <EyouSoft.Model.EnumType.CompanyStructure.PrintTemplateType, int>();
foreach (var item in sysInfo.Setting.PrintDocument)
{
if (dic.ContainsKey(item.PrintTemplateType))
{
dic[item.PrintTemplateType]++;
}
else
{
dic.Add(item.PrintTemplateType, 1);
}
}
bool isRepeat = false;
foreach (var item in dic)
{
if (item.Value > 1)
{
isRepeat = true;
break;
}
}
if (isRepeat)
{
return(-3);
}
}
#endregion
if (sysInfo.ModuleIds == null && sysInfo.ModuleIds.Length < 1)
{
sysInfo.ModuleIds = new int[] { -1 };
}
if (sysInfo.PartIds == null || sysInfo.PartIds.Length < 1)
{
sysInfo.PartIds = new int[] { -1 };
}
if (sysInfo.PermissionIds == null || sysInfo.PermissionIds.Length < 1)
{
sysInfo.PermissionIds = new int[] { -1 };
}
if (sysInfo.Domains != null && sysInfo.Domains.Count > 0)
{
foreach (var domain in sysInfo.Domains)
{
domain.Domain = domain.Domain.Replace("http://", "");
}
}
#endregion
int dalExceptionCode = dal.CreateSys(sysInfo);
if (dalExceptionCode == 1)
{
EyouSoft.BLL.SMSStructure.Account smsbll = new EyouSoft.BLL.SMSStructure.Account();
smsbll.SetAccountBaseInfo(sysInfo.CompanyInfo.Id);
smsbll = null;
}
return(dalExceptionCode);
}
