public List <Model.OsP> SelectvoP(int i, Model.OsP Vo) //instrução de select passando parametro de busca
{
string sql = "";
List <Model.OsP> lstVenda = new List <Model.OsP>();
SqlConnection con = new SqlConnection(strCon);
switch (i)
{
//case 0:
// sql = "select * from OrcamentoP;";
// break;
case 1:
sql = "select * from OsP where idOs =" + Vo.idOs + ";";
break;
}
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
try
{
while (reader.Read())
{
Model.OsP oVenda = new Model.OsP();
oVenda.idOs = Convert.ToInt32(reader["idOs"]);
oVenda.id_prod = Convert.ToInt32(reader["id_prod"]);
oVenda.nome_p = reader["nome_p"].ToString();
oVenda.qtd = Convert.ToDecimal(reader["qtd"]);
oVenda.valor_unit = Convert.ToDecimal(reader["valor_unit"]);
lstVenda.Add(oVenda);
}
}
finally
{
con.Close(); //finaliza a conexao
}
return(lstVenda); //retorna a lista
}
public List <Model.OsP> SelectvoP(int i, Model.OsP Vo)
{
DAL.DALLOs dalOr = new DAL.DALLOs();
return(dalOr.SelectvoP(i, Vo));
}
