public async Task <CookClassifyEntity> GetCookClassify()
{
var result = new CookClassifyEntity();
string url = StaticURLHelper.CookClassify;
var jsonstr = await GetJSON(url, null);
result = JsonConvert.DeserializeObject <CookClassifyEntity>(jsonstr);
return(result);
}
public async Task <CookClassifyEntity> GetCookClassify(string id)
{
var result = new CookClassifyEntity();
string url = StaticURLHelper.CookClassify;
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("id", id);
var jsonstr = await GetJSON(url, dic);
result = JsonConvert.DeserializeObject <CookClassifyEntity>(jsonstr);
return(result);
}
public CookClassifyEntity GetCookClassify()
{
CookClassifyEntity result = new CookClassifyEntity();
var dbdata = DBHelper.Context.From <cook_classify>();
if (dbdata != null)
{
result.Tngou = dbdata.ToEnumerable().Select(c => new CookClassify()
{
Id = c.Id,
Cookclass = c.cook_class ?? 0,
Description = c.description,
Name = c.name,
Title = c.title,
Seq = c.seq ?? 0,
}).ToList();
result.Status = true;
}
return(result);
}
/// <summary>
/// 获取菜谱分类
/// </summary>
/// <returns></returns>
public async Task <ProcessResult> GetCookClassify()
{
var processresult = new ProcessResult();
var clearresult = DBHelper.Context.DeleteAll <cook_classify>();
processresult.Add(ProcessResult.CleanDB, ProcessResultType.成功, clearresult.ToString(), new[] { "cook_classify" });
CookClassifyEntity data = null;
try
{
data = await recipeServer.GetCookClassify();
}
catch (Exception e)
{
processresult.Add("一级分类数据获取或解析", ProcessResultType.失败, e.Message);
}
if (data != null && data.Status)
{
processresult.Add("一级分类数据验证", ProcessResultType.成功);
}
else
{
processresult.Add("一级分类数据验证", ProcessResultType.失败);
return(processresult);
}
var datamodel = data.Tngou.Select(c => new cook_classify()
{
Id = c.Id,
cook_class = c.Cookclass,
description = c.Description,
name = c.Name,
seq = 0,
title = c.Title,
}).ToList();
try
{
var result = DBHelper.Context.Insert(datamodel);
processresult.Add("一级分类数插入", ProcessResultType.成功, result.ToString());
}
catch (Exception e)
{
processresult.Add("一级分类数插入", ProcessResultType.失败, e.Message);
return(processresult);
}
var topClassCookClassify = DBHelper.Context.From <cook_classify>().Where(c => c.cook_class == 0).ToList();
if (topClassCookClassify != null && topClassCookClassify.Count > 0)
{
processresult.Add("二级分类读取", ProcessResultType.成功, topClassCookClassify.Count.ToString());
foreach (var item in topClassCookClassify)
{
CookClassifyEntity subdata = null;
try
{
subdata = await recipeServer.GetCookClassify(item.Id.ToString());
}
catch (Exception e)
{
processresult.Add("二级分类获取或解析", ProcessResultType.失败, e.Message);
}
if (subdata != null && subdata.Status)
{
processresult.Add("二级分类数据验证", ProcessResultType.成功);
}
else
{
processresult.Add("二级分类数据验证", ProcessResultType.失败);
continue;
}
var subdatamodel = subdata.Tngou.Select(c => new cook_classify()
{
Id = c.Id,
cook_class = c.Cookclass,
description = c.Description,
name = c.Name,
seq = 1,
title = c.Title,
}).ToList();
try
{
var result = DBHelper.Context.Insert(subdatamodel);
processresult.Add("二级分类数插入", ProcessResultType.成功, result.ToString(), new string[] { "当前分类" + item.Id });
}
catch (Exception e)
{
processresult.Add("二级分类数插入", ProcessResultType.失败, e.Message, new string[] { "当前分类" + item.Id });
continue;
}
}
}
else
{
processresult.Add("二级分类读取", ProcessResultType.失败, "没找到二级分类数据");
}
return(processresult);
}
