public Farvorite QueryOneRecord(string uid, string foodID)
{
Farvorite farvorite;
string sqlStr = "SELECT * FROM [Favorite] WHERE UserID=@UserID AND FoodID=@FoodID";
SqlParameter[] SqlParam = new SqlParameter[2];
SqlParam[0] = new SqlParameter("@UserID", uid);
SqlParam[1] = new SqlParameter("@FoodID", foodID);
SqlDataReader dataReader = GetDataReader(sqlStr, SqlParam);
if (dataReader.Read())
{
farvorite = new Farvorite();
farvorite.ID = dataReader["ID"].ToString();
farvorite.UserID = dataReader["UserID"].ToString();
farvorite.FoodID = dataReader["FoodID"].ToString();
farvorite.Date = dataReader["Date"].ToString();
if (dataReader.Read())
{
throw new Exception("表有重复，请检查。");
}
}
else
{
farvorite = null;
}
dataReader.Close();
return(farvorite);
}
public bool FarvoriteFromUser(string userID, string foodID)
{
Farvorite farvorite = farvoriteDAL.QueryOneRecord(userID, foodID);
if (farvorite == null)
{
return(farvoriteDAL.InsertOneRecord(userID, foodID));
}
else
{
return(false);
}
}