예제 #1
0
        public void AvgYearSales(InfoAnual a)
        {
            SqlCommand   cmd = this.CreateCommand("avg_year_sales");
            SqlParameter param;

            cmd.CommandType = CommandType.StoredProcedure;
            param           = cmd.Parameters.Add(new SqlParameter("@codigo", SqlDbType.Char, 13));
            param.Value     = a.CodigoProduto;

            param       = cmd.Parameters.Add(new SqlParameter("@year", SqlDbType.SmallInt));
            param.Value = a.ano;

            MySession.EndTransaction(true, isMyTransaction);
            MySession.CloseConnection(isMyConnection);
        }
예제 #2
0
 public void Delete(InfoAnual entity)
 {
     throw new NotImplementedException();
 }