示例#1
0
文件: FoodService.cs 项目: fu-kim/-
        public static int InsertFood(Foods F)
        {
            int    n   = 0;
            string sql = "Insert Food(FoodName,Price,FoodType,FoodTime,FoodImage) ";

            sql += "Values ('{0}','{1}','{2}','{3}','{4}')";
            sql  = string.Format(sql, F.FoodName, F.FoodPrice, F.FoodType, F.FoodTime, F.FoodName);
            n    = DBHelper.ExecuteNonQuery(sql);
            return(n);
        }
示例#2
0
文件: FoodService.cs 项目: fu-kim/-
        public static int UpdateFood(Foods CII)
        {
            int    n   = 0;
            string sql = "Update Food Set FoodName='{0}',Price='{1}',";

            sql += "FoodType='{2}',FoodTime='{3}' Where FoodId='{4}'";
            sql  = string.Format(sql, CII.FoodName, CII.FoodPrice, CII.FoodType, CII.FoodTime, CII.FoodId);
            n    = DBHelper.ExecuteNonQuery(sql);
            return(n);
        }
示例#3
0
文件: FoodService.cs 项目: fu-kim/-
        //查询所有菜品信息
        public static List <Foods> SelectColdFoodAll()
        {
            List <Foods> tb  = new List <Foods>();
            string       sql = "Select f.FoodId,ft.Ftype,f.FoodName,f.Price,f.FoodTime ";

            sql += "From Food f,FoodType ft Where f.FoodType = ft.FoodTypeId and ft.FType='凉菜'";
            SqlDataReader dr = DBHelper.ExecuteReader(sql);

            while (dr.Read())
            {
                Foods tbs = new Foods();
                tbs.FoodId    = (int)dr["FoodId"];
                tbs.FoodName  = (string)dr["FoodName"];
                tbs.FoodPrice = (decimal)dr["Price"];
                tbs.FoodTime  = (TimeSpan)dr["FoodTime"];
                tbs.FoodType  = (string)dr["Ftype"];
                tb.Add(tbs);
            }
            dr.Close();
            DBHelper.Closecon();
            return(tb);
        }