public FoodManagementRules() { // // TODO: 在此处添加构造函数逻辑 // foodMgmt = new FoodMgmt(); }
public int DeleteNutrition(FoodMgmt foodMgmt) { deleteNutritionCommand = "DeleteNutrition"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(deleteNutritionCommand); dbCommandWrapper.AddInParameter("@foodID", DbType.Int32, foodMgmt.FoodID); dbCommandWrapper.AddOutParameter("@rowsAffected", DbType.Int16, 16); dbFoodMgmt.ExecuteNonQuery(dbCommandWrapper); return(Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"))); }
private DataSet FillFoodArrGrade(FoodMgmt foodMgmt, bool selStyle) { getFoodArrGradeCommand = "GetFoodArrGrade"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(getFoodArrGradeCommand); dbCommandWrapper.AddInParameter("@foodArrID", DbType.Int32, foodMgmt.FoodArrID); dbCommandWrapper.AddInParameter("@foodArrName", DbType.String, foodMgmt.FoodArrName); dbCommandWrapper.AddInParameter("@selStyle", DbType.Boolean, selStyle); return(dbFoodMgmt.ExecuteDataSet(dbCommandWrapper)); }
public int UpdateFoodArrGrade(FoodMgmt foodMgmt) { updateFoodArrGradeCommand = "UpdateFoodArrGrade"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(updateFoodArrGradeCommand); dbCommandWrapper.AddInParameter("@foodArrID", DbType.Int32, foodMgmt.FoodArrID); dbCommandWrapper.AddInParameter("@suitAge", DbType.String, foodMgmt.SuitAge); dbCommandWrapper.AddInParameter("@isUsed", DbType.String, foodMgmt.IsUsed); dbCommandWrapper.AddOutParameter("@rowsAffected", DbType.Int16, 16); dbFoodMgmt.ExecuteNonQuery(dbCommandWrapper); return(Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"))); }
public int InsertNutrition(FoodMgmt foodMgmt) { insertNutritionCommand = "InsertNutrition"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(insertNutritionCommand); dbCommandWrapper.AddInParameter("@foodCateName", DbType.String, foodMgmt.FoodCategory); dbCommandWrapper.AddInParameter("@foodName", DbType.String, foodMgmt.FoodName); dbCommandWrapper.AddInParameter("@foodProtein", DbType.Double, foodMgmt.Protein); dbCommandWrapper.AddInParameter("@foodFat", DbType.Double, foodMgmt.Fat); dbCommandWrapper.AddInParameter("@foodCarbohydrate", DbType.Double, foodMgmt.Carbohydrate); dbCommandWrapper.AddInParameter("@foodEnergy", DbType.Double, foodMgmt.Energy); dbCommandWrapper.AddInParameter("@foodRemark", DbType.String, foodMgmt.FoodRemark); dbCommandWrapper.AddOutParameter("@rowsAffected", DbType.Int16, 16); dbFoodMgmt.ExecuteNonQuery(dbCommandWrapper); return(Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"))); }
public int UpdateFoodArrMeal(FoodMgmt foodMgmt) { updateFoodArrMealCommand = "UpdateFoodArrMeal"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(updateFoodArrMealCommand); dbCommandWrapper.AddInParameter("@foodArrID", DbType.Int32, foodMgmt.FoodArrID); dbCommandWrapper.AddInParameter("@foodArrName", DbType.String, foodMgmt.MealName); dbCommandWrapper.AddInParameter("@foodArrRemark", DbType.String, foodMgmt.MealRemark); dbCommandWrapper.AddInParameter("@foodArrBreakFast", DbType.Boolean, foodMgmt.BreakFast); dbCommandWrapper.AddInParameter("@foodArrLunch", DbType.Boolean, foodMgmt.Lunch); dbCommandWrapper.AddInParameter("@foodArrSnack", DbType.Boolean, foodMgmt.Snack); dbCommandWrapper.AddInParameter("@foodArrDinner", DbType.Boolean, foodMgmt.Dinner); dbCommandWrapper.AddOutParameter("rowsAffected", DbType.Int16, 16); dbFoodMgmt.ExecuteNonQuery(dbCommandWrapper); return(Convert.ToInt32(dbCommandWrapper.GetParameterValue("rowsAffected"))); }
public DataSet GetFoodArrGrade(FoodMgmt foodMgmt, bool selStyle) { return(FillFoodArrGrade(foodMgmt, selStyle)); }