public static string fncNumEnPrep(string vPed, int vLin)
{
string vEnPrep = "";
using (SqlConnection cnn = new SqlConnection(cParamXml.strConecProduc_Prueb))
{
cnn.Open();
SqlCommand cmd = new SqlCommand("GC_Entregas_NumEnPrep", cnn);
cmd.CommandType = CommandType.StoredProcedure;
SQLDataAccess.AddParamToSQLCmd(cmd, "@Pedido", SqlDbType.VarChar, 20, ParameterDirection.Input, vPed);
SQLDataAccess.AddParamToSQLCmd(cmd, "@Lin", SqlDbType.Int, 0, ParameterDirection.Input, vLin);
SQLDataAccess.AddParamToSQLCmd(cmd, "@Res", SqlDbType.VarChar, 20, ParameterDirection.Output, null);
cmd.ExecuteScalar();
vEnPrep = cmd.Parameters["@Res"].Value.ToString();
cnn.Close();
}
return(vEnPrep);
}
