示例#1
0
        private static List <VendaBean> SetInstance(OracleDataReader dr, PessoaBean cliente, OracleTransaction trans)
        {
            List <VendaBean> list = new List <VendaBean>();

            try
            {
                while (dr.Read())
                {
                    VendaBean obj = new VendaBean();

                    obj.idVenda        = Convert.ToInt32(dr["id_venda"].ToString());
                    obj.dtVenda        = dr.GetDateTime(2);
                    obj.dtUltAlteracao = dr.GetDateTime(3);
                    obj.dtEmissao      = dr.GetDateTime(4);
                    obj.notaVenda      = dr["NOTA_VENDA"].ToString();
                    obj.vlrDesconto    = Convert.ToDouble(dr["VLR_DESCONTO"].ToString());
                    obj.tipoVenda      = dr["TIPO_VENDA"].ToString();
                    obj.qtdParcelas    = Convert.ToInt32(dr["QTD_PARCELAS"].ToString());
                    obj.obs            = dr["OBS"].ToString();
                    obj.status         = dr["STATUS"].ToString();
                    if (dr[13] != DBNull.Value)
                    {
                        obj.dtVencParcela1 = dr.GetDateTime(13);
                    }
                    else
                    {
                        obj.dtVencParcela1 = null;
                    }
                    obj.cliente = cliente;
                    obj.itens   = ItemVendaDAO.getRecordsByIdVenda(obj, trans);



                    list.Add(obj);
                }
            }

            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                if (!dr.IsClosed)
                {
                    dr.Close();
                }
            }
            return(list);
        }
示例#2
0
        public static int insert(VendaBean bean)
        {
            int qtdInsert = 0;

            using (OracleConnection conn = new OracleConnection(REFOracleDatabase.CONN_STRING))
            {
                OracleParameter[] parms = GetParameters(true);
                SetParameters(parms, bean);

                conn.Open();
                using (OracleTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                        //inseir a venda
                        OracleCommand cmd = REFOracleDatabase.ExecuteNonQueryCmd(trans, CommandType.Text, CMDINSERT, out qtdInsert, parms);
                        bean.idVenda = Convert.ToInt32(cmd.Parameters["id_venda_out"].Value.ToString());
                        //inserir os itens
                        foreach (ItemVendaBean item in bean.itens)
                        {
                            if (item.qtdProduto > 0)
                            {
                                ItemVendaDAO.insert(item, trans);
                            }
                        }

                        cmd.Parameters.Clear();
                        trans.Commit();
                    }
                    catch (Exception ex)
                    {
                        trans.Rollback();
                        throw (ex);
                    }
                }
            }

            return(qtdInsert);
        }