public List <SqlParameter> SetParametersAddDataPalet(Paleta datos) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = datos.Numero }, new SqlParameter() { ParameterName = "@p2", SqlDbType = SqlDbType.NVarChar, Value = datos.Number_palet }, new SqlParameter() { ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = datos.Medida }, new SqlParameter() { ParameterName = "@p4", SqlDbType = SqlDbType.NVarChar, Value = datos.Contenido }, new SqlParameter() { ParameterName = "@p5", SqlDbType = SqlDbType.Decimal, Value = datos.Kilo_neto }, new SqlParameter() { ParameterName = "@p6", SqlDbType = SqlDbType.Decimal, Value = datos.Kilo_bruto }, }; return(sp); }
public List <Paleta> GetDataPalet(string conduce) { List <Paleta> lista = new List <Paleta>(); try { Micomm.Conectar(R.SQL.DATABASE.NAME); SqlCommand comando = new SqlCommand { Connection = Micomm.cnn, CommandType = CommandType.Text, CommandText = R.SQL.QUERY_SQL.DESPACHOS.SQL_SELECT_DATA_PALET_DESPACHO }; SqlParameter p1 = new SqlParameter("@p1", conduce); comando.Parameters.Add(p1); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { Paleta rollo = new Paleta { Number_palet = reader.GetString(0), Medida = reader.GetString(1), Contenido = reader.GetString(2), Kilo_bruto = reader.GetDecimal(3), Kilo_neto = reader.GetDecimal(4), Numero = reader.GetString(5) }; lista.Add(rollo); } comando.Dispose(); Micomm.Desconectar(); return(lista); } catch (SqlException ex) { MessageBox.Show(R.ERROR_MESSAGES.DESPACHOS. MESSAGE_SELECT_GETDATAPALET + ex); return(lista); } }