bll_optable.cs

饮食管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataAccess;
using Entity;


namespace BusinessLayer
{
   public class Bll_OpTable
    {
       SqlDataAccess sql = new SqlDataAccess();

       public DataTable SelectOpTabelAll()
       {
           return sql.ExecuteDataSetBySelect("proc_SelectOpTabelAll");
       }
       public int InsertOpTable(OpTable o)
       {
           return sql.ExecuteDataSetByUpdate("proc_InsertOpTable",o.OpId,o.OpName,o.OpPwd,o.State,o.MaxMoney);
       }

       public int UpdateOpTableById(OpTable o)
       {
           return sql.ExecuteDataSetByUpdate("proc_UpdateOpTableById", o.OpId, o.OpName, o.OpPwd, o.State, o.MaxMoney);
       }
       public int DeleteOpTableById(OpTable o)
       {

           return sql.ExecuteDataSetByUpdate("proc_DeleteOpTableById", o.OpId);
       }

    }
}