/// <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;
}
/// 获取菜品信息列表
/// </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;
}
可以取图片的信息
}
else{
不可以取图片的信息
}
可以取图片的信息
}
else{
不可以取图片的信息
}