Пример #1
0
        /// <summary>
        /// 获取酒店新闻详细信息
        /// </summary>
        public static HotelNews GetNewsDetails(string nid, out int preId, out int afterId, string hotelid)
        {
            string    SqlStr = "SELECT id,hotelid,title,coverImage,addtime,content FROM HotelNews WITH(NOLOCK) WHERE id=@nid";
            DataTable DT     = HotelCloud.SqlServer.SQLHelper.Get_DataTable(SqlStr, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                { "nid", new HotelCloud.SqlServer.DBParam {
                      ParamValue = nid.ToString()
                  } },
            });
            HotelNews model = new HotelNews();

            if (DT.Rows.Count > 0)
            {
                System.Data.DataRow dr = DT.Rows[0];
                model.Id         = Convert.ToInt32(dr["id"].ToString());
                model.HotelID    = Convert.ToInt32(dr["hotelid"].ToString());
                model.Title      = dr["title"].ToString();
                model.AddTime    = Convert.ToDateTime(dr["addtime"].ToString()).ToString("yyyy-MM-dd").ToString();
                model.Content    = dr["content"].ToString();
                model.CoverImage = dr["coverImage"].ToString();
            }
            string sql = @"select top 1 id from Hotelnews where hotelid=@hotelid and id<@nid order by id desc ";
            string pid = HotelCloud.SqlServer.SQLHelper.Get_Value(sql, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                { "nid", new HotelCloud.SqlServer.DBParam {
                      ParamValue = nid
                  } },
                { "hotelid", new HotelCloud.SqlServer.DBParam {
                      ParamValue = hotelid
                  } }
            });

            if (pid.Equals(""))
            {
                preId = Convert.ToInt32(nid);
            }
            else
            {
                preId = Convert.ToInt32(pid);
            }

            string nextid = HotelCloud.SqlServer.SQLHelper.Get_Value("select top 1 id from Hotelnews where hotelid=@hotelid and id>@nid order by id asc", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                { "nid", new HotelCloud.SqlServer.DBParam {
                      ParamValue = nid
                  } },
                { "hotelid", new HotelCloud.SqlServer.DBParam {
                      ParamValue = hotelid
                  } }
            });

            if (nextid.Equals(""))
            {
                afterId = Convert.ToInt32(nid);
            }
            else
            {
                afterId = Convert.ToInt32(nextid);
            }

            return(model);
        }
Пример #2
0
        /// <summary>
        /// 获取酒店新闻记录数 分页数据操作
        /// </summary>
        public static List <HotelNews> PageNewList(int pageSize, int currentPage, string hid, string filedOrder, out int pageNumSum, out int pageCount, int type = 0)
        {
            string           strWhere = string.Format(" where hotelid={0} and type={1} AND isview=1 ", hid, type);
            List <HotelNews> list     = new List <HotelNews>();
            StringBuilder    sqlStr   = new StringBuilder();
            int beginPage             = ((currentPage - 1) * pageSize) + 1;
            int endPage = currentPage * pageSize;

            try
            {
                sqlStr.Append("select id,hotelid,title,addtime,coverImage ");
                sqlStr.Append("from (select id,hotelid,title,addtime,coverImage,type,row_number() over(order by " + filedOrder + " desc )");
                sqlStr.Append(" as pageNum,isview from HotelNews");
                if (!string.IsNullOrEmpty(strWhere.ToString().Trim()))
                {
                    sqlStr.Append(strWhere);
                }
                sqlStr.Append(")" + " as newHotelNews");
                if (string.IsNullOrEmpty(strWhere.ToString().Trim()))
                {
                    sqlStr.Append(" where ");
                }
                if (!string.IsNullOrEmpty(strWhere.ToString().Trim()))
                {
                    sqlStr.Append(strWhere + " and ");
                }
                sqlStr.Append(" newHotelNews.pageNum between " + beginPage + " and " + endPage + "");
                sqlStr.Append(" order by " + filedOrder + " desc ");
                var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(sqlStr.ToString(), HotelCloud.SqlServer.SQLHelper.GetCon(), null);
                if (dt != null)
                {
                    foreach (System.Data.DataRow dr in dt.Rows)
                    {
                        HotelNews model = new HotelNews();
                        model.Id         = Convert.ToInt32(Convert.ToDouble(dr["id"].ToString()));
                        model.HotelID    = Convert.ToInt32(Convert.ToDouble(dr["hotelid"].ToString()));
                        model.Title      = dr["title"].ToString();
                        model.AddTime    = Convert.ToDateTime(dr["addtime"].ToString()).ToString("yy-MM-dd");
                        model.Content    = Convert.ToDateTime(dr["addtime"].ToString()) > DateTime.Now.AddDays(-30) ? "1" : "0";
                        model.CoverImage = dr["coverImage"].ToString();
                        list.Add(model);
                    }
                }
                pageCount  = GetHotelNewsCount(hid);                                                        //总记录数
                pageNumSum = pageCount % pageSize == 0 ? pageCount / pageSize : (pageCount / pageSize) + 1; //总页数
                return(list);
            }
            catch (SqlException e) { throw e; }
        }