/// <summary>
    /// 获取菜品信息列表
    /// </summary>
    /// <param name="columnId">列</param>
    /// <param name="rowSize">行</param>
    /// <param name="titleSize">标识</param>
    /// <returns></returns>
    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public List<DishesClass> GetDisInfoList(int rowSize, int titleSize, int order)
    {
        DataAccessClass dac = null;
        List<DishesClass> retList = null;
        try
        {
            dac = new DataAccessClass();
            string descOrAsc = "";
            if (order == 0)
            {
                descOrAsc = "desc";
            }
            else
            {
                descOrAsc = "Asc";
            }
            string sqlStr = @"
                        begin
                            select TOP " + rowSize.ToString() + @" DISHESID,DISHESNAME,CONTENT,DESCRIBE,ISAUDIT,GRADE,SOMEDAYRECOMMEND,ITEMRECOMMEND
                            from T_DISHES  ORDER BY DISHESID " + descOrAsc + @";
                        end
                        ";
           
            DataTable dt = dac.SelectData(sqlStr);
            if (dt.Rows.Count > 0)
            {
                retList = new List<DishesClass>();
                foreach (DataRow dr in dt.Rows)
                {
                    DishesClass item = new DishesClass();
                    string disheid = dr["DISHESID"].ToString();
                    string sqlSte = @"
                                begin
                                    select FILENAME,FACTPACH,THUMBNAIL1,THUMBNAIL2
                                    from T_DISHES_IMAGE  where DISHESID=" + disheid + @"
                                    ;
                                end
                                ";
                    DataTable dts = dac.SelectData(sqlSte);
                    if (dts.Rows.Count > 0)
                    {
                        foreach (DataRow d in dts.Rows)
                        {
                            item.DishesColumn = d["FILENAME"].ToString();
                            item.DishesFactpach = d["FACTPACH"].ToString();
                            item.DishesThumbnail1 = d["THUMBNAIL1"].ToString();
                            item.DishesThumbnail2 = d["THUMBNAIL2"].ToString();
                        }
                    }
                    else 
                    {
                            item.DishesColumn = null;
                            item.DishesFactpach = null;
                            item.DishesThumbnail1 = null;
                            item.DishesThumbnail2 = null;
                    }
                    string title = dr["DISHESNAME"].ToString();
                    string content = dr["CONTENT"].ToString();
                    string isaudit = dr["ISAUDIT"].ToString();
                    string describe = dr["DESCRIBE"].ToString();
                    string grade = dr["GRADE"].ToString();
                    string somedayrecommend = dr["SOMEDAYRECOMMEND"].ToString();
                    string itemrecommend = dr["ITEMRECOMMEND"].ToString();
                    string name = "";
                    if (describe.Length > titleSize)
                    {
                        name = describe.Remove(titleSize, describe.Length - titleSize);
                        name += "...";
                    }
                    else
                    {
                        name = describe;
                    }
                    item.DishesTitle = title;
                    item.DishesContent = content;
                    item.DishesIsaudit = isaudit;
                    item.DishesDescribe = name;
                    item.DishesUrl = "neirong.htm?id=" + dr["DISHESID"].ToString();
                    item.DishesGrade = grade;
                    item.SomedayRecommend = somedayrecommend;
                    item.ItemRecommend = itemrecommend;
                    retList.Add(item);
                }
            }
            else
                throw new Exception();
        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (null != dac)
            {
                dac.Dispose();
                dac = null;
            }
        }
        return retList;
    }