/// <summary>
/// 获得菜谱列表
/// </summary>
/// <returns></returns>
public List <Recipe_foods> GetRecipe_FoodsList()
{
var ListModel = CacheHelper.Instance.GetCache <List <Recipe_foods> >("Recipe_FoodsList");
if (ListModel == null)
{
int outTime = CacheHelper.Instance.CacheOutTime;
Recipe_foods model = new Recipe_foods();
ListModel = Recipe_foodsOper.Instance.Select(model);
CacheHelper.Instance.SetCache("Recipe_FoodsList", ListModel, outTime);
}
return(ListModel);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="recipe_foods"></param>
/// <param name="pageSize">页面大小</param>
/// <param name="pageNo">页面编号</param>
/// <returns>对象列表</returns>
public List <Recipe_foods> SelectByPage(Recipe_foods recipe_foods, int pageSize, int pageNo)
{
StringBuilder sql = new StringBuilder("Select Top ").Append(pageSize).Append(" ");
if (!recipe_foods.Field.IsNullOrEmpty())
{
sql.Append(recipe_foods.Field);
}
else
{
sql.Append("*");
}
sql.Append(" from Recipe_foods ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
StringBuilder strBuliderPage = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!recipe_foods.id.IsNullOrEmpty())
{
if (flag)
{
part1.Append("id = @id");
flag = false;
}
else
{
part1.Append(" and id = @id");
}
parm.Add("id", recipe_foods.id);
}
if (!recipe_foods.recipeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("recipeId = @recipeId");
flag = false;
}
else
{
part1.Append(" and recipeId = @recipeId");
}
parm.Add("recipeId", recipe_foods.recipeId);
}
if (!recipe_foods.foodtypeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodtypeId = @foodtypeId");
flag = false;
}
else
{
part1.Append(" and foodtypeId = @foodtypeId");
}
parm.Add("foodtypeId", recipe_foods.foodtypeId);
}
if (!recipe_foods.foodId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodId = @foodId");
flag = false;
}
else
{
part1.Append(" and foodId = @foodId");
}
parm.Add("foodId", recipe_foods.foodId);
}
if (!recipe_foods.weight.IsNullOrEmpty())
{
if (flag)
{
part1.Append("weight = @weight");
flag = false;
}
else
{
part1.Append(" and weight = @weight");
}
parm.Add("weight", recipe_foods.weight);
}
if (!flag)
{
strBuliderPage.Append(" and");
}
strBuliderPage.Append(" id not in (").Append("Select Top ").Append(pageSize * (pageNo - 1)).Append(" id from Recipe_foods ");
if (!recipe_foods.GroupBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Group By ").Append(recipe_foods.GroupBy).Append(" ");
flag = false;
}
if (!recipe_foods.OrderBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Order By ").Append(recipe_foods.OrderBy).Append(" ");
flag = false;
}
strBuliderPage.Append(" )");
if (!flag)
{
sql.Append(" where ");
}
sql.Append(part1).Append(strBuliderPage).Append(part1);
if (!recipe_foods.GroupBy.IsNullOrEmpty())
{
part2.Append(" Group By ").Append(recipe_foods.GroupBy).Append(" ");
}
if (!recipe_foods.OrderBy.IsNullOrEmpty())
{
part2.Append(" Order By ").Append(recipe_foods.OrderBy).Append(" ");
}
sql.Append(part2);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = (List <Recipe_foods>)conn.Query <Recipe_foods>(sql.ToString(), parm);
conn.Close();
if (r == null)
{
r = new List <Recipe_foods>();
}
return(r);
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="recipe_foods"></param>
/// <returns>是否成功</returns>
public bool Insert(Recipe_foods recipe_foods)
{
StringBuilder sql = new StringBuilder("insert into Recipe_foods ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!recipe_foods.recipeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("recipeId");
part2.Append("@recipeId");
flag = false;
}
else
{
part1.Append(",recipeId");
part2.Append(",@recipeId");
}
parm.Add("recipeId", recipe_foods.recipeId);
}
if (!recipe_foods.foodtypeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodtypeId");
part2.Append("@foodtypeId");
flag = false;
}
else
{
part1.Append(",foodtypeId");
part2.Append(",@foodtypeId");
}
parm.Add("foodtypeId", recipe_foods.foodtypeId);
}
if (!recipe_foods.foodId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodId");
part2.Append("@foodId");
flag = false;
}
else
{
part1.Append(",foodId");
part2.Append(",@foodId");
}
parm.Add("foodId", recipe_foods.foodId);
}
if (!recipe_foods.weight.IsNullOrEmpty())
{
if (flag)
{
part1.Append("weight");
part2.Append("@weight");
flag = false;
}
else
{
part1.Append(",weight");
part2.Append(",@weight");
}
parm.Add("weight", recipe_foods.weight);
}
sql.Append("(").Append(part1).Append(") values(").Append(part2).Append(")");
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="recipe_foods"></param>
/// <returns>是否成功</returns>
public bool Update(Recipe_foods recipe_foods)
{
StringBuilder sql = new StringBuilder("update Recipe_foods set ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!recipe_foods.id.IsNullOrEmpty())
{
part2.Append("id = @id");
parm.Add("id", recipe_foods.id);
}
if (!recipe_foods.recipeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("recipeId = @recipeId");
flag = false;
}
else
{
part1.Append(", recipeId = @recipeId");
}
parm.Add("recipeId", recipe_foods.recipeId);
}
if (!recipe_foods.foodtypeId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodtypeId = @foodtypeId");
flag = false;
}
else
{
part1.Append(", foodtypeId = @foodtypeId");
}
parm.Add("foodtypeId", recipe_foods.foodtypeId);
}
if (!recipe_foods.foodId.IsNullOrEmpty())
{
if (flag)
{
part1.Append("foodId = @foodId");
flag = false;
}
else
{
part1.Append(", foodId = @foodId");
}
parm.Add("foodId", recipe_foods.foodId);
}
if (!recipe_foods.weight.IsNullOrEmpty())
{
if (flag)
{
part1.Append("weight = @weight");
flag = false;
}
else
{
part1.Append(", weight = @weight");
}
parm.Add("weight", recipe_foods.weight);
}
sql.Append(part1).Append(" where ").Append(part2);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
