Example #1
0
 /// <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;
 }
Example #2
0
        /// <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);
        }