/// <summary> /// 根据数据行生成实体 /// </summary> /// <param name="dr">数据行</param> /// <param name="model">返回参数,客户域名实体</param> private void GetModelByDataRow(DataRow dr, ref Model.SystemStructure.SysCompanyDomain model) { if (dr != null) { model = new EyouSoft.Model.SystemStructure.SysCompanyDomain(); if (!string.IsNullOrEmpty(dr["ID"].ToString())) { model.ID = int.Parse(dr["ID"].ToString()); } model.CompanyId = dr["CompanyId"].ToString(); if (!string.IsNullOrEmpty(dr["CompanyType"].ToString())) { model.CompanyType = (Model.CompanyStructure.CompanyType) int.Parse(dr["CompanyType"].ToString()); } model.CompanyName = dr["CompanyName"].ToString(); model.Domain = dr["Domain"].ToString(); if (!string.IsNullOrEmpty(dr["DomainType"].ToString())) { model.DomainType = (Model.SystemStructure.DomainType) int.Parse(dr["DomainType"].ToString()); } model.GoToUrl = dr["GoToUrl"].ToString(); if (!string.IsNullOrEmpty(dr["IssueTime"].ToString())) { model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString()); } if (!string.IsNullOrEmpty(dr["IsDisabled"].ToString())) { model.IsDisabled = dr["IsDisabled"].ToString() == "1" ? true : false; } } dr = null; }
/// <summary> /// 分页获取客户域名信息集合 /// </summary> /// <param name="PageSize">每页条数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记录数</param> /// <param name="OrderIndex">排序索引,0为时间升序,1为时间降序</param> /// <returns>返回客户域名实体集合</returns> public virtual IList <EyouSoft.Model.SystemStructure.SysCompanyDomain> GetDomainList(int PageSize, int PageIndex, ref int RecordCount, int OrderIndex) { IList <Model.SystemStructure.SysCompanyDomain> List = new List <Model.SystemStructure.SysCompanyDomain>(); string strWhere = string.Empty; string strFiles = " [ID],[CompanyId],[CompanyType],[CompanyName],[Domain],[DomainType],[GoToUrl],[IssueTime],[IsDisabled] "; string strOrder = string.Empty; switch (OrderIndex) { case 0: strOrder = " [IssueTime] asc "; break; case 1: strOrder = " [IssueTime] desc "; break; default: strOrder = " [IssueTime] desc "; break; } using (IDataReader dr = DbHelper.ExecuteReader(base.SystemStore, PageSize, PageIndex, ref RecordCount, "tbl_SysCompanyDomain", "[ID]", strFiles, strWhere, strOrder)) { Model.SystemStructure.SysCompanyDomain model = null; while (dr.Read()) { model = new EyouSoft.Model.SystemStructure.SysCompanyDomain(); if (!string.IsNullOrEmpty(dr["ID"].ToString())) { model.ID = int.Parse(dr["ID"].ToString()); } model.CompanyId = dr["CompanyId"].ToString(); if (!string.IsNullOrEmpty(dr["CompanyType"].ToString())) { model.CompanyType = (Model.CompanyStructure.CompanyType) int.Parse(dr["CompanyType"].ToString()); } model.CompanyName = dr["CompanyName"].ToString(); model.Domain = dr["Domain"].ToString(); if (!string.IsNullOrEmpty(dr["DomainType"].ToString())) { model.DomainType = (Model.SystemStructure.DomainType) int.Parse(dr["DomainType"].ToString()); } model.GoToUrl = dr["GoToUrl"].ToString(); if (!string.IsNullOrEmpty(dr["IssueTime"].ToString())) { model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString()); } if (!string.IsNullOrEmpty(dr["IsDisabled"].ToString())) { model.IsDisabled = bool.Parse(dr["IsDisabled"].ToString()); } List.Add(model); } model = null; } return(List); }