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